51 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\phosphonetx.dez 2010-03-31 2009-06-29 N:\group\cisd\phosphonetx\datamodel\schema.sql;N:\group\cisd\phosphonetx\datamodel\drop.sql;\\d.ethz.ch\dfs\groups\bsse\users\cisd\felmer\Documents\CreateDBLog_201003311.txt D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql SQLFILE postgresql8 postgresql8 176 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 N:\group\cisd\phosphonetx\datamodel\schema.sql N:\group\cisd\phosphonetx\datamodel\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

ACCESSION_NUMBER 109 0

CHARACTER VARYING 256 0 1

SPECTRUM_REFERENCE 171 0

CHARACTER VARYING 100 0 1

EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_%table%_%counter% 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

DB_ID NN_%column% 6 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_%table%_%counter% 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 7 5 1 1 PK_MODIFICATIONS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 MOPE_ID NN_%column% 7 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 7 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

NN_%column% 1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_%table%_%counter% 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_%table%_%counter% 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 6 1 1 1 PK_IDENTIFIED_PROTEINS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 COVERAGE 6 0 8

DOUBLE PRECISION 0 1

ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 4 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 ACCESSION_NUMBER NN_%column% 3 0 109

CHARACTER VARYING 256 0 1

NN_%column% 1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_%table%_%counter% 2 0 0 0 ACCESSION_NUMBER 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_%table%_%counter% 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 11

CHARACTER VARYING 200 0 1

NN_%column% 1 0 1 1 5 3 TUC_DATABASES_1 TUC_%table%_%counter% 2 0 2 2 3 MODIFIED_PEPTIDES PK_%table% 136 0 5 1 1 1 PK_MODIFIED_PEPTIDES PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 PEPT_ID NN_%column% 3 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 3 NTERM_MASS NN_%column% 4 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 4 CTERM_MASS NN_%column% 5 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 5 SPECTRUM_REFERENCES PK_%table% 160 0 4 1 1 1 PK_SPECTRUM_REFERENCES PK_%table% 1 0 2 3 4 ID 4 0 -1

BIGSERIAL 0 1

1 0 1 1 5 4 PEPT_ID 2 0 12

BIGINT 0 1

1 0 1 1 5 2 REFERENCE 3 0 171

CHARACTER VARYING 100 0 1

1 0 1 1 5 3 MODIFICATION_FRACTIONS PK_%table% 173 0 5 1 1 1 PK_MODIFICATION_FRACTIONS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 MODI_ID NN_%column% 3 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 3 SAMP_ID 4 0 12

BIGINT 0 1

FRACTION NN_%column% 5 0 8

DOUBLE PRECISION 0 1

NN_%column% 1 0 1 1 5 5 EVENTS NN_%column% 176 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID NN_%column% 2 0 12

BIGINT 0 1

