51 \\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.dez 2011-01-11 2010-06-14 G:\ERD\DeZign\screening\create_postgresql.sql;G:\ERD\DeZign\screening\drop_postgresql.sql;\CreateDBLog_201011261.txt SQLFILE G:\ERD\DeZign\screening\schema-009.sql postgresql83 postgresql83 65 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 G:\ERD\DeZign\screening\create_postgresql.sql G:\ERD\DeZign\screening\drop_postgresql.sql TECH_ID 2 0

BIGINT 0 1

CODE 3 0

CHARACTER VARYING 40 0 1

NAME 4 0

CHARACTER VARYING 80 0 1

DESCRIPTION 5 0

CHARACTER VARYING 200 0 1

FILE_PATH 6 0

CHARACTER VARYING 1000 0 1

COLOR_COMPONENT 7 0

CHARACTER VARYING 40 0 1

0 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 BOOLEAN_CHAR 41 0

BOOLEAN 0 1

0 0 FALSE 1 6 EXPERIMENTS 8 0 7 1 1 3 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 IMAGE_TRANSFORMER_FACTORY 7 0 -1

BYTEA 0 1

3 0 2 2 3 CONTAINERS CONTAINERS_EXPE_IDX 9 0 6 2 1 3 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 SPOTS_WIDTH 4 0 -1

INTEGER 0 1

SPOTS_HEIGHT 5 0 -1

INTEGER 0 1

EXPE_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 CONTAINERS_EXPE_IDX CONTAINERS_EXPE_IDX 2 0 0 0 EXPE_ID 0 0 6 3 0 2 2 3 SPOTS SPOTS_CONT_IDX 11 0 6 3 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 4 0 -1

INTEGER 0 1

Y 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 SPOTS_CONT_IDX SPOTS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 SPOTS_COORDS_IDX SPOTS_COORDS_IDX 3 0 0 0 CONT_ID 0 0 6 X 0 0 4 Y 0 0 5 DATA_SETS DATA_SETS_CONT_IDX 13 0 8 2 1 3 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 FIELDS_WIDTH 4 0 -1

INTEGER 0 1

FIELDS_HEIGHT 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

IS_MULTIDIMENSIONAL 7 0 41

BOOLEAN 0 1

1 0 1 1 5 7 1 0 FALSE 1 6 7 IMAGE_TRANSFORMER_FACTORY 8 0 -1

BYTEA 0 1

DATA_SETS_CONT_IDX DATA_SETS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 3 0 2 2 3 CHANNELS CHANNELS_DS_IDX 15 0 9 2 1 4 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 8 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 8 LABEL 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

WAVELENGTH 5 0 -1

INTEGER 0 1

IMAGE_TRANSFORMER_FACTORY 9 0 -1

BYTEA 0 1

DS_ID 6 0 2

BIGINT 0 1

EXP_ID 7 0 2

BIGINT 0 1

CHANNELS_DS_IDX CHANNELS_DS_IDX 2 0 0 0 DS_ID 0 0 6 CHANNELS_DS_EXP_ARC_CK CHANNELS_DS_EXP_ARC_CK 2 0 (DS_ID IS NOT NULL AND EXP_ID IS NULL) OR (DS_ID IS NULL AND EXP_ID IS NOT NULL) 2 1 2 6 7 CHANNELS_UK_1 CHANNELS_UK_1 3 0 2 2 8 6 CHANNELS_UK_2 CHANNELS_UK_2 4 0 2 2 8 7 CHANNEL_STACKS CHANNEL_STACKS_DS_IDX 18 0 17 4 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 3 0 -1

INTEGER 0 1

Y 4 0 -1

INTEGER 0 1

Z_in_M 5 0 -1

REAL 0 1

T_in_SEC 6 0 -1

REAL 0 1

SERIES_NUMBER 16 0 -1

INTEGER 0 1

is_representative 17 0 41

BOOLEAN 0 1

1 0 1 1 5 17 2 0 FALSE 1 6 17 DS_ID 7 0 2

BIGINT 0 1

1 0 1 1 5 7 SPOT_ID 8 0 2

BIGINT 0 1

CHANNEL_STACKS_DS_IDX CHANNEL_STACKS_DS_IDX 2 0 0 0 DS_ID 0 0 7 CHANNEL_STACKS_SPOT_IDX CHANNEL_STACKS_SPOT_IDX 3 0 0 0 SPOT_ID 0 0 8 CHANNEL_STACKS_DIM_IDX CHANNEL_STACKS_DIM_IDX 4 0 0 0 X 0 0 3 Y 0 0 4 Z_in_M 0 0 5 T_in_SEC 0 0 6 IMAGES 21 0 5 1 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PATH 3 0 6

CHARACTER VARYING 1000 0 1

1 0 1 1 5 3 PAGE 4 0 -1

INTEGER 0 1

COLOR 5 0 7

CHARACTER VARYING 40 0 1

3 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 5 ACQUIRED_IMAGES IMAGES_CHANNEL_STACK_IDX 22 0 6 5 2 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 IMG_ID 3 0 2

BIGINT 0 1

