1 ALTER TABLE "Allele" ADD
2 CONSTRAINT "pk_Allele" PRIMARY KEY
8 ALTER TABLE "AlleleFlagCode" ADD
9 CONSTRAINT "pk_AlleleFlagCode" PRIMARY KEY
15 ALTER TABLE "AlleleMotif" ADD
16 CONSTRAINT "pk_AlleleMotif" PRIMARY KEY
23 ALTER TABLE "AllocIds" ADD
24 CONSTRAINT "pk_AllocIds" PRIMARY KEY
30 ALTER TABLE "Author" ADD
31 CONSTRAINT "pk_Author" PRIMARY KEY
40 ALTER TABLE "CpGCode" ADD
41 CONSTRAINT "pk_CpGCode" PRIMARY KEY
49 ALTER TABLE "GenomeBuildInfo" ADD
50 CONSTRAINT "DF__GenomeBui__inser__15E52B55" DEFAULT (getdate()) FOR "insert_time",
51 CONSTRAINT "DF__GenomeBui__is_ma__18C19800" DEFAULT (1) FOR "is_major",
52 CONSTRAINT "DF__GenomeBui__ncbi___23FE4082" DEFAULT (0) FOR "ncbi_genome_tax_id"
55 ALTER TABLE "GtyAllele" ADD
56 CONSTRAINT "pk_GtyAllele" PRIMARY KEY
64 ALTER TABLE "IUPACna" ADD
65 CONSTRAINT "pk_IUPACna" PRIMARY KEY
71 ALTER TABLE "LoadHistory" ADD
72 CONSTRAINT "pk_LoadHistory" PRIMARY KEY
78 ALTER TABLE "LocTypeCode" ADD
79 CONSTRAINT "DF__LocTypeCo__creat__75CD617E" DEFAULT (getdate()) FOR "create_time",
80 CONSTRAINT "pk_LocTypeCode" PRIMARY KEY
86 ALTER TABLE "MapLinkCode" ADD
87 CONSTRAINT "pk_MapLinkCode" PRIMARY KEY
94 ALTER TABLE "Method" ADD
95 CONSTRAINT "pk_Method_mid" PRIMARY KEY
101 ALTER TABLE "MethodClass" ADD
102 CONSTRAINT "pk_MethodClass" PRIMARY KEY
108 ALTER TABLE "MethodLine" ADD
109 CONSTRAINT "pk_MethodLine" PRIMARY KEY
116 ALTER TABLE "Moltype" ADD
117 CONSTRAINT "pk_Moltype" PRIMARY KEY
123 ALTER TABLE "Motif" ADD
124 CONSTRAINT "pk_Motif" PRIMARY KEY
130 ALTER TABLE "ObsGenotype" ADD
131 CONSTRAINT "pk_ObsGenotype" PRIMARY KEY
137 ALTER TABLE "ObsVariation" ADD
138 CONSTRAINT "DF__ObsVariat__creat__3BB5CE82" DEFAULT (getdate()) FOR "create_time",
139 CONSTRAINT "DF__ObsVariat__last___3CA9F2BB" DEFAULT (getdate()) FOR "last_updated_time",
140 CONSTRAINT "pk_ObsVariation" PRIMARY KEY
146 ALTER TABLE "OrgDbStatus" ADD
147 CONSTRAINT "pk_org_db_status" PRIMARY KEY
153 ALTER TABLE "OrganismTax" ADD
154 CONSTRAINT "pk_organism" PRIMARY KEY
160 ALTER TABLE "PopClass" ADD
161 CONSTRAINT "pk_PopClass" PRIMARY KEY
168 ALTER TABLE "PopClassCode" ADD
169 CONSTRAINT "PK__PopClassCode__270595B6" PRIMARY KEY
175 ALTER TABLE "Publication" ADD
176 CONSTRAINT "pk_Publication" PRIMARY KEY
182 ALTER TABLE "SNPGlossary" ADD
183 CONSTRAINT "DF__SNPGlossa__last___4050666D" DEFAULT (getdate()) FOR "last_updated",
184 CONSTRAINT "pk_SNPGlossary" PRIMARY KEY
190 ALTER TABLE "SNP_tax_id" ADD
191 CONSTRAINT "DF__SNP_tax_i__statu__31583BA0" DEFAULT ('C') FOR "status",
192 CONSTRAINT "pk_SNP_tax_id" PRIMARY KEY
198 ALTER TABLE "SnpChrCode" ADD
199 CONSTRAINT "pk_SnpChrCode" PRIMARY KEY
205 ALTER TABLE "SnpClassCode" ADD
206 CONSTRAINT "pk_SnpClassCode" PRIMARY KEY
212 ALTER TABLE "SnpFunctionCode" ADD
213 CONSTRAINT "pk_SnpFunctionCode" PRIMARY KEY
219 ALTER TABLE "SnpValidationCode" ADD
220 CONSTRAINT "pk_SnpValidationCode" PRIMARY KEY
226 ALTER TABLE "StrandCode" ADD
227 CONSTRAINT "pk_StrandCode" PRIMARY KEY
235 ALTER TABLE "Submitter" ADD
236 CONSTRAINT "DF_Submitter_create_time" DEFAULT (getdate()) FOR "create_time",
237 CONSTRAINT "pk_Submitter" PRIMARY KEY
243 ALTER TABLE "TemplateType" ADD
244 CONSTRAINT "pk_TemplateType" PRIMARY KEY
250 ALTER TABLE "UniGty" ADD
251 CONSTRAINT "pk_UniGty" PRIMARY KEY
257 ALTER TABLE "UniVariAllele" ADD
258 CONSTRAINT "pk_UniVariAllele" PRIMARY KEY
265 ALTER TABLE "UniVariation" ADD
266 CONSTRAINT "pk_UniVariation" PRIMARY KEY
272 ALTER TABLE "UniVariationSrcCode" ADD
273 CONSTRAINT "pk_UniVariationSrcCode" PRIMARY KEY
279 ALTER TABLE "VariAllele" ADD
280 CONSTRAINT "pk_VariAllele" PRIMARY KEY
287 ALTER TABLE "db_DataDictionaryNew" ADD
288 CONSTRAINT "DF__db_DataDi__updat__5BB889C0" DEFAULT (getdate()) FOR "update_time"
291 ALTER TABLE "db_ftp_table_list" ADD
292 CONSTRAINT "DF__db_ftp_ta__creat__27F9B9EF" DEFAULT (getdate()) FOR "create_time",
293 CONSTRAINT "pk_db_ftp_table_list" PRIMARY KEY
300 ALTER TABLE "dn_Allele_rev" ADD
301 CONSTRAINT "pk_dn_Allele_rev" PRIMARY KEY
308 ALTER TABLE "dn_Motif_rev" ADD
309 CONSTRAINT "pk_dn_Motif_rev" PRIMARY KEY
316 ALTER TABLE "dn_UniGty_allele" ADD
317 CONSTRAINT "pk_dn_UniGty_allele" PRIMARY KEY
324 ALTER TABLE "dn_UniGty_rev" ADD
325 CONSTRAINT "pk_dn_Gty_rev" PRIMARY KEY
332 ALTER TABLE "dn_UniVariation_rev" ADD
333 CONSTRAINT "pk_dn_UniVariation_rev" PRIMARY KEY
342 ALTER TABLE "dn_summary" ADD
343 CONSTRAINT "DF__dn_summar__creat__383A4359" DEFAULT (getdate()) FOR "create_time",
344 CONSTRAINT "DF__dn_summar__last___392E6792" DEFAULT (getdate()) FOR "last_updated_time",