NN_%column% 1 0 1 1 5 2 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 0 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 2 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS %parent%_%child% 46 0 17 23 0 1 1 0 2 DATA_SETS_PROTEINS %relname% 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS %parent%_%child% 48 0 23 47 0 1 1 0 2 PROTEINS_IDENTIFIED_PROTEINS %relname% 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS %parent%_%child% 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS %relname% 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES %parent%_%child% 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES %relname% 1 0 2 4 4 0 0 2 4 PROTEINS_ABUNDANCES %parent%_%child% 94 0 23 91 0 1 1 0 2 PROTEINS_ABUNDANCES %relname% 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS %parent%_%child% 97 0 17 96 0 1 1 0 2 DATA_SETS_PROBABILITY_FDR_MAPPINGS %relname% 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES %parent%_%child% 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES %relname% 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES %parent%_%child% 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES %relname% 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS %parent%_%child% 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS %relname% 1 0 2 4 6 0 0 2 6 PEPTIDES_MODIFIED_PEPTIDES %parent%_%child% 138 0 21 136 0 1 1 0 2 PEPTIDES_MODIFIED_PEPTIDES %relname% 1 0 2 4 3 0 0 2 3 MODIFIED_PEPTIDES_MODIFICATIONS %parent%_%child% 139 0 136 19 0 1 1 0 2 MODIFIED_PEPTIDES_MODIFICATIONS %relname% 1 0 2 4 7 0 0 2 7 PEPTIDES_SPECTRUM_REFERENCES %parent%_%child% 172 0 21 160 0 1 1 0 2 PEPTIDES_SPECTRUM_REFERENCES %relname% 1 0 2 4 2 0 0 2 2 MODIFICATIONS_MODIFICATION_FRACTIONS %parent%_%child% 174 0 19 173 0 1 1 0 2 MODIFICATIONS_MODIFICATION_FRACTIONS %relname% 1 0 2 4 3 0 0 2 3 SAMPLES_MODIFICATION_FRACTIONS %parent%_%child% 175 0 24 173 0 1 0 0 0 SAMPLES_MODIFICATION_FRACTIONS %relname% 1 0 2 4 4 0 0 2 4 0 0 PK FK PF * 0 16777215 16777215 16777215 8421504 0 0 0 0 0 0 0 0 1 1 0 0 0 0 Arial,9,B,0,clNavy,0 Arial,8,B,0,clWindowText,0 Arial,8,I,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 Arial,8,,0,clWindowText,0 1 Main Diagram 1 16777215 0 2 0 1 1 1 0 16 1 136 63 544 1 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 17 1 139 108 295 1 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 19 1 177 93 12 628 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 1 187 93 271 480 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 23 1 180 78 274 328 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 24 1 136 78 12 1 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 25 1 250 108 736 328 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 47 1 167 93 518 328 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 91 1 161 93 114 182 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 96 1 243 93 490 182 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 98 1 252 78 734 480 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 110 1 252 63 734 91 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 136 1 183 93 273 628 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 160 1 214 78 505 480 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 173 1 164 93 12 480 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 176 1 226 48 746 1 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 29 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 4921 5000 2870 543 32 480 32 480 32 434 32 30 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 3611 148 40 219 40 219 40 294 40 36 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4973 5000 364 406 364 428 364 428 364 479 46 1 Arial,8,,0,clWindowText,0 1,1,4,0 4964 5000 5000 5000 364 109 364 183 364 183 364 327 48 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 4194 454 367 489 367 489 367 517 367 50 1 Arial,8,,0,clWindowText,0 1,1,4,0 2840 4259 5000 4946 735 374 722 374 722 374 685 374 92 1 Arial,8,,0,clWindowText,0 1,1,4,0 8750 5000 1056 5000 131 79 131 143 131 143 131 181 94 1 Arial,8,,0,clWindowText,0 1,1,4,0 0 5000 9938 4194 274 327 274 299 274 299 274 275 97 1 Arial,8,,0,clWindowText,0 1,1,4,0 8369 5000 5000 5000 411 109 411 161 612 161 612 181 111 1 Arial,8,,0,clWindowText,0 1,1,4,0 5040 7619 5000 1296 861 154 861 235 861 235 861 327 112 1 Arial,8,,0,clWindowText,0 1,1,4,0 5040 5000 5000 3611 861 479 861 447 861 447 861 436 125 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 1429 5000 9167 733 100 578 100 578 100 434 100 138 1 Arial,8,,0,clWindowText,0 1,1,4,0 4973 5000 4973 5000 364 573 364 585 364 585 364 627 139 1 Arial,8,,0,clWindowText,0 1,1,4,0 929 4946 5000 4946 272 674 237 674 237 674 189 674 172 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 4194 5000 5000 458 519 469 519 469 519 504 519 174 1 Arial,8,,0,clWindowText,0 1,1,4,0 4633 5000 5000 5000 94 627 94 585 94 585 94 573 175 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4146 5000 80 79 80 202 80 202 80 479 1 Version 2009-06-29 2009-06-29 10:58 DB Data dictionary only (no diagrams) postgresql8 46 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\targets\drop.sql BINARY_DATA 3 0

BYTEA 0 1

CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

ABUNDANCES_TYPES 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 5 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 IDENTIFICATION_DATA IX_FK_IDENTIFICATION_DATA_SPECTRA 18 0 4 2 1 1 PK_IDENTIFICATION_DATA PK_IDENTIFICATION_DATA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 SPEC_ID 3 0 12

BIGINT 0 1

SPECTRA_COUNT 4 0 7

INTEGER 0 1

IX_FK_IDENTIFICATION_DATA_SPECTRA IX_FK_IDENTIFICATION_DATA_SPECTRA 2 0 0 0 SPEC_ID 0 0 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES 20 0 6 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

DELTA_MASS 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 9 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID 8 0 12

BIGINT 0 1

IDDA_ID 6 0 12

BIGINT 0 1

CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PEPTIDES_IDENTIFICATION_DATA IX_FK_PEPTIDES_IDENTIFICATION_DATA 3 0 0 0 IDDA_ID 0 0 6 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 IX_FK_PEPTIDES_SEQUENCES IX_FK_PEPTIDES_SEQUENCES 5 0 0 0 SEQU_ID 0 0 4 PROTEIN_STATISTICS 22 0 2 1 1 1 PK_PROTEIN_STATISTICS PK_PROTEIN_STATISTICS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 10 5 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID 10 0 12

BIGINT 0 1

1 0 1 1 5 10 SEQU_ID 5 0 12

BIGINT 0 1

ABTY_ID 8 0 12

BIGINT 0 1

PRST_ID 6 0 12

BIGINT 0 1

DESCRIPTION 7 0 6

CHARACTER VARYING 2000 0 1

1 0 1 1 5 7 ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PROTEINS_SEQUENCES IX_FK_PROTEINS_SEQUENCES 3 0 0 0 SEQU_ID 0 0 5 IX_FK_PROTEINS_PROTEIN_STATISTICS IX_FK_PROTEINS_PROTEIN_STATISTICS 5 0 0 0 PRST_ID 0 0 6 SAMPLES 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES 25 0 4 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 SPECTRA 26 0 3 1 1 1 PK_SPECTRA PK_SPECTRA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DATA 3 0 3

BYTEA 0 1

1 0 1 1 5 3 SEQ 10 0 1 0 NOMAXVALUE NOMINVALUE DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 ID_SP_FK ID_SP_FK 31 0 26 18 0 1 0 0 0 ID_SP_FK ID_SP_FK 1 0 2 4 3 0 0 2 3 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_ID_FK PE_ID_FK 35 0 18 21 0 1 0 0 0 PE_ID_FK PE_ID_FK 1 0 2 4 6 0 0 2 6 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 PE_SE_FK PE_SE_FK 37 0 25 21 0 1 1 0 0 PE_SE_FK PE_SE_FK 1 0 2 4 4 0 0 2 4 PR_SE_FK PR_SE_FK 39 0 25 23 0 1 0 0 0 PR_SE_FK PR_SE_FK 1 0 2 4 5 0 0 2 5 PR_PS_FK PR_PS_FK 41 0 22 23 0 1 0 0 0 PR_PS_FK PR_PS_FK 1 0 2 4 6 0 0 2 6 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 43 0 14 23 0 1 0 0 0 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 1 0 2 4 8 0 0 2 8 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 44 0 14 21 0 1 0 0 0 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 1 0 2 4 8 0 0 2 8 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 2 Version 2009-06-29 1 2009-06-29 11:02 DB Data dictionary only (no diagrams) postgresql8 46 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\targets\drop.sql BINARY_DATA 3 0

BYTEA 0 1

CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

ABUNDANCES_TYPES 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 5 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 IDENTIFICATION_DATA IX_FK_IDENTIFICATION_DATA_SPECTRA 18 0 4 2 1 1 PK_IDENTIFICATION_DATA PK_IDENTIFICATION_DATA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 SPEC_ID 3 0 12

BIGINT 0 1

SPECTRA_COUNT 4 0 7

INTEGER 0 1

IX_FK_IDENTIFICATION_DATA_SPECTRA IX_FK_IDENTIFICATION_DATA_SPECTRA 2 0 0 0 SPEC_ID 0 0 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES 20 0 6 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

DELTA_MASS 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 9 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID 8 0 12

BIGINT 0 1

IDDA_ID 6 0 12

BIGINT 0 1

CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PEPTIDES_IDENTIFICATION_DATA IX_FK_PEPTIDES_IDENTIFICATION_DATA 3 0 0 0 IDDA_ID 0 0 6 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 IX_FK_PEPTIDES_SEQUENCES IX_FK_PEPTIDES_SEQUENCES 5 0 0 0 SEQU_ID 0 0 4 PROTEIN_STATISTICS 22 0 2 1 1 1 PK_PROTEIN_STATISTICS PK_PROTEIN_STATISTICS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 10 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID 10 0 12

BIGINT 0 1

1 0 1 1 5 10 SEQU_ID 5 0 12

BIGINT 0 1

ABTY_ID 8 0 12

BIGINT 0 1

PRST_ID 6 0 12

BIGINT 0 1

DESCRIPTION 7 0 6

CHARACTER VARYING 2000 0 1

