1 ALTER TABLE AlleleFreqBySsPop ADD
2 CONSTRAINT pk_AlleleFreqBySsPop_b129 PRIMARY KEY
11 CONSTRAINT pk_Batch PRIMARY KEY
15 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'))))))
18 ALTER TABLE BatchCita ADD
19 CONSTRAINT pk_BatchCita PRIMARY KEY
26 ALTER TABLE BatchCommLine ADD
27 CONSTRAINT pk_BatchCommLine PRIMARY KEY
34 ALTER TABLE BatchCultivar ADD
35 CONSTRAINT pk_BatchCultivar PRIMARY KEY
42 ALTER TABLE BatchMeExLine ADD
43 CONSTRAINT pk_BatchMeExLine PRIMARY KEY
50 ALTER TABLE BatchStrain ADD
51 CONSTRAINT pk_BatchStrain PRIMARY KEY
58 ALTER TABLE BatchValCode ADD
59 CONSTRAINT pk_BatchValCode PRIMARY KEY
65 ALTER TABLE Contact ADD
66 CONSTRAINT pk_Contact PRIMARY KEY
73 ALTER TABLE FreqSummaryBySsPop ADD
74 CONSTRAINT pk_FreqSummaryBySsPop PRIMARY KEY
81 ALTER TABLE GeneIdToName ADD
82 CONSTRAINT pk_GeneIdToName PRIMARY KEY
88 ALTER TABLE GtyFreqBySsPop ADD
89 CONSTRAINT pk_GtyFreqBySsPop_b129 PRIMARY KEY
97 ALTER TABLE IndGrpCode ADD
98 CONSTRAINT pk_IndGrpCode PRIMARY KEY
104 ALTER TABLE IndivBySource ADD
105 CONSTRAINT pk_IndivBySource PRIMARY KEY
113 ALTER TABLE Individual ADD
114 CONSTRAINT pk_Individual PRIMARY KEY
121 ALTER TABLE Pedigree ADD
122 CONSTRAINT p_ped_id PRIMARY KEY
128 ALTER TABLE PedigreeIndividual ADD
129 CONSTRAINT pk_PedigreeIndividual PRIMARY KEY
136 ALTER TABLE PopLine ADD
137 CONSTRAINT pk_PopLine PRIMARY KEY
144 ALTER TABLE PopMandLine ADD
145 CONSTRAINT pk_PopMandLine PRIMARY KEY
152 ALTER TABLE Population ADD
153 CONSTRAINT pk_Population_pop_id PRIMARY KEY
162 ALTER TABLE SNPAlleleFreq ADD
163 CONSTRAINT pk_SNPAlleleFreq PRIMARY KEY
170 ALTER TABLE SNPAncestralAllele ADD
171 -- CONSTRAINT DF__SNPAncest__batch__664F5149 DEFAULT ((0)) FOR batch_id,
172 CONSTRAINT pk_SNPAncestralAllele PRIMARY KEY
179 ALTER TABLE SNPGtyFreq ADD
180 CONSTRAINT pk_SNPGtyFreq PRIMARY KEY
187 ALTER TABLE SNPHWProb ADD
188 CONSTRAINT pk_SNPHWProb PRIMARY KEY
194 ALTER TABLE SNPHistory ADD
195 CONSTRAINT pk_SNPHistory PRIMARY KEY
201 ALTER TABLE SNPPubmed ADD
202 CONSTRAINT pk_SNPPubmed PRIMARY KEY
213 ALTER TABLE SNPVal ADD
214 CONSTRAINT pk_SNPVal PRIMARY KEY
222 ALTER TABLE SNP_bitfield ADD
223 CONSTRAINT pk_SNP_bitfield PRIMARY KEY
229 ALTER TABLE SubPop ADD
230 -- CONSTRAINT DF__SubPopB10__last___19AB9A98 DEFAULT (getdate()) FOR last_updated_time,
238 CONSTRAINT fk_SubPop_batch_id FOREIGN KEY
244 CONSTRAINT fk_SubPop_pop FOREIGN KEY
247 ) REFERENCES Population (
250 CHECK (type = 'GTY' or (type = 'HET' or type = 'ALE'))
253 ALTER TABLE SubPopAllele ADD
254 CONSTRAINT fk_SubPopAllele_bid_ss_pop_type FOREIGN KEY
260 ) REFERENCES SubPop (
268 ALTER TABLE SubPopGty ADD
269 CONSTRAINT pk_SubPopGty PRIMARY KEY
276 ALTER TABLE SubSNP ADD
277 CONSTRAINT pk_SubSNP PRIMARY KEY
283 ALTER TABLE SubSNPAcc_ins ADD
284 CONSTRAINT pk_SubSNPAcc PRIMARY KEY
290 CONSTRAINT ck_SubSNPAcc_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
293 ALTER TABLE SubSNPCommLine_ins ADD
294 CONSTRAINT pk_SubSNPCommLine PRIMARY KEY
299 CONSTRAINT ck_SubSNPCommLine_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
302 ALTER TABLE SubSNPHGVS ADD
303 CONSTRAINT pk_SubSNPHGVS PRIMARY KEY
309 ALTER TABLE SubSNPLinkout ADD
310 -- CONSTRAINT DF__SubSNPLin__link___660506BC DEFAULT ('NA') FOR link_type,
311 CONSTRAINT pk_SubSNPLinkout PRIMARY KEY
316 CONSTRAINT ck_SubSNPLinkout_link_type CHECK (link_type='NA' OR link_type='OTH' OR link_type='SRC')
319 ALTER TABLE SubSNPMdFailLn ADD
320 CONSTRAINT pk_SubSNPMdFailLn PRIMARY KEY
327 ALTER TABLE SubSNPNoVariSeq ADD
328 CONSTRAINT pk_SubSNPNoVariSeq PRIMARY KEY
335 ALTER TABLE SubSNPOmim ADD
336 CONSTRAINT pk_SubSNPOmim PRIMARY KEY
342 ALTER TABLE SubSNPPubmed ADD
343 CONSTRAINT pk_SubSNPPubmed PRIMARY KEY
350 ALTER TABLE SubSNPSeq3_ins ADD
351 CONSTRAINT pk_SubSNPSeq3 PRIMARY KEY
357 CONSTRAINT ck_SubSNPSeq3_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
360 ALTER TABLE SubSNPSeq5_ins ADD
361 CONSTRAINT pk_SubSNPSeq5 PRIMARY KEY
367 CONSTRAINT ck_SubSNPSeq5_ins CHECK (subsnp_id>=(30000001) AND subsnp_id<=(300000000))
370 ALTER TABLE SubSNPSeqPos ADD
371 CONSTRAINT pk_SubSNPSeqPos PRIMARY KEY
377 ALTER TABLE SubSNP_top_or_bot ADD
378 CONSTRAINT PK__t_ss_top_or_bot__0D5DFFA8 PRIMARY KEY
384 ALTER TABLE SubmittedIndividual ADD
385 -- CONSTRAINT DF__Submitted__ploid__41661CE5 DEFAULT (2) FOR ploidy,
386 CONSTRAINT pk_SubmittedIndividual PRIMARY KEY
393 ALTER TABLE Synonym ADD
394 CONSTRAINT pk_Synonym PRIMARY KEY
401 ALTER TABLE b132_ContigInfo_37_1 ADD
402 CONSTRAINT pk_b132_ContigInfo PRIMARY KEY
413 ALTER TABLE b132_SNPContigLoc_37_1 ADD
414 CONSTRAINT ck_snp_type CHECK (snp_type='rs')
417 ALTER TABLE b132_SNPContigLocusId_37_1 ADD
418 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))
421 ALTER TABLE b132_SNPMapInfo_37_1 ADD
422 CONSTRAINT ck_SNPMapInfo_snp_type CHECK (snp_type='rs')
425 ALTER TABLE dn_IND_batchCount ADD
426 CONSTRAINT pk_dn_IND_batchCount PRIMARY KEY
434 ALTER TABLE dn_PopulationIndGrp ADD
435 CONSTRAINT pk_dn_PopulationIndGrp PRIMARY KEY
441 ALTER TABLE dn_batchCount ADD
442 CONSTRAINT pk_dn_batchCount PRIMARY KEY
448 ALTER TABLE dn_handleCount ADD
449 CONSTRAINT pk_dn_handleCount PRIMARY KEY