51
\\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.dez
2010-06-14
2010-06-14
\\nas-bsse\share-1-$\group\cisd\screening\datamodel\003\schema-003.sql
SQLFILE
postgresql83
postgresql83
34
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
EXPERIMENTS
8
0
3
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
2
0
2
2
3
CONTAINERS
CONTAINERS_EXPE_IDX
9
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
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
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
2
0
2
2
3
DATA_SETS
DATA_SETS_CONT_IDX
13
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
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
DATA_SETS_CONT_IDX
DATA_SETS_CONT_IDX
2
0
0
0
CONT_ID
0
0
6
2
0
2
2
3
CHANNELS
CHANNELS_DS_IDX
15
0
7
2
1
4
1
0
2
3
2
ID
2
0
-1
BIGSERIAL
0
1
1
0
1
1
5
2
NAME
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
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
3
6
CHANNELS_UK_2
CHANNELS_UK_2
4
0
2
2
3
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
5
2
1
2
1
0
2
3
2
ID
2
0
-1
BIGSERIAL
0
1
1
0
1
1
5
2
NAME
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
3
5
FEATURE_VALUES
FEATURE_VALUES_FD_IDX
30
0
7
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
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
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
89
63
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
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
1
104
108
100
100
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
1
99
123
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
93
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
136
63
300
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
108
0
330
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
13
2
166
108
210
330
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
15
2
170
123
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
93
570
330
0,16777215
0,1,4,0
Arial,8,,0,clWindowText,0
0
1
30
2
136
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
189
132
143
132
143
154
204
154
12
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
154
154
154
154
154
99
154
14
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
154
154
154
154
154
99
154
16
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
99
154
158
154
158
162
99
162
17
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
189
132
146
132
146
162
199
162
19
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
177
154
162
154
162
169
215
169
20
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
162
154
162
169
215
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
199
162
158
162
158
154
238
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
154
150
154
150
146
99
146
31
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
194
146
154
146
154
162
210
162
32
1
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
204
154
158
154
158
162
210
162
10
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
5000
5000
368
63
368
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
293
279
293
329
16
2
Arial,8,,0,clWindowText,0
1,1,4,0
6566
5000
5500
5000
319
438
319
487
754
487
754
539
17
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
8294
5000
368
63
368
89
801
89
801
539
19
2
Arial,8,,0,clWindowText,0
1,1,4,0
5000
5000
4500
5000
72
438
72
489
153
489
153
509
20
2
Arial,8,,0,clWindowText,0
1,1,4,0
4500
5000
5500
5000
285
438
285
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
736
663
736
681
382
681
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
376
384
443
384
443
384
569
384
31
2
Arial,8,,0,clWindowText,0
1,1,4,0
5500
5000
5000
5000
660
329
660
301
608
301
608
243
32
2
Arial,8,,0,clWindowText,0
1,1,4,0
7651
2870
1544
5000
337
329
337
301
561
301
561
243