51
\\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
\\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.sql
SQLFILE
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