1 0 1 1 5 3 THUMBNAIL_ID 4 0 2

BIGINT 0 1

CHANNEL_STACK_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 CHANNEL_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IMAGES_CHANNEL_STACK_IDX IMAGES_CHANNEL_STACK_IDX 2 0 0 0 CHANNEL_STACK_ID 0 0 5 IMAGES_CHANNEL_IDX IMAGES_CHANNEL_IDX 3 0 0 0 CHANNEL_ID 0 0 6 IMAGES_IMG_IDX IMAGES_IMG_IDX 4 0 0 0 IMG_ID 0 0 3 IMAGES_THUMBNAIL_IDX IMAGES_THUMBNAIL_IDX 5 0 0 0 THUMBNAIL_ID 0 0 4 UNUSED_IMAGES 2 0 CREATE TRIGGER %triggername% AFTER DELETE ON ACQUIRED_IMAGES FOR EACH ROW EXECUTE PROCEDURE DELETE_%triggername%(); CREATE OR REPLACE FUNCTION CHANNEL_STACKS_CHECK() RETURNS trigger AS $$ DECLARE v_cont_id CODE; BEGIN select cont_id into v_cont_id from data_sets where id = NEW.ds_id; if v_cont_id IS NULL then if NEW.spot_id IS NOT NULL then RAISE EXCEPTION 'Insert/Update of CHANNEL_STACKS failed, as the dataset container is not set, but spot is (spot id = %).',NEW.spot_id; end if; else if NEW.spot_id IS NULL then RAISE EXCEPTION 'Insert/Update of CHANNEL_STACKS failed, as the dataset container is set (id = %), but spot is not set.',v_cont_id; end if; end if; RETURN NEW; END; EVENTS 27 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID 2 0 2

BIGINT 0 1

1 0 1 1 5 2 FEATURE_DEFS FEATURE_DEFS_DS_IDX 28 0 6 2 1 2 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 6 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 6 LABEL 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

DS_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 FEATURE_DEFS_DS_IDX FEATURE_DEFS_DS_IDX 2 0 0 0 DS_ID 0 0 5 FEATURE_DEFS_UK_1 FEATURE_DEFS_UK_1 2 0 2 2 6 5 FEATURE_VALUES FEATURE_VALUES_FD_IDX 30 0 11 4 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 Z_in_M 3 0 -1

REAL 0 1

T_in_SEC 4 0 -1

REAL 0 1

VALUES 11 0 -1

BYTEA 0 1

1 0 1 1 5 11 FD_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 FEATURE_VALUES_FD_IDX FEATURE_VALUES_FD_IDX 2 0 0 0 FD_ID 0 0 6 FEATURE_VALUES_Z_AND_T_IDX FEATURE_VALUES_Z_AND_T_IDX 4 0 0 0 Z_in_M 0 0 3 T_in_SEC 0 0 4 FEATURE_VOCABULARY_TERMS FEATURE_VOCABULARY_TERMS_FD_IDX 43 0 5 2 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 SEQUENCE_NUMBER 4 0 -1

INTEGER 0 1

