1 ALTER TABLE [AlleleFreqBySsPop] ADD
2 CONSTRAINT [pk_AlleleFreqBySsPop_b129] PRIMARY KEY CLUSTERED
11 ALTER TABLE [Batch] ADD
12 CONSTRAINT [pk_Batch] PRIMARY KEY CLUSTERED
16 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'))))))
20 ALTER TABLE [BatchCita] ADD
21 CONSTRAINT [pk_BatchCita] PRIMARY KEY NONCLUSTERED
29 ALTER TABLE [BatchCommLine] ADD
30 CONSTRAINT [pk_BatchCommLine] PRIMARY KEY NONCLUSTERED
38 ALTER TABLE [BatchCultivar] ADD
39 CONSTRAINT [pk_BatchCultivar] PRIMARY KEY NONCLUSTERED
47 ALTER TABLE [BatchMeExLine] ADD
48 CONSTRAINT [pk_BatchMeExLine] PRIMARY KEY NONCLUSTERED
56 ALTER TABLE [BatchStrain] ADD
57 CONSTRAINT [pk_BatchStrain] PRIMARY KEY NONCLUSTERED
65 ALTER TABLE [BatchValCode] ADD
66 CONSTRAINT [pk_BatchValCode] PRIMARY KEY CLUSTERED
73 ALTER TABLE [Contact] ADD
74 CONSTRAINT [pk_Contact] PRIMARY KEY NONCLUSTERED
82 ALTER TABLE [FreqSummaryBySsPop] ADD
83 CONSTRAINT [pk_FreqSummaryBySsPop] PRIMARY KEY CLUSTERED
91 ALTER TABLE [GeneIdToName] ADD
92 CONSTRAINT [pk_GeneIdToName] PRIMARY KEY CLUSTERED
99 ALTER TABLE [GtyFreqBySsPop] ADD
100 CONSTRAINT [pk_GtyFreqBySsPop_b129] PRIMARY KEY CLUSTERED
109 ALTER TABLE [IndGrpCode] ADD
110 CONSTRAINT [pk_IndGrpCode] PRIMARY KEY CLUSTERED
117 ALTER TABLE [IndivBySource] ADD
118 CONSTRAINT [pk_IndivBySource] PRIMARY KEY NONCLUSTERED
127 ALTER TABLE [Individual] ADD
128 CONSTRAINT [pk_Individual] PRIMARY KEY CLUSTERED
136 ALTER TABLE [Pedigree] ADD
137 CONSTRAINT [p_ped_id] PRIMARY KEY CLUSTERED
144 ALTER TABLE [PedigreeIndividual] ADD
145 CONSTRAINT [pk_PedigreeIndividual] PRIMARY KEY CLUSTERED
153 ALTER TABLE [PopLine] ADD
154 CONSTRAINT [pk_PopLine] PRIMARY KEY CLUSTERED
162 ALTER TABLE [PopMandLine] ADD
163 CONSTRAINT [pk_PopMandLine] PRIMARY KEY NONCLUSTERED
171 ALTER TABLE [Population] ADD
172 CONSTRAINT [pk_Population_pop_id] PRIMARY KEY CLUSTERED
182 ALTER TABLE [SNPAlleleFreq] ADD
183 CONSTRAINT [pk_SNPAlleleFreq] PRIMARY KEY CLUSTERED
191 ALTER TABLE [SNPAncestralAllele] ADD
192 CONSTRAINT [DF__SNPAncest__batch__664F5149] DEFAULT ((0)) FOR [batch_id],
193 CONSTRAINT [pk_SNPAncestralAllele] PRIMARY KEY CLUSTERED
201 ALTER TABLE [SNPGtyFreq] ADD
202 CONSTRAINT [pk_SNPGtyFreq] PRIMARY KEY CLUSTERED
210 ALTER TABLE [SNPHWProb] ADD
211 CONSTRAINT [pk_SNPHWProb] PRIMARY KEY CLUSTERED
218 ALTER TABLE [SNPHistory] ADD
219 CONSTRAINT [pk_SNPHistory] PRIMARY KEY CLUSTERED
226 ALTER TABLE [SNPPubmed] ADD
227 CONSTRAINT [pk_SNPPubmed] PRIMARY KEY CLUSTERED
239 ALTER TABLE [SNPVal] ADD
240 CONSTRAINT [pk_SNPVal] PRIMARY KEY CLUSTERED
249 ALTER TABLE [SNP_bitfield] ADD
250 CONSTRAINT [pk_SNP_bitfield] PRIMARY KEY CLUSTERED
257 ALTER TABLE [SubPop] ADD
258 CONSTRAINT [DF__SubPopB10__last___19AB9A98] DEFAULT (getdate()) FOR [last_updated_time],
259 PRIMARY KEY CLUSTERED
266 CONSTRAINT [fk_SubPop_batch_id] FOREIGN KEY
269 ) REFERENCES [Batch] (
272 CONSTRAINT [fk_SubPop_pop] FOREIGN KEY
275 ) REFERENCES [Population] (
278 CHECK ([type] = 'GTY' or ([type] = 'HET' or [type] = 'ALE'))
282 ALTER TABLE [SubPopAllele] ADD
283 CONSTRAINT [fk_SubPopAllele_bid_ss_pop_type] FOREIGN KEY
289 ) REFERENCES [SubPop] (
298 ALTER TABLE [SubPopGty] ADD
299 CONSTRAINT [pk_SubPopGty] PRIMARY KEY CLUSTERED
307 ALTER TABLE [SubSNP] ADD
308 CONSTRAINT [pk_SubSNP] PRIMARY KEY CLUSTERED
315 ALTER TABLE [SubSNPAcc_ins] ADD
316 CONSTRAINT [pk_SubSNPAcc] PRIMARY KEY CLUSTERED
322 CONSTRAINT [ck_SubSNPAcc_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
326 ALTER TABLE [SubSNPCommLine_ins] ADD
327 CONSTRAINT [pk_SubSNPCommLine] PRIMARY KEY CLUSTERED
332 CONSTRAINT [ck_SubSNPCommLine_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
336 ALTER TABLE [SubSNPHGVS] ADD
337 CONSTRAINT [pk_SubSNPHGVS] PRIMARY KEY CLUSTERED
344 ALTER TABLE [SubSNPLinkout] ADD
345 CONSTRAINT [DF__SubSNPLin__link___660506BC] DEFAULT ('NA') FOR [link_type],
346 CONSTRAINT [pk_SubSNPLinkout] PRIMARY KEY CLUSTERED
351 CONSTRAINT [ck_SubSNPLinkout_link_type] CHECK ([link_type]='NA' OR [link_type]='OTH' OR [link_type]='SRC')
355 ALTER TABLE [SubSNPMdFailLn] ADD
356 CONSTRAINT [pk_SubSNPMdFailLn] PRIMARY KEY NONCLUSTERED
364 ALTER TABLE [SubSNPNoVariSeq] ADD
365 CONSTRAINT [pk_SubSNPNoVariSeq] PRIMARY KEY NONCLUSTERED
373 ALTER TABLE [SubSNPOmim] ADD
374 CONSTRAINT [pk_SubSNPOmim] PRIMARY KEY CLUSTERED
381 ALTER TABLE [SubSNPPubmed] ADD
382 CONSTRAINT [pk_SubSNPPubmed] PRIMARY KEY CLUSTERED
390 ALTER TABLE [SubSNPSeq3_ins] ADD
391 CONSTRAINT [pk_SubSNPSeq3] PRIMARY KEY CLUSTERED
397 CONSTRAINT [ck_SubSNPSeq3_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
401 ALTER TABLE [SubSNPSeq5_ins] ADD
402 CONSTRAINT [pk_SubSNPSeq5] PRIMARY KEY CLUSTERED
408 CONSTRAINT [ck_SubSNPSeq5_ins] CHECK ([subsnp_id]>=(30000001) AND [subsnp_id]<=(300000000))
412 ALTER TABLE [SubSNPSeqPos] ADD
413 CONSTRAINT [pk_SubSNPSeqPos] PRIMARY KEY CLUSTERED
420 ALTER TABLE [SubSNP_top_or_bot] ADD
421 CONSTRAINT [PK__t_ss_top_or_bot__0D5DFFA8] PRIMARY KEY CLUSTERED
428 ALTER TABLE [SubmittedIndividual] ADD
429 CONSTRAINT [DF__Submitted__ploid__41661CE5] DEFAULT (2) FOR [ploidy],
430 CONSTRAINT [pk_SubmittedIndividual] PRIMARY KEY CLUSTERED
438 ALTER TABLE [Synonym] ADD
439 CONSTRAINT [pk_Synonym] PRIMARY KEY NONCLUSTERED
447 ALTER TABLE [b132_ContigInfo_37_1] ADD
448 CONSTRAINT [pk_b132_ContigInfo] PRIMARY KEY CLUSTERED
460 ALTER TABLE [b132_SNPContigLoc_37_1] ADD
461 CONSTRAINT [ck_snp_type] CHECK ([snp_type]='rs')
465 ALTER TABLE [b132_SNPContigLocusId_37_1] ADD
466 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))
470 ALTER TABLE [b132_SNPMapInfo_37_1] ADD
471 CONSTRAINT [ck_SNPMapInfo_snp_type] CHECK ([snp_type]='rs')
475 ALTER TABLE [dn_IND_batchCount] ADD
476 CONSTRAINT [pk_dn_IND_batchCount] PRIMARY KEY NONCLUSTERED
485 ALTER TABLE [dn_PopulationIndGrp] ADD
486 CONSTRAINT [pk_dn_PopulationIndGrp] PRIMARY KEY CLUSTERED
493 ALTER TABLE [dn_batchCount] ADD
494 CONSTRAINT [pk_dn_batchCount] PRIMARY KEY NONCLUSTERED
501 ALTER TABLE [dn_handleCount] ADD
502 CONSTRAINT [pk_dn_handleCount] PRIMARY KEY NONCLUSTERED