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 ,
7 [allele_flag] [int] NULL ,
9 [submitted_rs] [int] NULL
14 CREATE TABLE [SubInd_ch11] (
15 [chr] [varchar] (3) NOT NULL ,
16 [batch_id] [int] NOT NULL ,
17 [subsnp_id] [int] NOT NULL ,
18 [submitted_ind_id] [int] NOT NULL ,
19 [submitted_strand_code] [int] NULL ,
20 [allele_flag] [int] NULL ,
22 [submitted_rs] [int] NULL
27 CREATE TABLE [SubInd_ch12] (
28 [chr] [varchar] (3) NOT NULL ,
29 [batch_id] [int] NOT NULL ,
30 [subsnp_id] [int] NOT NULL ,
31 [submitted_ind_id] [int] NOT NULL ,
32 [submitted_strand_code] [int] NULL ,
33 [allele_flag] [int] NULL ,
35 [submitted_rs] [int] NULL
40 CREATE TABLE [SubInd_ch13] (
41 [chr] [varchar] (3) NOT NULL ,
42 [batch_id] [int] NOT NULL ,
43 [subsnp_id] [int] NOT NULL ,
44 [submitted_ind_id] [int] NOT NULL ,
45 [submitted_strand_code] [int] NULL ,
46 [allele_flag] [int] NULL ,
48 [submitted_rs] [int] NULL
53 CREATE TABLE [SubInd_ch14] (
54 [chr] [varchar] (3) NOT NULL ,
55 [batch_id] [int] NOT NULL ,
56 [subsnp_id] [int] NOT NULL ,
57 [submitted_ind_id] [int] NOT NULL ,
58 [submitted_strand_code] [int] NULL ,
59 [allele_flag] [int] NULL ,
61 [submitted_rs] [int] NULL
66 CREATE TABLE [SubInd_ch15] (
67 [chr] [varchar] (3) NOT NULL ,
68 [batch_id] [int] NOT NULL ,
69 [subsnp_id] [int] NOT NULL ,
70 [submitted_ind_id] [int] NOT NULL ,
71 [submitted_strand_code] [int] NULL ,
72 [allele_flag] [int] NULL ,
74 [submitted_rs] [int] NULL
79 CREATE TABLE [SubInd_ch16] (
80 [chr] [varchar] (3) NOT NULL ,
81 [batch_id] [int] NOT NULL ,
82 [subsnp_id] [int] NOT NULL ,
83 [submitted_ind_id] [int] NOT NULL ,
84 [submitted_strand_code] [int] NULL ,
85 [allele_flag] [int] NULL ,
87 [submitted_rs] [int] NULL
92 CREATE TABLE [SubInd_ch17] (
93 [chr] [varchar] (3) NOT NULL ,
94 [batch_id] [int] NOT NULL ,
95 [subsnp_id] [int] NOT NULL ,
96 [submitted_ind_id] [int] NOT NULL ,
97 [submitted_strand_code] [int] NULL ,
98 [allele_flag] [int] NULL ,
100 [submitted_rs] [int] NULL
105 CREATE TABLE [SubInd_ch18] (
106 [chr] [varchar] (3) NOT NULL ,
107 [batch_id] [int] NOT NULL ,
108 [subsnp_id] [int] NOT NULL ,
109 [submitted_ind_id] [int] NOT NULL ,
110 [submitted_strand_code] [int] NULL ,
111 [allele_flag] [int] NULL ,
112 [gty_id] [int] NULL ,
113 [submitted_rs] [int] NULL
118 CREATE TABLE [SubInd_ch19] (
119 [chr] [varchar] (3) NOT NULL ,
120 [batch_id] [int] NOT NULL ,
121 [subsnp_id] [int] NOT NULL ,
122 [submitted_ind_id] [int] NOT NULL ,
123 [submitted_strand_code] [int] NULL ,
124 [allele_flag] [int] NULL ,
125 [gty_id] [int] NULL ,
126 [submitted_rs] [int] NULL
131 CREATE TABLE [SubInd_ch20] (
132 [chr] [varchar] (3) NOT NULL ,
133 [batch_id] [int] NOT NULL ,
134 [subsnp_id] [int] NOT NULL ,
135 [submitted_ind_id] [int] NOT NULL ,
136 [submitted_strand_code] [int] NULL ,
137 [allele_flag] [int] NULL ,
138 [gty_id] [int] NULL ,
139 [submitted_rs] [int] NULL
144 CREATE TABLE [SubInd_ch21] (
145 [chr] [varchar] (3) NOT NULL ,
146 [batch_id] [int] NOT NULL ,
147 [subsnp_id] [int] NOT NULL ,
148 [submitted_ind_id] [int] NOT NULL ,
149 [submitted_strand_code] [int] NULL ,
150 [allele_flag] [int] NULL ,
151 [gty_id] [int] NULL ,
152 [submitted_rs] [int] NULL
157 CREATE TABLE [SubInd_ch22] (
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 ,
164 [gty_id] [int] NULL ,
165 [submitted_rs] [int] NULL
170 CREATE TABLE [SubInd_ch8] (
171 [chr] [varchar] (3) NOT NULL ,
172 [batch_id] [int] NOT NULL ,
173 [subsnp_id] [int] NOT NULL ,
174 [submitted_ind_id] [int] NOT NULL ,
175 [submitted_strand_code] [int] NULL ,
176 [allele_flag] [int] NULL ,
177 [gty_id] [int] NULL ,
178 [submitted_rs] [int] NULL
183 CREATE TABLE [SubInd_ch9] (
184 [chr] [varchar] (3) NOT NULL ,
185 [batch_id] [int] NOT NULL ,
186 [subsnp_id] [int] NOT NULL ,
187 [submitted_ind_id] [int] NOT NULL ,
188 [submitted_strand_code] [int] NULL ,
189 [allele_flag] [int] NULL ,
190 [gty_id] [int] NULL ,
191 [submitted_rs] [int] NULL
196 CREATE TABLE [SubInd_chAltOnly] (
197 [chr] [varchar] (8) NOT NULL ,
198 [batch_id] [int] NOT NULL ,
199 [subsnp_id] [int] NOT NULL ,
200 [submitted_ind_id] [int] NOT NULL ,
201 [submitted_strand_code] [int] NULL ,
202 [allele_flag] [int] NULL ,
203 [gty_id] [int] NULL ,
204 [submitted_rs] [int] NULL
209 CREATE TABLE [SubInd_chMT] (
210 [chr] [varchar] (8) NOT NULL ,
211 [batch_id] [int] NOT NULL ,
212 [subsnp_id] [int] NOT NULL ,
213 [submitted_ind_id] [int] NOT NULL ,
214 [submitted_strand_code] [int] NULL ,
215 [allele_flag] [int] NULL ,
216 [gty_id] [int] NULL ,
217 [submitted_rs] [int] NULL
222 CREATE TABLE [SubInd_chMulti] (
223 [chr] [varchar] (8) NOT NULL ,
224 [batch_id] [int] NOT NULL ,
225 [subsnp_id] [int] NOT NULL ,
226 [submitted_ind_id] [int] NOT NULL ,
227 [submitted_strand_code] [int] NULL ,
228 [allele_flag] [int] NULL ,
229 [gty_id] [int] NULL ,
230 [submitted_rs] [int] NULL
235 CREATE TABLE [SubInd_chNewSs] (
236 [chr] [varchar] (3) NOT NULL ,
237 [batch_id] [int] NOT NULL ,
238 [subsnp_id] [int] NOT NULL ,
239 [submitted_ind_id] [int] NOT NULL ,
240 [submitted_strand_code] [int] NULL ,
241 [allele_flag] [tinyint] NULL ,
242 [gty_id] [int] NULL ,
243 [submitted_rs] [int] NULL
248 CREATE TABLE [SubInd_chNotOn] (
249 [chr] [varchar] (8) NOT NULL ,
250 [batch_id] [int] NOT NULL ,
251 [subsnp_id] [int] NOT NULL ,
252 [submitted_ind_id] [int] NOT NULL ,
253 [submitted_strand_code] [int] NULL ,
254 [allele_flag] [int] NULL ,
255 [gty_id] [int] NULL ,
256 [submitted_rs] [int] NULL
261 CREATE TABLE [SubInd_chPAR] (
262 [chr] [varchar] (3) NOT NULL ,
263 [batch_id] [int] NOT NULL ,
264 [subsnp_id] [int] NOT NULL ,
265 [submitted_ind_id] [int] NOT NULL ,
266 [submitted_strand_code] [int] NULL ,
267 [allele_flag] [int] NULL ,
268 [gty_id] [int] NULL ,
269 [submitted_rs] [int] NULL
274 CREATE TABLE [SubInd_chUn] (
275 [chr] [varchar] (3) NOT NULL ,
276 [batch_id] [int] NOT NULL ,
277 [subsnp_id] [int] NOT NULL ,
278 [submitted_ind_id] [int] NOT NULL ,
279 [submitted_strand_code] [int] NULL ,
280 [allele_flag] [int] NULL ,
281 [gty_id] [int] NULL ,
282 [submitted_rs] [int] NULL
287 CREATE TABLE [SubInd_chX] (
288 [chr] [varchar] (3) NOT NULL ,
289 [batch_id] [int] NOT NULL ,
290 [subsnp_id] [int] NOT NULL ,
291 [submitted_ind_id] [int] NOT NULL ,
292 [submitted_strand_code] [int] NULL ,
293 [allele_flag] [int] NULL ,
294 [gty_id] [int] NULL ,
295 [submitted_rs] [int] NULL
300 CREATE TABLE [SubInd_chY] (
301 [chr] [varchar] (3) NOT NULL ,
302 [batch_id] [int] NOT NULL ,
303 [subsnp_id] [int] NOT NULL ,
304 [submitted_ind_id] [int] NOT NULL ,
305 [submitted_strand_code] [int] NULL ,
306 [allele_flag] [int] NULL ,
307 [gty_id] [int] NULL ,
308 [submitted_rs] [int] NULL
313 CREATE TABLE [dn_table_rowcount] (
314 [tabname] [varchar] (64) NOT NULL ,
315 [row_cnt] [int] NOT NULL ,
316 [build_id] [int] NOT NULL ,
317 [update_time] [datetime] NOT NULL ,
318 [rows_in_spaceused] [int] NULL ,
319 [reserved_KB_spaceused] [int] NULL ,
320 [data_KB_spaceused] [int] NULL ,
321 [index_size_KB_spaceused] [int] NULL ,
322 [unused_KB_spaceused] [int] NULL