schema/shared_schema/dbSNP_main_constraint.sql

   1 ALTER TABLE [Allele] ADD
   2         CONSTRAINT [pk_Allele] PRIMARY KEY  CLUSTERED
   3         (
   4                 [allele_id]
   5         )
   6 GO
   7
   8
   9 ALTER TABLE [AlleleFlagCode] ADD
  10         CONSTRAINT [pk_AlleleFlagCode] PRIMARY KEY  CLUSTERED
  11         (
  12                 [code]
  13         )
  14 GO
  15
  16
  17 ALTER TABLE [AlleleMotif] ADD
  18         CONSTRAINT [pk_AlleleMotif] PRIMARY KEY  CLUSTERED
  19         (
  20                 [allele_id],
  21                 [motif_order]
  22         )
  23 GO
  24
  25
  26 ALTER TABLE [AllocIds] ADD
  27         CONSTRAINT [pk_AllocIds] PRIMARY KEY  NONCLUSTERED
  28         (
  29                 [name]
  30         )
  31 GO
  32
  33
  34 ALTER TABLE [Author] ADD
  35         CONSTRAINT [pk_Author] PRIMARY KEY  NONCLUSTERED
  36         (
  37                 [pub_id],
  38                 [position]
  39         )
  40 GO
  41
  42
  43
  44
  45 ALTER TABLE [CpGCode] ADD
  46         CONSTRAINT [pk_CpGCode] PRIMARY KEY  CLUSTERED
  47         (
  48                 [code]
  49         )
  50 GO
  51
  52
  53
  54
  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]
  59 GO
  60
  61
  62 ALTER TABLE [GtyAllele] ADD
  63         CONSTRAINT [pk_GtyAllele] PRIMARY KEY  CLUSTERED
  64         (
  65                 [gty_id],
  66                 [rev_flag],
  67                 [chr_num]
  68         )
  69 GO
  70
  71
  72 ALTER TABLE [IUPACna] ADD
  73         CONSTRAINT [pk_IUPACna] PRIMARY KEY  CLUSTERED
  74         (
  75                 [allele]
  76         )
  77 GO
  78
  79
  80 ALTER TABLE [LoadHistory] ADD
  81         CONSTRAINT [pk_LoadHistory] PRIMARY KEY  NONCLUSTERED
  82         (
  83                 [build_id]
  84         )
  85 GO
  86
  87
  88 ALTER TABLE [LocTypeCode] ADD
  89         CONSTRAINT [DF__LocTypeCo__creat__75CD617E] DEFAULT (getdate()) FOR [create_time],
  90         CONSTRAINT [pk_LocTypeCode] PRIMARY KEY  CLUSTERED
  91         (
  92                 [code]
  93         )
  94 GO
  95
  96
  97 ALTER TABLE [MapLinkCode] ADD
  98         CONSTRAINT [pk_MapLinkCode] PRIMARY KEY  CLUSTERED
  99         (
 100                 [which_code],
 101                 [code]
 102         )
 103 GO
 104
 105
 106 ALTER TABLE [Method] ADD
 107         CONSTRAINT [pk_Method_mid] PRIMARY KEY  CLUSTERED
 108         (
 109                 [method_id]
 110         )
 111 GO
 112
 113
 114 ALTER TABLE [MethodClass] ADD
 115         CONSTRAINT [pk_MethodClass] PRIMARY KEY  CLUSTERED
 116         (
 117                 [meth_class_id]
 118         )
 119 GO
 120
 121
 122 ALTER TABLE [MethodLine] ADD
 123         CONSTRAINT [pk_MethodLine] PRIMARY KEY  NONCLUSTERED
 124         (
 125                 [method_id],
 126                 [line_num]
 127         )
 128 GO
 129
 130
 131 ALTER TABLE [Moltype] ADD
 132         CONSTRAINT [pk_Moltype] PRIMARY KEY  CLUSTERED
 133         (
 134                 [code]
 135         )
 136 GO
 137
 138
 139 ALTER TABLE [Motif] ADD
 140         CONSTRAINT [pk_Motif] PRIMARY KEY  CLUSTERED
 141         (
 142                 [motif_id]
 143         )
 144 GO
 145
 146
 147 ALTER TABLE [ObsGenotype] ADD
 148         CONSTRAINT [pk_ObsGenotype] PRIMARY KEY  CLUSTERED
 149         (
 150                 [gty_id]
 151         )
 152 GO
 153
 154
 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
 159         (
 160                 [var_id]
 161         )
 162 GO
 163
 164
 165 ALTER TABLE [OrgDbStatus] ADD
 166         CONSTRAINT [pk_org_db_status] PRIMARY KEY  CLUSTERED
 167         (
 168                 [database_name]
 169         )
 170 GO
 171
 172
 173 ALTER TABLE [OrganismTax] ADD
 174         CONSTRAINT [pk_organism] PRIMARY KEY  NONCLUSTERED
 175         (
 176                 [tax_id]
 177         )
 178 GO
 179
 180
 181 ALTER TABLE [PopClass] ADD
 182         CONSTRAINT [pk_PopClass] PRIMARY KEY  CLUSTERED
 183         (
 184                 [pop_id],
 185                 [pop_class_id]
 186         )
 187 GO
 188
 189
 190 ALTER TABLE [PopClassCode] ADD
 191         CONSTRAINT [PK__PopClassCode__270595B6] PRIMARY KEY  CLUSTERED
 192         (
 193                 [pop_class_id]
 194         )
 195 GO
 196
 197
 198 ALTER TABLE [Publication] ADD
 199         CONSTRAINT [pk_Publication] PRIMARY KEY  NONCLUSTERED
 200         (
 201                 [pub_id]
 202         )
 203 GO
 204
 205
 206 ALTER TABLE [SNPGlossary] ADD
 207         CONSTRAINT [DF__SNPGlossa__last___4050666D] DEFAULT (getdate()) FOR [last_updated],
 208         CONSTRAINT [pk_SNPGlossary] PRIMARY KEY  CLUSTERED
 209         (
 210                 [term]
 211         )
 212 GO
 213
 214
 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
 218         (
 219                 [snp_id]
 220         )
 221 GO
 222
 223
 224 ALTER TABLE [SnpChrCode] ADD
 225         CONSTRAINT [pk_SnpChrCode] PRIMARY KEY  CLUSTERED
 226         (
 227                 [code]
 228         )
 229 GO
 230
 231
 232 ALTER TABLE [SnpClassCode] ADD
 233         CONSTRAINT [pk_SnpClassCode] PRIMARY KEY  CLUSTERED
 234         (
 235                 [code]
 236         )
 237 GO
 238
 239
 240 ALTER TABLE [SnpFunctionCode] ADD
 241         CONSTRAINT [pk_SnpFunctionCode] PRIMARY KEY  CLUSTERED
 242         (
 243                 [code]
 244         )
 245 GO
 246
 247
 248 ALTER TABLE [SnpValidationCode] ADD
 249         CONSTRAINT [pk_SnpValidationCode] PRIMARY KEY  NONCLUSTERED
 250         (
 251                 [code]
 252         )
 253 GO
 254
 255
 256 ALTER TABLE [StrandCode] ADD
 257         CONSTRAINT [pk_StrandCode] PRIMARY KEY  CLUSTERED
 258         (
 259                 [code]
 260         )
 261 GO
 262
 263
 264
 265
 266 ALTER TABLE [Submitter] ADD
 267         CONSTRAINT [DF_Submitter_create_time] DEFAULT (getdate()) FOR [create_time],
 268         CONSTRAINT [pk_Submitter] PRIMARY KEY  NONCLUSTERED
 269         (
 270                 [handle]
 271         )
 272 GO
 273
 274
 275 ALTER TABLE [TemplateType] ADD
 276         CONSTRAINT [pk_TemplateType] PRIMARY KEY  CLUSTERED
 277         (
 278                 [temp_type_id]
 279         )
 280 GO
 281
 282
 283 ALTER TABLE [UniGty] ADD
 284         CONSTRAINT [pk_UniGty] PRIMARY KEY  CLUSTERED
 285         (
 286                 [unigty_id]
 287         )
 288 GO
 289
 290
 291 ALTER TABLE [UniVariAllele] ADD
 292         CONSTRAINT [pk_UniVariAllele] PRIMARY KEY  CLUSTERED
 293         (
 294                 [univar_id],
 295                 [allele_id]
 296         )
 297 GO
 298
 299
 300 ALTER TABLE [UniVariation] ADD
 301         CONSTRAINT [pk_UniVariation] PRIMARY KEY  CLUSTERED
 302         (
 303                 [univar_id]
 304         )
 305 GO
 306
 307
 308 ALTER TABLE [UniVariationSrcCode] ADD
 309         CONSTRAINT [pk_UniVariationSrcCode] PRIMARY KEY  CLUSTERED
 310         (
 311                 [code]
 312         )
 313 GO
 314
 315
 316 ALTER TABLE [VariAllele] ADD
 317         CONSTRAINT [pk_VariAllele] PRIMARY KEY  CLUSTERED
 318         (
 319                 [var_id],
 320                 [allele_id]
 321         )
 322 GO
 323
 324
 325 ALTER TABLE [db_DataDictionaryNew] ADD
 326         CONSTRAINT [DF__db_DataDi__updat__5BB889C0] DEFAULT (getdate()) FOR [update_time]
 327 GO
 328
 329
 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
 333         (
 334                 [table_name]
 335         )
 336 GO
 337
 338
 339
 340 ALTER TABLE [dn_Allele_rev] ADD
 341         CONSTRAINT [pk_dn_Allele_rev] PRIMARY KEY  CLUSTERED
 342         (
 343                 [allele_id],
 344                 [rev_flag]
 345         )
 346 GO
 347
 348
 349 ALTER TABLE [dn_Motif_rev] ADD
 350         CONSTRAINT [pk_dn_Motif_rev] PRIMARY KEY  CLUSTERED
 351         (
 352                 [motif_id],
 353                 [rev_flag]
 354         )
 355 GO
 356
 357
 358 ALTER TABLE [dn_UniGty_allele] ADD
 359         CONSTRAINT [pk_dn_UniGty_allele] PRIMARY KEY  CLUSTERED
 360         (
 361                 [unigty_id],
 362                 [chr_num]
 363         )
 364 GO
 365
 366
 367 ALTER TABLE [dn_UniGty_rev] ADD
 368         CONSTRAINT [pk_dn_Gty_rev] PRIMARY KEY  CLUSTERED
 369         (
 370                 [unigty_id],
 371                 [rev_flag]
 372         )
 373 GO
 374
 375
 376 ALTER TABLE [dn_UniVariation_rev] ADD
 377         CONSTRAINT [pk_dn_UniVariation_rev] PRIMARY KEY  CLUSTERED
 378         (
 379                 [univar_id],
 380                 [rev_flag]
 381         )
 382 GO
 383
 384
 385
 386
 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
 391         (
 392                 [tax_id],
 393                 [build_id],
 394                 [type]
 395         )
 396 GO
 397
 398