-ALTER TABLE "Allele" ADD
- CONSTRAINT "pk_Allele" PRIMARY KEY
- (
- "allele_id"
- )
-;
-
-ALTER TABLE "AlleleFlagCode" ADD
- CONSTRAINT "pk_AlleleFlagCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "AlleleMotif" ADD
- CONSTRAINT "pk_AlleleMotif" PRIMARY KEY
- (
- "allele_id",
- "motif_order"
- )
-;
-
-ALTER TABLE "AllocIds" ADD
- CONSTRAINT "pk_AllocIds" PRIMARY KEY
- (
- "name"
- )
-;
-
-ALTER TABLE "Author" ADD
- CONSTRAINT "pk_Author" PRIMARY KEY
- (
- "pub_id",
- "position"
- )
-;
-
-
-
-ALTER TABLE "CpGCode" ADD
- CONSTRAINT "pk_CpGCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-
-
-ALTER TABLE "GenomeBuildInfo" ADD
- CONSTRAINT "DF__GenomeBui__inser__15E52B55" DEFAULT (getdate()) FOR "insert_time",
- CONSTRAINT "DF__GenomeBui__is_ma__18C19800" DEFAULT (1) FOR "is_major",
- CONSTRAINT "DF__GenomeBui__ncbi___23FE4082" DEFAULT (0) FOR "ncbi_genome_tax_id"
-;
-
-ALTER TABLE "GtyAllele" ADD
- CONSTRAINT "pk_GtyAllele" PRIMARY KEY
- (
- "gty_id",
- "rev_flag",
- "chr_num"
- )
-;
-
-ALTER TABLE "IUPACna" ADD
- CONSTRAINT "pk_IUPACna" PRIMARY KEY
- (
- "allele"
- )
-;
-
-ALTER TABLE "LoadHistory" ADD
- CONSTRAINT "pk_LoadHistory" PRIMARY KEY
- (
- "build_id"
- )
-;
-
-ALTER TABLE "LocTypeCode" ADD
- CONSTRAINT "DF__LocTypeCo__creat__75CD617E" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_LocTypeCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "MapLinkCode" ADD
- CONSTRAINT "pk_MapLinkCode" PRIMARY KEY
- (
- "which_code",
- "code"
- )
-;
-
-ALTER TABLE "Method" ADD
- CONSTRAINT "pk_Method_mid" PRIMARY KEY
- (
- "method_id"
- )
-;
-
-ALTER TABLE "MethodClass" ADD
- CONSTRAINT "pk_MethodClass" PRIMARY KEY
- (
- "meth_class_id"
- )
-;
-
-ALTER TABLE "MethodLine" ADD
- CONSTRAINT "pk_MethodLine" PRIMARY KEY
- (
- "method_id",
- "line_num"
- )
-;
-
-ALTER TABLE "Moltype" ADD
- CONSTRAINT "pk_Moltype" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "Motif" ADD
- CONSTRAINT "pk_Motif" PRIMARY KEY
- (
- "motif_id"
- )
-;
-
-ALTER TABLE "ObsGenotype" ADD
- CONSTRAINT "pk_ObsGenotype" PRIMARY KEY
- (
- "gty_id"
- )
-;
-
-ALTER TABLE "ObsVariation" ADD
- CONSTRAINT "DF__ObsVariat__creat__3BB5CE82" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "DF__ObsVariat__last___3CA9F2BB" DEFAULT (getdate()) FOR "last_updated_time",
- CONSTRAINT "pk_ObsVariation" PRIMARY KEY
- (
- "var_id"
- )
-;
-
-ALTER TABLE "OrgDbStatus" ADD
- CONSTRAINT "pk_org_db_status" PRIMARY KEY
- (
- "database_name"
- )
-;
-
-ALTER TABLE "OrganismTax" ADD
- CONSTRAINT "pk_organism" PRIMARY KEY
- (
- "tax_id"
- )
-;
-
-ALTER TABLE "PopClass" ADD
- CONSTRAINT "pk_PopClass" PRIMARY KEY
- (
- "pop_id",
- "pop_class_id"
- )
-;
-
-ALTER TABLE "PopClassCode" ADD
- CONSTRAINT "PK__PopClassCode__270595B6" PRIMARY KEY
- (
- "pop_class_id"
- )
-;
-
-ALTER TABLE "Publication" ADD
- CONSTRAINT "pk_Publication" PRIMARY KEY
- (
- "pub_id"
- )
-;
-
-ALTER TABLE "SNPGlossary" ADD
- CONSTRAINT "DF__SNPGlossa__last___4050666D" DEFAULT (getdate()) FOR "last_updated",
- CONSTRAINT "pk_SNPGlossary" PRIMARY KEY
- (
- "term"
- )
-;
-
-ALTER TABLE "SNP_tax_id" ADD
- CONSTRAINT "DF__SNP_tax_i__statu__31583BA0" DEFAULT ('C') FOR "status",
- CONSTRAINT "pk_SNP_tax_id" PRIMARY KEY
- (
- "snp_id"
- )
-;
-
-ALTER TABLE "SnpChrCode" ADD
- CONSTRAINT "pk_SnpChrCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpClassCode" ADD
- CONSTRAINT "pk_SnpClassCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpFunctionCode" ADD
- CONSTRAINT "pk_SnpFunctionCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "SnpValidationCode" ADD
- CONSTRAINT "pk_SnpValidationCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "StrandCode" ADD
- CONSTRAINT "pk_StrandCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-
-
-ALTER TABLE "Submitter" ADD
- CONSTRAINT "DF_Submitter_create_time" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_Submitter" PRIMARY KEY
- (
- "handle"
- )
-;
-
-ALTER TABLE "TemplateType" ADD
- CONSTRAINT "pk_TemplateType" PRIMARY KEY
- (
- "temp_type_id"
- )
-;
-
-ALTER TABLE "UniGty" ADD
- CONSTRAINT "pk_UniGty" PRIMARY KEY
- (
- "unigty_id"
- )
-;
-
-ALTER TABLE "UniVariAllele" ADD
- CONSTRAINT "pk_UniVariAllele" PRIMARY KEY
- (
- "univar_id",
- "allele_id"
- )
-;
-
-ALTER TABLE "UniVariation" ADD
- CONSTRAINT "pk_UniVariation" PRIMARY KEY
- (
- "univar_id"
- )
-;
-
-ALTER TABLE "UniVariationSrcCode" ADD
- CONSTRAINT "pk_UniVariationSrcCode" PRIMARY KEY
- (
- "code"
- )
-;
-
-ALTER TABLE "VariAllele" ADD
- CONSTRAINT "pk_VariAllele" PRIMARY KEY
- (
- "var_id",
- "allele_id"
- )
-;
-
-ALTER TABLE "db_DataDictionaryNew" ADD
- CONSTRAINT "DF__db_DataDi__updat__5BB889C0" DEFAULT (getdate()) FOR "update_time"
-;
-
-ALTER TABLE "db_ftp_table_list" ADD
- CONSTRAINT "DF__db_ftp_ta__creat__27F9B9EF" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "pk_db_ftp_table_list" PRIMARY KEY
- (
- "table_name"
- )
-;
-
-
-ALTER TABLE "dn_Allele_rev" ADD
- CONSTRAINT "pk_dn_Allele_rev" PRIMARY KEY
- (
- "allele_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_Motif_rev" ADD
- CONSTRAINT "pk_dn_Motif_rev" PRIMARY KEY
- (
- "motif_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_UniGty_allele" ADD
- CONSTRAINT "pk_dn_UniGty_allele" PRIMARY KEY
- (
- "unigty_id",
- "chr_num"
- )
-;
-
-ALTER TABLE "dn_UniGty_rev" ADD
- CONSTRAINT "pk_dn_Gty_rev" PRIMARY KEY
- (
- "unigty_id",
- "rev_flag"
- )
-;
-
-ALTER TABLE "dn_UniVariation_rev" ADD
- CONSTRAINT "pk_dn_UniVariation_rev" PRIMARY KEY
- (
- "univar_id",
- "rev_flag"
- )
-;
-
-
-
-ALTER TABLE "dn_summary" ADD
- CONSTRAINT "DF__dn_summar__creat__383A4359" DEFAULT (getdate()) FOR "create_time",
- CONSTRAINT "DF__dn_summar__last___392E6792" DEFAULT (getdate()) FOR "last_updated_time",
- PRIMARY KEY
- (
- "tax_id",
- "build_id",
- "type"
- )
-;
-
+ALTER TABLE Allele ADD \r
+ CONSTRAINT pk_Allele PRIMARY KEY \r
+ (\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE AlleleFlagCode ADD \r
+ CONSTRAINT pk_AlleleFlagCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE AlleleMotif ADD \r
+ CONSTRAINT pk_AlleleMotif PRIMARY KEY \r
+ (\r
+ allele_id,\r
+ motif_order\r
+ )\r
+;\r
+\r
+ALTER TABLE AllocIds ADD \r
+ CONSTRAINT pk_AllocIds PRIMARY KEY\r
+ (\r
+ name\r
+ )\r
+;\r
+\r
+ALTER TABLE Author ADD \r
+ CONSTRAINT pk_Author PRIMARY KEY\r
+ (\r
+ pub_id,\r
+ position\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE CpGCode ADD \r
+ CONSTRAINT pk_CpGCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+\r
+\r
+-- ALTER TABLE GenomeBuildInfo ADD \r
+-- CONSTRAINT DF__GenomeBui__inser__15E52B55 DEFAULT (getdate()) FOR insert_time,\r
+-- CONSTRAINT DF__GenomeBui__is_ma__18C19800 DEFAULT (1) FOR is_major,\r
+-- CONSTRAINT DF__GenomeBui__ncbi___23FE4082 DEFAULT (0) FOR ncbi_genome_tax_id\r
+-- ;\r
+\r
+ALTER TABLE GtyAllele ADD \r
+ CONSTRAINT pk_GtyAllele PRIMARY KEY \r
+ (\r
+ gty_id,\r
+ rev_flag,\r
+ chr_num\r
+ )\r
+;\r
+\r
+ALTER TABLE IUPACna ADD \r
+ CONSTRAINT pk_IUPACna PRIMARY KEY \r
+ (\r
+ allele\r
+ )\r
+;\r
+\r
+ALTER TABLE LoadHistory ADD \r
+ CONSTRAINT pk_LoadHistory PRIMARY KEY\r
+ (\r
+ build_id\r
+ )\r
+;\r
+\r
+ALTER TABLE LocTypeCode ADD \r
+-- CONSTRAINT DF__LocTypeCo__creat__75CD617E DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_LocTypeCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE MapLinkCode ADD \r
+ CONSTRAINT pk_MapLinkCode PRIMARY KEY \r
+ (\r
+ which_code,\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE Method ADD \r
+ CONSTRAINT pk_Method_mid PRIMARY KEY \r
+ (\r
+ method_id\r
+ )\r
+;\r
+\r
+ALTER TABLE MethodClass ADD \r
+ CONSTRAINT pk_MethodClass PRIMARY KEY \r
+ (\r
+ meth_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE MethodLine ADD \r
+ CONSTRAINT pk_MethodLine PRIMARY KEY\r
+ (\r
+ method_id,\r
+ line_num\r
+ )\r
+;\r
+\r
+ALTER TABLE Moltype ADD \r
+ CONSTRAINT pk_Moltype PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE Motif ADD \r
+ CONSTRAINT pk_Motif PRIMARY KEY \r
+ (\r
+ motif_id\r
+ )\r
+;\r
+\r
+ALTER TABLE ObsGenotype ADD \r
+ CONSTRAINT pk_ObsGenotype PRIMARY KEY \r
+ (\r
+ gty_id\r
+ )\r
+;\r
+\r
+ALTER TABLE ObsVariation ADD \r
+-- CONSTRAINT DF__ObsVariat__creat__3BB5CE82 DEFAULT (getdate()) FOR create_time,\r
+-- CONSTRAINT DF__ObsVariat__last___3CA9F2BB DEFAULT (getdate()) FOR last_updated_time,\r
+ CONSTRAINT pk_ObsVariation PRIMARY KEY \r
+ (\r
+ var_id\r
+ )\r
+;\r
+\r
+ALTER TABLE OrgDbStatus ADD \r
+ CONSTRAINT pk_org_db_status PRIMARY KEY \r
+ (\r
+ database_name\r
+ )\r
+;\r
+\r
+ALTER TABLE OrganismTax ADD \r
+ CONSTRAINT pk_organism PRIMARY KEY\r
+ (\r
+ tax_id\r
+ )\r
+;\r
+\r
+ALTER TABLE PopClass ADD \r
+ CONSTRAINT pk_PopClass PRIMARY KEY \r
+ (\r
+ pop_id,\r
+ pop_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE PopClassCode ADD \r
+ CONSTRAINT PK__PopClassCode__270595B6 PRIMARY KEY \r
+ (\r
+ pop_class_id\r
+ )\r
+;\r
+\r
+ALTER TABLE Publication ADD \r
+ CONSTRAINT pk_Publication PRIMARY KEY\r
+ (\r
+ pub_id\r
+ )\r
+;\r
+\r
+ALTER TABLE SNPGlossary ADD \r
+-- CONSTRAINT DF__SNPGlossa__last___4050666D DEFAULT (getdate()) FOR last_updated,\r
+ CONSTRAINT pk_SNPGlossary PRIMARY KEY \r
+ (\r
+ term\r
+ )\r
+;\r
+\r
+ALTER TABLE SNP_tax_id ADD \r
+-- CONSTRAINT DF__SNP_tax_i__statu__31583BA0 DEFAULT ('C') FOR status,\r
+ CONSTRAINT pk_SNP_tax_id PRIMARY KEY \r
+ (\r
+ snp_id\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpChrCode ADD \r
+ CONSTRAINT pk_SnpChrCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpClassCode ADD \r
+ CONSTRAINT pk_SnpClassCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpFunctionCode ADD \r
+ CONSTRAINT pk_SnpFunctionCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE SnpValidationCode ADD \r
+ CONSTRAINT pk_SnpValidationCode PRIMARY KEY\r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE StrandCode ADD \r
+ CONSTRAINT pk_StrandCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE Submitter ADD \r
+-- CONSTRAINT DF_Submitter_create_time DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_Submitter PRIMARY KEY\r
+ (\r
+ handle\r
+ )\r
+;\r
+\r
+ALTER TABLE TemplateType ADD \r
+ CONSTRAINT pk_TemplateType PRIMARY KEY \r
+ (\r
+ temp_type_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniGty ADD \r
+ CONSTRAINT pk_UniGty PRIMARY KEY \r
+ (\r
+ unigty_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariAllele ADD \r
+ CONSTRAINT pk_UniVariAllele PRIMARY KEY \r
+ (\r
+ univar_id,\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariation ADD \r
+ CONSTRAINT pk_UniVariation PRIMARY KEY \r
+ (\r
+ univar_id\r
+ )\r
+;\r
+\r
+ALTER TABLE UniVariationSrcCode ADD \r
+ CONSTRAINT pk_UniVariationSrcCode PRIMARY KEY \r
+ (\r
+ code\r
+ )\r
+;\r
+\r
+ALTER TABLE VariAllele ADD \r
+ CONSTRAINT pk_VariAllele PRIMARY KEY \r
+ (\r
+ var_id,\r
+ allele_id\r
+ )\r
+;\r
+\r
+ALTER TABLE db_ftp_table_list ADD \r
+-- CONSTRAINT DF__db_ftp_ta__creat__27F9B9EF DEFAULT (getdate()) FOR create_time,\r
+ CONSTRAINT pk_db_ftp_table_list PRIMARY KEY \r
+ (\r
+ table_name\r
+ )\r
+;\r
+\r
+-- ALTER TABLE db_map_table_name ADD \r
+-- CONSTRAINT DF__db_map_ta__inNon__206E7217 DEFAULT ('N') FOR inNonHuman\r
+-- ;\r
+\r
+ALTER TABLE dn_Allele_rev ADD \r
+ CONSTRAINT pk_dn_Allele_rev PRIMARY KEY \r
+ (\r
+ allele_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_Motif_rev ADD \r
+ CONSTRAINT pk_dn_Motif_rev PRIMARY KEY \r
+ (\r
+ motif_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniGty_allele ADD \r
+ CONSTRAINT pk_dn_UniGty_allele PRIMARY KEY \r
+ (\r
+ unigty_id,\r
+ chr_num\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniGty_rev ADD \r
+ CONSTRAINT pk_dn_Gty_rev PRIMARY KEY \r
+ (\r
+ unigty_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+ALTER TABLE dn_UniVariation_rev ADD \r
+ CONSTRAINT pk_dn_UniVariation_rev PRIMARY KEY \r
+ (\r
+ univar_id,\r
+ rev_flag\r
+ )\r
+;\r
+\r
+\r
+\r
+ALTER TABLE dn_summary ADD \r
+-- CONSTRAINT DF__dn_summar__creat__383A4359 DEFAULT (getdate()) FOR create_time,\r
+-- CONSTRAINT DF__dn_summar__last___392E6792 DEFAULT (getdate()) FOR last_updated_time,\r
+ PRIMARY KEY \r
+ (\r
+ tax_id,\r
+ build_id,\r
+ type\r
+ )\r
+;\r
+\r
-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 / commitdiff