--- /dev/null
+ALTER TABLE AlleleFreqBySsPop ADD
+ CONSTRAINT pk_AlleleFreqBySsPop_b129 PRIMARY KEY
+ (
+ subsnp_id,
+ pop_id,
+ allele_id
+ )
+;
+
+ALTER TABLE Batch ADD
+ CONSTRAINT pk_Batch PRIMARY KEY
+ (
+ batch_id
+ ), ADD
+ CONSTRAINT ck_batch_type CHECK (batch_type='ANC' OR (batch_type='MNT' OR (batch_type='VAL' OR (batch_type='POP' OR (batch_type='IND' OR (batch_type='SNP' OR batch_type='NOV'))))))
+;
+
+ALTER TABLE BatchCita ADD
+ CONSTRAINT pk_BatchCita PRIMARY KEY
+ (
+ batch_id,
+ position
+ )
+;
+
+ALTER TABLE BatchCommLine ADD
+ CONSTRAINT pk_BatchCommLine PRIMARY KEY
+ (
+ batch_id,
+ line_num
+ )
+;
+
+ALTER TABLE BatchCultivar ADD
+ CONSTRAINT pk_BatchCultivar PRIMARY KEY
+ (
+ batch_id,
+ line_num
+ )
+;
+
+ALTER TABLE BatchMeExLine ADD
+ CONSTRAINT pk_BatchMeExLine PRIMARY KEY
+ (
+ batch_id,
+ line_num
+ )
+;
+
+ALTER TABLE BatchStrain ADD
+ CONSTRAINT pk_BatchStrain PRIMARY KEY
+ (
+ batch_id,
+ line_num
+ )
+;
+
+ALTER TABLE BatchValCode ADD
+ CONSTRAINT pk_BatchValCode PRIMARY KEY
+ (
+ batch_id
+ )
+;
+
+ALTER TABLE Contact ADD
+ CONSTRAINT pk_Contact PRIMARY KEY
+ (
+ batch_id,
+ handle
+ )
+;
+
+ALTER TABLE FreqSummaryBySsPop ADD
+ CONSTRAINT pk_FreqSummaryBySsPop PRIMARY KEY
+ (
+ subsnp_id,
+ pop_id
+ )
+;
+
+ALTER TABLE GeneIdToName ADD
+ CONSTRAINT pk_GeneIdToName PRIMARY KEY
+ (
+ gene_id
+ )
+;
+
+ALTER TABLE GtyFreqBySsPop ADD
+ CONSTRAINT pk_GtyFreqBySsPop_b129 PRIMARY KEY
+ (
+ subsnp_id,
+ pop_id,
+ unigty_id
+ )
+;
+
+ALTER TABLE IndGrpCode ADD
+ CONSTRAINT pk_IndGrpCode PRIMARY KEY
+ (
+ code
+ )
+;
+
+ALTER TABLE IndivBySource ADD
+ CONSTRAINT pk_IndivBySource PRIMARY KEY
+ (
+ src_id,
+ src_ind_id
+ )
+;
+
+
+ALTER TABLE Individual ADD
+ CONSTRAINT pk_Individual PRIMARY KEY
+ (
+ ind_id
+ )
+;
+
+
+ALTER TABLE Pedigree ADD
+ CONSTRAINT p_ped_id PRIMARY KEY
+ (
+ ped_id
+ )
+;
+
+ALTER TABLE PedigreeIndividual ADD
+ CONSTRAINT pk_PedigreeIndividual PRIMARY KEY
+ (
+ ped_id,
+ ind_id
+ )
+;
+
+ALTER TABLE PopLine ADD
+ CONSTRAINT pk_PopLine PRIMARY KEY
+ (
+ pop_id,
+ line_num
+ )
+;
+
+ALTER TABLE PopMandLine ADD
+ CONSTRAINT pk_PopMandLine PRIMARY KEY
+ (
+ pop_id,
+ line_num
+ )
+;
+
+ALTER TABLE Population ADD
+ CONSTRAINT pk_Population_pop_id PRIMARY KEY
+ (
+ pop_id
+ )
+;
+
+
+
+
+ALTER TABLE SNPAlleleFreq ADD
+ CONSTRAINT pk_SNPAlleleFreq PRIMARY KEY
+ (
+ snp_id,
+ allele_id
+ )
+;
+
+ALTER TABLE SNPAncestralAllele ADD
+-- CONSTRAINT DF__SNPAncest__batch__664F5149 DEFAULT ((0)) FOR batch_id,
+ CONSTRAINT pk_SNPAncestralAllele PRIMARY KEY
+ (
+ snp_id,
+ batch_id
+ )
+;
+
+ALTER TABLE SNPGtyFreq ADD
+ CONSTRAINT pk_SNPGtyFreq PRIMARY KEY
+ (
+ snp_id,
+ unigty_id
+ )
+;
+
+ALTER TABLE SNPHWProb ADD
+ CONSTRAINT pk_SNPHWProb PRIMARY KEY
+ (
+ snp_id
+ )
+;
+
+ALTER TABLE SNPHistory ADD
+ CONSTRAINT pk_SNPHistory PRIMARY KEY
+ (
+ snp_id
+ )
+;
+
+ALTER TABLE SNPPubmed ADD
+ CONSTRAINT pk_SNPPubmed PRIMARY KEY
+ (
+ snp_id,
+ subsnp_id,
+ pubmed_id,
+ type
+ )
+;
+
+
+
+ALTER TABLE SNPVal ADD
+ CONSTRAINT pk_SNPVal PRIMARY KEY
+ (
+ batch_id,
+ snp_id
+ )
+;
+
+
+ALTER TABLE SNP_bitfield ADD
+ CONSTRAINT pk_SNP_bitfield PRIMARY KEY
+ (
+ snp_id
+ )
+;
+
+ALTER TABLE SubPop ADD
+-- CONSTRAINT DF__SubPopB10__last___19AB9A98 DEFAULT (getdate()) FOR last_updated_time,
+ PRIMARY KEY
+ (
+ batch_id,
+ subsnp_id,
+ pop_id,
+ type
+ ), ADD
+ CONSTRAINT fk_SubPop_batch_id FOREIGN KEY
+ (
+ batch_id
+ ) REFERENCES Batch (
+ batch_id
+ ), ADD
+ CONSTRAINT fk_SubPop_pop FOREIGN KEY
+ (
+ pop_id
+ ) REFERENCES Population (
+ pop_id
+ ), ADD
+ CHECK (type = 'GTY' or (type = 'HET' or type = 'ALE'))
+;
+
+ALTER TABLE SubPopAllele ADD
+ CONSTRAINT fk_SubPopAllele_bid_ss_pop_type FOREIGN KEY
+ (
+ batch_id,
+ subsnp_id,
+ pop_id,
+ type
+ ) REFERENCES SubPop (
+ batch_id,
+ subsnp_id,
+ pop_id,
+ type
+ ) ON DELETE CASCADE
+;
+
+ALTER TABLE SubPopGty ADD
+ CONSTRAINT pk_SubPopGty PRIMARY KEY
+ (
+ subpop_id,
+ gty_id
+ )
+;
+
+ALTER TABLE SubSNP ADD
+ CONSTRAINT pk_SubSNP PRIMARY KEY
+ (
+ subsnp_id
+ )
+;
+
+ALTER TABLE SubSNPAcc_ins ADD
+ CONSTRAINT pk_SubSNPAcc PRIMARY KEY
+ (
+ subsnp_id,
+ acc_part,
+ acc_type_ind
+ ), ADD
+ CONSTRAINT ck_SubSNPAcc_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
+;
+
+ALTER TABLE SubSNPCommLine_ins ADD
+ CONSTRAINT pk_SubSNPCommLine PRIMARY KEY
+ (
+ subsnp_id,
+ line_num
+ ), ADD
+ CONSTRAINT ck_SubSNPCommLine_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
+;
+
+ALTER TABLE SubSNPHGVS ADD
+ CONSTRAINT pk_SubSNPHGVS PRIMARY KEY
+ (
+ subsnp_id
+ )
+;
+
+ALTER TABLE SubSNPLinkout ADD
+-- CONSTRAINT DF__SubSNPLin__link___660506BC DEFAULT ('NA') FOR link_type,
+ CONSTRAINT pk_SubSNPLinkout PRIMARY KEY
+ (
+ subsnp_id,
+ link_type
+ ), ADD
+ CONSTRAINT ck_SubSNPLinkout_link_type CHECK (link_type='NA' OR link_type='OTH' OR link_type='SRC')
+;
+
+ALTER TABLE SubSNPMdFailLn ADD
+ CONSTRAINT pk_SubSNPMdFailLn PRIMARY KEY
+ (
+ subsnp_id,
+ line_num
+ )
+;
+
+ALTER TABLE SubSNPNoVariSeq ADD
+ CONSTRAINT pk_SubSNPNoVariSeq PRIMARY KEY
+ (
+ subsnp_id,
+ line_num
+ )
+;
+
+ALTER TABLE SubSNPOmim ADD
+ CONSTRAINT pk_SubSNPOmim PRIMARY KEY
+ (
+ subsnp_id
+ )
+;
+
+ALTER TABLE SubSNPPubmed ADD
+ CONSTRAINT pk_SubSNPPubmed PRIMARY KEY
+ (
+ subsnp_id,
+ line_num
+ )
+;
+
+ALTER TABLE SubSNPSeq3_ins ADD
+ CONSTRAINT pk_SubSNPSeq3 PRIMARY KEY
+ (
+ subsnp_id,
+ type,
+ line_num
+ ), ADD
+ CONSTRAINT ck_SubSNPSeq3_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
+;
+
+ALTER TABLE SubSNPSeq5_ins ADD
+ CONSTRAINT pk_SubSNPSeq5 PRIMARY KEY
+ (
+ subsnp_id,
+ type,
+ line_num
+ ), ADD
+ CONSTRAINT ck_SubSNPSeq5_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
+;
+
+ALTER TABLE SubSNPSeqPos ADD
+ CONSTRAINT pk_SubSNPSeqPos PRIMARY KEY
+ (
+ subsnp_id
+x )
+;
+
+ALTER TABLE SubSNP_top_or_bot ADD
+ CONSTRAINT PK__t_ss_top_or_bot__0D5DFFA8 PRIMARY KEY
+ (
+ subsnp_id
+ )
+;
+
+ALTER TABLE SubmittedIndividual ADD
+-- CONSTRAINT DF__Submitted__ploid__41661CE5 DEFAULT (2) FOR ploidy,
+ CONSTRAINT pk_SubmittedIndividual PRIMARY KEY
+ (
+ pop_id,
+ loc_ind_id_upp
+ )
+;
+
+ALTER TABLE Synonym ADD
+ CONSTRAINT pk_Synonym PRIMARY KEY
+ (
+ subsnp_id,
+ type
+ )
+;
+
+ALTER TABLE b132_ContigInfo_37_1 ADD
+ CONSTRAINT pk_b132_ContigInfo PRIMARY KEY
+ (
+ ctg_id
+ )
+;
+
+
+
+
+
+
+ALTER TABLE b132_SNPContigLoc_37_1 ADD
+ CONSTRAINT ck_snp_type CHECK (snp_type='rs')
+;
+
+ALTER TABLE b132_SNPContigLocusId_37_1 ADD
+ CONSTRAINT ck_fxn CHECK (fxn_class=(75) OR fxn_class=(73) OR fxn_class=(55) OR fxn_class=(53) OR fxn_class=(45) OR fxn_class=(44) OR fxn_class=(43) OR fxn_class=(42) OR fxn_class=(41) OR fxn_class=(15) OR fxn_class=(13) OR fxn_class=(8) OR fxn_class=(6) OR fxn_class=(3))
+;
+
+ALTER TABLE b132_SNPMapInfo_37_1 ADD
+ CONSTRAINT ck_SNPMapInfo_snp_type CHECK (snp_type='rs')
+;
+
+ALTER TABLE dn_IND_batchCount ADD
+ CONSTRAINT pk_dn_IND_batchCount PRIMARY KEY
+ (
+ batch_id,
+ pop_id
+ )
+;
+
+
+ALTER TABLE dn_PopulationIndGrp ADD
+ CONSTRAINT pk_dn_PopulationIndGrp PRIMARY KEY
+ (
+ pop_id
+ )
+;
+
+ALTER TABLE dn_batchCount ADD
+ CONSTRAINT pk_dn_batchCount PRIMARY KEY
+ (
+ batch_id
+ )
+;
+
+ALTER TABLE dn_handleCount ADD
+ CONSTRAINT pk_dn_handleCount PRIMARY KEY
+ (
+ handle,
+ batch_type
+ )
+;
+
+
+
projects / dbsnp.git / blobdiff