1 0 1 1 5 4 FD_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 FEATURE_VOCABULARY_TERMS_FD_IDX FEATURE_VOCABULARY_TERMS_FD_IDX 2 0 0 0 FD_ID 0 0 5 Groupbox1 34 0 ARC FK_SAMPLE_1 FK_SAMPLE_1 10 0 8 9 0 1 1 2 2 FK_SAMPLE_1 FK_SAMPLE_1 1 0 2 4 6 0 0 2 6 FK_SPOT_1 FK_SPOT_1 12 0 9 11 0 1 1 2 2 FK_SPOT_1 FK_SPOT_1 1 0 2 4 6 0 0 2 6 FK_DATA_SET_1 FK_DATA_SET_1 14 0 9 13 0 1 0 2 2 FK_DATA_SET_1 FK_DATA_SET_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_1 FK_CHANNELS_1 16 0 13 15 0 1 0 2 2 FK_CHANNELS_1 FK_CHANNELS_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_2 FK_CHANNELS_2 17 0 8 15 0 1 0 2 2 FK_CHANNELS_2 FK_CHANNELS_2 1 0 2 4 7 0 0 2 7 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 19 0 11 18 0 1 0 2 2 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 1 0 2 4 8 0 0 2 8 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 20 0 13 18 0 1 1 2 2 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 1 0 2 4 7 0 0 2 7 FK_IMAGES_1 FK_IMAGES_1 23 0 18 22 0 1 1 2 2 FK_IMAGES_1 FK_IMAGES_1 1 0 2 4 5 0 0 2 5 FK_IMAGES_2 FK_IMAGES_2 24 0 15 22 0 1 1 2 2 FK_IMAGES_2 FK_IMAGES_2 1 0 2 4 6 0 0 2 6 FK_IMAGES_3 FK_IMAGES_3 25 0 21 22 0 1 1 2 2 FK_IMAGES_3 FK_IMAGES_3 1 0 2 4 3 0 0 2 3 FK_IMAGES_4 FK_IMAGES_4 26 0 21 22 0 1 0 2 2 FK_IMAGES_4 FK_IMAGES_4 1 0 2 4 4 0 0 2 4 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 29 0 13 28 0 1 1 2 2 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 1 0 2 4 5 0 0 2 5 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 31 0 28 30 0 1 1 2 2 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 1 0 2 4 6 0 0 2 6 FK_FEATURE_VOCABULARY_TERMS_1 FK_FEATURE_VOCABULARY_TERMS_1 42 0 28 43 0 1 1 2 2 FK_FEATURE_VOCABULARY_TERMS_1 FK_FEATURE_VOCABULARY_TERMS_1 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 8421376 0 0 0 1 1 0 0 2 HCS Images 0 8421376 0 2 0 1 1 1 0 3 Feature Vectors 0 8421376 0 0 0 1 1 0 0 4 Microscopy Images 0 8421376 0 0 0 1 1 0 0 8 1 198 78 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 1 104 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 1 77 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 1 198 138 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 1 198 153 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 1 115 168 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 1 64 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 1 138 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 1 175 48 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 28 1 94 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 1 110 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 43 1 191 93 20 468 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 8 2 260 78 286 12 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 2 166 108 90 150 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 2 143 93 0 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 2 289 138 210 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 2 269 153 545 535 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 2 207 168 87 524 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 2 175 93 288 916 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 2 204 108 274 733 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 2 226 48 551 955 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 3 198 138 34 336 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 4 12632256 5 12632256 6 12632256 7 12632256 8 12632256 28 3 94 108 376 350 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 3 110 108 367 525 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 43 3 191 93 548 357 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 3 104 108 83 170 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 4 12632256 5 12632256 8 3 198 78 36 23 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 7 12632256 22 4 138 108 58 644 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 4 115 168 70 401 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 4 198 153 363 216 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 4 198 138 29 216 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 4 64 93 94 819 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 34 2 101 22 677 489 0,8421504 0,0,4,0 Arial,8,,0,clWindowText,0 0 0 0 0 10 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 147 139 147 154 99 154 12 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 154 150 154 150 146 99 146 14 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 204 154 162 154 162 169 298 169 16 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 169 173 169 173 176 99 176 17 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 157 139 157 176 99 176 19 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 177 146 165 146 165 184 215 184 20 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 169 177 169 177 184 99 184 23 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 215 184 169 184 169 154 238 154 24 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 176 165 176 165 154 99 154 25 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 26 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 29 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 169 162 169 162 154 99 154 31 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 194 154 154 154 154 154 210 154 42 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 147 208 147 338 116 338 116 467 10 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 416 90 416 127 173 127 173 149 12 2 Arial,8,,0,clWindowText,0 1,1,4,0 1566 5000 8112 5000 116 258 116 279 116 279 116 329 14 2 Arial,8,,0,clWindowText,0 1,1,4,0 8614 5000 796 5000 233 258 233 279 233 279 233 329 16 2 Arial,8,,0,clWindowText,0 1,1,4,0 6566 5000 5500 5000 400 468 400 491 693 491 693 534 17 2 Arial,8,,0,clWindowText,0 1,1,4,0 6808 5000 8294 5000 463 90 463 128 768 128 768 534 19 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 72 423 72 489 180 489 180 523 20 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 5500 5000 340 468 340 489 201 489 201 523 23 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 191 692 191 706 366 706 366 732 24 2 Arial,8,,0,clWindowText,0 1,1,4,0 2007 5000 5500 5000 599 688 599 706 386 706 386 732 25 2 Arial,8,,0,clWindowText,0 1,1,4,0 4457 5000 4500 5000 366 915 366 901 366 901 366 841 26 2 Arial,8,,0,clWindowText,0 1,1,4,0 6571 5000 6324 5000 403 915 403 901 403 901 403 841 29 3 Arial,8,,0,clWindowText,0 1,1,4,0 5000 4928 5000 5000 232 404 304 404 304 404 375 404 31 3 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 423 458 423 480 422 480 422 524 42 3 Arial,8,,0,clWindowText,0 1,1,4,0 5000 4907 5000 4946 470 403 499 403 499 403 547 403 10 3 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 135 101 135 125 135 125 135 169 14 3 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5101 5000 135 278 135 303 135 303 135 335 16 4 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 4510 227 285 297 285 297 285 362 285 20 4 Arial,8,,0,clWindowText,0 1,1,4,0 4949 5000 4957 5000 127 354 127 384 127 384 127 400 23 4 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 128 569 128 587 127 587 127 643 24 4 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 462 369 462 495 127 495 127 643 25 4 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 126 818 126 767 127 767 127 752 26 4 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4928 5000 126 818 126 767 126 767 126 752 1 Archived model before update 2010-11-26 2010-11-26 15:59 This version has been archived automatically before updating from the database. Diagrams and data dictionary \\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.dez 2010-11-26 2010-06-14 G:\ERD\DeZign\screening\create_postgresql.sql;G:\ERD\DeZign\screening\drop_postgresql.sql;\CreateDBLog_201011261.txt SQLFILE G:\ERD\DeZign\screening\schema-008.sql postgresql83 postgresql83 43 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 G:\ERD\DeZign\screening\create_postgresql.sql G:\ERD\DeZign\screening\drop_postgresql.sql TECH_ID 2 0