1 0 1 1 5 7 ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PROTEINS_SEQUENCES IX_FK_PROTEINS_SEQUENCES 3 0 0 0 SEQU_ID 0 0 5 IX_FK_PROTEINS_PROTEIN_STATISTICS IX_FK_PROTEINS_PROTEIN_STATISTICS 5 0 0 0 PRST_ID 0 0 6 IDX_PROTEINS_3 IDX_PROTEINS_3 6 0 0 0 DASE_ID 0 0 10 SAMPLES 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES 25 0 4 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 SPECTRA 26 0 3 1 1 1 PK_SPECTRA PK_SPECTRA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DATA 3 0 3

BYTEA 0 1

1 0 1 1 5 3 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 ID_SP_FK ID_SP_FK 31 0 26 18 0 1 0 0 0 ID_SP_FK ID_SP_FK 1 0 2 4 3 0 0 2 3 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_ID_FK PE_ID_FK 35 0 18 21 0 1 0 0 0 PE_ID_FK PE_ID_FK 1 0 2 4 6 0 0 2 6 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 PE_SE_FK PE_SE_FK 37 0 25 21 0 1 1 0 0 PE_SE_FK PE_SE_FK 1 0 2 4 4 0 0 2 4 PR_SE_FK PR_SE_FK 39 0 25 23 0 1 0 0 0 PR_SE_FK PR_SE_FK 1 0 2 4 5 0 0 2 5 PR_PS_FK PR_PS_FK 41 0 22 23 0 1 0 0 0 PR_PS_FK PR_PS_FK 1 0 2 4 6 0 0 2 6 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 43 0 14 23 0 1 0 0 0 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 1 0 2 4 8 0 0 2 8 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 44 0 14 21 0 1 0 0 0 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 1 0 2 4 8 0 0 2 8 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 3 Version 2009-06-29 2 2009-06-29 12:29 DB Data dictionary only (no diagrams) postgresql8 48 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\targets\drop.sql BINARY_DATA 3 0

BYTEA 0 1

CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

ABUNDANCES_TYPES PK_%table% 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 5 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 IDENTIFICATION_DATA IX_FK_IDENTIFICATION_DATA_SPECTRA 18 0 4 2 1 1 PK_IDENTIFICATION_DATA PK_IDENTIFICATION_DATA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 SPEC_ID 3 0 12

BIGINT 0 1

SPECTRA_COUNT 4 0 7

INTEGER 0 1

IX_FK_IDENTIFICATION_DATA_SPECTRA IX_FK_IDENTIFICATION_DATA_SPECTRA 2 0 0 0 SPEC_ID 0 0 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES PK_%table% 20 0 6 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

DELTA_MASS 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 9 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID 8 0 12

BIGINT 0 1

IDDA_ID 6 0 12

BIGINT 0 1

CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PEPTIDES_IDENTIFICATION_DATA IX_FK_PEPTIDES_IDENTIFICATION_DATA 3 0 0 0 IDDA_ID 0 0 6 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 IX_FK_PEPTIDES_SEQUENCES IX_FK_PEPTIDES_SEQUENCES 5 0 0 0 SEQU_ID 0 0 4 PROTEIN_STATISTICS PK_%table% 22 0 2 1 1 1 PK_PROTEIN_STATISTICS PK_PROTEIN_STATISTICS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 10 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 SEQU_ID 5 0 12

BIGINT 0 1

ABTY_ID 8 0 12

BIGINT 0 1

PRST_ID 6 0 12

BIGINT 0 1

ABUNDANCE 9 0 8

DOUBLE PRECISION 0 1

IX_FK_PROTEINS_SEQUENCES IX_FK_PROTEINS_SEQUENCES 3 0 0 0 SEQU_ID 0 0 5 IX_FK_PROTEINS_PROTEIN_STATISTICS IX_FK_PROTEINS_PROTEIN_STATISTICS 5 0 0 0 PRST_ID 0 0 6 IDX_PROTEINS_3 IDX_PROTEINS_3 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 4 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 SPECTRA PK_%table% 26 0 3 1 1 1 PK_SPECTRA PK_SPECTRA 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DATA 3 0 3

BYTEA 0 1

1 0 1 1 5 3 IDENTIFIED_PROTEINS 47 0 4 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

