1 CREATE TABLE SubInd_ch10 (
2 chr varchar (3) NOT NULL ,
3 batch_id int NOT NULL ,
4 subsnp_id int NOT NULL ,
5 submitted_ind_id int NOT NULL ,
6 submitted_strand_code int NULL ,
13 CREATE TABLE SubInd_ch11 (
14 chr varchar (3) NOT NULL ,
15 batch_id int NOT NULL ,
16 subsnp_id int NOT NULL ,
17 submitted_ind_id int NOT NULL ,
18 submitted_strand_code int NULL ,
19 allele_flag int NULL ,
25 CREATE TABLE SubInd_ch12 (
26 chr varchar (3) NOT NULL ,
27 batch_id int NOT NULL ,
28 subsnp_id int NOT NULL ,
29 submitted_ind_id int NOT NULL ,
30 submitted_strand_code int NULL ,
31 allele_flag int NULL ,
37 CREATE TABLE SubInd_ch13 (
38 chr varchar (3) NOT NULL ,
39 batch_id int NOT NULL ,
40 subsnp_id int NOT NULL ,
41 submitted_ind_id int NOT NULL ,
42 submitted_strand_code int NULL ,
43 allele_flag int NULL ,
49 CREATE TABLE SubInd_ch14 (
50 chr varchar (3) NOT NULL ,
51 batch_id int NOT NULL ,
52 subsnp_id int NOT NULL ,
53 submitted_ind_id int NOT NULL ,
54 submitted_strand_code int NULL ,
55 allele_flag int NULL ,
61 CREATE TABLE SubInd_ch15 (
62 chr varchar (3) NOT NULL ,
63 batch_id int NOT NULL ,
64 subsnp_id int NOT NULL ,
65 submitted_ind_id int NOT NULL ,
66 submitted_strand_code int NULL ,
67 allele_flag int NULL ,
73 CREATE TABLE SubInd_ch16 (
74 chr varchar (3) NOT NULL ,
75 batch_id int NOT NULL ,
76 subsnp_id int NOT NULL ,
77 submitted_ind_id int NOT NULL ,
78 submitted_strand_code int NULL ,
79 allele_flag int NULL ,
85 CREATE TABLE SubInd_ch17 (
86 chr varchar (3) NOT NULL ,
87 batch_id int NOT NULL ,
88 subsnp_id int NOT NULL ,
89 submitted_ind_id int NOT NULL ,
90 submitted_strand_code int NULL ,
91 allele_flag int NULL ,
97 CREATE TABLE SubInd_ch18 (
98 chr varchar (3) NOT NULL ,
99 batch_id int NOT NULL ,
100 subsnp_id int NOT NULL ,
101 submitted_ind_id int NOT NULL ,
102 submitted_strand_code int NULL ,
103 allele_flag int NULL ,
105 submitted_rs int NULL
109 CREATE TABLE SubInd_ch19 (
110 chr varchar (3) NOT NULL ,
111 batch_id int NOT NULL ,
112 subsnp_id int NOT NULL ,
113 submitted_ind_id int NOT NULL ,
114 submitted_strand_code int NULL ,
115 allele_flag int NULL ,
117 submitted_rs int NULL
121 CREATE TABLE SubInd_ch20 (
122 chr varchar (3) NOT NULL ,
123 batch_id int NOT NULL ,
124 subsnp_id int NOT NULL ,
125 submitted_ind_id int NOT NULL ,
126 submitted_strand_code int NULL ,
127 allele_flag int NULL ,
129 submitted_rs int NULL
133 CREATE TABLE SubInd_ch21 (
134 chr varchar (3) NOT NULL ,
135 batch_id int NOT NULL ,
136 subsnp_id int NOT NULL ,
137 submitted_ind_id int NOT NULL ,
138 submitted_strand_code int NULL ,
139 allele_flag int NULL ,
141 submitted_rs int NULL
145 CREATE TABLE SubInd_ch22 (
146 chr varchar (3) NOT NULL ,
147 batch_id int NOT NULL ,
148 subsnp_id int NOT NULL ,
149 submitted_ind_id int NOT NULL ,
150 submitted_strand_code int NULL ,
151 allele_flag int NULL ,
153 submitted_rs int NULL
157 CREATE TABLE SubInd_ch8 (
158 chr varchar (3) NOT NULL ,
159 batch_id int NOT NULL ,
160 subsnp_id int NOT NULL ,
161 submitted_ind_id int NOT NULL ,
162 submitted_strand_code int NULL ,
163 allele_flag int NULL ,
165 submitted_rs int NULL
169 CREATE TABLE SubInd_ch9 (
170 chr varchar (3) NOT NULL ,
171 batch_id int NOT NULL ,
172 subsnp_id int NOT NULL ,
173 submitted_ind_id int NOT NULL ,
174 submitted_strand_code int NULL ,
175 allele_flag int NULL ,
177 submitted_rs int NULL
181 CREATE TABLE SubInd_chAltOnly (
182 chr varchar (8) NOT NULL ,
183 batch_id int NOT NULL ,
184 subsnp_id int NOT NULL ,
185 submitted_ind_id int NOT NULL ,
186 submitted_strand_code int NULL ,
187 allele_flag int NULL ,
189 submitted_rs int NULL
193 CREATE TABLE SubInd_chMT (
194 chr varchar (8) NOT NULL ,
195 batch_id int NOT NULL ,
196 subsnp_id int NOT NULL ,
197 submitted_ind_id int NOT NULL ,
198 submitted_strand_code int NULL ,
199 allele_flag int NULL ,
201 submitted_rs int NULL
205 CREATE TABLE SubInd_chMulti (
206 chr varchar (8) NOT NULL ,
207 batch_id int NOT NULL ,
208 subsnp_id int NOT NULL ,
209 submitted_ind_id int NOT NULL ,
210 submitted_strand_code int NULL ,
211 allele_flag int NULL ,
213 submitted_rs int NULL
217 CREATE TABLE SubInd_chNewSs (
218 chr varchar (3) NOT NULL ,
219 batch_id int NOT NULL ,
220 subsnp_id int NOT NULL ,
221 submitted_ind_id int NOT NULL ,
222 submitted_strand_code int NULL ,
223 allele_flag smallint NULL ,
225 submitted_rs int NULL
229 CREATE TABLE SubInd_chNotOn (
230 chr varchar (8) NOT NULL ,
231 batch_id int NOT NULL ,
232 subsnp_id int NOT NULL ,
233 submitted_ind_id int NOT NULL ,
234 submitted_strand_code int NULL ,
235 allele_flag int NULL ,
237 submitted_rs int NULL
241 CREATE TABLE SubInd_chPAR (
242 chr varchar (3) NOT NULL ,
243 batch_id int NOT NULL ,
244 subsnp_id int NOT NULL ,
245 submitted_ind_id int NOT NULL ,
246 submitted_strand_code int NULL ,
247 allele_flag int NULL ,
249 submitted_rs int NULL
253 CREATE TABLE SubInd_chUn (
254 chr varchar (3) NOT NULL ,
255 batch_id int NOT NULL ,
256 subsnp_id int NOT NULL ,
257 submitted_ind_id int NOT NULL ,
258 submitted_strand_code int NULL ,
259 allele_flag int NULL ,
261 submitted_rs int NULL
265 CREATE TABLE SubInd_chX (
266 chr varchar (3) NOT NULL ,
267 batch_id int NOT NULL ,
268 subsnp_id int NOT NULL ,
269 submitted_ind_id int NOT NULL ,
270 submitted_strand_code int NULL ,
271 allele_flag int NULL ,
273 submitted_rs int NULL
277 CREATE TABLE SubInd_chY (
278 chr varchar (3) NOT NULL ,
279 batch_id int NOT NULL ,
280 subsnp_id int NOT NULL ,
281 submitted_ind_id int NOT NULL ,
282 submitted_strand_code int NULL ,
283 allele_flag int NULL ,
285 submitted_rs int NULL
289 CREATE TABLE dn_table_rowcount (
290 tabname varchar (64) NOT NULL ,
291 row_cnt int NOT NULL ,
292 build_id int NOT NULL ,
293 update_time TIMESTAMP NOT NULL ,
294 rows_in_spaceused int NULL ,
295 reserved_KB_spaceused int NULL ,
296 data_KB_spaceused int NULL ,
297 index_size_KB_spaceused int NULL ,
298 unused_KB_spaceused int NULL