BIGINT 0 1

CODE 3 0

CHARACTER VARYING 40 0 1

NAME 4 0

CHARACTER VARYING 80 0 1

DESCRIPTION 5 0

CHARACTER VARYING 200 0 1

FILE_PATH 6 0

CHARACTER VARYING 1000 0 1

COLOR_COMPONENT 7 0

CHARACTER VARYING 40 0 1

0 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 BOOLEAN_CHAR 41 0

BOOLEAN 0 1

0 0 FALSE 1 6 EXPERIMENTS 8 0 4 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 3

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 IMAGE_TRANSFORMER_FACTORY BYTEA 4 0 -1

BYTEA 0 1

TUC_EXPERIMENTS_1 TUC_%table%_%counter% 2 0 2 2 3 CONTAINERS CONTAINERS_EXPE_IDX 9 0 6 2 1 2 PK_CONTAINERS PK_%table% 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 SPOTS_WIDTH 4 0 -1

INTEGER 0 1

SPOTS_HEIGHT 5 0 -1

INTEGER 0 1

EXPE_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 CONTAINERS_EXPE_IDX CONTAINERS_EXPE_IDX 2 0 0 0 EXPE_ID 0 0 6 TUC_CONTAINERS_1 TUC_%table%_%counter% 2 0 2 2 3 SPOTS SPOTS_CONT_IDX 11 0 6 3 1 2 PK_SPOTS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 4 0 -1

INTEGER 0 1

Y 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 SPOTS_CONT_IDX SPOTS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 SPOTS_COORDS_IDX SPOTS_COORDS_IDX 3 0 0 0 X 0 0 4 Y 0 0 5 CONT_ID 0 0 6 DATA_SETS DATA_SETS_CONT_IDX 13 0 7 2 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 PERM_ID 3 0 3

CHARACTER VARYING 40 0 1

1 0 1 1 5 3 FIELDS_WIDTH 4 0 -1

INTEGER 0 1

FIELDS_HEIGHT 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IS_MULTIDIMENSIONAL 7 0 41

BOOLEAN 0 1

NN_%column% 1 0 1 1 5 7 DEF_%table%_%column% 2 0 FALSE 1 6 7 DATA_SETS_CONT_IDX DATA_SETS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 TUC_DATA_SETS_1 TUC_%table%_%counter% 2 0 2 2 3 CHANNELS CHANNELS_DS_IDX 15 0 9 2 1 4 PK_CHANNELS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 8 0 4

CHARACTER VARYING 80 0 1

NN_%column% 1 0 1 1 5 8 CC_CHANNELS_CODE CC_%table%_%column% 3 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 8 LABEL 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

WAVELENGTH 5 0 -1

INTEGER 0 1

DS_ID 6 0 2

BIGINT 0 1

EXP_ID 7 0 2

BIGINT 0 1

IMAGE_TRANSFORMER_FACTORY 9 0 -1

BYTEA 0 1

CHANNELS_DS_IDX CHANNELS_DS_IDX 2 0 0 0 DS_ID 0 0 6 CHANNELS_DS_EXP_ARC_CK CHANNELS_DS_EXP_ARC_CK 2 0 (DS_ID IS NOT NULL AND EXP_ID IS NULL) OR (DS_ID IS NULL AND EXP_ID IS NOT NULL) 2 1 2 6 7 CHANNELS_UK_1 CHANNELS_UK_1 3 0 2 2 6 8 CHANNELS_UK_2 CHANNELS_UK_2 4 0 2 2 7 8 CHANNEL_STACKS CHANNEL_STACKS_DS_IDX 18 0 8 4 1 1 PK_CHANNEL_STACKS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 3 0 -1

INTEGER 0 1

Y 4 0 -1

INTEGER 0 1

Z_in_M 5 0 -1

REAL 0 1

T_in_SEC 6 0 -1

REAL 0 1

DS_ID 7 0 2

BIGINT 0 1

1 0 1 1 5 7 SPOT_ID 8 0 2

BIGINT 0 1

1 0 1 1 5 8 CHANNEL_STACKS_DS_IDX CHANNEL_STACKS_DS_IDX 2 0 0 0 DS_ID 0 0 7 CHANNEL_STACKS_SPOT_IDX CHANNEL_STACKS_SPOT_IDX 3 0 0 0 SPOT_ID 0 0 8 CHANNEL_STACKS_DIM_IDX CHANNEL_STACKS_DIM_IDX 4 0 0 0 X 0 0 3 Y 0 0 4 Z_in_M 0 0 5 T_in_SEC 0 0 6 IMAGES 21 0 5 1 1 1 PK_IMAGES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PATH 3 0 6

CHARACTER VARYING 1000 0 1

1 0 1 1 5 3 PAGE 4 0 -1

INTEGER 0 1

COLOR 5 0 7

CHARACTER VARYING 40 0 1