1 0 1 1 5 4 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 ID_SP_FK ID_SP_FK 31 0 26 18 0 1 0 0 0 ID_SP_FK ID_SP_FK 1 0 2 4 3 0 0 2 3 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_ID_FK PE_ID_FK 35 0 18 21 0 1 0 0 0 PE_ID_FK PE_ID_FK 1 0 2 4 6 0 0 2 6 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 PE_SE_FK PE_SE_FK 37 0 25 21 0 1 1 0 0 PE_SE_FK PE_SE_FK 1 0 2 4 4 0 0 2 4 PR_SE_FK PR_SE_FK 39 0 25 23 0 1 0 0 0 PR_SE_FK PR_SE_FK 1 0 2 4 5 0 0 2 5 PR_PS_FK PR_PS_FK 41 0 22 23 0 1 0 0 0 PR_PS_FK PR_PS_FK 1 0 2 4 6 0 0 2 6 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 43 0 14 23 0 1 0 0 0 ABUNDANCES_TYPES_PROTEINS ABUNDANCES_TYPES_PROTEINS 1 0 2 4 8 0 0 2 8 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 44 0 14 21 0 1 0 0 0 ABUNDANCES_TYPES_PEPTIDES ABUNDANCES_TYPES_PEPTIDES 1 0 2 4 8 0 0 2 8 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 4 Version 2009-06-30 2009-06-30 09:00 DB Data dictionary only (no diagrams) postgresql8 97 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\targets\drop.sql BINARY_DATA 3 0

BYTEA 0 1

CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

ABUNDANCES_TYPES PK_%table% 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 5 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES PK_%table% 20 0 6 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

DELTA_MASS 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 4 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

DESCRIPTION NN_%column% 4 0 6

CHARACTER VARYING 2000 0 1

1 0 1 1 5 4 ABUNDANCES 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 VALUE 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 0 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 93 0 14 91 0 1 1 0 0 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 1 0 2 4 5 0 0 2 5 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 5 Version 2009-07-06 2009-07-06 13:15 DB Data dictionary only (no diagrams) postgresql8 135 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 N:\user\cisd\felmer\phosphonetx\schema-001.sql N:\user\cisd\felmer\phosphonetx\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

UNIPROT_ACCESSION_NUMBER 109 0

CHARACTER VARYING 40 0 1

ABUNDANCES_TYPES PK_%table% 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 DB_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES PK_%table% 20 0 7 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

AMINO_ACID 7 0 -1

CHARACTER 1 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

MASS_TOLERANCE 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_PROTEIN_REFERENCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 UNIPROT_ID NN_%column% 3 0 109

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_PROTEIN_REFERENCES_1 2 0 0 0 UNIPROT_ID 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_PROTEIN_REFERENCES_1 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_DATABASES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 3 TUC_DATABASES_1 TUC_DATABASES_1 2 0 2 2 3 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 93 0 14 91 0 1 1 0 0 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 1 0 2 4 5 0 0 2 5 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES DATABASES_SEQUENCES 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES DATABASES_SEQUENCES 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS DATABASES_DATA_SETS 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS DATABASES_DATA_SETS 1 0 2 4 6 0 0 2 6 6 Version 2009-07-06 1 2009-07-06 13:30 DB Data dictionary only (no diagrams) postgresql8 135 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 N:\user\cisd\felmer\phosphonetx\schema-001.sql N:\user\cisd\felmer\phosphonetx\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

UNIPROT_ACCESSION_NUMBER 109 0

CHARACTER VARYING 40 0 1

ABUNDANCES_TYPES PK_%table% 14 0 4 1 1 2 PK_ABUNDANCES_TYPES PK_ABUNDANCES_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

TUC_ABUNDANCES_TYPES_1 TUC_ABUNDANCES_TYPES_1 2 0 2 2 3 EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 DB_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES PK_%table% 20 0 7 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

AMINO_ACID 7 0 -1

CHARACTER 1 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

MASS_TOLERANCE 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

1 0 1 1 5 4 ABTY_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_PROTEIN_REFERENCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 UNIPROT_ID NN_%column% 3 0 109

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_PROTEIN_REFERENCES_1 2 0 0 0 UNIPROT_ID 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_PROTEIN_REFERENCES_1 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_DATABASES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 11

CHARACTER VARYING 200 0 1

1 0 1 1 5 3 TUC_DATABASES_1 TUC_DATABASES_1 2 0 2 2 3 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 93 0 14 91 0 1 1 0 0 ABUNDANCES_TYPES_ABUNDANCES ABUNDANCES_TYPES_ABUNDANCES 1 0 2 4 5 0 0 2 5 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES DATABASES_SEQUENCES 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES DATABASES_SEQUENCES 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS DATABASES_DATA_SETS 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS DATABASES_DATA_SETS 1 0 2 4 6 0 0 2 6 7 Version 2009-07-07 2009-07-07 08:01 DB Data dictionary only (no diagrams) postgresql8 135 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 N:\user\cisd\felmer\phosphonetx\schema-001.sql N:\user\cisd\felmer\phosphonetx\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

