USE PIRPSD;
show tables;

select count(*) "tbl 1. C_PSDMAIN"  from c_psdmain;
desc c_psdmain;
show keys from c_psdmain;

select count(*) "tbl 2. C_PSDREF" from c_psdref;
desc c_psdref;
show keys from c_psdref;

select count(*) "tbl 3. C_LITBAS" from c_litbas;
desc c_litbas;
show keys from c_litbas;

select count(*) "tbl 4. C_LITAUTHOR" from c_litauthor;
desc c_litauthor;
show keys from c_litauthor;

select count(*) "tbl 5. C_LITXREF" from c_litxref;
desc c_litxref;
show keys from c_litxref;

select count(*) "tbl 6. C_LITCITATION" from c_litcitation;
desc c_litcitation;
show keys from c_litcitation;

select count(*) "tbl 7. C_ACCESSION" from c_accession;
desc c_accession "DEC";
show keys from c_accession;
 
select count(*) "tbl 8. C_ACCXREF" from c_accxref;
desc c_accxref;
show keys from c_accxref;

select count(*) "tbl 9. C_PSDCLASS" from c_psdclass;
desc c_psdclass;
show keys from c_psdclass;

select count(*) "tbl 10. C_PSDKEYWORD" from c_psdkeyword;
desc c_psdkeyword;
show keys from c_psdkeyword;

select count(*) "tbl 11. C_PSDCOMPLEX" from c_psdcomplex;
desc c_psdcomplex;
show keys from c_psdcomplex;

select count(*) "tbl 12. C_PSDFUNCTION" from c_psdfunction;
desc c_psdfunction;
show keys from c_psdfunction;

select count(*) "tbl 13. C_PSDFEATURE" from c_psdfeature;
desc c_psdfeature;
show keys from c_psdfeature;

select count(*) "tbl 14. C_PSDSEQUENCE" from c_psdsequence;
desc c_psdsequence;
show keys from c_psdsequence;

select count(*) "tbl 15. C_PSDGENETICS" from c_psdgenetics;
desc c_psdgenetics;
show keys from c_psdgenetics;

select count(*) "tbl 16. C_PSDGNXREF" from c_psdgnxref;
desc c_psdgnxref;
show keys from c_psdgnxref;