3 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 5 ACQUIRED_IMAGES IMAGES_CHANNEL_STACK_IDX 22 0 6 5 2 1 PK_ACQUIRED_IMAGES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 IMG_ID 3 0 2

BIGINT 0 1

1 0 1 1 5 3 THUMBNAIL_ID 4 0 2

BIGINT 0 1

CHANNEL_STACK_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 CHANNEL_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IMAGES_CHANNEL_STACK_IDX IMAGES_CHANNEL_STACK_IDX 2 0 0 0 CHANNEL_STACK_ID 0 0 5 IMAGES_CHANNEL_IDX IMAGES_CHANNEL_IDX 3 0 0 0 CHANNEL_ID 0 0 6 IMAGES_IMG_IDX IMAGES_IMG_IDX 4 0 0 0 IMG_ID 0 0 3 IMAGES_THUMBNAIL_IDX IMAGES_THUMBNAIL_IDX 5 0 0 0 THUMBNAIL_ID 0 0 4 UNUSED_IMAGES 2 0 CREATE TRIGGER UNUSED_IMAGES AFTER DELETE ON ACQUIRED_IMAGES FOR EACH ROW EXECUTE PROCEDURE DELETE_UNUSED_IMAGES(); EVENTS 27 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID 2 0 2

BIGINT 0 1

1 0 1 1 5 2 FEATURE_DEFS FEATURE_DEFS_DS_IDX 28 0 6 2 1 2 PK_FEATURE_DEFS PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 6 0 4

CHARACTER VARYING 80 0 1

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

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

DS_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 FEATURE_DEFS_DS_IDX FEATURE_DEFS_DS_IDX 2 0 0 0 DS_ID 0 0 5 FEATURE_DEFS_UK_1 FEATURE_DEFS_UK_1 2 0 2 2 5 6 FEATURE_VALUES FEATURE_VALUES_FD_IDX 30 0 7 4 1 1 PK_FEATURE_VALUES PK_%table% 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 Z_in_M 3 0 -1

REAL 0 1

T_in_SEC 4 0 -1

REAL 0 1

_VALUES 5 0 -1

BYTEA 0 1

1 0 1 1 5 5 FD_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 DS_ID 7 0 2

BIGINT 0 1

