3 allele_id int NOT NULL ,
4 allele varchar(255) NOT NULL ,
5 create_time TIMESTAMP NOT NULL ,
6 rev_allele_id int NULL ,
8 last_updated_time TIMESTAMP NULL
10 CREATE TABLE AlleleFlagCode
12 code smallint NOT NULL ,
13 abbrev varchar(12) NOT NULL ,
14 descrip varchar(255) NOT NULL ,
15 create_time TIMESTAMP NOT NULL
17 CREATE TABLE AlleleMotif
19 allele_id int NOT NULL ,
20 motif_order int NOT NULL ,
21 motif_id int NOT NULL ,
22 repeat_cnt real NOT NULL ,
23 create_time TIMESTAMP NOT NULL
27 name varchar(30) NOT NULL ,
30 create_time TIMESTAMP NULL ,
31 last_updated_time TIMESTAMP NULL ,
32 comment varchar(255) NULL
37 position smallint NOT NULL ,
38 author varchar(255) NOT NULL ,
39 create_time TIMESTAMP NULL ,
40 last_updated_time TIMESTAMP NULL
42 CREATE TABLE Batch_tax_id
44 batch_id int NOT NULL ,
46 update_time TIMESTAMP NOT NULL
48 CREATE TABLE ChiSqPValueLookUp
50 df smallint NOT NULL ,
51 chisq_from float NOT NULL ,
52 chisq_to float NOT NULL ,
53 pvalue_upper_bound float NOT NULL
57 code smallint NOT NULL ,
58 abbrev varchar(12) NOT NULL ,
59 descrip varchar(255) NOT NULL
61 CREATE TABLE GenBankDivisionCode
63 code varchar(6) NOT NULL ,
64 abbrev varchar(40) NOT NULL ,
65 descrip varchar(255) NOT NULL ,
66 display_order smallint NOT NULL ,
67 create_time TIMESTAMP NOT NULL
69 CREATE TABLE GenderCode
71 code char(1) NOT NULL ,
72 gender varchar(6) NOT NULL
74 CREATE TABLE GenomeBuildInfo
76 snp_build_id int NOT NULL ,
78 database_name varchar(32) NOT NULL ,
79 ncbi_build_id int NOT NULL ,
80 ncbi_build_ver smallint NOT NULL ,
81 insert_time TIMESTAMP NOT NULL ,
82 is_major smallint NOT NULL ,
83 ncbi_genome_tax_id int NOT NULL ,
84 ref_assembly varchar(32) NULL ,
85 annot_set_acc varchar(32) NULL ,
86 annot_set_ver smallint NULL
88 CREATE TABLE GtyAllele
91 rev_flag bit NOT NULL ,
92 chr_num smallint NOT NULL ,
93 fwd_allele_id int NOT NULL ,
95 create_time TIMESTAMP NOT NULL ,
96 last_updated_time TIMESTAMP NOT NULL
100 allele varchar(1) NOT NULL ,
101 meaning varchar(10) NOT NULL ,
102 bitcode varchar(4) NOT NULL ,
103 value smallint NOT NULL ,
104 rev_base char(1) NULL
106 CREATE TABLE LoadHistory
108 build_id int NOT NULL ,
109 loaddate TIMESTAMP NOT NULL ,
110 status char(30) NOT NULL ,
111 comments varchar(255) NULL ,
112 script varchar(255) NULL ,
113 ftp_done_date TIMESTAMP NULL ,
114 entrez_done_date TIMESTAMP NULL ,
115 blastdb_done_date TIMESTAMP NULL ,
116 web_date TIMESTAMP NULL
118 CREATE TABLE LocTypeCode
120 code smallint NOT NULL ,
121 abbrev varchar(12) NOT NULL ,
122 descrip varchar(255) NOT NULL ,
123 create_time TIMESTAMP NOT NULL
125 CREATE TABLE MapLinkCode
127 which_code varchar(20) NOT NULL ,
128 code smallint NOT NULL ,
129 abbr varchar(10) NULL ,
130 note varchar(255) NULL ,
131 create_time TIMESTAMP NULL ,
132 last_updated_time TIMESTAMP NULL
136 method_id int NOT NULL ,
137 handle varchar(20) NOT NULL ,
138 loc_method_id varchar(64) NOT NULL ,
139 loc_method_id_upp varchar(64) NOT NULL ,
140 method_class smallint NULL ,
141 template_type smallint NULL ,
142 seq_both_strands varchar(3) NULL ,
143 mult_pcr_amplification varchar(3) NULL ,
144 mult_clones_tested varchar(3) NULL ,
145 create_time TIMESTAMP NULL ,
146 last_updated_time TIMESTAMP NULL
148 CREATE TABLE MethodClass
150 meth_class_id smallint NOT NULL ,
151 name varchar(64) NOT NULL ,
152 last_updated_time TIMESTAMP NOT NULL ,
153 validation_status smallint NOT NULL
155 CREATE TABLE MethodLine
157 method_id int NOT NULL ,
158 line_num smallint NOT NULL ,
159 line varchar(255) NOT NULL ,
160 create_time TIMESTAMP NULL ,
161 last_updated_time TIMESTAMP NULL
165 code smallint NOT NULL ,
166 moltype varchar(10) NOT NULL ,
167 descrip varchar(255) NOT NULL
171 motif_id int NOT NULL ,
172 motif varchar(253) NOT NULL ,
173 rev_motif_id int NULL ,
174 last_updated_time TIMESTAMP NULL
176 CREATE TABLE ObsGenotype
178 gty_id int NOT NULL ,
179 obs varchar(512) NOT NULL ,
180 obs_upp_fix varchar(512) NOT NULL ,
181 last_updated_time TIMESTAMP NOT NULL
183 CREATE TABLE ObsVariation
185 var_id int NOT NULL ,
186 pattern varchar(255) NOT NULL ,
187 create_time TIMESTAMP NOT NULL ,
188 last_updated_time TIMESTAMP NULL ,
190 var_flag smallint NULL
192 CREATE TABLE OrgDbStatus
194 database_name varchar(32) NOT NULL ,
196 SubSNP_cnt int NULL ,
197 cluster_cnt int NULL ,
198 unmapped_rs_cnt int NULL ,
199 SubInd_cnt int NULL ,
201 SubInd_ss_cnt int NULL ,
202 SubPop_cnt int NULL ,
204 SubPop_ss_cnt int NULL ,
205 GtyFreqBySsPop_ss_cnt int NULL ,
206 AlleleFreqBySsPop_ss_cnt int NULL ,
207 SNPGtyFreq_rs_cnt int NULL ,
208 SNPAlleleFreq_rs_cnt int NULL ,
209 snp_build_max int NULL ,
210 genome_build_max varchar(8) NULL ,
211 map_time TIMESTAMP NULL ,
212 cluster_time_max TIMESTAMP NULL ,
213 create_time TIMESTAMP NULL ,
214 last_SNPBatch_time TIMESTAMP NULL ,
215 last_POPBatch_time TIMESTAMP NULL ,
216 last_INDBatch_time TIMESTAMP NULL ,
218 rsMissenseMax int NULL ,
219 copy2FTP_time TIMESTAMP NULL
221 CREATE TABLE OrganismTax
223 organism varchar(128) NOT NULL ,
224 tax_id int NOT NULL ,
225 common_name varchar(32) NULL ,
226 gpipe_abbr varchar(7) NOT NULL ,
227 create_time TIMESTAMP NOT NULL ,
228 last_updated_time TIMESTAMP NOT NULL ,
229 comment varchar(255) NULL ,
230 division_cd varchar(6) NULL ,
231 database_name varchar(32) NOT NULL ,
232 short_common_name varchar(32) NOT NULL ,
233 tax_id_rank varchar(5) NOT NULL ,
234 species_tax_id int NOT NULL ,
235 no_freq_summary bit NULL ,
236 entrez_index smallint NULL ,
237 pub_genome_build decimal NULL
239 CREATE TABLE PopClass
241 pop_id int NOT NULL ,
242 pop_class_id int NOT NULL ,
245 CREATE TABLE PopClassCode
247 pop_class_id int NOT NULL ,
248 pop_class char(50) NOT NULL ,
249 pop_class_text char(255) NOT NULL
251 CREATE TABLE Publication
253 pub_id int NOT NULL ,
255 handle varchar(20) NOT NULL ,
257 title varchar(235) NOT NULL ,
258 journal varchar(255) NULL ,
259 vol varchar(255) NULL ,
260 suppl varchar(128) NULL ,
261 issue varchar(128) NULL ,
262 i_suppl varchar(128) NULL ,
263 pages varchar(255) NULL ,
264 year smallint NOT NULL ,
265 status smallint NOT NULL ,
266 blobflag smallint NULL ,
267 last_updated TIMESTAMP NOT NULL ,
268 create_time TIMESTAMP NULL ,
269 last_updated_time TIMESTAMP NULL
271 CREATE TABLE SNPGlossary
273 term varchar(256) NOT NULL ,
274 description varchar(4000) NULL ,
275 last_updated TIMESTAMP NULL ,
276 used_in varchar(32) NULL
278 CREATE TABLE SNP_tax_id
280 snp_id int NOT NULL ,
282 update_time TIMESTAMP NULL ,
285 CREATE TABLE SnpChrCode
287 code varchar(8) NOT NULL ,
288 abbrev varchar(20) NOT NULL ,
289 descrip varchar(255) NOT NULL ,
290 create_time TIMESTAMP NOT NULL ,
291 sort_order smallint NULL ,
292 db_name varchar(32) NULL ,
293 NC_acc varchar(16) NULL
295 CREATE TABLE SnpClassCode
297 code smallint NOT NULL ,
298 abbrev varchar(20) NOT NULL ,
299 descrip varchar(255) NOT NULL ,
300 display_str varchar(255) NULL
302 CREATE TABLE SnpFunctionCode
304 code smallint NOT NULL ,
305 abbrev varchar(20) NOT NULL ,
306 descrip varchar(255) NOT NULL ,
307 create_time TIMESTAMP NOT NULL ,
308 top_level_class char(5) NOT NULL ,
309 is_coding smallint NOT NULL ,
311 var_prop_effect_code int NULL ,
312 var_prop_gene_loc_code int NULL ,
313 SO_id varchar(32) NULL
315 CREATE TABLE SnpValidationCode
317 code smallint NOT NULL ,
318 abbrev varchar(64) NOT NULL ,
319 descrip varchar(255) NOT NULL ,
320 create_time TIMESTAMP NULL ,
321 last_updated_time TIMESTAMP NULL
323 CREATE TABLE StrandCode
325 code smallint NOT NULL ,
326 abbrev varchar(20) NOT NULL ,
327 rs_to_ss_orien bit NOT NULL ,
328 descrip varchar(255) NOT NULL ,
329 create_time TIMESTAMP NOT NULL
331 CREATE TABLE SubSNPDelComm
333 comment_id smallint NOT NULL ,
334 comment varchar(400) NOT NULL ,
335 create_time TIMESTAMP NULL
337 CREATE TABLE SubSNPSeqTypeCode
339 code smallint NOT NULL ,
340 abbrev varchar(20) NOT NULL ,
341 descrip varchar(255) NOT NULL
343 CREATE TABLE Submitter
345 handle varchar(20) NOT NULL ,
346 name varchar(255) NOT NULL ,
347 fax varchar(255) NULL ,
348 phone varchar(255) NULL ,
349 email varchar(255) NULL ,
350 lab varchar(255) NULL ,
351 institution varchar(255) NULL ,
352 address varchar(255) NULL ,
353 create_time TIMESTAMP NULL ,
354 last_updated_time TIMESTAMP NULL
356 CREATE TABLE TemplateType
358 temp_type_id smallint NOT NULL ,
359 name varchar(64) NOT NULL ,
360 last_updated_time TIMESTAMP NOT NULL
364 unigty_id int NOT NULL ,
365 gty_str varchar(255) NULL ,
366 allele_id_1 int NOT NULL ,
367 allele_id_2 int NULL ,
368 create_time TIMESTAMP NOT NULL
370 CREATE TABLE UniVariAllele
372 univar_id int NOT NULL ,
373 allele_id int NOT NULL ,
374 create_time TIMESTAMP NOT NULL
376 CREATE TABLE UniVariation
378 univar_id int NOT NULL ,
379 var_str varchar(900) NULL ,
380 allele_cnt smallint NOT NULL ,
381 subsnp_class smallint NOT NULL ,
382 iupack_code char(1) NOT NULL ,
383 top_or_bot_strand char(1) NOT NULL ,
384 create_time TIMESTAMP NOT NULL ,
385 last_updated_time TIMESTAMP NOT NULL ,
386 src_code smallint NULL ,
387 rev_univar_id int NULL
389 CREATE TABLE UniVariationSrcCode
391 code smallint NOT NULL ,
392 abbrev varchar(20) NOT NULL ,
393 descrip varchar(255) NOT NULL
395 CREATE TABLE VariAllele
397 var_id int NOT NULL ,
398 allele_id int NOT NULL ,
399 create_time TIMESTAMP NOT NULL
401 CREATE TABLE db_ftp_table_list
403 table_name varchar(32) NOT NULL ,
404 db_str varchar(64) NOT NULL ,
405 create_time TIMESTAMP NULL
407 CREATE TABLE db_map_table_name
409 table_name varchar(32) NOT NULL ,
411 isCurrent char(1) NULL ,
412 inNonHuman char(1) NOT NULL
414 CREATE TABLE dn_Allele_rev
416 allele_id int NOT NULL ,
417 rev_flag smallint NOT NULL ,
418 fwd_allele_id int NOT NULL ,
419 fwd_allele varchar(255) NOT NULL
421 CREATE TABLE dn_Motif_rev
423 motif_id int NOT NULL ,
424 rev_flag smallint NOT NULL ,
425 fwd_motif varchar(253) NULL ,
426 fwd_motif_id int NULL
428 CREATE TABLE dn_UniGty_allele
430 unigty_id int NOT NULL ,
431 chr_num smallint NOT NULL ,
432 allele_id int NOT NULL ,
433 create_time TIMESTAMP NOT NULL
435 CREATE TABLE dn_UniGty_rev
437 unigty_id int NOT NULL ,
438 rev_flag smallint NOT NULL ,
439 fwd_unigty_id int NOT NULL ,
440 fwd_gty_str varchar(255) NULL
442 CREATE TABLE dn_UniVariation_rev
444 univar_id int NOT NULL ,
445 rev_flag smallint NOT NULL ,
446 fwd_univar_id int NULL ,
447 fwd_univar_str varchar(900) NULL
449 CREATE TABLE dn_baseFlip
452 rev_flag smallint NULL ,
453 fwd_base char(1) NULL
455 CREATE TABLE dn_gty2unigty_trueSNP
457 gty_id int NOT NULL ,
458 rev_flag bit NOT NULL ,
460 obs varchar(512) NOT NULL ,
461 gty_str varchar(255) NULL
463 CREATE TABLE dn_summary
465 tax_id int NOT NULL ,
466 build_id int NOT NULL ,
467 type varchar(20) NOT NULL ,
469 create_time TIMESTAMP NOT NULL ,
470 last_updated_time TIMESTAMP NOT NULL