1 ALTER TABLE [Allele] ADD
2 CONSTRAINT [pk_Allele] PRIMARY KEY CLUSTERED
9 ALTER TABLE [AlleleFlagCode] ADD
10 CONSTRAINT [pk_AlleleFlagCode] PRIMARY KEY CLUSTERED
17 ALTER TABLE [AlleleMotif] ADD
18 CONSTRAINT [pk_AlleleMotif] PRIMARY KEY CLUSTERED
26 ALTER TABLE [AllocIds] ADD
27 CONSTRAINT [pk_AllocIds] PRIMARY KEY NONCLUSTERED
34 ALTER TABLE [Author] ADD
35 CONSTRAINT [pk_Author] PRIMARY KEY NONCLUSTERED
45 ALTER TABLE [CpGCode] ADD
46 CONSTRAINT [pk_CpGCode] PRIMARY KEY CLUSTERED
55 ALTER TABLE [GenomeBuildInfo] ADD
56 CONSTRAINT [DF__GenomeBui__inser__15E52B55] DEFAULT (getdate()) FOR [insert_time],
57 CONSTRAINT [DF__GenomeBui__is_ma__18C19800] DEFAULT (1) FOR [is_major],
58 CONSTRAINT [DF__GenomeBui__ncbi___23FE4082] DEFAULT (0) FOR [ncbi_genome_tax_id]
62 ALTER TABLE [GtyAllele] ADD
63 CONSTRAINT [pk_GtyAllele] PRIMARY KEY CLUSTERED
72 ALTER TABLE [IUPACna] ADD
73 CONSTRAINT [pk_IUPACna] PRIMARY KEY CLUSTERED
80 ALTER TABLE [LoadHistory] ADD
81 CONSTRAINT [pk_LoadHistory] PRIMARY KEY NONCLUSTERED
88 ALTER TABLE [LocTypeCode] ADD
89 CONSTRAINT [DF__LocTypeCo__creat__75CD617E] DEFAULT (getdate()) FOR [create_time],
90 CONSTRAINT [pk_LocTypeCode] PRIMARY KEY CLUSTERED
97 ALTER TABLE [MapLinkCode] ADD
98 CONSTRAINT [pk_MapLinkCode] PRIMARY KEY CLUSTERED
106 ALTER TABLE [Method] ADD
107 CONSTRAINT [pk_Method_mid] PRIMARY KEY CLUSTERED
114 ALTER TABLE [MethodClass] ADD
115 CONSTRAINT [pk_MethodClass] PRIMARY KEY CLUSTERED
122 ALTER TABLE [MethodLine] ADD
123 CONSTRAINT [pk_MethodLine] PRIMARY KEY NONCLUSTERED
131 ALTER TABLE [Moltype] ADD
132 CONSTRAINT [pk_Moltype] PRIMARY KEY CLUSTERED
139 ALTER TABLE [Motif] ADD
140 CONSTRAINT [pk_Motif] PRIMARY KEY CLUSTERED
147 ALTER TABLE [ObsGenotype] ADD
148 CONSTRAINT [pk_ObsGenotype] PRIMARY KEY CLUSTERED
155 ALTER TABLE [ObsVariation] ADD
156 CONSTRAINT [DF__ObsVariat__creat__3BB5CE82] DEFAULT (getdate()) FOR [create_time],
157 CONSTRAINT [DF__ObsVariat__last___3CA9F2BB] DEFAULT (getdate()) FOR [last_updated_time],
158 CONSTRAINT [pk_ObsVariation] PRIMARY KEY CLUSTERED
165 ALTER TABLE [OrgDbStatus] ADD
166 CONSTRAINT [pk_org_db_status] PRIMARY KEY CLUSTERED
173 ALTER TABLE [OrganismTax] ADD
174 CONSTRAINT [pk_organism] PRIMARY KEY NONCLUSTERED
181 ALTER TABLE [PopClass] ADD
182 CONSTRAINT [pk_PopClass] PRIMARY KEY CLUSTERED
190 ALTER TABLE [PopClassCode] ADD
191 CONSTRAINT [PK__PopClassCode__270595B6] PRIMARY KEY CLUSTERED
198 ALTER TABLE [Publication] ADD
199 CONSTRAINT [pk_Publication] PRIMARY KEY NONCLUSTERED
206 ALTER TABLE [SNPGlossary] ADD
207 CONSTRAINT [DF__SNPGlossa__last___4050666D] DEFAULT (getdate()) FOR [last_updated],
208 CONSTRAINT [pk_SNPGlossary] PRIMARY KEY CLUSTERED
215 ALTER TABLE [SNP_tax_id] ADD
216 CONSTRAINT [DF__SNP_tax_i__statu__31583BA0] DEFAULT ('C') FOR [status],
217 CONSTRAINT [pk_SNP_tax_id] PRIMARY KEY CLUSTERED
224 ALTER TABLE [SnpChrCode] ADD
225 CONSTRAINT [pk_SnpChrCode] PRIMARY KEY CLUSTERED
232 ALTER TABLE [SnpClassCode] ADD
233 CONSTRAINT [pk_SnpClassCode] PRIMARY KEY CLUSTERED
240 ALTER TABLE [SnpFunctionCode] ADD
241 CONSTRAINT [pk_SnpFunctionCode] PRIMARY KEY CLUSTERED
248 ALTER TABLE [SnpValidationCode] ADD
249 CONSTRAINT [pk_SnpValidationCode] PRIMARY KEY NONCLUSTERED
256 ALTER TABLE [StrandCode] ADD
257 CONSTRAINT [pk_StrandCode] PRIMARY KEY CLUSTERED
266 ALTER TABLE [Submitter] ADD
267 CONSTRAINT [DF_Submitter_create_time] DEFAULT (getdate()) FOR [create_time],
268 CONSTRAINT [pk_Submitter] PRIMARY KEY NONCLUSTERED
275 ALTER TABLE [TemplateType] ADD
276 CONSTRAINT [pk_TemplateType] PRIMARY KEY CLUSTERED
283 ALTER TABLE [UniGty] ADD
284 CONSTRAINT [pk_UniGty] PRIMARY KEY CLUSTERED
291 ALTER TABLE [UniVariAllele] ADD
292 CONSTRAINT [pk_UniVariAllele] PRIMARY KEY CLUSTERED
300 ALTER TABLE [UniVariation] ADD
301 CONSTRAINT [pk_UniVariation] PRIMARY KEY CLUSTERED
308 ALTER TABLE [UniVariationSrcCode] ADD
309 CONSTRAINT [pk_UniVariationSrcCode] PRIMARY KEY CLUSTERED
316 ALTER TABLE [VariAllele] ADD
317 CONSTRAINT [pk_VariAllele] PRIMARY KEY CLUSTERED
325 ALTER TABLE [db_DataDictionaryNew] ADD
326 CONSTRAINT [DF__db_DataDi__updat__5BB889C0] DEFAULT (getdate()) FOR [update_time]
330 ALTER TABLE [db_ftp_table_list] ADD
331 CONSTRAINT [DF__db_ftp_ta__creat__27F9B9EF] DEFAULT (getdate()) FOR [create_time],
332 CONSTRAINT [pk_db_ftp_table_list] PRIMARY KEY CLUSTERED
340 ALTER TABLE [dn_Allele_rev] ADD
341 CONSTRAINT [pk_dn_Allele_rev] PRIMARY KEY CLUSTERED
349 ALTER TABLE [dn_Motif_rev] ADD
350 CONSTRAINT [pk_dn_Motif_rev] PRIMARY KEY CLUSTERED
358 ALTER TABLE [dn_UniGty_allele] ADD
359 CONSTRAINT [pk_dn_UniGty_allele] PRIMARY KEY CLUSTERED
367 ALTER TABLE [dn_UniGty_rev] ADD
368 CONSTRAINT [pk_dn_Gty_rev] PRIMARY KEY CLUSTERED
376 ALTER TABLE [dn_UniVariation_rev] ADD
377 CONSTRAINT [pk_dn_UniVariation_rev] PRIMARY KEY CLUSTERED
387 ALTER TABLE [dn_summary] ADD
388 CONSTRAINT [DF__dn_summar__creat__383A4359] DEFAULT (getdate()) FOR [create_time],
389 CONSTRAINT [DF__dn_summar__last___392E6792] DEFAULT (getdate()) FOR [last_updated_time],
390 PRIMARY KEY CLUSTERED