-CREATE TABLE "Allele" (
- "allele_id" "int" NOT NULL ,
- "allele" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "rev_allele_id" "int" NULL ,
- "src" "varchar" (10) NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "AlleleFlagCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (12) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "AlleleMotif" (
- "allele_id" "int" NOT NULL ,
- "motif_order" "int" NOT NULL ,
- "motif_id" "int" NOT NULL ,
- "repeat_cnt" "real" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "AllocIds" (
- "name" "varchar" (30) NOT NULL ,
- "id" "int" NOT NULL ,
- "cycle" "int" NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "Author" (
- "pub_id" "int" NOT NULL ,
- "position" "smallint" NOT NULL ,
- "author" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "Batch_tax_id" (
- "batch_id" "int" NOT NULL ,
- "tax_id" "int" NOT NULL ,
- "update_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "ChiSqPValueLookUp" (
- "df" "smallint" NOT NULL ,
- "chisq_from" "float" NOT NULL ,
- "chisq_to" "float" NOT NULL ,
- "pvalue_upper_bound" "float" NOT NULL
-)
-;
-
-CREATE TABLE "CpGCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (12) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL
-)
-;
-
-CREATE TABLE "GenBankDivisionCode" (
- "code" "varchar" (6) NOT NULL ,
- "abbrev" "varchar" (40) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "display_order" "smallint" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "GenderCode" (
- "code" "char" (1) NOT NULL ,
- "gender" "varchar" (6) NOT NULL
-)
-;
-
-CREATE TABLE "GenomeBuildInfo" (
- "snp_build_id" "int" NOT NULL ,
- "tax_id" "int" NOT NULL ,
- "database_name" "varchar" (32) NOT NULL ,
- "ncbi_build_id" "int" NOT NULL ,
- "ncbi_build_ver" "smallint" NOT NULL ,
- "insert_time" "TIMESTAMP" NOT NULL ,
- "is_major" "smallint" NOT NULL ,
- "ncbi_genome_tax_id" "int" NOT NULL ,
- "ref_assembly" "varchar" (255) NULL
-)
-;
-
-CREATE TABLE "GtyAllele" (
- "gty_id" "int" NOT NULL ,
- "rev_flag" "bit" NOT NULL ,
- "chr_num" "smallint" NOT NULL ,
- "fwd_allele_id" "int" NOT NULL ,
- "unigty_id" "int" NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "IUPACna" (
- "allele" "varchar" (1) NOT NULL ,
- "meaning" "varchar" (10) NOT NULL ,
- "bitcode" "varchar" (4) NOT NULL ,
- "value" "smallint" NOT NULL ,
- "rev_base" "char" (1) NULL
-)
-;
-
-CREATE TABLE "LoadHistory" (
- "build_id" "int" NOT NULL ,
- "loaddate" "TIMESTAMP" NOT NULL ,
- "status" "char" (30) NOT NULL ,
- "comments" "varchar" (255) NULL ,
- "script" "varchar" (255) NULL ,
- "ftp_done_date" "TIMESTAMP" NULL ,
- "entrez_done_date" "TIMESTAMP" NULL ,
- "blastdb_done_date" "TIMESTAMP" NULL ,
- "web_date" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "LocTypeCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (12) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "MapLinkCode" (
- "which_code" "varchar" (20) NOT NULL ,
- "code" "smallint" NOT NULL ,
- "abbr" "varchar" (10) NULL ,
- "note" "varchar" (255) NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "Method" (
- "method_id" "int" NOT NULL ,
- "handle" "varchar" (20) NOT NULL ,
- "loc_method_id" "varchar" (64) NOT NULL ,
- "loc_method_id_upp" "varchar" (64) NOT NULL ,
- "method_class" "smallint" NULL ,
- "template_type" "smallint" NULL ,
- "seq_both_strands" "varchar" (3) NULL ,
- "mult_pcr_amplification" "varchar" (3) NULL ,
- "mult_clones_tested" "varchar" (3) NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "MethodClass" (
- "meth_class_id" "smallint" NOT NULL ,
- "name" "varchar" (64) NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL ,
- "validation_status" "smallint" NOT NULL
-)
-;
-
-CREATE TABLE "MethodLine" (
- "method_id" "int" NOT NULL ,
- "line_num" "smallint" NOT NULL ,
- "line" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "Moltype" (
- "code" "smallint" NOT NULL ,
- "moltype" "varchar" (10) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL
-)
-;
-
-CREATE TABLE "Motif" (
- "motif_id" "int" NOT NULL ,
- "motif" "varchar" (253) NOT NULL ,
- "rev_motif_id" "int" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "ObsGenotype" (
- "gty_id" "int" NOT NULL ,
- "obs" "varchar" (512) NOT NULL ,
- "obs_upp_fix" "varchar" (512) NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "ObsVariation" (
- "var_id" "int" NOT NULL ,
- "pattern" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "last_updated_time" "TIMESTAMP" NULL ,
- "univar_id" "int" NULL ,
- "var_flag" "smallint" NULL
-)
-;
-
-CREATE TABLE "OrgDbStatus" (
- "database_name" "varchar" (32) NOT NULL ,
- "SNP_cnt" "int" NULL ,
- "SubSNP_cnt" "int" NULL ,
- "cluster_cnt" "int" NULL ,
- "unmapped_rs_cnt" "int" NULL ,
- "SubInd_cnt" "int" NULL ,
- "ind_cnt" "int" NULL ,
- "SubInd_ss_cnt" "int" NULL ,
- "SubPop_cnt" "int" NULL ,
- "pop_cnt" "int" NULL ,
- "SubPop_ss_cnt" "int" NULL ,
- "GtyFreqBySsPop_ss_cnt" "int" NULL ,
- "AlleleFreqBySsPop_ss_cnt" "int" NULL ,
- "SNPGtyFreq_rs_cnt" "int" NULL ,
- "SNPAlleleFreq_rs_cnt" "int" NULL ,
- "snp_build_max" "int" NULL ,
- "genome_build_max" "varchar" (8) NULL ,
- "map_time" "TIMESTAMP" NULL ,
- "cluster_time_max" "TIMESTAMP" NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_SNPBatch_time" "TIMESTAMP" NULL ,
- "last_POPBatch_time" "TIMESTAMP" NULL ,
- "last_INDBatch_time" "TIMESTAMP" NULL ,
- "rsMax" "int" NULL ,
- "rsMissenseMax" "int" NULL
-)
-;
-
-CREATE TABLE "OrganismTax" (
- "organism" "varchar" (40) NOT NULL ,
- "tax_id" "int" NOT NULL ,
- "common_name" "varchar" (32) NULL ,
- "gpipe_abbr" "varchar" (7) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL ,
- "comment" "varchar" (255) NULL ,
- "division_cd" "varchar" (6) NULL ,
- "database_name" "varchar" (32) NOT NULL ,
- "short_common_name" "varchar" (32) NOT NULL ,
- "tax_id_rank" "varchar" (5) NOT NULL ,
- "species_tax_id" "int" NOT NULL ,
- "no_freq_summary" "bit" NULL ,
- "entrez_index" "smallint" NULL ,
- "pub_genome_build" "decimal"(4, 1) NULL
-)
-;
-
-CREATE TABLE "PopClass" (
- "pop_id" "int" NOT NULL ,
- "pop_class_id" "int" NOT NULL ,
- "snp_count" "int" NULL
-)
-;
-
-CREATE TABLE "PopClassCode" (
- "pop_class_id" "int" NOT NULL ,
- "pop_class" "char" (50) NOT NULL ,
- "pop_class_text" "char" (255) NOT NULL
-)
-;
-
-CREATE TABLE "Publication" (
- "pub_id" "int" NOT NULL ,
- "pmid" "int" NULL ,
- "handle" "varchar" (20) NOT NULL ,
- "meduid" "int" NULL ,
- "title" "varchar" (235) NOT NULL ,
- "journal" "varchar" (255) NULL ,
- "vol" "varchar" (255) NULL ,
- "suppl" "varchar" (128) NULL ,
- "issue" "varchar" (128) NULL ,
- "i_suppl" "varchar" (128) NULL ,
- "pages" "varchar" (255) NULL ,
- "year" "smallint" NOT NULL ,
- "status" "smallint" NOT NULL ,
- "blobflag" "smallint" NULL ,
- "last_updated" "TIMESTAMP" NOT NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "SNPGlossary" (
- "term" "varchar" (256) NOT NULL ,
- "description" "varchar" (4000) NULL ,
- "last_updated" "TIMESTAMP" NULL ,
- "used_in" "varchar" (32) NULL
-)
-;
-
-CREATE TABLE "SNP_tax_id" (
- "snp_id" "int" NOT NULL ,
- "tax_id" "int" NULL ,
- "update_time" "TIMESTAMP" NULL ,
- "status" "char" (1) NULL
-)
-;
-
-CREATE TABLE "SnpChrCode" (
- "code" "varchar" (8) NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "sort_order" "smallint" NULL ,
- "db_name" "varchar" (32) NULL
-)
-;
-
-CREATE TABLE "SnpClassCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "display_str" "varchar" (255) NULL
-)
-;
-
-CREATE TABLE "SnpFunctionCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "top_level_class" "char" (5) NOT NULL ,
- "is_coding" "smallint" NOT NULL ,
- "is_exon" "bit" NULL
-)
-;
-
-CREATE TABLE "SnpValidationCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (40) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "StrandCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "rs_to_ss_orien" "bit" NOT NULL ,
- "descrip" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "SubSNPDelComm" (
- "comment_id" "smallint" NOT NULL ,
- "comment" "varchar" (255) NOT NULL ,
- "create_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "SubSNPSeqTypeCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL
-)
-;
-
-CREATE TABLE "Submitter" (
- "handle" "varchar" (20) NOT NULL ,
- "name" "varchar" (255) NOT NULL ,
- "fax" "varchar" (255) NULL ,
- "phone" "varchar" (255) NULL ,
- "email" "varchar" (255) NULL ,
- "lab" "varchar" (255) NULL ,
- "institution" "varchar" (255) NULL ,
- "address" "varchar" (255) NULL ,
- "create_time" "TIMESTAMP" NULL ,
- "last_updated_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "TemplateType" (
- "temp_type_id" "smallint" NOT NULL ,
- "name" "varchar" (64) NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "UniGty" (
- "unigty_id" "int" NOT NULL ,
- "gty_str" "varchar" (255) NULL ,
- "allele_id_1" "int" NOT NULL ,
- "allele_id_2" "int" NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "UniVariAllele" (
- "univar_id" "int" NOT NULL ,
- "allele_id" "int" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "UniVariation" (
- "univar_id" "int" NOT NULL ,
- "var_str" "varchar" (900) NULL ,
- "allele_cnt" "smallint" NOT NULL ,
- "subsnp_class" "smallint" NOT NULL ,
- "iupack_code" "char" (1) NOT NULL ,
- "top_or_bot_strand" "char" (1) NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL ,
- "src_code" "smallint" NULL ,
- "rev_univar_id" "int" NULL
-)
-;
-
-CREATE TABLE "UniVariationSrcCode" (
- "code" "smallint" NOT NULL ,
- "abbrev" "varchar" (20) NOT NULL ,
- "descrip" "varchar" (255) NOT NULL
-)
-;
-
-CREATE TABLE "VariAllele" (
- "var_id" "int" NOT NULL ,
- "allele_id" "int" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "db_DataDictionaryNew" (
- "tab" "varchar" (64) NULL ,
- "col" "varchar" (32) NULL ,
- "col_order" "int" NULL ,
- "typ" "varchar" (16) NULL ,
- "length" "int" NULL ,
- "description" "varchar" (6000) NULL ,
- "todo" "varchar" (1000) NULL ,
- "update_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "db_ftp_table_list" (
- "table_name" "varchar" (32) NOT NULL ,
- "db_str" "varchar" (64) NOT NULL ,
- "create_time" "TIMESTAMP" NULL
-)
-;
-
-CREATE TABLE "db_map_table_name" (
- "table_name" "varchar" (32) NOT NULL ,
- "to_index" "bit" NULL
-)
-;
-
-CREATE TABLE "dn_Allele_rev" (
- "allele_id" "int" NOT NULL ,
- "rev_flag" "smallint" NOT NULL ,
- "fwd_allele_id" "int" NOT NULL ,
- "fwd_allele" "varchar" (255) NOT NULL
-)
-;
-
-CREATE TABLE "dn_Motif_rev" (
- "motif_id" "int" NOT NULL ,
- "rev_flag" "smallint" NOT NULL ,
- "fwd_motif" "varchar" (253) NULL ,
- "fwd_motif_id" "int" NULL
-)
-;
-
-CREATE TABLE "dn_UniGty_allele" (
- "unigty_id" "int" NOT NULL ,
- "chr_num" "smallint" NOT NULL ,
- "allele_id" "int" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL
-)
-;
-
-CREATE TABLE "dn_UniGty_rev" (
- "unigty_id" "int" NOT NULL ,
- "rev_flag" "smallint" NOT NULL ,
- "fwd_unigty_id" "int" NOT NULL ,
- "fwd_gty_str" "varchar" (255) NULL
-)
-;
-
-CREATE TABLE "dn_UniVariation_rev" (
- "univar_id" "int" NOT NULL ,
- "rev_flag" "smallint" NOT NULL ,
- "fwd_univar_id" "int" NULL ,
- "fwd_univar_str" "varchar" (900) NULL
-)
-;
-
-CREATE TABLE "dn_baseFlip" (
- "base" "char" (1) NULL ,
- "rev_flag" "smallint" NULL ,
- "fwd_base" "char" (1) NULL
-)
-;
-
-CREATE TABLE "dn_gty2unigty_trueSNP" (
- "gty_id" "int" NOT NULL ,
- "rev_flag" "bit" NOT NULL ,
- "unigty_id" "int" NULL ,
- "obs" "varchar" (512) NOT NULL ,
- "gty_str" "varchar" (255) NULL
-)
-;
-
-CREATE TABLE "dn_summary" (
- "tax_id" "int" NOT NULL ,
- "build_id" "int" NOT NULL ,
- "type" "varchar" (20) NOT NULL ,
- "cnt" "int" NOT NULL ,
- "create_time" "TIMESTAMP" NOT NULL ,
- "last_updated_time" "TIMESTAMP" NOT NULL
-)
-;
-
+CREATE TABLE Allele
+(
+allele_id int NOT NULL ,
+allele varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+rev_allele_id int NULL ,
+src varchar(10) NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE AlleleFlagCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE AlleleMotif
+(
+allele_id int NOT NULL ,
+motif_order int NOT NULL ,
+motif_id int NOT NULL ,
+repeat_cnt real NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE AllocIds
+(
+name varchar(30) NOT NULL ,
+id int NOT NULL ,
+cycle int NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL ,
+comment varchar(255) NULL
+);
+CREATE TABLE Author
+(
+pub_id int NOT NULL ,
+position smallint NOT NULL ,
+author varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Batch_tax_id
+(
+batch_id int NOT NULL ,
+tax_id int NOT NULL ,
+update_time TIMESTAMP NOT NULL
+);
+CREATE TABLE ChiSqPValueLookUp
+(
+df smallint NOT NULL ,
+chisq_from float NOT NULL ,
+chisq_to float NOT NULL ,
+pvalue_upper_bound float NOT NULL
+);
+CREATE TABLE CpGCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE GenBankDivisionCode
+(
+code varchar(6) NOT NULL ,
+abbrev varchar(40) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+display_order smallint NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE GenderCode
+(
+code char(1) NOT NULL ,
+gender varchar(6) NOT NULL
+);
+CREATE TABLE GenomeBuildInfo
+(
+snp_build_id int NOT NULL ,
+tax_id int NOT NULL ,
+database_name varchar(32) NOT NULL ,
+ncbi_build_id int NOT NULL ,
+ncbi_build_ver smallint NOT NULL ,
+insert_time TIMESTAMP NOT NULL ,
+is_major smallint NOT NULL ,
+ncbi_genome_tax_id int NOT NULL ,
+ref_assembly varchar(32) NULL ,
+annot_set_acc varchar(32) NULL ,
+annot_set_ver smallint NULL
+);
+CREATE TABLE GtyAllele
+(
+gty_id int NOT NULL ,
+rev_flag bit NOT NULL ,
+chr_num smallint NOT NULL ,
+fwd_allele_id int NOT NULL ,
+unigty_id int NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE IUPACna
+(
+allele varchar(1) NOT NULL ,
+meaning varchar(10) NOT NULL ,
+bitcode varchar(4) NOT NULL ,
+value smallint NOT NULL ,
+rev_base char(1) NULL
+);
+CREATE TABLE LoadHistory
+(
+build_id int NOT NULL ,
+loaddate TIMESTAMP NOT NULL ,
+status char(30) NOT NULL ,
+comments varchar(255) NULL ,
+script varchar(255) NULL ,
+ftp_done_date TIMESTAMP NULL ,
+entrez_done_date TIMESTAMP NULL ,
+blastdb_done_date TIMESTAMP NULL ,
+web_date TIMESTAMP NULL
+);
+CREATE TABLE LocTypeCode
+(
+code smallint NOT NULL ,
+abbrev varchar(12) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE MapLinkCode
+(
+which_code varchar(20) NOT NULL ,
+code smallint NOT NULL ,
+abbr varchar(10) NULL ,
+note varchar(255) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Method
+(
+method_id int NOT NULL ,
+handle varchar(20) NOT NULL ,
+loc_method_id varchar(64) NOT NULL ,
+loc_method_id_upp varchar(64) NOT NULL ,
+method_class smallint NULL ,
+template_type smallint NULL ,
+seq_both_strands varchar(3) NULL ,
+mult_pcr_amplification varchar(3) NULL ,
+mult_clones_tested varchar(3) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE MethodClass
+(
+meth_class_id smallint NOT NULL ,
+name varchar(64) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+validation_status smallint NOT NULL
+);
+CREATE TABLE MethodLine
+(
+method_id int NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE Moltype
+(
+code smallint NOT NULL ,
+moltype varchar(10) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE Motif
+(
+motif_id int NOT NULL ,
+motif varchar(253) NOT NULL ,
+rev_motif_id int NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE ObsGenotype
+(
+gty_id int NOT NULL ,
+obs varchar(512) NOT NULL ,
+obs_upp_fix varchar(512) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE ObsVariation
+(
+var_id int NOT NULL ,
+pattern varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NULL ,
+univar_id int NULL ,
+var_flag smallint NULL
+);
+CREATE TABLE OrgDbStatus
+(
+database_name varchar(32) NOT NULL ,
+SNP_cnt int NULL ,
+SubSNP_cnt int NULL ,
+cluster_cnt int NULL ,
+unmapped_rs_cnt int NULL ,
+SubInd_cnt int NULL ,
+ind_cnt int NULL ,
+SubInd_ss_cnt int NULL ,
+SubPop_cnt int NULL ,
+pop_cnt int NULL ,
+SubPop_ss_cnt int NULL ,
+GtyFreqBySsPop_ss_cnt int NULL ,
+AlleleFreqBySsPop_ss_cnt int NULL ,
+SNPGtyFreq_rs_cnt int NULL ,
+SNPAlleleFreq_rs_cnt int NULL ,
+snp_build_max int NULL ,
+genome_build_max varchar(8) NULL ,
+map_time TIMESTAMP NULL ,
+cluster_time_max TIMESTAMP NULL ,
+create_time TIMESTAMP NULL ,
+last_SNPBatch_time TIMESTAMP NULL ,
+last_POPBatch_time TIMESTAMP NULL ,
+last_INDBatch_time TIMESTAMP NULL ,
+rsMax int NULL ,
+rsMissenseMax int NULL ,
+copy2FTP_time TIMESTAMP NULL
+);
+CREATE TABLE OrganismTax
+(
+organism varchar(128) NOT NULL ,
+tax_id int NOT NULL ,
+common_name varchar(32) NULL ,
+gpipe_abbr varchar(7) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+comment varchar(255) NULL ,
+division_cd varchar(6) NULL ,
+database_name varchar(32) NOT NULL ,
+short_common_name varchar(32) NOT NULL ,
+tax_id_rank varchar(5) NOT NULL ,
+species_tax_id int NOT NULL ,
+no_freq_summary bit NULL ,
+entrez_index smallint NULL ,
+pub_genome_build decimal NULL
+);
+CREATE TABLE PopClass
+(
+pop_id int NOT NULL ,
+pop_class_id int NOT NULL ,
+snp_count int NULL
+);
+CREATE TABLE PopClassCode
+(
+pop_class_id int NOT NULL ,
+pop_class char(50) NOT NULL ,
+pop_class_text char(255) NOT NULL
+);
+CREATE TABLE Publication
+(
+pub_id int NOT NULL ,
+pmid int NULL ,
+handle varchar(20) NOT NULL ,
+meduid int NULL ,
+title varchar(235) NOT NULL ,
+journal varchar(255) NULL ,
+vol varchar(255) NULL ,
+suppl varchar(128) NULL ,
+issue varchar(128) NULL ,
+i_suppl varchar(128) NULL ,
+pages varchar(255) NULL ,
+year smallint NOT NULL ,
+status smallint NOT NULL ,
+blobflag smallint NULL ,
+last_updated TIMESTAMP NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE SNPGlossary
+(
+term varchar(256) NOT NULL ,
+description varchar(4000) NULL ,
+last_updated TIMESTAMP NULL ,
+used_in varchar(32) NULL
+);
+CREATE TABLE SNP_tax_id
+(
+snp_id int NOT NULL ,
+tax_id int NULL ,
+update_time TIMESTAMP NULL ,
+status char(1) NULL
+);
+CREATE TABLE SnpChrCode
+(
+code varchar(8) NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+sort_order smallint NULL ,
+db_name varchar(32) NULL ,
+NC_acc varchar(16) NULL
+);
+CREATE TABLE SnpClassCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+display_str varchar(255) NULL
+);
+CREATE TABLE SnpFunctionCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+top_level_class char(5) NOT NULL ,
+is_coding smallint NOT NULL ,
+is_exon bit NULL ,
+var_prop_loc_code int NULL ,
+var_prop_effect_code int NULL
+);
+CREATE TABLE SnpValidationCode
+(
+code smallint NOT NULL ,
+abbrev varchar(64) NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE StrandCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+rs_to_ss_orien bit NOT NULL ,
+descrip varchar(255) NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE SubSNPDelComm
+(
+comment_id smallint NOT NULL ,
+comment varchar(255) NOT NULL ,
+create_time TIMESTAMP NULL
+);
+CREATE TABLE SubSNPSeqTypeCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE Submitter
+(
+handle varchar(20) NOT NULL ,
+name varchar(255) NOT NULL ,
+fax varchar(255) NULL ,
+phone varchar(255) NULL ,
+email varchar(255) NULL ,
+lab varchar(255) NULL ,
+institution varchar(255) NULL ,
+address varchar(255) NULL ,
+create_time TIMESTAMP NULL ,
+last_updated_time TIMESTAMP NULL
+);
+CREATE TABLE TemplateType
+(
+temp_type_id smallint NOT NULL ,
+name varchar(64) NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniGty
+(
+unigty_id int NOT NULL ,
+gty_str varchar(255) NULL ,
+allele_id_1 int NOT NULL ,
+allele_id_2 int NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniVariAllele
+(
+univar_id int NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE UniVariation
+(
+univar_id int NOT NULL ,
+var_str varchar(900) NULL ,
+allele_cnt smallint NOT NULL ,
+subsnp_class smallint NOT NULL ,
+iupack_code char(1) NOT NULL ,
+top_or_bot_strand char(1) NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL ,
+src_code smallint NULL ,
+rev_univar_id int NULL
+);
+CREATE TABLE UniVariationSrcCode
+(
+code smallint NOT NULL ,
+abbrev varchar(20) NOT NULL ,
+descrip varchar(255) NOT NULL
+);
+CREATE TABLE VariAllele
+(
+var_id int NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE db_ftp_table_list
+(
+table_name varchar(32) NOT NULL ,
+db_str varchar(64) NOT NULL ,
+create_time TIMESTAMP NULL
+);
+CREATE TABLE db_map_table_name
+(
+table_name varchar(32) NOT NULL ,
+to_index bit NULL ,
+isCurrent char(1) NULL ,
+inNonHuman char(1) NOT NULL
+);
+CREATE TABLE dn_Allele_rev
+(
+allele_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_allele_id int NOT NULL ,
+fwd_allele varchar(255) NOT NULL
+);
+CREATE TABLE dn_Motif_rev
+(
+motif_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_motif varchar(253) NULL ,
+fwd_motif_id int NULL
+);
+CREATE TABLE dn_UniGty_allele
+(
+unigty_id int NOT NULL ,
+chr_num smallint NOT NULL ,
+allele_id int NOT NULL ,
+create_time TIMESTAMP NOT NULL
+);
+CREATE TABLE dn_UniGty_rev
+(
+unigty_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_unigty_id int NOT NULL ,
+fwd_gty_str varchar(255) NULL
+);
+CREATE TABLE dn_UniVariation_rev
+(
+univar_id int NOT NULL ,
+rev_flag smallint NOT NULL ,
+fwd_univar_id int NULL ,
+fwd_univar_str varchar(900) NULL
+);
+CREATE TABLE dn_baseFlip
+(
+base char(1) NULL ,
+rev_flag smallint NULL ,
+fwd_base char(1) NULL
+);
+CREATE TABLE dn_gty2unigty_trueSNP
+(
+gty_id int NOT NULL ,
+rev_flag bit NOT NULL ,
+unigty_id int NULL ,
+obs varchar(512) NOT NULL ,
+gty_str varchar(255) NULL
+);
+CREATE TABLE dn_summary
+(
+tax_id int NOT NULL ,
+build_id int NOT NULL ,
+type varchar(20) NOT NULL ,
+cnt int NOT NULL ,
+create_time TIMESTAMP NOT NULL ,
+last_updated_time TIMESTAMP NOT NULL
+);