UNIPROT_ACCESSION_NUMBER 109 0

CHARACTER VARYING 40 0 1

EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 DB_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 6 3 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 MOTY_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 IX_FK_MODIFICATIONS_PEPTIDES IX_FK_MODIFICATIONS_PEPTIDES 2 0 0 0 PEPT_ID 0 0 3 IX_FK_MODIFICATIONS_MODIFICATION_TYPES IX_FK_MODIFICATIONS_MODIFICATION_TYPES 3 0 0 0 MOTY_ID 0 0 4 MODIFICATION_TYPES PK_%table% 20 0 7 1 1 2 PK_MODIFICATION_TYPES PK_MODIFICATION_TYPES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 11

CHARACTER VARYING 200 0 1

AMINO_ACID 7 0 -1

CHARACTER 1 0 1

MASS 5 0 8

DOUBLE PRECISION 0 1

MASS_TOLERANCE 6 0 8

DOUBLE PRECISION 0 1

TUC_MODIFICATION_TYPES_1 TUC_MODIFICATION_TYPES_1 2 0 2 2 3 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

1 0 1 1 5 4 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_PROTEIN_REFERENCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 UNIPROT_ID NN_%column% 3 0 109

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_PROTEIN_REFERENCES_1 2 0 0 0 UNIPROT_ID 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_PROTEIN_REFERENCES_1 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_DATABASES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 11

CHARACTER VARYING 200 0 1

1 0 1 1 5 3 TUC_DATABASES_1 TUC_DATABASES_1 2 0 2 2 3 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 MO_PE_FK MO_PE_FK 32 0 21 19 0 1 1 0 0 MO_PE_FK MO_PE_FK 1 0 2 4 3 0 0 2 3 MO_MT_FK MO_MT_FK 33 0 20 19 0 1 1 0 0 MO_MT_FK MO_MT_FK 1 0 2 4 4 0 0 2 4 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES DATABASES_SEQUENCES 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES DATABASES_SEQUENCES 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS DATABASES_DATA_SETS 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS DATABASES_DATA_SETS 1 0 2 4 6 0 0 2 6 8 Version 2009-07-15 2009-07-15 15:52 DB Data dictionary only (no diagrams) postgresql8 139 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

UNIPROT_ACCESSION_NUMBER 109 0

CHARACTER VARYING 40 0 1

EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 DB_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 7 5 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 MOPE_ID 7 0 12

BIGINT 0 1

1 0 1 1 5 7 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

1 0 1 1 5 4 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_PROTEIN_REFERENCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 UNIPROT_ID NN_%column% 3 0 109

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_PROTEIN_REFERENCES_1 2 0 0 0 UNIPROT_ID 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_PROTEIN_REFERENCES_1 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_DATABASES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 11

CHARACTER VARYING 200 0 1

1 0 1 1 5 3 TUC_DATABASES_1 TUC_DATABASES_1 2 0 2 2 3 MODIFIED_PEPTIDES 136 0 5 1 1 1 PK_MODIFIED_PEPTIDES PK_MODIFIED_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 NTERM_MASS 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 CTERM_MASS 5 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 5 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES DATABASES_SEQUENCES 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES DATABASES_SEQUENCES 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS DATABASES_DATA_SETS 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS DATABASES_DATA_SETS 1 0 2 4 6 0 0 2 6 PEPTIDES_MODIFIED_PEPTIDES PEPTIDES_MODIFIED_PEPTIDES 138 0 21 136 0 1 1 0 0 PEPTIDES_MODIFIED_PEPTIDES PEPTIDES_MODIFIED_PEPTIDES 1 0 2 4 3 0 0 2 3 MODIFIED_PEPTIDES_MODIFICATIONS MODIFIED_PEPTIDES_MODIFICATIONS 139 0 136 19 0 1 1 0 0 MODIFIED_PEPTIDES_MODIFICATIONS MODIFIED_PEPTIDES_MODIFICATIONS 1 0 2 4 7 0 0 2 7 9 Version 2009-07-15 1 2009-07-15 15:53 DB Data dictionary only (no diagrams) postgresql8 139 PK_%table% %relname% CC_%table%_%column% NN_%column% DEF_%table%_%column% TUC_%table%_%counter% TCC_%table%_%counter% %parent%_%child% IDX_%table%_%counter% 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\schema-001.sql D:\User\felmer\dev-workspace\rtd_phosphonetx\source\sql\postgresql\001\drop.sql CHECKSUM 4 0

