51 U:\basysbio\schema-006.dez 2010-09-08 2010-09-08 U:\basysbio\schema-006.sql SQLFILE postgresql83 postgresql83 14 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 TECH_ID 2 0

BIGINT 0 1

CODE 3 0

CHARACTER VARYING 40 0 1

PROPERTY 4 0

CHARACTER VARYING 1000 0 1

INTEGER 5 0

INTEGER 0 1

REAL 6 0

DOUBLE PRECISION 0 1

DATA_SETS DATA_PK 7 0 6 1 1 2 DATA_PK DATA_PK 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PERM_ID 3 0 3

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 UPLOADER_EMAIL 4 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 4 EXP_CODE 5 0 3

CHARACTER VARYING 40 0 1

1 0 1 1 5 5 EXP_PERM_ID 6 0 3

CHARACTER VARYING 40 0 1

1 0 1 1 5 6 DATA_BK_UK DATA_BK_UK 2 0 2 2 3 TIME_SERIES TISE_PK 9 0 27 17 1 1 TISE_PK TISE_PK 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID 3 0 2

BIGINT 0 1

1 0 1 1 5 3 ROW_INDEX 4 0 5

INTEGER 0 1

1 0 1 1 5 4 COLUMN_INDEX 5 0 5

INTEGER 0 1

1 0 1 1 5 5 VALUE_GROUP_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IDENTIFIER 7 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 7 IDENTIFIER_TYPE 8 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 8 IDENTIFIER_HUMAN_READABLE 9 0 4

CHARACTER VARYING 1000 0 1

BSB_ID 10 0 4

CHARACTER VARYING 1000 0 1

CONFIDENCE_LEVEL 11 0 4

CHARACTER VARYING 1000 0 1

CONTROLLED_GENE 12 0 4

CHARACTER VARYING 1000 0 1

NUMBER_OF_REPLICATES 13 0 5

INTEGER 0 1

EXPERIMENT_TYPE 14 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 14 CULTIVATION_METHOD 15 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 15 BIOLOGICAL_REPLICATES 16 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 16 TIME_POINT 17 0 5

INTEGER 0 1

1 0 1 1 5 17 TIME_POINT_TYPE 18 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 18 TECHNICAL_REPLICATES 19 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 19 CELL_LOCATION 20 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 20 DATA_SET_TYPE 21 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 21 VALUE_TYPE 22 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 22 UNIT 23 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 23 SCALE 24 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 24 BI_ID 25 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 25 CG 26 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 26 VALUE 27 0 6

DOUBLE PRECISION 0 1

TISE_DASE_FK_I TISE_DASE_FK_I 2 0 0 0 DASE_ID 0 0 3 TISE_VALUE_GROUP_ID_I TISE_VALUE_GROUP_ID_I 3 0 0 0 VALUE_GROUP_ID 0 0 6 TISE_IDENTIFIER_I TISE_IDENTIFIER_I 4 0 0 0 IDENTIFIER 0 0 7 TISE_EXPERIMENT_TYPE_I TISE_EXPERIMENT_TYPE_I 5 0 0 0 EXPERIMENT_TYPE 0 0 14 TISE_CULTIVATION_METHOD_I TISE_CULTIVATION_METHOD_I 6 0 0 0 CULTIVATION_METHOD 0 0 15 TISE_BIOLOGICAL_REPLICATES_I TISE_BIOLOGICAL_REPLICATES_I 7 0 0 0 BIOLOGICAL_REPLICATES 0 0 16 TISE_TIME_POINT_I TISE_TIME_POINT_I 8 0 0 0 TIME_POINT 0 0 17 TISE_TIME_POINT_TYPE_I TISE_TIME_POINT_TYPE_I 9 0 0 0 TIME_POINT_TYPE 0 0 18 TISE_TECHNICAL_REPLICATES_I TISE_TECHNICAL_REPLICATES_I 10 0 0 0 TECHNICAL_REPLICATES 0 0 19 TISE_CELL_LOCATION_I TISE_CELL_LOCATION_I 11 0 0 0 CELL_LOCATION 0 0 20 TISE_DATA_SET_TYPE_I TISE_DATA_SET_TYPE_I 12 0 0 0 DATA_SET_TYPE 0 0 21 TISE_VALUE_TYPE_I TISE_VALUE_TYPE_I 13 0 0 0 VALUE_TYPE 0 0 22 TISE_UNIT_I TISE_UNIT_I 14 0 0 0 UNIT 0 0 23 TISE_SCALE_I TISE_SCALE_I 15 0 0 0 SCALE 0 0 24 TISE_BI_ID_I TISE_BI_ID_I 16 0 0 0 BI_ID 0 0 25 TISE_CG_I TISE_CG_I 17 0 0 0 CG 0 0 26 CHIP_CHIP_DATA CHCH_PK 12 0 26 8 1 1 CHCH_PK CHCH_PK 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 DASE_ID 3 0 2

