1 ALTER TABLE [AlleleFreqBySsPop] ADD CONSTRAINT [pk_AlleleFreqBySsPop_b129] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[pop_id] ASC,[allele_id] ASC)
\r
4 ALTER TABLE [Batch] ADD CONSTRAINT [pk_Batch] PRIMARY KEY CLUSTERED ([batch_id] ASC)
\r
7 ALTER TABLE [BatchCita] ADD CONSTRAINT [pk_BatchCita] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[position] ASC)
\r
10 ALTER TABLE [BatchCommLine] ADD CONSTRAINT [pk_BatchCommLine] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
\r
13 ALTER TABLE [BatchCultivar] ADD CONSTRAINT [pk_BatchCultivar] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
\r
16 ALTER TABLE [BatchMeExLine] ADD CONSTRAINT [pk_BatchMeExLine] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
\r
19 ALTER TABLE [BatchStrain] ADD CONSTRAINT [pk_BatchStrain] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[line_num] ASC)
\r
22 ALTER TABLE [BatchValCode] ADD CONSTRAINT [pk_BatchValCode] PRIMARY KEY CLUSTERED ([batch_id] ASC)
\r
25 ALTER TABLE [ClinSigCode] ADD CONSTRAINT [DF__ClinSigCo__creat__5FBB8CD0] DEFAULT (GETDATE()) FOR [create_time]
26 ALTER TABLE [ClinSigCode] ADD CONSTRAINT [DF__ClinSigCo__last___60AFB109] DEFAULT (GETDATE()) FOR [last_updated_time]
27 ALTER TABLE [ClinSigCode] ADD CONSTRAINT [PK__ClinSigC__357D4CF85DD3445E] PRIMARY KEY CLUSTERED ([code] ASC)
\r
30 ALTER TABLE [Contact] ADD CONSTRAINT [pk_Contact] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[handle] ASC)
\r
34 ALTER TABLE [GeneIdToName] ADD CONSTRAINT [pk_GeneIdToName] PRIMARY KEY CLUSTERED ([gene_id] ASC)
\r
37 ALTER TABLE [GtyFreqBySsPop] ADD CONSTRAINT [pk_GtyFreqBySsPop_b129] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[pop_id] ASC,[unigty_id] ASC)
\r
40 ALTER TABLE [IndGrpCode] ADD CONSTRAINT [pk_IndGrpCode] PRIMARY KEY CLUSTERED ([code] ASC)
\r
43 ALTER TABLE [IndivBySource] ADD CONSTRAINT [pk_IndivBySource] PRIMARY KEY NONCLUSTERED ([src_id] ASC,[src_ind_id] ASC)
\r
47 ALTER TABLE [Individual] ADD CONSTRAINT [pk_Individual] PRIMARY KEY CLUSTERED ([ind_id] ASC)
\r
50 ALTER TABLE [OmimVarLocusIdSNP] ADD CONSTRAINT [fk_OmimVarLocusIdSNP_snp_id] FOREIGN KEY (snp_id) REFERENCES [b134_SNP](snp_id)
\r
53 ALTER TABLE [Pedigree] ADD CONSTRAINT [p_ped_id] PRIMARY KEY CLUSTERED ([ped_id] ASC)
\r
56 ALTER TABLE [PedigreeIndividual] ADD CONSTRAINT [pk_PedigreeIndividual] PRIMARY KEY CLUSTERED ([ped_id] ASC,[ind_id] ASC)
\r
59 ALTER TABLE [PopLine] ADD CONSTRAINT [pk_PopLine] PRIMARY KEY CLUSTERED ([pop_id] ASC,[line_num] ASC)
\r
62 ALTER TABLE [PopMandLine] ADD CONSTRAINT [pk_PopMandLine] PRIMARY KEY NONCLUSTERED ([pop_id] ASC,[line_num] ASC)
\r
65 ALTER TABLE [Population] ADD CONSTRAINT [pk_Population_pop_id] PRIMARY KEY CLUSTERED ([pop_id] ASC)
\r
71 ALTER TABLE [SNPAlleleFreq] ADD CONSTRAINT [pk_SNPAlleleFreq] PRIMARY KEY CLUSTERED ([snp_id] ASC,[allele_id] ASC)
\r
75 ALTER TABLE [SNPAncestralAllele] ADD CONSTRAINT [DF__SNPAncest__batch__664F5149] DEFAULT ((0)) FOR [batch_id]
76 ALTER TABLE [SNPAncestralAllele] ADD CONSTRAINT [pk_SNPAncestralAllele] PRIMARY KEY CLUSTERED ([snp_id] ASC,[batch_id] ASC)
\r
79 ALTER TABLE [SNPClinSig] ADD CONSTRAINT [DF__SNPClinSi__upd_t__1BBC3395] DEFAULT (GETDATE()) FOR [upd_time]
80 ALTER TABLE [SNPClinSig] ADD CONSTRAINT [PK__SNPClinS__430A13A119D3EB23] PRIMARY KEY CLUSTERED ([snp_id] ASC)
\r
83 ALTER TABLE [SNPGtyFreq] ADD CONSTRAINT [pk_SNPGtyFreq] PRIMARY KEY CLUSTERED ([snp_id] ASC,[unigty_id] ASC)
\r
86 ALTER TABLE [SNPHWProb] ADD CONSTRAINT [pk_SNPHWProb] PRIMARY KEY CLUSTERED ([snp_id] ASC)
\r
89 ALTER TABLE [SNPHistory] ADD CONSTRAINT [pk_SNPHistory] PRIMARY KEY CLUSTERED ([snp_id] ASC)
\r
93 ALTER TABLE [SNPSubSNPLink] ADD CONSTRAINT [fk_SNPSubSNPLink_ss] FOREIGN KEY (subsnp_id) REFERENCES [SubSNP](subsnp_id)
\r
97 ALTER TABLE [SNPSuspect] ADD CONSTRAINT [DF__SNPSuspec__upd_t__18BF0002] DEFAULT (GETDATE()) FOR [upd_time]
98 ALTER TABLE [SNPSuspect] ADD CONSTRAINT [PK__SNPSuspe__430A13A116D6B790] PRIMARY KEY CLUSTERED ([snp_id] ASC)
\r
101 ALTER TABLE [SNPVal] ADD CONSTRAINT [pk_SNPVal] PRIMARY KEY CLUSTERED ([batch_id] ASC,[snp_id] ASC)
\r
105 ALTER TABLE [SNP_bitfield] ADD CONSTRAINT [pk_SNP_bitfield] PRIMARY KEY CLUSTERED ([snp_id] ASC)
\r
108 ALTER TABLE [SubPop] ADD CONSTRAINT [DF__SubPopB10__last___19AB9A98] DEFAULT (GETDATE()) FOR [last_updated_time]
109 ALTER TABLE [SubPop] ADD CONSTRAINT [fk_SubPop_batch_id] FOREIGN KEY (batch_id) REFERENCES [Batch](batch_id)
\r
111 ALTER TABLE [SubPop] ADD CONSTRAINT [fk_SubPop_pop] FOREIGN KEY (pop_id) REFERENCES [Population](pop_id)
\r
113 ALTER TABLE [SubPop] ADD CONSTRAINT [PK__SubPop_new__180E3640] PRIMARY KEY CLUSTERED ([batch_id] ASC,[subsnp_id] ASC,[pop_id] ASC,[type] ASC)
\r
116 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)
\r
119 ALTER TABLE [SubPopGty] ADD CONSTRAINT [pk_SubPopGty] PRIMARY KEY CLUSTERED ([subpop_id] ASC,[gty_id] ASC)
\r
122 ALTER TABLE [SubSNP] ADD CONSTRAINT [pk_SubSNP] PRIMARY KEY CLUSTERED ([subsnp_id] ASC)
\r
125 ALTER TABLE [SubSNPAcc_ins] ADD CONSTRAINT [pk_SubSNPAcc] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[acc_type_ind] ASC,[acc_part] ASC)
\r
128 ALTER TABLE [SubSNPCommLine_ins] ADD CONSTRAINT [pk_SubSNPCommLine] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
\r
131 ALTER TABLE [SubSNPHGVS] ADD CONSTRAINT [pk_SubSNPHGVS] PRIMARY KEY CLUSTERED ([subsnp_id] ASC)
\r
134 ALTER TABLE [SubSNPLinkout] ADD CONSTRAINT [DF__SubSNPLin__link___660506BC] DEFAULT ('NA') FOR [link_type]
135 ALTER TABLE [SubSNPLinkout] ADD CONSTRAINT [pk_SubSNPLinkout] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[link_type] ASC)
\r
138 ALTER TABLE [SubSNPMdFailLn] ADD CONSTRAINT [pk_SubSNPMdFailLn] PRIMARY KEY NONCLUSTERED ([subsnp_id] ASC,[line_num] ASC)
\r
141 ALTER TABLE [SubSNPNoVariSeq] ADD CONSTRAINT [pk_SubSNPNoVariSeq] PRIMARY KEY NONCLUSTERED ([subsnp_id] ASC,[line_num] ASC)
\r
144 ALTER TABLE [SubSNPOmim] ADD CONSTRAINT [pk_SubSNPOmim] PRIMARY KEY CLUSTERED ([subsnp_id] ASC)
\r
147 ALTER TABLE [SubSNPPubmed] ADD CONSTRAINT [pk_SubSNPPubmed] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[line_num] ASC)
\r
150 ALTER TABLE [SubSNPSeq3_ins] ADD CONSTRAINT [pk_SubSNPSeq3] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
\r
153 ALTER TABLE [SubSNPSeq5_ins] ADD CONSTRAINT [pk_SubSNPSeq5] PRIMARY KEY CLUSTERED ([subsnp_id] ASC,[type] ASC,[line_num] ASC)
\r
156 ALTER TABLE [SubSNPSeqPos] ADD CONSTRAINT [pk_SubSNPSeqPos] PRIMARY KEY CLUSTERED ([subsnp_id] ASC)
\r
159 ALTER TABLE [SubSNP_top_or_bot] ADD CONSTRAINT [PK__t_ss_top_or_bot__0D5DFFA8] PRIMARY KEY CLUSTERED ([subsnp_id] ASC)
\r
162 ALTER TABLE [SubmittedIndividual] ADD CONSTRAINT [DF__Submitted__ploid__41661CE5] DEFAULT (2) FOR [ploidy]
163 ALTER TABLE [SubmittedIndividual] ADD CONSTRAINT [pk_SubmittedIndividual] PRIMARY KEY CLUSTERED ([pop_id] ASC,[loc_ind_id_upp] ASC)
\r
166 ALTER TABLE [Synonym] ADD CONSTRAINT [pk_Synonym] PRIMARY KEY NONCLUSTERED ([subsnp_id] ASC,[type] ASC)
\r
169 ALTER TABLE [b135_ContigInfo_37_3] ADD CONSTRAINT [df_b135_ContigInfo_37_3_last_updated_time] DEFAULT (GETDATE()) FOR [last_updated_time]
170 ALTER TABLE [b135_ContigInfo_37_3] ADD CONSTRAINT [pk_b135_ContigInfo_37_3] PRIMARY KEY CLUSTERED ([contig_gi] ASC)
\r
175 ALTER TABLE [b135_MapLink_37_3] ADD CONSTRAINT [fk_b135_MapLink_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
180 ALTER TABLE [b135_SNPChrPosOnRef_37_3] ADD CONSTRAINT [fk_b135_SNPChrPosOnRef_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
183 ALTER TABLE [b135_SNPContigLoc_37_3] ADD CONSTRAINT [fk_b135_SNPContigLoc_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
186 ALTER TABLE [b135_SNPContigLocusId_37_3] ADD CONSTRAINT [fk_b135_SNPContigLocusId_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
189 ALTER TABLE [b135_SNPContigProtein_37_3] ADD CONSTRAINT [fk_b135_SNPContigProtein_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
192 ALTER TABLE [b135_SNPMapInfo_37_3] ADD CONSTRAINT [fk_b135_SNPMapInfo_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
195 ALTER TABLE [b135_SNPMapLinkProtein_37_3] ADD CONSTRAINT [fk_b135_SNPMapLinkProtein_37_3_rs] FOREIGN KEY (snp_id) REFERENCES [SNP](snp_id)
\r
198 ALTER TABLE [dn_IND_batchCount] ADD CONSTRAINT [pk_dn_IND_batchCount] PRIMARY KEY NONCLUSTERED ([batch_id] ASC,[pop_id] ASC)
\r
202 ALTER TABLE [dn_PopulationIndGrp] ADD CONSTRAINT [pk_dn_PopulationIndGrp] PRIMARY KEY CLUSTERED ([pop_id] ASC)
\r
205 ALTER TABLE [dn_batchCount] ADD CONSTRAINT [pk_dn_batchCount] PRIMARY KEY NONCLUSTERED ([batch_id] ASC)
\r
208 ALTER TABLE [dn_handleCount] ADD CONSTRAINT [pk_dn_handleCount] PRIMARY KEY NONCLUSTERED ([handle] ASC,[batch_type] ASC)
\r