CHARACTER VARYING 8 0 1

CODE 5 0

CHARACTER VARYING 40 0 1

DESCRIPTION 6 0

CHARACTER VARYING 2000 0 1

INTEGER_NUMBER 7 0

INTEGER 0 1

REAL_NUMBER 8 0

DOUBLE PRECISION 0 1

LONG_SEQUENCE 9 0

TEXT 0 1

SHORT_DESCRIPTION 11 0

CHARACTER VARYING 200 0 1

TECH_ID 12 0

BIGINT 0 1

SHORT_SEQUENCE 69 0

CHARACTER VARYING 1000 0 1

UNIPROT_ACCESSION_NUMBER 109 0

CHARACTER VARYING 40 0 1

EXPERIMENTS PK_%table% 16 0 3 1 1 2 PK_EXPERIMENTS PK_EXPERIMENTS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_EXPERIMENTS_1 2 0 2 2 3 DATA_SETS IX_FK_DATA_SETS_EXPERIMENTS 17 0 6 3 1 2 PK_DATA_SETS PK_DATA_SETS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 SAMP_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 DB_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IX_FK_DATA_SETS_EXPERIMENTS IX_FK_DATA_SETS_EXPERIMENTS 2 0 0 0 EXPE_ID 0 0 4 IX_FK_DATA_SETS_SAMPLES IX_FK_DATA_SETS_SAMPLES 3 0 0 0 SAMP_ID 0 0 5 TUC_DATA_SETS_1 TUC_DATA_SETS_1 2 0 2 2 3 MODIFICATIONS IX_FK_MODIFICATIONS_PEPTIDES 19 0 7 5 1 1 PK_MODIFICATIONS PK_MODIFICATIONS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 MOPE_ID 7 0 12

BIGINT 0 1

1 0 1 1 5 7 POS 5 0 7

INTEGER 0 1

1 0 1 1 5 5 MASS 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PEPTIDES IX_FK_PEPTIDES_ABUNDANCES 21 0 10 5 1 1 PK_PEPTIDES PK_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQUENCE NN_%column% 10 0 69

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CHARGE 7 0 7

INTEGER 0 1

1 0 1 1 5 7 IX_FK_PEPTIDES_PROTEINS IX_FK_PEPTIDES_PROTEINS 4 0 0 0 PROT_ID 0 0 3 PROTEINS IX_FK_PROTEINS_DATA_SETS 23 0 11 7 1 1 PK_PROTEINS PK_PROTEINS 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 10 0 12

BIGINT 0 1

1 0 1 1 5 10 PROBABILITY 9 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 9 IDX_PROTEINS_1 IDX_PROTEINS_1 6 0 0 0 DASE_ID 0 0 10 SAMPLES PK_%table% 24 0 4 1 1 2 PK_SAMPLES PK_SAMPLES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 5

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 EXPE_ID 4 0 12

BIGINT 0 1

1 0 1 1 5 4 TUC_SAMPLES_1 TUC_SAMPLES_1 2 0 2 2 3 SEQUENCES PK_%table% 25 0 6 1 1 1 PK_SEQUENCES PK_SEQUENCES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DB_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PRRE_ID NN_%column% 6 0 12

BIGINT 0 1

1 0 1 1 5 6 AMINO_ACID_SEQUENCE 3 0 9

TEXT 0 1

1 0 1 1 5 3 CHECKSUM 4 0 4

CHARACTER VARYING 8 0 1

1 0 1 1 5 4 IDENTIFIED_PROTEINS PK_%table% 47 0 5 1 1 1 PK_IDENTIFIED_PROTEINS PK_IDENTIFIED_PROTEINS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SEQU_ID 5 0 12

BIGINT 0 1

1 0 1 1 5 5 ABUNDANCES PK_%table% 91 0 6 1 1 1 PK_ABUNDANCES PK_ABUNDANCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PROT_ID NN_%column% 3 0 12

BIGINT 0 1

1 0 1 1 5 3 SAMP_ID NN_%column% 4 0 12

BIGINT 0 1

1 0 1 1 5 4 VALUE NN_%column% 6 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 6 PROBABILITY_FDR_MAPPINGS PK_%table% 96 0 5 1 1 1 PK_PROBABILITY_FDR_MAPPINGS PK_PROBABILITY_FDR_MAPPINGS 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID NN_%column% 5 0 12