BIGINT 0 1

1 0 1 1 5 3 ROW_INDEX 4 0 5

INTEGER 0 1

1 0 1 1 5 4 BSU_IDENTIFIER 5 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 5 GENE_NAME 6 0 4

CHARACTER VARYING 1000 0 1

GENE_FUNCTION 7 0 4

CHARACTER VARYING 1000 0 1

ARRAY_DESIGN 8 0 4

CHARACTER VARYING 1000 0 1

MICROARRAY_ID 9 0 5

INTEGER 0 1

EXPERIMENT_TYPE 10 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 10 CULTIVATION_METHOD 11 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 11 BIOLOGICAL_REPLICATES 12 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 12 TECHNICAL_REPLICATES 13 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 13 CELL_LOCATION 14 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 14 GROWTH_PHASE 15 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 15 GENOTYPE 16 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 16 CHIP_PEAK_POSITION_VALUE 17 0 5

INTEGER 0 1

CHIP_PEAK_POSITION_SCALE 18 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 18 CHIP_LOCAL_HEIGHT_VALUE 19 0 6

DOUBLE PRECISION 0 1

CHIP_LOCAL_HEIGHT_SCALE 20 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 20 CHIP_SCORE_VALUE 21 0 6

DOUBLE PRECISION 0 1

CHIP_SCORE_SCALE 22 0 4

CHARACTER VARYING 1000 0 1

1 0 1 1 5 22 INTERGENIC 23 0 -1

BOOLEAN 0 1

1 0 1 1 5 23 NEARBY_GENE_NAMES 24 0 4

CHARACTER VARYING 1000 0 1

NEARBY_GENE_IDS 25 0 4

CHARACTER VARYING 1000 0 1

DISTANCES_FROM_START 26 0 4

CHARACTER VARYING 1000 0 1

CHCH_EXPERIMENT_TYPE_I CHCH_EXPERIMENT_TYPE_I 2 0 0 0 EXPERIMENT_TYPE 0 0 10 CHCH_CULTIVATION_METHOD_I CHCH_CULTIVATION_METHOD_I 3 0 0 0 CULTIVATION_METHOD 0 0 11 CHCH_BIOLOGICAL_REPLICATES_I CHCH_BIOLOGICAL_REPLICATES_I 4 0 0 0 BIOLOGICAL_REPLICATES 0 0 12 CHCH_TECHNICAL_REPLICATES_I CHCH_TECHNICAL_REPLICATES_I 5 0 0 0 TECHNICAL_REPLICATES 0 0 13 CHCH_CELL_LOCATION_I CHCH_CELL_LOCATION_I 6 0 0 0 CELL_LOCATION 0 0 14 CHCH_GROWTH_PHASE_I CHCH_GROWTH_PHASE_I 7 0 0 0 GROWTH_PHASE 0 0 15 CHCH_GENOTYPE_I CHCH_GENOTYPE_I 8 0 0 0 GENOTYPE 0 0 16 EVENTS 14 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID 2 0 -1

BIGINT 0 1

1 0 1 1 5 2 TIME_SERIES_VALUE_GROUP_ID_SEQ 8 0 1 0 NOMAXVALUE NOMINVALUE CHIP_CHIP_VALUE_GROUP_ID_SEQ 11 0 1 0 NOMAXVALUE NOMINVALUE TISE_DASE_FK TISE_DASE_FK 10 0 7 9 0 1 1 0 2 TISE_DASE_FK TISE_DASE_FK 1 0 2 4 3 0 0 2 3 CHCH_DASE_FK CHCH_DASE_FK 13 0 7 12 0 1 1 0 2 CHCH_DASE_FK CHCH_DASE_FK 1 0 2 4 3 0 0 2 3 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 8421376 0 4 0 1 1 0 0 2 Diagram_1 0 16777215 0 4 0 1 1 0 0 7 1 181 108 275 5 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 1 245 423 37 183 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 12 1 237 408 502 185 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 14 1 213 48 198 725 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 7 2 181 108 209 3 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 12 2 237 408 328 187 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 2 245 423 29 187 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 10 1 Arial,8,,0,clWindowText,0 1,1,4,0 2431 5000 5000 5000 319 113 319 148 159 148 159 182 13 1 Arial,8,,0,clWindowText,0 1,1,4,0 7680 5000 5000 5000 414 113 414 145 620 145 620 184 13 2 Arial,8,,0,clWindowText,0 1,1,4,0 7680 5000 5000 5000 348 111 348 160 446 160 446 186 10 2 Arial,8,,0,clWindowText,0 1,1,4,0 2431 5000 5000 5000 253 111 253 153 151 153 151 186