1 0 1 1 5 7 FEATURE_VALUES_FD_IDX FEATURE_VALUES_FD_IDX 2 0 0 0 FD_ID 0 0 6 FEATURE_VALUES_DS_IDX FEATURE_VALUES_DS_IDX 3 0 0 0 DS_ID 0 0 7 FEATURE_VALUES_Z_AND_T_IDX FEATURE_VALUES_Z_AND_T_IDX 4 0 0 0 Z_in_M 0 0 3 T_in_SEC 0 0 4 Groupbox1 34 0 ARC DELETE_UNUSED_IMAGES 42 0 CREATE OR REPLACE FUNCTION DELETE_UNUSED_IMAGES() RETURNS trigger AS $$ BEGIN delete from images where id = OLD.img_id or id = OLD.thumbnail_id; RETURN NEW; END; $$ LANGUAGE 'plpgsql'; FK_SAMPLE_1 FK_SAMPLE_1 10 0 8 9 0 1 1 2 2 FK_SAMPLE_1 FK_SAMPLE_1 1 0 2 4 6 0 0 2 6 FK_SPOT_1 FK_SPOT_1 12 0 9 11 0 1 1 2 2 FK_SPOT_1 FK_SPOT_1 1 0 2 4 6 0 0 2 6 FK_DATA_SET_1 FK_DATA_SET_1 14 0 9 13 0 1 1 2 2 FK_DATA_SET_1 FK_DATA_SET_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_1 FK_CHANNELS_1 16 0 13 15 0 1 0 2 2 FK_CHANNELS_1 FK_CHANNELS_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_2 FK_CHANNELS_2 17 0 8 15 0 1 0 2 2 FK_CHANNELS_2 FK_CHANNELS_2 1 0 2 4 7 0 0 2 7 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 19 0 11 18 0 1 1 2 2 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 1 0 2 4 8 0 0 2 8 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 20 0 13 18 0 1 1 2 2 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 1 0 2 4 7 0 0 2 7 FK_IMAGES_1 FK_IMAGES_1 23 0 18 22 0 1 1 2 2 FK_IMAGES_1 FK_IMAGES_1 1 0 2 4 5 0 0 2 5 FK_IMAGES_2 FK_IMAGES_2 24 0 15 22 0 1 1 2 2 FK_IMAGES_2 FK_IMAGES_2 1 0 2 4 6 0 0 2 6 FK_IMAGES_3 FK_IMAGES_3 25 0 21 22 0 1 1 2 2 FK_IMAGES_3 FK_IMAGES_3 1 0 2 4 3 0 0 2 3 FK_IMAGES_4 FK_IMAGES_4 26 0 21 22 0 1 0 2 2 FK_IMAGES_4 FK_IMAGES_4 1 0 2 4 4 0 0 2 4 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 29 0 13 28 0 1 1 2 2 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 1 0 2 4 5 0 0 2 5 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 31 0 28 30 0 1 1 2 2 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 1 0 2 4 6 0 0 2 6 FK_FEATURE_VALUES_2 FK_FEATURE_VALUES_2 32 0 13 30 0 1 1 2 2 FK_FEATURE_VALUES_2 FK_FEATURE_VALUES_2 1 0 2 4 7 0 0 2 7 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 0 0 1 1 0 0 2 Diagram_1 0 8421376 0 2 0 1 1 1 0 8 1 236 78 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 1 104 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 1 77 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 1 139 123 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 1 198 153 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 1 115 138 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 1 64 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 1 138 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 1 175 48 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 28 1 94 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 1 110 123 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 8 2 298 78 301 0 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 2 166 108 90 150 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 2 143 93 0 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 2 234 123 210 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 2 269 153 660 540 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 2 141 138 90 510 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 2 175 93 570 930 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 2 204 108 270 720 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 2 226 48 30 1050 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 28 2 164 108 570 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 2 141 123 540 120 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 34 2 82 22 734 497 0,8421504 0,0,4,0 Arial,8,,0,clWindowText,0 0 0 0 0 10 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 147 139 147 154 99 154 12 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 154 150 154 150 146 99 146 14 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 204 154 158 154 158 162 239 162 16 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 239 162 169 162 169 176 298 176 17 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 157 139 157 176 99 176 19 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 177 146 158 146 158 169 215 169 20 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 162 165 162 165 169 99 169 23 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 215 169 162 169 162 154 238 154 24 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 176 165 176 165 154 99 154 25 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 26 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 29 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 162 158 162 158 154 99 154 31 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 194 154 158 154 158 162 210 162 32 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 162 161 162 161 162 99 162 10 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 450 78 450 91 173 91 173 149 12 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 173 258 173 279 72 279 72 329 14 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 173 258 173 279 327 279 327 329 16 2 Arial,8,,0,clWindowText,0 1,1,4,0 6566 5000 5500 5000 364 453 364 487 808 487 808 539 17 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 8294 5000 450 78 450 89 883 89 883 539 19 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 72 423 72 489 153 489 153 509 20 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 5500 5000 315 453 315 489 168 489 168 509 23 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 160 648 160 684 362 684 362 719 24 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 5500 5000 781 693 781 706 382 706 382 719 25 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 4500 5000 649 929 649 894 362 894 362 828 26 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 5500 5000 666 929 666 875 382 875 382 828 29 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 4500 5806 444 392 507 392 507 393 569 393 31 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 5000 5000 660 329 660 301 610 301 610 243 32 2 Arial,8,,0,clWindowText,0 1,1,4,0 7651 2870 1544 5000 389 329 389 301 562 301 562 243 2 Archived model before update 2011-01-11 2011-01-11 17:11 This version has been archived automatically before updating from the database. Diagrams and data dictionary \\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.dez 2010-11-26 2010-06-14 G:\ERD\DeZign\screening\create_postgresql.sql;G:\ERD\DeZign\screening\drop_postgresql.sql;\CreateDBLog_201011261.txt SQLFILE G:\ERD\DeZign\screening\schema-009.sql postgresql83 postgresql83 41 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 G:\ERD\DeZign\screening\create_postgresql.sql G:\ERD\DeZign\screening\drop_postgresql.sql TECH_ID 2 0

BIGINT 0 1

CODE 3 0

CHARACTER VARYING 40 0 1

NAME 4 0

CHARACTER VARYING 80 0 1

DESCRIPTION 5 0

CHARACTER VARYING 200 0 1

FILE_PATH 6 0

CHARACTER VARYING 1000 0 1

COLOR_COMPONENT 7 0

CHARACTER VARYING 40 0 1

0 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 BOOLEAN_CHAR 41 0

BOOLEAN 0 1

0 0 FALSE 1 6 EXPERIMENTS 8 0 7 1 1 3 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 IMAGE_TRANSFORMER_FACTORY 7 0 -1

BYTEA 0 1

3 0 2 2 3 CONTAINERS CONTAINERS_EXPE_IDX 9 0 6 2 1 3 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 SPOTS_WIDTH 4 0 -1

INTEGER 0 1

SPOTS_HEIGHT 5 0 -1

INTEGER 0 1

EXPE_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 CONTAINERS_EXPE_IDX CONTAINERS_EXPE_IDX 2 0 0 0 EXPE_ID 0 0 6 3 0 2 2 3 SPOTS SPOTS_CONT_IDX 11 0 6 3 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 4 0 -1

INTEGER 0 1

Y 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 SPOTS_CONT_IDX SPOTS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 SPOTS_COORDS_IDX SPOTS_COORDS_IDX 3 0 0 0 CONT_ID 0 0 6 X 0 0 4 Y 0 0 5 DATA_SETS DATA_SETS_CONT_IDX 13 0 7 2 1 3 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 FIELDS_WIDTH 4 0 -1

INTEGER 0 1

FIELDS_HEIGHT 5 0 -1

INTEGER 0 1

CONT_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IS_MULTIDIMENSIONAL 7 0 41

BOOLEAN 0 1

