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 ,
12 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 ,
23 CREATE TABLE SubInd_ch12
25 chr varchar(3) NOT NULL ,
26 batch_id int NOT NULL ,
27 subsnp_id int NOT NULL ,
28 submitted_ind_id int NOT NULL ,
29 submitted_strand_code int NULL ,
30 allele_flag int NULL ,
34 CREATE TABLE SubInd_ch13
36 chr varchar(3) NOT NULL ,
37 batch_id int NOT NULL ,
38 subsnp_id int NOT NULL ,
39 submitted_ind_id int NOT NULL ,
40 submitted_strand_code int NULL ,
41 allele_flag int NULL ,
45 CREATE TABLE SubInd_ch14
47 chr varchar(3) NOT NULL ,
48 batch_id int NOT NULL ,
49 subsnp_id int NOT NULL ,
50 submitted_ind_id int NOT NULL ,
51 submitted_strand_code int NULL ,
52 allele_flag int NULL ,
56 CREATE TABLE SubInd_ch15
58 chr varchar(3) NOT NULL ,
59 batch_id int NOT NULL ,
60 subsnp_id int NOT NULL ,
61 submitted_ind_id int NOT NULL ,
62 submitted_strand_code int NULL ,
63 allele_flag int NULL ,
67 CREATE TABLE SubInd_ch16
69 chr varchar(3) NOT NULL ,
70 batch_id int NOT NULL ,
71 subsnp_id int NOT NULL ,
72 submitted_ind_id int NOT NULL ,
73 submitted_strand_code int NULL ,
74 allele_flag int NULL ,
78 CREATE TABLE SubInd_ch17
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 ,
89 CREATE TABLE SubInd_ch18
91 chr varchar(3) NOT NULL ,
92 batch_id int NOT NULL ,
93 subsnp_id int NOT NULL ,
94 submitted_ind_id int NOT NULL ,
95 submitted_strand_code int NULL ,
96 allele_flag int NULL ,
100 CREATE TABLE SubInd_ch19
102 chr varchar(3) NOT NULL ,
103 batch_id int NOT NULL ,
104 subsnp_id int NOT NULL ,
105 submitted_ind_id int NOT NULL ,
106 submitted_strand_code int NULL ,
107 allele_flag int NULL ,
109 submitted_rs int NULL
111 CREATE TABLE SubInd_ch20
113 chr varchar(3) NOT NULL ,
114 batch_id int NOT NULL ,
115 subsnp_id int NOT NULL ,
116 submitted_ind_id int NOT NULL ,
117 submitted_strand_code int NULL ,
118 allele_flag int NULL ,
120 submitted_rs int NULL
122 CREATE TABLE SubInd_ch21
124 chr varchar(3) NOT NULL ,
125 batch_id int NOT NULL ,
126 subsnp_id int NOT NULL ,
127 submitted_ind_id int NOT NULL ,
128 submitted_strand_code int NULL ,
129 allele_flag int NULL ,
131 submitted_rs int NULL
133 CREATE TABLE SubInd_ch22
135 chr varchar(3) NOT NULL ,
136 batch_id int NOT NULL ,
137 subsnp_id int NOT NULL ,
138 submitted_ind_id int NOT NULL ,
139 submitted_strand_code int NULL ,
140 allele_flag int NULL ,
142 submitted_rs int NULL
144 CREATE TABLE SubInd_ch8
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
155 CREATE TABLE SubInd_ch9
157 chr varchar(3) NOT NULL ,
158 batch_id int NOT NULL ,
159 subsnp_id int NOT NULL ,
160 submitted_ind_id int NOT NULL ,
161 submitted_strand_code int NULL ,
162 allele_flag int NULL ,
164 submitted_rs int NULL
166 CREATE TABLE SubInd_chAltOnly
168 chr varchar(8) NOT NULL ,
169 batch_id int NOT NULL ,
170 subsnp_id int NOT NULL ,
171 submitted_ind_id int NOT NULL ,
172 submitted_strand_code int NULL ,
173 allele_flag int NULL ,
175 submitted_rs int NULL
177 CREATE TABLE SubInd_chMT
179 chr varchar(8) NOT NULL ,
180 batch_id int NOT NULL ,
181 subsnp_id int NOT NULL ,
182 submitted_ind_id int NOT NULL ,
183 submitted_strand_code int NULL ,
184 allele_flag int NULL ,
186 submitted_rs int NULL
188 CREATE TABLE SubInd_chMulti
190 chr varchar(8) NOT NULL ,
191 batch_id int NOT NULL ,
192 subsnp_id int NOT NULL ,
193 submitted_ind_id int NOT NULL ,
194 submitted_strand_code int NULL ,
195 allele_flag int NULL ,
197 submitted_rs int NULL
199 CREATE TABLE SubInd_chNewSs
201 chr varchar(3) NOT NULL ,
202 batch_id int NOT NULL ,
203 subsnp_id int NOT NULL ,
204 submitted_ind_id int NOT NULL ,
205 submitted_strand_code int NULL ,
206 allele_flag smallint NULL ,
208 submitted_rs int NULL
210 CREATE TABLE SubInd_chNotOn
212 chr varchar(8) NOT NULL ,
213 batch_id int NOT NULL ,
214 subsnp_id int NOT NULL ,
215 submitted_ind_id int NOT NULL ,
216 submitted_strand_code int NULL ,
217 allele_flag int NULL ,
219 submitted_rs int NULL
221 CREATE TABLE SubInd_chPAR
223 chr varchar(3) 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 ,
230 submitted_rs int NULL
232 CREATE TABLE SubInd_chUn
234 chr varchar(3) NOT NULL ,
235 batch_id int NOT NULL ,
236 subsnp_id int NOT NULL ,
237 submitted_ind_id int NOT NULL ,
238 submitted_strand_code int NULL ,
239 allele_flag int NULL ,
241 submitted_rs int NULL
243 CREATE TABLE SubInd_chX
245 chr varchar(3) NOT NULL ,
246 batch_id int NOT NULL ,
247 subsnp_id int NOT NULL ,
248 submitted_ind_id int NOT NULL ,
249 submitted_strand_code int NULL ,
250 allele_flag int NULL ,
252 submitted_rs int NULL
254 CREATE TABLE SubInd_chY
256 chr varchar(3) NOT NULL ,
257 batch_id int NOT NULL ,
258 subsnp_id int NOT NULL ,
259 submitted_ind_id int NOT NULL ,
260 submitted_strand_code int NULL ,
261 allele_flag int NULL ,
263 submitted_rs int NULL
265 CREATE TABLE dn_table_rowcount
267 tabname varchar(64) NOT NULL ,
268 row_cnt int NOT NULL ,
269 build_id int NOT NULL ,
270 update_time TIMESTAMP NOT NULL ,
271 rows_in_spaceused int NULL ,
272 reserved_KB_spaceused int NULL ,
273 data_KB_spaceused int NULL ,
274 index_size_KB_spaceused int NULL ,
275 unused_KB_spaceused int NULL