51 N:\group\cisd\basysbio\schema.dez 2010-06-14 2010-01-27 N:\group\cisd\basysbio\datamodel\schema.sql;N:\group\cisd\basysbio\datamodel\drop_postgresql.sql;\\d.ethz.ch\dfs\groups\bsse\users\cisd\felmer\Documents\CreateDBLog_201006141.txt postgresql8 68 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\basysbio\datamodel\schema.sql N:\group\cisd\basysbio\datamodel\drop_postgresql.sql REAL 3 0

DOUBLE PRECISION 0 1

IDENTIFIER 6 0

CHARACTER VARYING 1000 0 1

TECH_ID 11 0

BIGINT 0 1

CODE 19 0

CHARACTER VARYING 40 0 1

HEADER 37 0

CHARACTER VARYING 1000 0 1

PROPERTY 54 0

CHARACTER VARYING 100 0 1

INTEGER 61 0

INTEGER 0 1

DATA_COLUMN_VALUES PK_%table% 2 0 9 1 1 1 PK_DATA_COLUMN_VALUES PK_%table% 1 0 2 3 7 8 DACO_ID NN_%column% 7 0 11

BIGINT 0 1

NN_%column% 1 0 1 1 5 7 ROW_ID NN_%column% 8 0 11

BIGINT 0 1

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

DOUBLE PRECISION 0 1

SAMPLES PK_%table% 15 0 3 1 1 2 PK_SAMPLES PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 PERM_ID NN_%column% 3 0 19

CHARACTER VARYING 40 0 1

NN_%column% 1 0 1 1 5 3 TUC_SAMPLES_1 TUC_%table%_%counter% 2 0 2 2 3 DATA_SETS PK_%table% 21 0 4 1 1 2 PK_DATA_SETS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 EXPE_ID NN_%column% 4 0 11

BIGINT 0 1

NN_%column% 1 0 1 1 5 4 PERM_ID NN_%column% 3 0 19

CHARACTER VARYING 40 0 1

NN_%column% 1 0 1 1 5 3 TUC_DATA_SETS_1 TUC_%table%_%counter% 2 0 2 2 3 EXPERIMENTS PK_%table% 23 0 3 1 1 2 PK_EXPERIMENTS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 PERM_ID NN_%column% 3 0 19

CHARACTER VARYING 40 0 1

NN_%column% 1 0 1 1 5 3 TUC_EXPERIMENTS_1 TUC_%table%_%counter% 2 0 2 2 3 EVENTS NN_%column% 31 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID NN_%column% 2 0 -1

BIGINT 0 1

NN_%column% 1 0 1 1 5 2 COLUMNS PK_%table% 32 0 4 1 1 1 PK_COLUMNS 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% 4 0 11

BIGINT 0 1

NN_%column% 1 0 1 1 5 4 HEADER 3 0 37

CHARACTER VARYING 1000 0 1

1 0 1 1 5 3 DATA_COLUMNS PK_%table% 39 0 18 1 1 1 PK_DATA_COLUMNS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 SAMP_ID NN_%column% 4 0 11

BIGINT 0 1

DASE_ID NN_%column% 5 0 11

BIGINT 0 1

NN_%column% 1 0 1 1 5 5 EXPERIMENT_CODE 3 0 54

CHARACTER VARYING 100 0 1

1 0 1 1 5 3 CULTIVATION_METHOD NN_%column% 6 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 6 BIOLOGICAL_REPLICATE_CODE NN_%column% 7 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 7 TIME_POINT 8 0 61

INTEGER 0 1

1 0 1 1 5 8 TIME_POINT_TYPE NN_%column% 9 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 9 TECHNICAL_REPLICATE_CODE NN_%column% 10 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 10 CELLOC NN_%column% 11 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 11 TIME_SERIES_DATA_SET_TYPE NN_%column% 12 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 12 VALUE_TYPE NN_%column% 13 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 13 SCALE NN_%column% 14 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 14 BI_ID NN_%column% 15 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 15 CONTROLLED_GENE NN_%column% 16 0 54