BIGINT 0 1

1 0 1 1 5 5 PROBABILITY NN_%column% 3 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 3 FALSE_DISCOVERY_RATE NN_%column% 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 PROTEIN_REFERENCES PK_%table% 98 0 4 2 1 2 PK_PROTEIN_REFERENCES PK_PROTEIN_REFERENCES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 UNIPROT_ID NN_%column% 3 0 109

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 6

CHARACTER VARYING 2000 0 1

IDX_PROTEIN_REFERENCES_1 IDX_PROTEIN_REFERENCES_1 2 0 0 0 UNIPROT_ID 0 0 3 TUC_PROTEIN_REFERENCES_1 TUC_PROTEIN_REFERENCES_1 2 0 2 2 3 DATABASES PK_%table% 110 0 3 1 1 2 PK_DATABASES PK_DATABASES 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 NAME_AND_VERSION NN_%column% 3 0 11

CHARACTER VARYING 200 0 1

1 0 1 1 5 3 TUC_DATABASES_1 TUC_DATABASES_1 2 0 2 2 3 MODIFIED_PEPTIDES 136 0 5 1 1 1 PK_MODIFIED_PEPTIDES PK_MODIFIED_PEPTIDES 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PEPT_ID 3 0 12

BIGINT 0 1

1 0 1 1 5 3 NTERM_MASS 4 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 4 CTERM_MASS 5 0 8

DOUBLE PRECISION 0 1

1 0 1 1 5 5 DA_EX_FK DA_EX_FK 29 0 16 17 0 1 1 0 0 DA_EX_FK DA_EX_FK 1 0 2 4 4 0 0 2 4 DA_SA_FK DA_SA_FK 30 0 24 17 0 1 1 0 0 DA_SA_FK DA_SA_FK 1 0 2 4 5 0 0 2 5 PE_PR_FK PE_PR_FK 36 0 23 21 0 1 1 0 0 PE_PR_FK PE_PR_FK 1 0 2 4 3 0 0 2 3 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 46 0 17 23 0 1 1 0 0 DATA_SETS_PROTEINS DATA_SETS_PROTEINS 1 0 2 4 10 0 0 2 10 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 48 0 23 47 0 1 1 0 0 PROTEINS_IDENTIFIED_PROTEINS PROTEINS_IDENTIFIED_PROTEINS 1 0 2 4 3 0 0 2 3 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 50 0 25 47 0 1 1 0 0 SEQUENCES_IDENTIFIED_PROTEINS SEQUENCES_IDENTIFIED_PROTEINS 1 0 2 4 5 0 0 2 5 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 92 0 24 91 0 1 1 0 0 SAMPLES_ABUNDANCES SAMPLES_ABUNDANCES 1 0 2 4 4 0 0 2 4 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 94 0 23 91 0 1 1 0 0 PROTEINS_ABUNDANCES PROTEINS_ABUNDANCES 1 0 2 4 3 0 0 2 3 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 97 0 17 96 0 1 1 0 0 DATA_SETS_PROBABILITY_FDR_MAPPINGS DATA_SETS_PROBABILITY_FDR_MAPPINGS 1 0 2 4 5 0 0 2 5 DATABASES_SEQUENCES DATABASES_SEQUENCES 111 0 110 25 0 1 1 0 0 DATABASES_SEQUENCES DATABASES_SEQUENCES 1 0 2 4 5 0 0 2 5 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 112 0 98 25 0 1 1 0 0 PROTEIN_REFERENCES_SEQUENCES PROTEIN_REFERENCES_SEQUENCES 1 0 2 4 6 0 0 2 6 DATABASES_DATA_SETS DATABASES_DATA_SETS 125 0 110 17 0 1 1 0 0 DATABASES_DATA_SETS DATABASES_DATA_SETS 1 0 2 4 6 0 0 2 6 PEPTIDES_MODIFIED_PEPTIDES PEPTIDES_MODIFIED_PEPTIDES 138 0 21 136 0 1 1 0 0 PEPTIDES_MODIFIED_PEPTIDES PEPTIDES_MODIFIED_PEPTIDES 1 0 2 4 3 0 0 2 3 MODIFIED_PEPTIDES_MODIFICATIONS MODIFIED_PEPTIDES_MODIFICATIONS 139 0 136 19 0 1 1 0 0 MODIFIED_PEPTIDES_MODIFICATIONS MODIFIED_PEPTIDES_MODIFICATIONS 1 0 2 4 7 0 0 2 7