1 0 1 1 5 7 1 0 FALSE 1 6 7 DATA_SETS_CONT_IDX DATA_SETS_CONT_IDX 2 0 0 0 CONT_ID 0 0 6 3 0 2 2 3 CHANNELS CHANNELS_DS_IDX 15 0 9 2 1 4 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 8 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 8 LABEL 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

WAVELENGTH 5 0 -1

INTEGER 0 1

IMAGE_TRANSFORMER_FACTORY 9 0 -1

BYTEA 0 1

DS_ID 6 0 2

BIGINT 0 1

EXP_ID 7 0 2

BIGINT 0 1

CHANNELS_DS_IDX CHANNELS_DS_IDX 2 0 0 0 DS_ID 0 0 6 CHANNELS_DS_EXP_ARC_CK CHANNELS_DS_EXP_ARC_CK 2 0 (DS_ID IS NOT NULL AND EXP_ID IS NULL) OR (DS_ID IS NULL AND EXP_ID IS NOT NULL) 2 1 2 6 7 CHANNELS_UK_1 CHANNELS_UK_1 3 0 2 2 8 6 CHANNELS_UK_2 CHANNELS_UK_2 4 0 2 2 8 7 CHANNEL_STACKS CHANNEL_STACKS_DS_IDX 18 0 8 4 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 X 3 0 -1

INTEGER 0 1

Y 4 0 -1

INTEGER 0 1

Z_in_M 5 0 -1

REAL 0 1

T_in_SEC 6 0 -1

REAL 0 1

DS_ID 7 0 2

BIGINT 0 1

1 0 1 1 5 7 SPOT_ID 8 0 2

BIGINT 0 1

1 0 1 1 5 8 CHANNEL_STACKS_DS_IDX CHANNEL_STACKS_DS_IDX 2 0 0 0 DS_ID 0 0 7 CHANNEL_STACKS_SPOT_IDX CHANNEL_STACKS_SPOT_IDX 3 0 0 0 SPOT_ID 0 0 8 CHANNEL_STACKS_DIM_IDX CHANNEL_STACKS_DIM_IDX 4 0 0 0 X 0 0 3 Y 0 0 4 Z_in_M 0 0 5 T_in_SEC 0 0 6 IMAGES 21 0 5 1 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 PATH 3 0 6

CHARACTER VARYING 1000 0 1

1 0 1 1 5 3 PAGE 4 0 -1

INTEGER 0 1

COLOR 5 0 7

CHARACTER VARYING 40 0 1

3 0 VALUE IN ('RED', 'GREEN', 'BLUE') 1 1 5 ACQUIRED_IMAGES IMAGES_CHANNEL_STACK_IDX 22 0 6 5 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 IMG_ID 3 0 2

BIGINT 0 1

1 0 1 1 5 3 THUMBNAIL_ID 4 0 2

BIGINT 0 1

CHANNEL_STACK_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 CHANNEL_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 IMAGES_CHANNEL_STACK_IDX IMAGES_CHANNEL_STACK_IDX 2 0 0 0 CHANNEL_STACK_ID 0 0 5 IMAGES_CHANNEL_IDX IMAGES_CHANNEL_IDX 3 0 0 0 CHANNEL_ID 0 0 6 IMAGES_IMG_IDX IMAGES_IMG_IDX 4 0 0 0 IMG_ID 0 0 3 IMAGES_THUMBNAIL_IDX IMAGES_THUMBNAIL_IDX 5 0 0 0 THUMBNAIL_ID 0 0 4 EVENTS 27 0 2 1 1 1 LAST_SEEN_DELETION_EVENT_ID 2 0 2

BIGINT 0 1

1 0 1 1 5 2 FEATURE_DEFS FEATURE_DEFS_DS_IDX 28 0 6 2 1 2 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 CODE 6 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 6 LABEL 3 0 4

CHARACTER VARYING 80 0 1

1 0 1 1 5 3 DESCRIPTION 4 0 5

CHARACTER VARYING 200 0 1

DS_ID 5 0 2

BIGINT 0 1

1 0 1 1 5 5 FEATURE_DEFS_DS_IDX FEATURE_DEFS_DS_IDX 2 0 0 0 DS_ID 0 0 5 FEATURE_DEFS_UK_1 FEATURE_DEFS_UK_1 2 0 2 2 6 5 FEATURE_VALUES FEATURE_VALUES_FD_IDX 30 0 11 4 1 1 1 0 2 3 2 ID 2 0 -1

BIGSERIAL 0 1

1 0 1 1 5 2 Z_in_M 3 0 -1

REAL 0 1

T_in_SEC 4 0 -1

REAL 0 1

VALUES 11 0 -1

BYTEA 0 1

1 0 1 1 5 11 FD_ID 6 0 2

BIGINT 0 1