CHARACTER VARYING 100 0 1

NN_%column% 1 0 1 1 5 16 GROWTH_PHASE 17 0 54

CHARACTER VARYING 100 0 1

GENOTYPE 18 0 54

CHARACTER VARYING 100 0 1

COLUMN_VALUES PK_%table% 40 0 5 1 1 1 PK_COLUMN_VALUES PK_%table% 1 0 2 3 4 5 COLU_ID NN_%column% 4 0 11

BIGINT 0 1

NN_%column% 1 0 1 1 5 4 ROW_ID NN_%column% 5 0 11

BIGINT 0 1

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

CHARACTER VARYING 1000 0 1

ROWS PK_%table% 41 0 2 1 1 1 PK_ROWS PK_%table% 1 0 2 3 2 ID NN_%column% 2 0 -1

BIGSERIAL 0 1

NN_%column% 1 0 1 1 5 2 EXPERIMENTS_DATA_SETS %parent%_%child% 24 0 23 21 0 1 1 0 0 EXPERIMENTS_DATA_SETS %relname% 1 0 2 4 4 0 0 2 4 COLUMNS_COLUMN_VALUES %parent%_%child% 42 0 32 40 0 0 1 0 2 COLUMNS_COLUMN_VALUES %relname% 1 0 2 4 4 0 0 2 4 ROWS_COLUMN_VALUES %parent%_%child% 43 0 41 40 0 0 1 0 0 ROWS_COLUMN_VALUES %relname% 1 0 2 4 5 0 0 2 5 ROWS_DATA_COLUMN_VALUES %parent%_%child% 44 0 41 2 0 0 1 0 0 ROWS_DATA_COLUMN_VALUES %relname% 1 0 2 4 8 0 0 2 8 DATA_COLUMNS_DATA_COLUMN_VALUES %parent%_%child% 45 0 39 2 0 0 1 0 2 DATA_COLUMNS_DATA_COLUMN_VALUES %relname% 1 0 2 4 7 0 0 2 7 SAMPLES_DATA_COLUMNS %parent%_%child% 46 0 15 39 0 1 0 0 0 SAMPLES_DATA_COLUMNS %relname% 1 0 2 4 4 0 0 2 4 DATA_SETS_COLUMNS %parent%_%child% 47 0 21 32 0 1 1 0 2 DATA_SETS_COLUMNS %relname% 1 0 2 4 4 0 0 2 4 DATA_SETS_DATA_COLUMNS %parent%_%child% 48 0 21 39 0 1 1 0 2 DATA_SETS_DATA_COLUMNS %relname% 1 0 2 4 5 0 0 2 5 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 0 0 2 1 146 78 484 529 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 1 132 63 501 16 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 1 135 78 227 16 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 23 1 132 63 11 16 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 31 1 213 48 11 635 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 32 1 136 78 11 184 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 39 1 245 288 387 184 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 40 1 130 78 11 529 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 41 1 100 48 244 544 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 24 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 4921 5000 3974 143 47 211 47 211 47 226 47 42 1 Arial,8,,0,clWindowText,0 0,1,4,0 4779 5000 5000 5000 76 262 76 294 76 294 76 528 43 1 Arial,8,,0,clWindowText,0 0,1,4,0 5000 5000 5000 5000 243 568 204 568 204 568 141 568 44 1 Arial,8,,0,clWindowText,0 0,1,4,0 5000 5000 5000 5000 344 568 378 568 378 568 483 568 45 1 Arial,8,,0,clWindowText,0 0,1,4,0 6951 5000 4966 5000 557 472 557 483 557 483 557 528 46 1 Arial,8,,0,clWindowText,0 1,1,4,0 4924 5000 7306 5000 566 79 566 145 566 145 566 183 47 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 295 94 295 138 79 138 79 183 48 1 Arial,8,,0,clWindowText,0 1,1,4,0 7111 5000 3139 5000 323 94 323 138 464 138 464 183