1 CREATE TABLE [SubInd_ch10]
3 [chr] [varchar](3) NOT NULL ,
4 [batch_id] [int] NOT NULL ,
5 [subsnp_id] [int] NOT NULL ,
6 [submitted_ind_id] [int] NOT NULL ,
7 [submitted_strand_code] [int] NULL ,
8 [allele_flag] [int] NULL ,
10 [submitted_rs] [int] NULL
14 CREATE TABLE [SubInd_ch11]
16 [chr] [varchar](3) NOT NULL ,
17 [batch_id] [int] NOT NULL ,
18 [subsnp_id] [int] NOT NULL ,
19 [submitted_ind_id] [int] NOT NULL ,
20 [submitted_strand_code] [int] NULL ,
21 [allele_flag] [int] NULL ,
23 [submitted_rs] [int] NULL
27 CREATE TABLE [SubInd_ch12]
29 [chr] [varchar](3) NOT NULL ,
30 [batch_id] [int] NOT NULL ,
31 [subsnp_id] [int] NOT NULL ,
32 [submitted_ind_id] [int] NOT NULL ,
33 [submitted_strand_code] [int] NULL ,
34 [allele_flag] [int] NULL ,
36 [submitted_rs] [int] NULL
40 CREATE TABLE [SubInd_ch13]
42 [chr] [varchar](3) NOT NULL ,
43 [batch_id] [int] NOT NULL ,
44 [subsnp_id] [int] NOT NULL ,
45 [submitted_ind_id] [int] NOT NULL ,
46 [submitted_strand_code] [int] NULL ,
47 [allele_flag] [int] NULL ,
49 [submitted_rs] [int] NULL
53 CREATE TABLE [SubInd_ch14]
55 [chr] [varchar](3) NOT NULL ,
56 [batch_id] [int] NOT NULL ,
57 [subsnp_id] [int] NOT NULL ,
58 [submitted_ind_id] [int] NOT NULL ,
59 [submitted_strand_code] [int] NULL ,
60 [allele_flag] [int] NULL ,
62 [submitted_rs] [int] NULL
66 CREATE TABLE [SubInd_ch15]
68 [chr] [varchar](3) NOT NULL ,
69 [batch_id] [int] NOT NULL ,
70 [subsnp_id] [int] NOT NULL ,
71 [submitted_ind_id] [int] NOT NULL ,
72 [submitted_strand_code] [int] NULL ,
73 [allele_flag] [int] NULL ,
75 [submitted_rs] [int] NULL
79 CREATE TABLE [SubInd_ch16]
81 [chr] [varchar](3) NOT NULL ,
82 [batch_id] [int] NOT NULL ,
83 [subsnp_id] [int] NOT NULL ,
84 [submitted_ind_id] [int] NOT NULL ,
85 [submitted_strand_code] [int] NULL ,
86 [allele_flag] [int] NULL ,
88 [submitted_rs] [int] NULL
92 CREATE TABLE [SubInd_ch17]
94 [chr] [varchar](3) NOT NULL ,
95 [batch_id] [int] NOT NULL ,
96 [subsnp_id] [int] NOT NULL ,
97 [submitted_ind_id] [int] NOT NULL ,
98 [submitted_strand_code] [int] NULL ,
99 [allele_flag] [int] NULL ,
100 [gty_id] [int] NULL ,
101 [submitted_rs] [int] NULL
105 CREATE TABLE [SubInd_ch18]
107 [chr] [varchar](3) NOT NULL ,
108 [batch_id] [int] NOT NULL ,
109 [subsnp_id] [int] NOT NULL ,
110 [submitted_ind_id] [int] NOT NULL ,
111 [submitted_strand_code] [int] NULL ,
112 [allele_flag] [int] NULL ,
113 [gty_id] [int] NULL ,
114 [submitted_rs] [int] NULL
118 CREATE TABLE [SubInd_ch19]
120 [chr] [varchar](3) NOT NULL ,
121 [batch_id] [int] NOT NULL ,
122 [subsnp_id] [int] NOT NULL ,
123 [submitted_ind_id] [int] NOT NULL ,
124 [submitted_strand_code] [int] NULL ,
125 [allele_flag] [int] NULL ,
126 [gty_id] [int] NULL ,
127 [submitted_rs] [int] NULL
131 CREATE TABLE [SubInd_ch20]
133 [chr] [varchar](3) NOT NULL ,
134 [batch_id] [int] NOT NULL ,
135 [subsnp_id] [int] NOT NULL ,
136 [submitted_ind_id] [int] NOT NULL ,
137 [submitted_strand_code] [int] NULL ,
138 [allele_flag] [int] NULL ,
139 [gty_id] [int] NULL ,
140 [submitted_rs] [int] NULL
144 CREATE TABLE [SubInd_ch21]
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 ,
152 [gty_id] [int] NULL ,
153 [submitted_rs] [int] NULL
157 CREATE TABLE [SubInd_ch22]
159 [chr] [varchar](3) NOT NULL ,
160 [batch_id] [int] NOT NULL ,
161 [subsnp_id] [int] NOT NULL ,
162 [submitted_ind_id] [int] NOT NULL ,
163 [submitted_strand_code] [int] NULL ,
164 [allele_flag] [int] NULL ,
165 [gty_id] [int] NULL ,
166 [submitted_rs] [int] NULL
170 CREATE TABLE [SubInd_ch8]
172 [chr] [varchar](3) NOT NULL ,
173 [batch_id] [int] NOT NULL ,
174 [subsnp_id] [int] NOT NULL ,
175 [submitted_ind_id] [int] NOT NULL ,
176 [submitted_strand_code] [int] NULL ,
177 [allele_flag] [int] NULL ,
178 [gty_id] [int] NULL ,
179 [submitted_rs] [int] NULL
183 CREATE TABLE [SubInd_ch9]
185 [chr] [varchar](3) NOT NULL ,
186 [batch_id] [int] NOT NULL ,
187 [subsnp_id] [int] NOT NULL ,
188 [submitted_ind_id] [int] NOT NULL ,
189 [submitted_strand_code] [int] NULL ,
190 [allele_flag] [int] NULL ,
191 [gty_id] [int] NULL ,
192 [submitted_rs] [int] NULL
196 CREATE TABLE [SubInd_chAltOnly]
198 [chr] [varchar](8) NOT NULL ,
199 [batch_id] [int] NOT NULL ,
200 [subsnp_id] [int] NOT NULL ,
201 [submitted_ind_id] [int] NOT NULL ,
202 [submitted_strand_code] [int] NULL ,
203 [allele_flag] [int] NULL ,
204 [gty_id] [int] NULL ,
205 [submitted_rs] [int] NULL
209 CREATE TABLE [SubInd_chMT]
211 [chr] [varchar](8) NOT NULL ,
212 [batch_id] [int] NOT NULL ,
213 [subsnp_id] [int] NOT NULL ,
214 [submitted_ind_id] [int] NOT NULL ,
215 [submitted_strand_code] [int] NULL ,
216 [allele_flag] [int] NULL ,
217 [gty_id] [int] NULL ,
218 [submitted_rs] [int] NULL
222 CREATE TABLE [SubInd_chMulti]
224 [chr] [varchar](8) NOT NULL ,
225 [batch_id] [int] NOT NULL ,
226 [subsnp_id] [int] NOT NULL ,
227 [submitted_ind_id] [int] NOT NULL ,
228 [submitted_strand_code] [int] NULL ,
229 [allele_flag] [int] NULL ,
230 [gty_id] [int] NULL ,
231 [submitted_rs] [int] NULL
235 CREATE TABLE [SubInd_chNewSs]
237 [chr] [varchar](3) NOT NULL ,
238 [batch_id] [int] NOT NULL ,
239 [subsnp_id] [int] NOT NULL ,
240 [submitted_ind_id] [int] NOT NULL ,
241 [submitted_strand_code] [int] NULL ,
242 [allele_flag] [tinyint] NULL ,
243 [gty_id] [int] NULL ,
244 [submitted_rs] [int] NULL
248 CREATE TABLE [SubInd_chNotOn]
250 [chr] [varchar](8) NOT NULL ,
251 [batch_id] [int] NOT NULL ,
252 [subsnp_id] [int] NOT NULL ,
253 [submitted_ind_id] [int] NOT NULL ,
254 [submitted_strand_code] [int] NULL ,
255 [allele_flag] [int] NULL ,
256 [gty_id] [int] NULL ,
257 [submitted_rs] [int] NULL
261 CREATE TABLE [SubInd_chPAR]
263 [chr] [varchar](3) NOT NULL ,
264 [batch_id] [int] NOT NULL ,
265 [subsnp_id] [int] NOT NULL ,
266 [submitted_ind_id] [int] NOT NULL ,
267 [submitted_strand_code] [int] NULL ,
268 [allele_flag] [int] NULL ,
269 [gty_id] [int] NULL ,
270 [submitted_rs] [int] NULL
274 CREATE TABLE [SubInd_chUn]
276 [chr] [varchar](3) NOT NULL ,
277 [batch_id] [int] NOT NULL ,
278 [subsnp_id] [int] NOT NULL ,
279 [submitted_ind_id] [int] NOT NULL ,
280 [submitted_strand_code] [int] NULL ,
281 [allele_flag] [int] NULL ,
282 [gty_id] [int] NULL ,
283 [submitted_rs] [int] NULL
287 CREATE TABLE [SubInd_chX]
289 [chr] [varchar](3) NOT NULL ,
290 [batch_id] [int] NOT NULL ,
291 [subsnp_id] [int] NOT NULL ,
292 [submitted_ind_id] [int] NOT NULL ,
293 [submitted_strand_code] [int] NULL ,
294 [allele_flag] [int] NULL ,
295 [gty_id] [int] NULL ,
296 [submitted_rs] [int] NULL
300 CREATE TABLE [SubInd_chY]
302 [chr] [varchar](3) NOT NULL ,
303 [batch_id] [int] NOT NULL ,
304 [subsnp_id] [int] NOT NULL ,
305 [submitted_ind_id] [int] NOT NULL ,
306 [submitted_strand_code] [int] NULL ,
307 [allele_flag] [int] NULL ,
308 [gty_id] [int] NULL ,
309 [submitted_rs] [int] NULL
313 CREATE TABLE [dn_table_rowcount]
315 [tabname] [varchar](64) NOT NULL ,
316 [row_cnt] [int] NOT NULL ,
317 [build_id] [int] NOT NULL ,
318 [update_time] [datetime] NOT NULL ,
319 [rows_in_spaceused] [int] NULL ,
320 [reserved_KB_spaceused] [int] NULL ,
321 [data_KB_spaceused] [int] NULL ,
322 [index_size_KB_spaceused] [int] NULL ,
323 [unused_KB_spaceused] [int] NULL