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