+CREATE TABLE [AlleleFreqBySsPop] (
+ [subsnp_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [allele_id] [int] NOT NULL ,
+ [source] [varchar] (2) NOT NULL ,
+ [cnt] [real] NULL ,
+ [freq] [real] NULL ,
+ [last_updated_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [Batch] (
+ [batch_id] [int] NOT NULL ,
+ [handle] [varchar] (20) NOT NULL ,
+ [loc_batch_id] [varchar] (64) NOT NULL ,
+ [loc_batch_id_upp] [varchar] (64) NOT NULL ,
+ [batch_type] [char] (3) NOT NULL ,
+ [status] [tinyint] NULL ,
+ [simul_sts_status] [tinyint] NOT NULL ,
+ [moltype] [varchar] (8) NOT NULL ,
+ [method_id] [int] NOT NULL ,
+ [samplesize] [int] NULL ,
+ [synonym_type] [varchar] (255) NULL ,
+ [submitted_time] [smalldatetime] NOT NULL ,
+ [linkout_url] [varchar] (255) NULL ,
+ [pop_id] [int] NULL ,
+ [last_updated_time] [smalldatetime] NULL ,
+ [success_rate_int] [int] NULL ,
+ [build_id] [int] NULL ,
+ [tax_id] [int] NOT NULL ,
+ [ss_cnt] [int] NULL
+)
+GO
+
+
+CREATE TABLE [BatchCita] (
+ [batch_id] [int] NOT NULL ,
+ [position] [int] NOT NULL ,
+ [pub_id] [int] NOT NULL ,
+ [citation] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [BatchCommLine] (
+ [batch_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [BatchCultivar] (
+ [batch_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [BatchMeExLine] (
+ [batch_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [BatchStrain] (
+ [batch_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [BatchValCode] (
+ [batch_id] [int] NOT NULL ,
+ [validation_status] [tinyint] NOT NULL
+)
+GO
+
+
+CREATE TABLE [Contact] (
+ [batch_id] [int] NOT NULL ,
+ [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] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [FreqSummaryBySsPop] (
+ [subsnp_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [source] [varchar] (1) NOT NULL ,
+ [chr_cnt] [int] NOT NULL ,
+ [ind_cnt] [int] NOT NULL ,
+ [non_founder_ind_cnt] [int] NOT NULL ,
+ [chisq] [real] NULL ,
+ [df] [tinyint] NULL ,
+ [hwp] [real] NULL ,
+ [het] [real] NULL ,
+ [het_se] [real] NULL ,
+ [last_updated_time] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [GeneIdToName] (
+ [gene_id] [int] NOT NULL ,
+ [gene_symbol] [varchar] (64) NOT NULL ,
+ [gene_name] [varchar] (255) NULL ,
+ [gene_type] [varchar] (255) NULL ,
+ [tax_id] [int] NOT NULL ,
+ [last_update_time] [smalldatetime] NOT NULL ,
+ [ref_tax_id] [int] NOT NULL ,
+ [dbSNP_tax_id] [int] NOT NULL ,
+ [ins_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [GtyFreqBySsPop] (
+ [subsnp_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [unigty_id] [int] NOT NULL ,
+ [source] [varchar] (1) NULL ,
+ [cnt] [real] NULL ,
+ [freq] [real] NULL ,
+ [last_updated_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [IndGrpCode] (
+ [code] [tinyint] NOT NULL ,
+ [name] [varchar] (32) NOT NULL ,
+ [descrip] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [IndivBySource] (
+ [ind_id] [int] NOT NULL ,
+ [src_id] [int] NOT NULL ,
+ [src_ind_id] [varchar] (64) NOT NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [src_ind_grp] [varchar] (64) NULL
+)
+GO
+
+
+CREATE TABLE [IndivSourceCode] (
+ [code] [int] NOT NULL ,
+ [name] [varchar] (22) NOT NULL ,
+ [descrip] [varchar] (255) NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [src_type] [varchar] (10) NULL ,
+ [display_order] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [Individual] (
+ [ind_id] [int] NOT NULL ,
+ [descrip] [varchar] (255) NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [tax_id] [int] NULL ,
+ [ind_grp] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [OmimVarLocusIdSNP] (
+ [omim_id] [int] NOT NULL ,
+ [locus_id] [int] NULL ,
+ [omimvar_id] [char] (4) NULL ,
+ [locus_symbol] [char] (10) NULL ,
+ [var1] [char] (20) NULL ,
+ [aa_position] [int] NULL ,
+ [var2] [char] (20) NULL ,
+ [var_class] [int] NOT NULL ,
+ [snp_id] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [Pedigree] (
+ [ped_id] [numeric](7, 0) NOT NULL ,
+ [curator] [varchar] (12) NOT NULL ,
+ [curator_ped_id] [varchar] (12) NOT NULL ,
+ [create_time] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [PedigreeIndividual] (
+ [ped_id] [decimal](7, 0) NOT NULL ,
+ [ind_id] [int] NOT NULL ,
+ [ma_ind_id] [int] NULL ,
+ [pa_ind_id] [int] NULL ,
+ [sex] [char] (1) NULL ,
+ [create_time] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [PopLine] (
+ [pop_id] [int] NOT NULL ,
+ [line_num] [int] NOT NULL ,
+ [line] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [PopMandLine] (
+ [pop_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [Population] (
+ [pop_id] [int] NOT NULL ,
+ [handle] [varchar] (20) NOT NULL ,
+ [loc_pop_id] [varchar] (64) NOT NULL ,
+ [loc_pop_id_upp] [varchar] (64) NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL ,
+ [src_id] [int] NULL
+)
+GO
+
+
+CREATE TABLE [RsMergeArch] (
+ [rsHigh] [int] NULL ,
+ [rsLow] [int] NULL ,
+ [build_id] [int] NULL ,
+ [orien] [tinyint] NULL ,
+ [create_time] [datetime] NOT NULL ,
+ [last_updated_time] [datetime] NOT NULL ,
+ [rsCurrent] [int] NULL ,
+ [orien2Current] [tinyint] NULL ,
+ [comment] [varchar] (255) NULL
+)
+GO
+
+
+CREATE TABLE [SNP] (
+ [snp_id] [int] NULL ,
+ [avg_heterozygosity] [real] NULL ,
+ [het_se] [real] NULL ,
+ [create_time] [datetime] NULL ,
+ [last_updated_time] [datetime] NULL ,
+ [CpG_code] [tinyint] NULL ,
+ [tax_id] [int] NULL ,
+ [validation_status] [tinyint] NULL ,
+ [exemplar_subsnp_id] [int] NULL ,
+ [univar_id] [int] NULL ,
+ [cnt_subsnp] [int] NULL ,
+ [map_property] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [SNP3D] (
+ [snp_id] [int] NOT NULL ,
+ [protein_acc] [char] (50) NOT NULL ,
+ [master_gi] [int] NOT NULL ,
+ [neighbor_gi] [int] NOT NULL ,
+ [aa_position] [int] NOT NULL ,
+ [var_res] [char] (1) NOT NULL ,
+ [contig_res] [char] (1) NOT NULL ,
+ [neighbor_res] [char] (1) NOT NULL ,
+ [neighbor_pos] [int] NOT NULL ,
+ [var_color] [int] NOT NULL ,
+ [var_label] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNPAlleleFreq] (
+ [snp_id] [int] NOT NULL ,
+ [allele_id] [int] NOT NULL ,
+ [chr_cnt] [float] NULL ,
+ [freq] [float] NULL ,
+ [last_updated_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNPAncestralAllele] (
+ [snp_id] [int] NOT NULL ,
+ [ancestral_allele_id] [int] NOT NULL ,
+ [batch_id] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNPGtyFreq] (
+ [snp_id] [int] NOT NULL ,
+ [unigty_id] [int] NOT NULL ,
+ [ind_cnt] [float] NULL ,
+ [freq] [float] NULL ,
+ [last_updated_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNPHWProb] (
+ [snp_id] [int] NOT NULL ,
+ [df] [tinyint] NULL ,
+ [chisq] [real] NULL ,
+ [hwp] [real] NULL ,
+ [ind_cnt] [smallint] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [SNPHistory] (
+ [snp_id] [int] NOT NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NOT NULL ,
+ [history_create_time] [smalldatetime] NULL ,
+ [comment] [varchar] (255) NULL
+)
+GO
+
+
+CREATE TABLE [SNPPubmed] (
+ [snp_id] [int] NOT NULL ,
+ [subsnp_id] [int] NOT NULL ,
+ [pubmed_id] [int] NOT NULL ,
+ [type] [varchar] (16) NOT NULL ,
+ [score] [int] NOT NULL ,
+ [upd_date] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNPSubSNPLink] (
+ [subsnp_id] [int] NULL ,
+ [snp_id] [int] NULL ,
+ [substrand_reversed_flag] [tinyint] NULL ,
+ [create_time] [datetime] NULL ,
+ [last_updated_time] [datetime] NULL ,
+ [build_id] [int] NULL ,
+ [comment] [varchar] (255) NULL
+)
+GO
+
+
+CREATE TABLE [SNPSubSNPLinkHistory] (
+ [subsnp_id] [int] NULL ,
+ [snp_id] [int] NULL ,
+ [build_id] [int] NULL ,
+ [history_create_time] [datetime] NOT NULL ,
+ [link_create_time] [datetime] NULL ,
+ [link_last_updated_time] [datetime] NULL ,
+ [orien] [tinyint] NULL ,
+ [build_id_when_history_made] [int] NULL ,
+ [comment] [varchar] (255) NULL
+)
+GO
+
+
+CREATE TABLE [SNPVal] (
+ [batch_id] [int] NOT NULL ,
+ [snp_id] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNP_HGVS] (
+ [snp_id] [int] NULL ,
+ [hgvs_name] [varchar] (256) NULL ,
+ [source] [varchar] (8) NOT NULL ,
+ [upd_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SNP_bitfield] (
+ [snp_id] [int] NOT NULL ,
+ [ver_code] [tinyint] NULL ,
+ [link_prop_b1] [tinyint] NULL ,
+ [link_prop_b2] [tinyint] NULL ,
+ [gene_prop_b1] [tinyint] NULL ,
+ [gene_prop_b2] [tinyint] NULL ,
+ [map_prop] [tinyint] NULL ,
+ [freq_prop] [tinyint] NULL ,
+ [gty_prop] [tinyint] NULL ,
+ [hapmap_prop] [tinyint] NULL ,
+ [pheno_prop] [tinyint] NULL ,
+ [variation_class] [tinyint] NOT NULL ,
+ [quality_check] [tinyint] NULL ,
+ [upd_time] [datetime] NOT NULL ,
+ [encoding] [binary] (12) NULL
+)
+GO
+
+
+CREATE TABLE [SubPop] (
+ [batch_id] [int] NOT NULL ,
+ [subsnp_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [type] [char] (3) NOT NULL ,
+ [samplesize] [int] NOT NULL ,
+ [submitted_strand_code] [tinyint] NULL ,
+ [submitted_rs] [int] NULL ,
+ [allele_flag] [tinyint] NULL ,
+ [ambiguity_status] [tinyint] NULL ,
+ [sub_heterozygosity] [real] NULL ,
+ [est_heterozygosity] [real] NULL ,
+ [est_het_se_sq] [real] NULL ,
+ [last_updated_time] [smalldatetime] NOT NULL ,
+ [observed] [varchar] (1000) NULL ,
+ [sub_het_se_sq] [real] NULL ,
+ [subpop_id] [int] IDENTITY (1, 1) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubPopAllele] (
+ [batch_id] [int] NOT NULL ,
+ [subsnp_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [allele] [char] (1) NOT NULL ,
+ [other] [varchar] (255) NULL ,
+ [freq] [real] NULL ,
+ [cnt_int] [int] NULL ,
+ [freq_min] [real] NULL ,
+ [freq_max] [real] NULL ,
+ [data_src] [varchar] (6) NULL ,
+ [type] [char] (3) NULL ,
+ [last_updated_time] [smalldatetime] NULL ,
+ [allele_flag] [tinyint] NULL ,
+ [cnt] [real] NULL ,
+ [allele_id] [int] NULL ,
+ [subpop_id] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubPopGty] (
+ [subpop_id] [int] NOT NULL ,
+ [gty_id] [int] NOT NULL ,
+ [gty_str] [varchar] (255) NULL ,
+ [cnt] [real] NULL ,
+ [freq] [real] NULL ,
+ [last_updated_time] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNP] (
+ [subsnp_id] [int] NOT NULL ,
+ [known_snp_handle] [varchar] (20) NULL ,
+ [known_snp_loc_id] [varchar] (64) NULL ,
+ [known_snp_loc_id_upp] [varchar] (64) NULL ,
+ [batch_id] [int] NOT NULL ,
+ [loc_snp_id] [varchar] (64) NULL ,
+ [loc_snp_id_upp] [varchar] (64) NULL ,
+ [synonym_names] [varchar] (255) NULL ,
+ [loc_sts_id] [varchar] (64) NULL ,
+ [loc_sts_id_upp] [varchar] (64) NULL ,
+ [segregate] [char] (1) NOT NULL ,
+ [indiv_homozygosity_detected] [char] (1) NULL ,
+ [PCR_confirmed_ind] [char] (1) NULL ,
+ [gene_name] [varchar] (64) NULL ,
+ [sequence_len] [int] NULL ,
+ [samplesize] [int] NULL ,
+ [EXPRESSED_SEQUENCE_ind] [char] (1) NULL ,
+ [SOMATIC_ind] [char] (1) NULL ,
+ [sub_locus_id] [int] NULL ,
+ [create_time] [smalldatetime] NULL ,
+ [last_updated_time] [smalldatetime] NULL ,
+ [ancestral_allele] [varchar] (255) NULL ,
+ [CpG_code] [tinyint] NULL ,
+ [variation_id] [int] NULL ,
+ [top_or_bot_strand] [char] (1) NULL ,
+ [validation_status] [tinyint] NULL ,
+ [snp_id] [int] NULL ,
+ [tax_id] [int] NOT NULL ,
+ [chr_id] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPAcc_ins] (
+ [subsnp_id] [int] NOT NULL ,
+ [acc_type_ind] [char] (1) NOT NULL ,
+ [acc_part] [varchar] (16) NOT NULL ,
+ [acc_ver] [int] NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPCommLine_ins] (
+ [subsnp_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPHGVS] (
+ [subsnp_id] [int] NOT NULL ,
+ [sub_hgvs_c] [varchar] (32) NULL ,
+ [sub_hgvs_g] [varchar] (32) NULL ,
+ [sub_hgvs_p] [varchar] (32) NULL ,
+ [cal_hgvs_c] [varchar] (32) NULL ,
+ [cal_hgvs_g] [varchar] (32) NULL ,
+ [cal_hgvs_p] [varchar] (32) NULL ,
+ [upd_time] [smalldatetime] NULL ,
+ [gene_id] [int] NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPLinkout] (
+ [subsnp_id] [int] NOT NULL ,
+ [url_val] [varchar] (255) NOT NULL ,
+ [updated_time] [smalldatetime] NULL ,
+ [link_type] [varchar] (3) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPMdFailLn] (
+ [subsnp_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPNoVariSeq] (
+ [subsnp_id] [int] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPOmim] (
+ [subsnp_id] [int] NOT NULL ,
+ [omim_id] [int] NOT NULL ,
+ [allele_variant_id] [varchar] (32) NULL ,
+ [update_time] [smalldatetime] NULL ,
+ [mutObsCount] [int] NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPPubmed] (
+ [subsnp_id] [int] NOT NULL ,
+ [line_num] [int] NOT NULL ,
+ [pubmed_id] [int] NOT NULL ,
+ [updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPSeq3_ins] (
+ [subsnp_id] [int] NOT NULL ,
+ [type] [tinyint] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPSeq5_ins] (
+ [subsnp_id] [int] NOT NULL ,
+ [type] [tinyint] NOT NULL ,
+ [line_num] [tinyint] NOT NULL ,
+ [line] [varchar] (255) NOT NULL
+)
+GO
+
+
+CREATE TABLE [SubSNPSeqPos] (
+ [subsnp_id] [int] NOT NULL ,
+ [contig_acc] [varchar] (20) NOT NULL ,
+ [contig_pos] [int] NOT NULL ,
+ [chr] [varchar] (2) NULL ,
+ [upstream_len] [int] NOT NULL ,
+ [downstream_len] [int] NOT NULL ,
+ [last_update_time] [smalldatetime] NOT NULL ,
+ [mrna_acc] [varchar] (24) NULL
+)
+GO
+
+
+CREATE TABLE [SubSNP_top_or_bot] (
+ [subsnp_id] [int] NOT NULL ,
+ [top_or_bot] [char] (1) NULL ,
+ [step] [tinyint] NULL ,
+ [last_updated_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [SubmittedIndividual] (
+ [submitted_ind_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [loc_ind_id_upp] [varchar] (64) NOT NULL ,
+ [ind_id] [int] NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [last_updated_time] [smalldatetime] NULL ,
+ [tax_id] [int] NOT NULL ,
+ [loc_ind_alias] [varchar] (64) NULL ,
+ [loc_ind_id] [varchar] (64) NULL ,
+ [loc_ind_grp] [varchar] (64) NULL ,
+ [ploidy] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [Synonym] (
+ [subsnp_id] [int] NOT NULL ,
+ [type] [varchar] (64) NOT NULL ,
+ [name] [varchar] (64) NULL
+)
+GO
+
+
+CREATE TABLE [b132_ContigInfo_37_1] (
+ [ctg_id] [int] NOT NULL ,
+ [tax_id] [int] NOT NULL ,
+ [contig_acc] [varchar] (32) NOT NULL ,
+ [contig_ver] [tinyint] NULL ,
+ [contig_name] [varchar] (32) NOT NULL ,
+ [contig_chr] [varchar] (32) NULL ,
+ [contig_start] [int] NULL ,
+ [contig_end] [int] NULL ,
+ [orient] [tinyint] NULL ,
+ [contig_gi] [int] NULL ,
+ [group_term] [varchar] (32) NULL ,
+ [group_label] [varchar] (32) NULL ,
+ [contig_label] [varchar] (32) NULL ,
+ [build_id] [int] NULL ,
+ [build_ver] [int] NULL ,
+ [last_updated_time] [datetime] NOT NULL ,
+ [placement_status] [tinyint] NOT NULL
+)
+GO
+
+
+CREATE TABLE [b132_GenomeAssemblyInfo_37_1] (
+ [assembly] [varchar] (32) NOT NULL ,
+ [assembly_type] [varchar] (8) NOT NULL ,
+ [rep_order] [tinyint] NULL ,
+ [comment] [varchar] (255) NULL ,
+ [upd_time] [smalldatetime] NULL
+)
+GO
+
+
+CREATE TABLE [b132_MapLinkInfo_37_1] (
+ [gi] [int] NULL ,
+ [accession] [varchar] (127) NULL ,
+ [accession_ver] [int] NULL
+)
+GO
+
+
+CREATE TABLE [b132_MapLink_37_1] (
+ [snp_type] [char] (2) NOT NULL ,
+ [snp_id] [int] NULL ,
+ [gi] [int] NOT NULL ,
+ [accession_how_cd] [int] NULL ,
+ [offset] [int] NULL ,
+ [asn_to] [int] NULL ,
+ [lf_ngbr] [int] NULL ,
+ [rf_ngbr] [int] NULL ,
+ [lc_ngbr] [int] NULL ,
+ [rc_ngbr] [int] NULL ,
+ [loc_type] [tinyint] NULL ,
+ [build_id] [int] NULL ,
+ [process_time] [datetime] NULL ,
+ [process_status] [int] NULL ,
+ [orientation] [int] NULL ,
+ [allele] [varchar] (1024) NULL ,
+ [aln_quality] [float] NULL ,
+ [num_mism] [int] NULL ,
+ [num_ins] [int] NULL ,
+ [num_del] [int] NULL ,
+ [tier] [int] NULL ,
+ [ctg_gi] [int] NULL ,
+ [ctg_from] [int] NULL ,
+ [ctg_to] [int] NULL ,
+ [ctg_orient] [tinyint] NULL ,
+ [source] [varchar] (5) NOT NULL
+)
+GO
+
+
+CREATE TABLE [b132_ProteinInfo_37_1] (
+ [prot_gi] [int] NULL ,
+ [prot_acc] [varchar] (128) NULL ,
+ [prot_ver] [int] NULL
+)
+GO
+
+
+CREATE TABLE [b132_SNPChrPosOnRef_37_1] (
+ [snp_id] [int] NULL ,
+ [chr] [varchar] (32) NULL ,
+ [pos] [int] NULL ,
+ [orien] [int] NULL ,
+ [neighbor_snp_list] [int] NULL ,
+ [isPAR] [varchar] (1) NOT NULL
+)
+GO
+
+
+CREATE TABLE [b132_SNPContigLoc_37_1] (
+ [snp_type] [char] (2) NOT NULL ,
+ [snp_id] [int] NOT NULL ,
+ [ctg_id] [int] NOT NULL ,
+ [asn_from] [int] NOT NULL ,
+ [asn_to] [int] NOT NULL ,
+ [lf_ngbr] [int] NULL ,
+ [rf_ngbr] [int] NULL ,
+ [lc_ngbr] [int] NOT NULL ,
+ [rc_ngbr] [int] NOT NULL ,
+ [loc_type] [tinyint] NOT NULL ,
+ [phys_pos_from] [int] NULL ,
+ [snp_bld_id] [int] NOT NULL ,
+ [last_updated_time] [datetime] NOT NULL ,
+ [process_status] [int] NOT NULL ,
+ [orientation] [tinyint] NULL ,
+ [allele] [varchar] (1024) NULL ,
+ [loc_sts_uid] [int] NULL ,
+ [aln_quality] [float] NULL ,
+ [num_mism] [int] NULL ,
+ [num_del] [int] NULL ,
+ [num_ins] [int] NULL ,
+ [tier] [tinyint] NULL
+)
+GO
+
+
+CREATE TABLE [b132_SNPContigLocusId_37_1] (
+ [snp_id] [int] NULL ,
+ [contig_acc] [varchar] (32) NULL ,
+ [contig_ver] [tinyint] NULL ,
+ [asn_from] [int] NULL ,
+ [asn_to] [int] NULL ,
+ [locus_id] [int] NULL ,
+ [locus_symbol] [varchar] (128) NULL ,
+ [mrna_acc] [varchar] (128) NULL ,
+ [mrna_ver] [int] NULL ,
+ [protein_acc] [varchar] (128) NULL ,
+ [protein_ver] [int] NULL ,
+ [fxn_class] [int] NULL ,
+ [reading_frame] [int] NULL ,
+ [allele] [varchar] (256) NULL ,
+ [residue] [varchar] (1024) NULL ,
+ [aa_position] [int] NULL ,
+ [build_id] [varchar] (4) NOT NULL ,
+ [ctg_id] [int] NULL ,
+ [mrna_start] [int] NULL ,
+ [mrna_stop] [int] NULL ,
+ [codon] [varchar] (1024) NULL ,
+ [protRes] [char] (3) NULL ,
+ [contig_gi] [int] NULL ,
+ [mrna_gi] [int] NULL ,
+ [mrna_orien] [tinyint] NULL ,
+ [cp_mrna_ver] [int] NULL ,
+ [cp_mrna_gi] [int] NULL ,
+ [verComp] [varchar] (7) NOT NULL
+)
+GO
+
+
+CREATE TABLE [b132_SNPMapInfo_37_1] (
+ [snp_type] [char] (2) NOT NULL ,
+ [snp_id] [int] NOT NULL ,
+ [chr_cnt] [int] NOT NULL ,
+ [contig_cnt] [int] NOT NULL ,
+ [loc_cnt] [int] NOT NULL ,
+ [weight] [int] NOT NULL ,
+ [hap_cnt] [int] NOT NULL ,
+ [placed_cnt] [int] NOT NULL ,
+ [grouped_cnt] [int] NOT NULL ,
+ [unplaced_cnt] [int] NOT NULL ,
+ [md5] [char] (32) NULL ,
+ [assembly] [varchar] (32) NULL
+)
+GO
+
+
+CREATE TABLE [dn_IND_batchCount] (
+ [batch_id] [int] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [ss_cnt] [int] NOT NULL ,
+ [rs_cnt] [int] NOT NULL ,
+ [ind_cnt] [int] NOT NULL ,
+ [create_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [dn_IND_batch_pop] (
+ [batch_id] [smallint] NOT NULL ,
+ [pop_id] [int] NOT NULL ,
+ [update_time] [datetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [dn_PopulationIndGrp] (
+ [pop_id] [int] NOT NULL ,
+ [ind_grp_name] [varchar] (32) NOT NULL ,
+ [ind_grp_code] [tinyint] NOT NULL
+)
+GO
+
+
+CREATE TABLE [dn_batchCount] (
+ [batch_id] [int] NOT NULL ,
+ [ss_cnt] [int] NOT NULL ,
+ [rs_cnt] [int] NOT NULL ,
+ [rs_validated_cnt] [int] NOT NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [pop_cnt] [int] NULL ,
+ [ind_cnt] [int] NULL
+)
+GO
+
+
+CREATE TABLE [dn_handleCount] (
+ [handle] [varchar] (20) NOT NULL ,
+ [batch_type] [char] (3) NOT NULL ,
+ [ss_cnt] [int] NOT NULL ,
+ [rs_cnt] [int] NULL ,
+ [rs_validated_cnt] [int] NULL ,
+ [create_time] [smalldatetime] NOT NULL
+)
+GO
+
+
+CREATE TABLE [dn_snpFxnCnt] (
+ [build_id] [int] NOT NULL ,
+ [fxn_class] [tinyint] NULL ,
+ [snp_cnt] [int] NOT NULL ,
+ [gene_cnt] [int] NOT NULL ,
+ [create_time] [smalldatetime] NOT NULL ,
+ [last_updated_time] [smalldatetime] NOT NULL ,
+ [tax_id] [int] NOT NULL
+)
+GO
+
+
+CREATE TABLE [dn_table_rowcount] (
+ [tabname] [varchar] (64) NOT NULL ,
+ [row_cnt] [int] NOT NULL ,
+ [build_id] [int] NOT NULL ,
+ [update_time] [datetime] NOT NULL ,
+ [rows_in_spaceused] [int] NULL ,
+ [reserved_KB_spaceused] [int] NULL ,
+ [data_KB_spaceused] [int] NULL ,
+ [index_size_KB_spaceused] [int] NULL ,
+ [unused_KB_spaceused] [int] NULL
+)
+GO
+
+