51
U:\imaging-schema.dez
2011-12-15
2011-12-15
SQLFILE
U:\imaging-schema-019.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
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
CHANNEL_COLOR
8
0
CHARACTER VARYING
20
0
1
0
0
VALUE IN ('BLUE', 'GREEN', 'RED', 'RED_GREEN', 'RED_BLUE', 'GREEN_BLUE')
1
1
BOOLEAN_CHAR
9
0
BOOLEAN
0
1
0
0
FALSE
1
6
EXPERIMENTS
10
0
4
1
1
2
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
4
0
-1
BYTEA
0
1
2
0
2
2
3
CONTAINERS
CONTAINERS_EXPE_IDX
11
0
6
2
1
2
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
2
0
2
2
3
SPOTS
SPOTS_CONT_IDX
13
0
5
3
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
CONT_ID
5
0
2
BIGINT
0
1
1
0
1
1
5
5
SPOTS_CONT_IDX
SPOTS_CONT_IDX
2
0
0
0
CONT_ID
0
0
5
SPOTS_COORDS_IDX
SPOTS_COORDS_IDX
3
0
0
0
CONT_ID
0
0
5
X
0
0
3
Y
0
0
4
ANALYSIS_DATA_SETS
ANALYSIS_DATA_SETS_CONT_IDX
15
0
4
2
1
2
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
CONT_ID
4
0
2
BIGINT
0
1
ANALYSIS_DATA_SETS_CONT_IDX
ANALYSIS_DATA_SETS_CONT_IDX
2
0
0
0
CONT_ID
0
0
4
2
0
2
2
3
IMAGE_DATA_SETS
IMAGE_DATA_SETS_CONT_IDX
17
0
19
2
1
2
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
13
0
-1
INTEGER
0
1
FIELDS_HEIGHT
5
0
-1
INTEGER
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
IS_MULTIDIMENSIONAL
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IMAGE_LIBRARY_NAME
8
0
4
CHARACTER VARYING
80
0
1
IMAGE_LIBRARY_READER_NAME
9
0
4
CHARACTER VARYING
80
0
1
CONT_ID
19
0
2
BIGINT
0
1
IMAGE_DATA_SETS_CONT_IDX
IMAGE_DATA_SETS_CONT_IDX
2
0
0
0
CONT_ID
0
0
19
2
0
2
2
3
IMAGE_ZOOM_LEVELS
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
19
0
8
3
1
2
1
0
2
3
2
ID
2
0
-1
BIGSERIAL
0
1
1
0
1
1
5
2
IS_ORIGINAL
3
0
9
BOOLEAN
0
1
1
0
1
1
5
3
1
0
FALSE
1
6
3
CONTAINER_DATASET_ID
4
0
2
BIGINT
0
1
1
0
1
1
5
4
PHYSICAL_DATASET_PERM_ID
5
0
-1
TEXT
0
1
1
0
1
1
5
5
PATH
6
0
6
CHARACTER VARYING
1000
0
1
WIDTH
7
0
-1
INTEGER
0
1
HEIGHT
8
0
-1
INTEGER
0
1
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
2
0
0
0
PHYSICAL_DATASET_PERM_ID
0
0
5
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
3
0
0
0
CONTAINER_DATASET_ID
0
0
4
2
0
2
2
5
CHANNELS
CHANNELS_DS_IDX
21
0
11
2
1
4
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
WAVELENGTH
6
0
-1
INTEGER
0
1
RED_CC
7
0
-1
INTEGER
0
1
1
0
1
1
5
7
GREEN_CC
8
0
-1
INTEGER
0
1
1
0
1
1
5
8
BLUE_CC
9
0
-1
INTEGER
0
1
1
0
1
1
5
9
DS_ID
10
0
2
BIGINT
0
1
EXP_ID
11
0
2
BIGINT
0
1
CHANNELS_DS_IDX
CHANNELS_DS_IDX
2
0
0
0
DS_ID
0
0
10
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
10
11
CHANNELS_UK_1
CHANNELS_UK_1
3
0
2
2
3
10
CHANNELS_UK_2
CHANNELS_UK_2
4
0
2
2
3
11
IMAGE_TRANSFORMATIONS
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
24
0
9
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
-1
CHARACTER VARYING
1000
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
1
0
1
1
5
6
IS_EDITABLE
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IS_DEFAULT
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
CHANNEL_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
2
0
0
0
CHANNEL_ID
0
0
9
IMAGE_TRANSFORMATIONS_UK_1
IMAGE_TRANSFORMATIONS_UK_1
2
0
2
2
3
9
CHANNEL_STACKS
CHANNEL_STACKS_DS_IDX
26
0
10
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
7
0
-1
INTEGER
0
1
is_representative
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
DS_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
SPOT_ID
10
0
2
BIGINT
0
1
CHANNEL_STACKS_DS_IDX
CHANNEL_STACKS_DS_IDX
2
0
0
0
DS_ID
0
0
9
CHANNEL_STACKS_SPOT_IDX
CHANNEL_STACKS_SPOT_IDX
3
0
0
0
SPOT_ID
0
0
10
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
29
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
IMAGE_ID
4
0
3
CHARACTER VARYING
40
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
30
0
7
5
4
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
THUMBNAIL_ID
4
0
2
BIGINT
0
1
IMAGE_TRANSFORMER_FACTORY
5
0
-1
BYTEA
0
1
CHANNEL_STACK_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
CHANNEL_ID
7
0
2
BIGINT
0
1
1
0
1
1
5
7
IMAGES_CHANNEL_STACK_IDX
IMAGES_CHANNEL_STACK_IDX
2
0
0
0
CHANNEL_STACK_ID
0
0
6
IMAGES_CHANNEL_IDX
IMAGES_CHANNEL_IDX
3
0
0
0
CHANNEL_ID
0
0
7
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 DELETE_UNUSED_NULLED_IMAGES() RETURNS trigger AS $$
BEGIN
if NEW.img_id IS NULL then
if OLD.img_id IS NOT NULL then
delete from images where id = OLD.img_id;
end if;
end if;
if NEW.thumbnail_id IS NULL then
if OLD.thumbnail_id IS NOT NULL then
delete from images where id = OLD.thumbnail_id;
end if;
end if;
RETURN NEW;
END;
UNUSED_NULLED_IMAGES
3
0
CREATE TRIGGER %triggername% AFTER UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW EXECUTE PROCEDURE DELETE_%triggername%();
CREATE OR REPLACE FUNCTION DELETE_EMPTY_ACQUIRED_IMAGES() RETURNS trigger AS $$
BEGIN
delete from acquired_images where id = OLD.id;
RETURN NEW;
END;
EMPTY_ACQUIRED_IMAGES
4
0
CREATE TRIGGER %triggername% BEFORE UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW
WHEN (NEW.img_id IS NULL AND NEW.thumbnail_id IS NULL)
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 image_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
35
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
36
0
6
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
DS_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
FEATURE_DEFS_DS_IDX
FEATURE_DEFS_DS_IDX
2
0
0
0
DS_ID
0
0
6
FEATURE_DEFS_UK_1
FEATURE_DEFS_UK_1
2
0
2
2
3
6
FEATURE_VOCABULARY_TERMS
FEATURE_VOCABULARY_TERMS_FD_IDX
38
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
FEATURE_VALUES
FEATURE_VALUES_FD_IDX
40
0
6
3
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
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
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
3
0
0
0
Z_in_M
0
0
3
T_in_SEC
0
0
4
FK_SAMPLE_1
FK_SAMPLE_1
12
0
10
11
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
14
0
11
13
0
1
1
2
2
FK_SPOT_1
FK_SPOT_1
1
0
2
4
5
0
0
2
5
FK_ANALYSIS_DATA_SET_1
FK_ANALYSIS_DATA_SET_1
16
0
11
15
0
1
0
2
2
FK_ANALYSIS_DATA_SET_1
FK_ANALYSIS_DATA_SET_1
1
0
2
4
4
0
0
2
4
FK_IMAGE_DATA_SET_1
FK_IMAGE_DATA_SET_1
18
0
11
17
0
1
0
2
2
FK_IMAGE_DATA_SET_1
FK_IMAGE_DATA_SET_1
1
0
2
4
19
0
0
2
19
FK_IMAGE_ZOOM_LEVELS_1
FK_IMAGE_ZOOM_LEVELS_1
20
0
17
19
0
1
1
2
2
FK_IMAGE_ZOOM_LEVELS_1
FK_IMAGE_ZOOM_LEVELS_1
1
0
2
4
4
0
0
2
4
FK_CHANNELS_1
FK_CHANNELS_1
22
0
17
21
0
1
0
2
2
FK_CHANNELS_1
FK_CHANNELS_1
1
0
2
4
10
0
0
2
10
FK_CHANNELS_2
FK_CHANNELS_2
23
0
10
21
0
1
0
2
2
FK_CHANNELS_2
FK_CHANNELS_2
1
0
2
4
11
0
0
2
11
FK_IMAGE_TRANSFORMATIONS_CHANNEL
FK_IMAGE_TRANSFORMATIONS_CHANNEL
25
0
21
24
0
1
1
2
2
FK_IMAGE_TRANSFORMATIONS_CHANNEL
FK_IMAGE_TRANSFORMATIONS_CHANNEL
1
0
2
4
9
0
0
2
9
FK_CHANNEL_STACKS_1
FK_CHANNEL_STACKS_1
27
0
13
26
0
1
0
2
2
FK_CHANNEL_STACKS_1
FK_CHANNEL_STACKS_1
1
0
2
4
10
0
0
2
10
FK_CHANNEL_STACKS_2
FK_CHANNEL_STACKS_2
28
0
17
26
0
1
1
2
2
FK_CHANNEL_STACKS_2
FK_CHANNEL_STACKS_2
1
0
2
4
9
0
0
2
9
FK_IMAGES_1
FK_IMAGES_1
31
0
26
30
0
1
1
2
2
FK_IMAGES_1
FK_IMAGES_1
1
0
2
4
6
0
0
2
6
FK_IMAGES_2
FK_IMAGES_2
32
0
21
30
0
1
1
2
2
FK_IMAGES_2
FK_IMAGES_2
1
0
2
4
7
0
0
2
7
FK_IMAGES_3
FK_IMAGES_3
33
0
29
30
0
1
0
2
3
FK_IMAGES_3
FK_IMAGES_3
1
0
2
4
3
0
0
2
3
FK_IMAGES_4
FK_IMAGES_4
34
0
29
30
0
1
0
2
3
FK_IMAGES_4
FK_IMAGES_4
1
0
2
4
4
0
0
2
4
FK_FEATURE_DEFS_1
FK_FEATURE_DEFS_1
37
0
15
36
0
1
1
2
2
FK_FEATURE_DEFS_1
FK_FEATURE_DEFS_1
1
0
2
4
6
0
0
2
6
FK_FEATURE_VOCABULARY_TERMS_1
FK_FEATURE_VOCABULARY_TERMS_1
39
0
36
38
0
1
1
2
2
FK_FEATURE_VOCABULARY_TERMS_1
FK_FEATURE_VOCABULARY_TERMS_1
1
0
2
4
5
0
0
2
5
FK_FEATURE_VALUES_1
FK_FEATURE_VALUES_1
41
0
36
40
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
16777215
0
0
0
1
1
0
0
3
HCS Images
0
16777215
0
0
0
1
1
0
0
4
Feature Vectors
0
16777215
0
0
0
1
1
0
0
10
1
198
78
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
1
104
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
1
77
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
1
137
78
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
1
198
168
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
1
179
138
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
1
99
183
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
1
198
153
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
1
115
168
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
1
75
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
1
198
123
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
1
175
48
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
1
94
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
1
191
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
1
110
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
2
198
78
20
220
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
2
104
108
147
448
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
2
77
93
20
620
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
2
137
78
625
463
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
2
198
168
297
844
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
2
179
138
601
846
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
2
99
183
534
201
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
2
198
153
789
266
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
2
115
168
20
820
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
2
75
93
686
1126
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
2
198
123
120
1104
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
2
175
48
258
20
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
2
94
108
951
618
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
2
191
93
1169
617
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
2
110
108
1241
437
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
3
198
78
0
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
3
175
48
714
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
3
104
108
0
134
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
3
77
93
0
329
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
3
198
168
164
207
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
3
115
168
0
506
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
3
99
183
517
499
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
3
198
123
250
529
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
3
75
93
312
740
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
3
179
138
399
222
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
3
198
153
691
514
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
4
198
78
0
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
4
104
108
0
147
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
4
137
78
216
162
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
4
94
108
414
147
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
4
110
108
406
328
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
4
191
93
619
155
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
12
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
147
139
147
154
99
154
14
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
154
150
154
150
146
99
146
16
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
147
154
147
139
237
139
18
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
169
154
169
184
298
184
20
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
177
184
177
169
99
169
22
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
188
184
188
192
99
192
23
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
165
139
165
192
99
192
25
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
199
192
150
192
150
176
99
176
27
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
177
146
165
146
165
184
215
184
28
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
184
184
184
184
99
184
31
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
215
184
173
184
173
162
298
162
32
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
199
192
150
192
150
162
99
162
33
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
175
146
150
146
150
162
99
162
34
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
175
146
150
146
150
162
99
162
37
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
147
139
147
154
99
154
39
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
194
154
150
154
150
146
99
146
41
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
194
154
154
154
154
154
210
154
12
2
Arial,8,,0,clWindowText,0
1,1,4,0
8182
5000
3365
5000
182
298
182
359
182
359
182
447
14
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
5000
5000
5000
194
556
194
588
58
588
58
619
16
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
251
502
401
502
401
502
624
502
18
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
5000
4500
5000
204
556
204
679
386
679
386
843
20
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
4226
5000
5000
495
915
517
915
517
915
600
915
22
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
5000
5500
5000
406
843
406
511
588
511
588
384
23
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
3169
218
259
238
259
238
259
533
259
25
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
6776
5000
3856
633
325
711
325
711
325
788
325
27
2
Arial,8,,0,clWindowText,0
1,1,4,0
4935
5000
3304
5000
58
713
58
766
58
766
58
819
28
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
4286
5500
5714
296
916
185
916
185
916
135
916
31
2
Arial,8,,0,clWindowText,0
1,1,4,0
9304
5000
354
5000
127
988
127
1004
127
1004
127
1103
32
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
5000
5500
5000
579
384
579
711
229
711
229
1103
33
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
4946
4500
5528
685
1172
502
1172
502
1172
318
1172
34
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
4946
5500
5528
685
1172
502
1172
502
1172
318
1172
37
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
693
541
693
579
998
579
998
617
39
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4259
5000
5054
1045
664
1107
664
1107
664
1168
664
41
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
998
617
998
573
1296
573
1296
545
12
3
Arial,8,,0,clWindowText,0
1,1,4,0
2626
5000
5000
5000
52
78
52
120
52
120
52
133
14
3
Arial,8,,0,clWindowText,0
1,1,4,0
3654
5000
4935
5000
38
242
38
289
38
289
38
328
18
3
Arial,8,,0,clWindowText,0
1,1,4,0
7212
8333
5000
1012
104
224
134
224
134
224
163
224
27
3
Arial,8,,0,clWindowText,0
1,1,4,0
4935
5000
3304
5000
38
422
38
467
38
467
38
505
28
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
263
375
263
493
58
493
58
505
22
3
Arial,8,,0,clWindowText,0
1,1,4,0
9192
5000
5000
5000
346
375
346
456
567
456
567
498
23
3
Arial,8,,0,clWindowText,0
1,1,4,0
8283
5000
7677
5000
164
78
164
139
593
139
593
498
31
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
4959
115
590
204
590
204
590
249
590
32
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4973
5000
4959
516
590
503
590
503
590
448
590
33
3
Arial,8,,0,clWindowText,0
1,1,4,0
4933
5000
5000
5000
349
739
349
696
349
696
349
652
34
3
Arial,8,,0,clWindowText,0
1,1,4,0
8400
5000
6263
5000
375
739
375
695
374
695
374
652
20
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
362
291
380
291
380
291
398
291
25
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4973
5000
4967
616
590
650
590
650
590
690
590
12
4
Arial,8,,0,clWindowText,0
1,1,4,0
2626
5000
5000
5000
52
78
52
130
52
130
52
146
16
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
104
201
152
201
152
201
215
201
37
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
353
201
372
201
372
201
413
201
41
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
461
255
461
307
461
307
461
327
39
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
4946
508
201
566
201
566
201
618
201
1
Archived model before update 2011-12-15
2011-12-15 14:02
This version has been archived automatically before updating from the database.
Diagrams and data dictionary
U:\imaging-schema.dez
2011-12-15
2011-12-15
SQLFILE
U:\imaging-schema-019.sql
postgresql83
postgresql83
71
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
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
CHANNEL_COLOR
8
0
CHARACTER VARYING
20
0
1
0
0
VALUE IN ('BLUE', 'GREEN', 'RED', 'RED_GREEN', 'RED_BLUE', 'GREEN_BLUE')
1
1
BOOLEAN_CHAR
9
0
BOOLEAN
0
1
0
0
FALSE
1
6
EXPERIMENTS
10
0
4
1
1
2
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
4
0
-1
BYTEA
0
1
2
0
2
2
3
CONTAINERS
CONTAINERS_EXPE_IDX
11
0
6
2
1
2
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
2
0
2
2
3
SPOTS
SPOTS_CONT_IDX
13
0
5
3
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
CONT_ID
5
0
2
BIGINT
0
1
1
0
1
1
5
5
SPOTS_CONT_IDX
SPOTS_CONT_IDX
2
0
0
0
CONT_ID
0
0
5
SPOTS_COORDS_IDX
SPOTS_COORDS_IDX
3
0
0
0
CONT_ID
0
0
5
X
0
0
3
Y
0
0
4
ANALYSIS_DATA_SETS
ANALYSIS_DATA_SETS_CONT_IDX
15
0
4
2
1
2
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
CONT_ID
4
0
2
BIGINT
0
1
ANALYSIS_DATA_SETS_CONT_IDX
ANALYSIS_DATA_SETS_CONT_IDX
2
0
0
0
CONT_ID
0
0
4
2
0
2
2
3
IMAGE_DATA_SETS
IMAGE_DATA_SETS_CONT_IDX
17
0
10
2
1
2
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
--
4
0
-1
CHARACTER
0
1
FIELDS_HEIGHT
5
0
-1
INTEGER
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
IS_MULTIDIMENSIONAL
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IMAGE_LIBRARY_NAME
8
0
4
CHARACTER VARYING
80
0
1
IMAGE_LIBRARY_READER_NAME
9
0
4
CHARACTER VARYING
80
0
1
--
10
0
-1
CHARACTER
0
1
IMAGE_DATA_SETS_CONT_IDX
IMAGE_DATA_SETS_CONT_IDX
2
0
0
0
2
0
2
2
3
IMAGE_ZOOM_LEVELS
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
19
0
8
3
1
2
1
0
2
3
2
ID
2
0
-1
BIGSERIAL
0
1
1
0
1
1
5
2
IS_ORIGINAL
3
0
9
BOOLEAN
0
1
1
0
1
1
5
3
1
0
FALSE
1
6
3
CONTAINER_DATASET_ID
4
0
2
BIGINT
0
1
1
0
1
1
5
4
PHYSICAL_DATASET_PERM_ID
5
0
-1
TEXT
0
1
1
0
1
1
5
5
PATH
6
0
6
CHARACTER VARYING
1000
0
1
WIDTH
7
0
-1
INTEGER
0
1
HEIGHT
8
0
-1
INTEGER
0
1
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
2
0
0
0
PHYSICAL_DATASET_PERM_ID
0
0
5
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
3
0
0
0
CONTAINER_DATASET_ID
0
0
4
2
0
2
2
5
CHANNELS
CHANNELS_DS_IDX
21
0
11
2
1
4
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
WAVELENGTH
6
0
-1
INTEGER
0
1
RED_CC
7
0
-1
INTEGER
0
1
1
0
1
1
5
7
GREEN_CC
8
0
-1
INTEGER
0
1
1
0
1
1
5
8
BLUE_CC
9
0
-1
INTEGER
0
1
1
0
1
1
5
9
DS_ID
10
0
2
BIGINT
0
1
EXP_ID
11
0
2
BIGINT
0
1
CHANNELS_DS_IDX
CHANNELS_DS_IDX
2
0
0
0
DS_ID
0
0
10
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
10
11
CHANNELS_UK_1
CHANNELS_UK_1
3
0
2
2
3
10
CHANNELS_UK_2
CHANNELS_UK_2
4
0
2
2
3
11
IMAGE_TRANSFORMATIONS
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
24
0
9
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
-1
CHARACTER VARYING
1000
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
1
0
1
1
5
6
IS_EDITABLE
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IS_DEFAULT
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
CHANNEL_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
2
0
0
0
CHANNEL_ID
0
0
9
IMAGE_TRANSFORMATIONS_UK_1
IMAGE_TRANSFORMATIONS_UK_1
2
0
2
2
3
9
CHANNEL_STACKS
CHANNEL_STACKS_DS_IDX
26
0
10
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
7
0
-1
INTEGER
0
1
is_representative
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
DS_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
SPOT_ID
10
0
2
BIGINT
0
1
CHANNEL_STACKS_DS_IDX
CHANNEL_STACKS_DS_IDX
2
0
0
0
DS_ID
0
0
9
CHANNEL_STACKS_SPOT_IDX
CHANNEL_STACKS_SPOT_IDX
3
0
0
0
SPOT_ID
0
0
10
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
29
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
IMAGE_ID
4
0
3
CHARACTER VARYING
40
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
30
0
7
5
4
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
THUMBNAIL_ID
4
0
2
BIGINT
0
1
IMAGE_TRANSFORMER_FACTORY
5
0
-1
BYTEA
0
1
CHANNEL_STACK_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
CHANNEL_ID
7
0
2
BIGINT
0
1
1
0
1
1
5
7
IMAGES_CHANNEL_STACK_IDX
IMAGES_CHANNEL_STACK_IDX
2
0
0
0
CHANNEL_STACK_ID
0
0
6
IMAGES_CHANNEL_IDX
IMAGES_CHANNEL_IDX
3
0
0
0
CHANNEL_ID
0
0
7
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 DELETE_UNUSED_NULLED_IMAGES() RETURNS trigger AS $$
BEGIN
if NEW.img_id IS NULL then
if OLD.img_id IS NOT NULL then
delete from images where id = OLD.img_id;
end if;
end if;
if NEW.thumbnail_id IS NULL then
if OLD.thumbnail_id IS NOT NULL then
delete from images where id = OLD.thumbnail_id;
end if;
end if;
RETURN NEW;
END;
UNUSED_NULLED_IMAGES
3
0
CREATE TRIGGER %triggername% AFTER UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW EXECUTE PROCEDURE DELETE_%triggername%();
CREATE OR REPLACE FUNCTION DELETE_EMPTY_ACQUIRED_IMAGES() RETURNS trigger AS $$
BEGIN
delete from acquired_images where id = OLD.id;
RETURN NEW;
END;
EMPTY_ACQUIRED_IMAGES
4
0
CREATE TRIGGER %triggername% BEFORE UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW
WHEN (NEW.img_id IS NULL AND NEW.thumbnail_id IS NULL)
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 image_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
35
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
36
0
6
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
DS_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
FEATURE_DEFS_DS_IDX
FEATURE_DEFS_DS_IDX
2
0
0
0
DS_ID
0
0
6
FEATURE_DEFS_UK_1
FEATURE_DEFS_UK_1
2
0
2
2
3
6
FEATURE_VOCABULARY_TERMS
FEATURE_VOCABULARY_TERMS_FD_IDX
38
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
FEATURE_VALUES
FEATURE_VALUES_FD_IDX
40
0
6
3
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
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
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
3
0
0
0
Z_in_M
0
0
3
T_in_SEC
0
0
4
EXPERIMENTS1
43
0
4
1
1
2
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
4
0
-1
BYTEA
0
1
2
0
2
2
3
CONTAINERS1
CONTAINERS_EXPE_IDX
45
0
6
2
1
2
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
2
0
2
2
3
SPOTS1
SPOTS_CONT_IDX
47
0
5
3
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
CONT_ID
5
0
2
BIGINT
0
1
1
0
1
1
5
5
SPOTS_CONT_IDX
SPOTS_CONT_IDX
2
0
0
0
CONT_ID
0
0
5
SPOTS_COORDS_IDX
SPOTS_COORDS_IDX
3
0
0
0
CONT_ID
0
0
5
X
0
0
3
Y
0
0
4
ANALYSIS_DATA_SETS1
ANALYSIS_DATA_SETS_CONT_IDX
49
0
4
2
1
2
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
CONT_ID
4
0
2
BIGINT
0
1
ANALYSIS_DATA_SETS_CONT_IDX
ANALYSIS_DATA_SETS_CONT_IDX
2
0
0
0
CONT_ID
0
0
4
2
0
2
2
3
IMAGE_DATA_SETS1
IMAGE_DATA_SETS_CONT_IDX
51
0
10
2
1
2
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
--
4
0
-1
CHARACTER
0
1
FIELDS_HEIGHT
5
0
-1
INTEGER
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
IS_MULTIDIMENSIONAL
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IMAGE_LIBRARY_NAME
8
0
4
CHARACTER VARYING
80
0
1
IMAGE_LIBRARY_READER_NAME
9
0
4
CHARACTER VARYING
80
0
1
--
10
0
-1
CHARACTER
0
1
IMAGE_DATA_SETS_CONT_IDX
IMAGE_DATA_SETS_CONT_IDX
2
0
0
0
2
0
2
2
3
IMAGE_ZOOM_LEVELS1
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
53
0
8
3
1
2
1
0
2
3
2
ID
2
0
-1
BIGSERIAL
0
1
1
0
1
1
5
2
IS_ORIGINAL
3
0
9
BOOLEAN
0
1
1
0
1
1
5
3
1
0
FALSE
1
6
3
CONTAINER_DATASET_ID
4
0
2
BIGINT
0
1
1
0
1
1
5
4
PHYSICAL_DATASET_PERM_ID
5
0
-1
TEXT
0
1
1
0
1
1
5
5
PATH
6
0
6
CHARACTER VARYING
1000
0
1
WIDTH
7
0
-1
INTEGER
0
1
HEIGHT
8
0
-1
INTEGER
0
1
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
IMAGE_ZOOM_LEVELS_PHYS_DS_IDX
2
0
0
0
PHYSICAL_DATASET_PERM_ID
0
0
5
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
IMAGE_ZOOM_LEVELS_CONT_FK_IDX
3
0
0
0
CONTAINER_DATASET_ID
0
0
4
2
0
2
2
5
CHANNELS1
CHANNELS_DS_IDX
55
0
11
2
1
4
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
WAVELENGTH
6
0
-1
INTEGER
0
1
RED_CC
7
0
-1
INTEGER
0
1
1
0
1
1
5
7
GREEN_CC
8
0
-1
INTEGER
0
1
1
0
1
1
5
8
BLUE_CC
9
0
-1
INTEGER
0
1
1
0
1
1
5
9
DS_ID
10
0
2
BIGINT
0
1
EXP_ID
11
0
2
BIGINT
0
1
CHANNELS_DS_IDX
CHANNELS_DS_IDX
2
0
0
0
DS_ID
0
0
10
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
10
11
CHANNELS_UK_1
CHANNELS_UK_1
3
0
2
2
3
10
CHANNELS_UK_2
CHANNELS_UK_2
4
0
2
2
3
11
IMAGE_TRANSFORMATIONS1
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
57
0
9
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
-1
CHARACTER VARYING
1000
0
1
IMAGE_TRANSFORMER_FACTORY
6
0
-1
BYTEA
0
1
1
0
1
1
5
6
IS_EDITABLE
7
0
9
BOOLEAN
0
1
1
0
1
1
5
7
1
0
FALSE
1
6
7
IS_DEFAULT
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
CHANNEL_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
IMAGE_TRANSFORMATIONS_CHANNELS_IDX
2
0
0
0
CHANNEL_ID
0
0
9
IMAGE_TRANSFORMATIONS_UK_1
IMAGE_TRANSFORMATIONS_UK_1
2
0
2
2
3
9
CHANNEL_STACKS1
CHANNEL_STACKS_DS_IDX
59
0
10
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
7
0
-1
INTEGER
0
1
is_representative
8
0
9
BOOLEAN
0
1
1
0
1
1
5
8
2
0
FALSE
1
6
8
DS_ID
9
0
2
BIGINT
0
1
1
0
1
1
5
9
SPOT_ID
10
0
2
BIGINT
0
1
CHANNEL_STACKS_DS_IDX
CHANNEL_STACKS_DS_IDX
2
0
0
0
DS_ID
0
0
9
CHANNEL_STACKS_SPOT_IDX
CHANNEL_STACKS_SPOT_IDX
3
0
0
0
SPOT_ID
0
0
10
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
IMAGES1
61
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
IMAGE_ID
4
0
3
CHARACTER VARYING
40
0
1
COLOR
5
0
7
CHARACTER VARYING
40
0
1
3
0
VALUE IN ('RED', 'GREEN', 'BLUE')
1
1
5
ACQUIRED_IMAGES1
IMAGES_CHANNEL_STACK_IDX
63
0
7
5
4
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
THUMBNAIL_ID
4
0
2
BIGINT
0
1
IMAGE_TRANSFORMER_FACTORY
5
0
-1
BYTEA
0
1
CHANNEL_STACK_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
CHANNEL_ID
7
0
2
BIGINT
0
1
1
0
1
1
5
7
IMAGES_CHANNEL_STACK_IDX
IMAGES_CHANNEL_STACK_IDX
2
0
0
0
CHANNEL_STACK_ID
0
0
6
IMAGES_CHANNEL_IDX
IMAGES_CHANNEL_IDX
3
0
0
0
CHANNEL_ID
0
0
7
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 DELETE_UNUSED_NULLED_IMAGES() RETURNS trigger AS $$
BEGIN
if NEW.img_id IS NULL then
if OLD.img_id IS NOT NULL then
delete from images where id = OLD.img_id;
end if;
end if;
if NEW.thumbnail_id IS NULL then
if OLD.thumbnail_id IS NOT NULL then
delete from images where id = OLD.thumbnail_id;
end if;
end if;
RETURN NEW;
END;
UNUSED_NULLED_IMAGES
3
0
CREATE TRIGGER %triggername% AFTER UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW EXECUTE PROCEDURE DELETE_%triggername%();
CREATE OR REPLACE FUNCTION DELETE_EMPTY_ACQUIRED_IMAGES() RETURNS trigger AS $$
BEGIN
delete from acquired_images where id = OLD.id;
RETURN NEW;
END;
EMPTY_ACQUIRED_IMAGES
4
0
CREATE TRIGGER %triggername% BEFORE UPDATE ON ACQUIRED_IMAGES
FOR EACH ROW
WHEN (NEW.img_id IS NULL AND NEW.thumbnail_id IS NULL)
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 image_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;
EVENTS1
65
0
2
1
1
1
LAST_SEEN_DELETION_EVENT_ID
2
0
2
BIGINT
0
1
1
0
1
1
5
2
FEATURE_DEFS1
FEATURE_DEFS_DS_IDX
67
0
6
2
1
2
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
LABEL
4
0
4
CHARACTER VARYING
80
0
1
1
0
1
1
5
4
DESCRIPTION
5
0
5
CHARACTER VARYING
200
0
1
DS_ID
6
0
2
BIGINT
0
1
1
0
1
1
5
6
FEATURE_DEFS_DS_IDX
FEATURE_DEFS_DS_IDX
2
0
0
0
DS_ID
0
0
6
FEATURE_DEFS_UK_1
FEATURE_DEFS_UK_1
2
0
2
2
3
6
FEATURE_VOCABULARY_TERMS1
FEATURE_VOCABULARY_TERMS_FD_IDX
69
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
FEATURE_VALUES1
FEATURE_VALUES_FD_IDX
71
0
6
3
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
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
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
3
0
0
0
Z_in_M
0
0
3
T_in_SEC
0
0
4
FK_SAMPLE_1
FK_SAMPLE_1
12
0
10
11
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
14
0
11
13
0
1
1
2
2
FK_SPOT_1
FK_SPOT_1
1
0
2
4
5
0
0
2
5
FK_ANALYSIS_DATA_SET_1
FK_ANALYSIS_DATA_SET_1
16
0
11
15
0
1
0
2
2
FK_ANALYSIS_DATA_SET_1
FK_ANALYSIS_DATA_SET_1
1
0
2
4
4
0
0
2
4
FK_IMAGE_DATA_SET_1
FK_IMAGE_DATA_SET_1
18
0
11
17
0
1
0
2
2
FK_IMAGE_DATA_SET_1
FK_IMAGE_DATA_SET_1
1
0
2
4
FK_IMAGE_ZOOM_LEVELS_1
FK_IMAGE_ZOOM_LEVELS_1
20
0
17
19
0
1
1
2
2
FK_IMAGE_ZOOM_LEVELS_1
FK_IMAGE_ZOOM_LEVELS_1
1
0
2
4
4
0
0
2
4
FK_CHANNELS_1
FK_CHANNELS_1
22
0
17
21
0
1
0
2
2
FK_CHANNELS_1
FK_CHANNELS_1
1
0
2
4
10
0
0
2
10
FK_CHANNELS_2
FK_CHANNELS_2
23
0
10
21
0
1
0
2
2
FK_CHANNELS_2
FK_CHANNELS_2
1
0
2
4
11
0
0
2
11
FK_IMAGE_TRANSFORMATIONS_CHANNEL
FK_IMAGE_TRANSFORMATIONS_CHANNEL
25
0
21
24
0
1
1
2
2
FK_IMAGE_TRANSFORMATIONS_CHANNEL
FK_IMAGE_TRANSFORMATIONS_CHANNEL
1
0
2
4
9
0
0
2
9
FK_CHANNEL_STACKS_1
FK_CHANNEL_STACKS_1
27
0
13
26
0
1
0
2
2
FK_CHANNEL_STACKS_1
FK_CHANNEL_STACKS_1
1
0
2
4
10
0
0
2
10
FK_CHANNEL_STACKS_2
FK_CHANNEL_STACKS_2
28
0
17
26
0
1
1
2
2
FK_CHANNEL_STACKS_2
FK_CHANNEL_STACKS_2
1
0
2
4
9
0
0
2
9
FK_IMAGES_1
FK_IMAGES_1
31
0
26
30
0
1
1
2
2
FK_IMAGES_1
FK_IMAGES_1
1
0
2
4
6
0
0
2
6
FK_IMAGES_2
FK_IMAGES_2
32
0
21
30
0
1
1
2
2
FK_IMAGES_2
FK_IMAGES_2
1
0
2
4
7
0
0
2
7
FK_IMAGES_3
FK_IMAGES_3
33
0
29
30
0
1
0
2
3
FK_IMAGES_3
FK_IMAGES_3
1
0
2
4
3
0
0
2
3
FK_IMAGES_4
FK_IMAGES_4
34
0
29
30
0
1
0
2
3
FK_IMAGES_4
FK_IMAGES_4
1
0
2
4
4
0
0
2
4
FK_FEATURE_DEFS_1
FK_FEATURE_DEFS_1
37
0
15
36
0
1
1
2
2
FK_FEATURE_DEFS_1
FK_FEATURE_DEFS_1
1
0
2
4
6
0
0
2
6
FK_FEATURE_VOCABULARY_TERMS_1
FK_FEATURE_VOCABULARY_TERMS_1
39
0
36
38
0
1
1
2
2
FK_FEATURE_VOCABULARY_TERMS_1
FK_FEATURE_VOCABULARY_TERMS_1
1
0
2
4
5
0
0
2
5
FK_FEATURE_VALUES_1
FK_FEATURE_VALUES_1
41
0
36
40
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
16777215
0
0
0
1
1
0
0
3
HCS Images
0
16777215
0
0
0
1
1
0
0
4
Feature Vectors
0
16777215
0
0
0
1
1
0
0
10
1
198
78
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
1
104
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
1
77
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
1
137
78
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
1
198
168
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
1
179
138
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
1
99
183
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
1
198
153
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
1
115
168
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
1
75
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
1
198
123
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
1
175
48
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
1
94
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
1
191
93
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
1
110
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
43
1
198
78
20
220
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
45
1
104
108
147
448
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
47
1
71
93
20
620
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
49
1
144
78
625
463
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
51
1
198
168
297
844
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
53
1
179
138
601
846
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
55
1
99
183
534
201
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
57
1
198
153
789
266
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
59
1
122
168
20
820
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
61
1
75
93
686
1126
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
63
1
198
123
120
1104
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
65
1
175
48
258
20
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
67
1
101
108
951
618
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
69
1
198
93
1169
617
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
71
1
117
108
1241
437
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
2
198
78
20
220
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
2
104
108
147
448
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
2
77
93
20
620
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
2
137
78
625
463
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
2
198
168
297
844
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
2
179
138
601
846
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
2
99
183
534
201
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
2
198
153
789
266
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
2
115
168
20
820
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
2
75
93
686
1126
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
2
198
123
120
1104
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
2
175
48
258
20
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
2
94
108
951
618
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
2
191
93
1169
617
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
2
110
108
1241
437
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
3
198
78
0
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
35
3
175
48
714
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
3
104
108
0
134
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
3
77
93
0
329
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
17
3
198
168
164
207
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
26
3
115
168
0
506
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
21
3
99
183
517
499
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
3
198
123
250
529
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
29
3
75
93
312
740
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
19
3
179
138
399
222
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
24
3
198
153
691
514
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
10
4
198
78
0
0
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
11
4
104
108
0
147
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
4
137
78
216
162
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
36
4
94
108
414
147
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
40
4
110
108
406
328
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
38
4
191
93
619
155
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
12
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
147
139
147
154
99
154
14
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
154
150
154
150
146
99
146
16
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
147
154
147
139
237
139
18
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
169
154
169
184
298
184
20
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
177
184
177
169
99
169
22
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
188
184
188
192
99
192
23
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
165
139
165
192
99
192
25
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
199
192
150
192
150
176
99
176
27
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
177
146
165
146
165
184
215
184
28
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
184
184
184
184
184
99
184
31
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
215
184
173
184
173
162
298
162
32
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
199
192
150
192
150
162
99
162
33
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
175
146
150
146
150
162
99
162
34
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
175
146
150
146
150
162
99
162
37
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
139
147
139
147
154
99
154
39
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
194
154
150
154
150
146
99
146
41
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
194
154
154
154
154
154
210
154
12
2
Arial,8,,0,clWindowText,0
1,1,4,0
8182
5000
3365
5000
182
298
182
359
182
359
182
447
14
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
5000
5000
5000
194
556
194
588
58
588
58
619
16
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
251
502
401
502
401
502
624
502
18
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
5000
4500
5000
204
556
204
679
386
679
386
843
20
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
4226
5000
5000
495
915
517
915
517
915
600
915
22
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
5000
5500
5000
406
843
406
511
588
511
588
384
23
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
3169
218
259
238
259
238
259
533
259
25
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
6776
5000
3856
633
325
711
325
711
325
788
325
27
2
Arial,8,,0,clWindowText,0
1,1,4,0
4935
5000
3304
5000
58
713
58
766
58
766
58
819
28
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
4286
5500
5714
296
916
185
916
185
916
135
916
31
2
Arial,8,,0,clWindowText,0
1,1,4,0
9304
5000
354
5000
127
988
127
1004
127
1004
127
1103
32
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
5000
5500
5000
579
384
579
711
229
711
229
1103
33
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
4946
4500
5528
685
1172
502
1172
502
1172
318
1172
34
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
4946
5500
5528
685
1172
502
1172
502
1172
318
1172
37
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
693
541
693
579
998
579
998
617
39
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4259
5000
5054
1045
664
1107
664
1107
664
1168
664
41
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
998
617
998
573
1296
573
1296
545
12
3
Arial,8,,0,clWindowText,0
1,1,4,0
2626
5000
5000
5000
52
78
52
120
52
120
52
133
14
3
Arial,8,,0,clWindowText,0
1,1,4,0
3654
5000
4935
5000
38
242
38
289
38
289
38
328
18
3
Arial,8,,0,clWindowText,0
1,1,4,0
7212
8333
5000
1012
104
224
134
224
134
224
163
224
27
3
Arial,8,,0,clWindowText,0
1,1,4,0
4935
5000
3304
5000
38
422
38
467
38
467
38
505
28
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
263
375
263
493
58
493
58
505
22
3
Arial,8,,0,clWindowText,0
1,1,4,0
9192
5000
5000
5000
346
375
346
456
567
456
567
498
23
3
Arial,8,,0,clWindowText,0
1,1,4,0
8283
5000
7677
5000
164
78
164
139
593
139
593
498
31
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
4959
115
590
204
590
204
590
249
590
32
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4973
5000
4959
516
590
503
590
503
590
448
590
33
3
Arial,8,,0,clWindowText,0
1,1,4,0
4933
5000
5000
5000
349
739
349
696
349
696
349
652
34
3
Arial,8,,0,clWindowText,0
1,1,4,0
8400
5000
6263
5000
375
739
375
695
374
695
374
652
20
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
362
291
380
291
380
291
398
291
25
3
Arial,8,,0,clWindowText,0
1,1,4,0
5000
4973
5000
4967
616
590
650
590
650
590
690
590
12
4
Arial,8,,0,clWindowText,0
1,1,4,0
2626
5000
5000
5000
52
78
52
130
52
130
52
146
16
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
104
201
152
201
152
201
215
201
37
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
353
201
372
201
372
201
413
201
41
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
461
255
461
307
461
307
461
327
39
4
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
4946
508
201
566
201
566
201
618
201