1 0 1 1 5 6 FEATURE_VALUES_FD_IDX FEATURE_VALUES_FD_IDX 2 0 0 0 FD_ID 0 0 6 FEATURE_VALUES_Z_AND_T_IDX FEATURE_VALUES_Z_AND_T_IDX 4 0 0 0 Z_in_M 0 0 3 T_in_SEC 0 0 4 Groupbox1 34 0 ARC FK_SAMPLE_1 FK_SAMPLE_1 10 0 8 9 0 1 1 2 2 FK_SAMPLE_1 FK_SAMPLE_1 1 0 2 4 6 0 0 2 6 FK_SPOT_1 FK_SPOT_1 12 0 9 11 0 1 1 2 2 FK_SPOT_1 FK_SPOT_1 1 0 2 4 6 0 0 2 6 FK_DATA_SET_1 FK_DATA_SET_1 14 0 9 13 0 1 1 2 2 FK_DATA_SET_1 FK_DATA_SET_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_1 FK_CHANNELS_1 16 0 13 15 0 1 0 2 2 FK_CHANNELS_1 FK_CHANNELS_1 1 0 2 4 6 0 0 2 6 FK_CHANNELS_2 FK_CHANNELS_2 17 0 8 15 0 1 0 2 2 FK_CHANNELS_2 FK_CHANNELS_2 1 0 2 4 7 0 0 2 7 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 19 0 11 18 0 1 1 2 2 FK_CHANNEL_STACKS_1 FK_CHANNEL_STACKS_1 1 0 2 4 8 0 0 2 8 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 20 0 13 18 0 1 1 2 2 FK_CHANNEL_STACKS_2 FK_CHANNEL_STACKS_2 1 0 2 4 7 0 0 2 7 FK_IMAGES_1 FK_IMAGES_1 23 0 18 22 0 1 1 2 2 FK_IMAGES_1 FK_IMAGES_1 1 0 2 4 5 0 0 2 5 FK_IMAGES_2 FK_IMAGES_2 24 0 15 22 0 1 1 2 2 FK_IMAGES_2 FK_IMAGES_2 1 0 2 4 6 0 0 2 6 FK_IMAGES_3 FK_IMAGES_3 25 0 21 22 0 1 1 2 2 FK_IMAGES_3 FK_IMAGES_3 1 0 2 4 3 0 0 2 3 FK_IMAGES_4 FK_IMAGES_4 26 0 21 22 0 1 0 2 2 FK_IMAGES_4 FK_IMAGES_4 1 0 2 4 4 0 0 2 4 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 29 0 13 28 0 1 1 2 2 FK_FEATURE_DEFS_1 FK_FEATURE_DEFS_1 1 0 2 4 5 0 0 2 5 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 31 0 28 30 0 1 1 2 2 FK_FEATURE_VALUES_1 FK_FEATURE_VALUES_1 1 0 2 4 6 0 0 2 6 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 0 0 1 1 0 0 2 Diagram_1 0 8421376 0 2 0 1 1 1 0 8 1 198 78 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 1 104 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 1 77 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 1 139 123 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 1 198 153 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 1 115 138 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 1 64 93 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 1 138 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 1 175 48 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 28 1 94 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 1 110 108 100 100 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 8 2 260 78 301 0 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 9 2 166 108 90 150 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 11 2 143 93 0 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 13 2 234 123 210 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 15 2 269 153 660 540 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 18 2 141 138 90 510 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 21 2 175 93 570 930 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 22 2 204 108 270 720 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 27 2 226 48 30 1050 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 28 2 164 108 570 330 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 30 2 136 108 540 120 0,16777215 0,1,4,0 Arial,8,,0,clWindowText,0 0 1 34 2 82 22 806 494 0,8421504 0,0,4,0 Arial,8,,0,clWindowText,0 0 0 0 0 10 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 147 139 147 154 99 154 12 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 154 150 154 150 146 99 146 14 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 204 154 158 154 158 162 239 162 16 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 239 162 169 162 169 176 298 176 17 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 139 157 139 157 176 99 176 19 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 177 146 158 146 158 169 215 169 20 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 162 165 162 165 169 99 169 23 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 215 169 162 169 162 154 238 154 24 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 176 165 176 165 154 99 154 25 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 26 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 164 146 150 146 150 154 99 154 29 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 99 162 158 162 158 154 99 154 31 1 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 194 154 154 154 154 154 210 154 10 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 431 78 431 91 173 91 173 149 12 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 173 258 173 279 72 279 72 329 14 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 5000 5000 173 258 173 279 327 279 327 329 16 2 Arial,8,,0,clWindowText,0 1,1,4,0 6566 5000 5500 5000 364 453 364 487 808 487 808 539 17 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 8294 5000 431 78 431 89 883 89 883 539 19 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 72 423 72 489 153 489 153 509 20 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 5500 5000 315 453 315 489 168 489 168 509 23 2 Arial,8,,0,clWindowText,0 1,1,4,0 5000 5000 4500 5000 160 648 160 684 362 684 362 719 24 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 5500 5000 781 693 781 706 382 706 382 719 25 2 Arial,8,,0,clWindowText,0 1,1,4,0 4500 5000 4500 5000 649 929 649 894 362 894 362 828 26 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 5500 5000 666 929 666 875 382 875 382 828 29 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 4500 5806 444 392 507 392 507 393 569 393 31 2 Arial,8,,0,clWindowText,0 1,1,4,0 5500 5000 5000 5000 660 329 660 301 608 301 608 228