schema/human_9606_schema/human_gty2_constraint.sql

   1 ALTER TABLE [SubInd_ch10] ADD
   2         CONSTRAINT [pk_ch_t_SubInd_ch10] PRIMARY KEY  CLUSTERED
   3         (
   4                 [subsnp_id],
   5                 [submitted_ind_id],
   6                 [batch_id],
   7                 [chr]
   8         )
   9 GO
  10
  11
  12 ALTER TABLE [SubInd_ch11] ADD
  13         CONSTRAINT [pk_ch_t_SubInd_ch11] PRIMARY KEY  CLUSTERED
  14         (
  15                 [subsnp_id],
  16                 [submitted_ind_id],
  17                 [batch_id],
  18                 [chr]
  19         )
  20 GO
  21
  22
  23 ALTER TABLE [SubInd_ch12] ADD
  24         CONSTRAINT [pk_ch_t_SubInd_ch12] PRIMARY KEY  CLUSTERED
  25         (
  26                 [subsnp_id],
  27                 [submitted_ind_id],
  28                 [batch_id],
  29                 [chr]
  30         )
  31 GO
  32
  33
  34 ALTER TABLE [SubInd_ch13] ADD
  35         CONSTRAINT [pk_ch_t_SubInd_ch13] PRIMARY KEY  CLUSTERED
  36         (
  37                 [subsnp_id],
  38                 [submitted_ind_id],
  39                 [batch_id],
  40                 [chr]
  41         )
  42 GO
  43
  44
  45 ALTER TABLE [SubInd_ch14] ADD
  46         CONSTRAINT [pk_ch_t_SubInd_ch14] PRIMARY KEY  CLUSTERED
  47         (
  48                 [subsnp_id],
  49                 [submitted_ind_id],
  50                 [batch_id],
  51                 [chr]
  52         )
  53 GO
  54
  55
  56 ALTER TABLE [SubInd_ch15] ADD
  57         CONSTRAINT [pk_ch_t_SubInd_ch15] PRIMARY KEY  CLUSTERED
  58         (
  59                 [subsnp_id],
  60                 [submitted_ind_id],
  61                 [batch_id],
  62                 [chr]
  63         )
  64 GO
  65
  66
  67 ALTER TABLE [SubInd_ch16] ADD
  68         CONSTRAINT [pk_ch_t_SubInd_ch16] PRIMARY KEY  CLUSTERED
  69         (
  70                 [subsnp_id],
  71                 [submitted_ind_id],
  72                 [batch_id],
  73                 [chr]
  74         )
  75 GO
  76
  77
  78 ALTER TABLE [SubInd_ch17] ADD
  79         CONSTRAINT [pk_ch_t_SubInd_ch17] PRIMARY KEY  CLUSTERED
  80         (
  81                 [subsnp_id],
  82                 [submitted_ind_id],
  83                 [batch_id],
  84                 [chr]
  85         )
  86 GO
  87
  88
  89 ALTER TABLE [SubInd_ch18] ADD
  90         CONSTRAINT [pk_ch_t_SubInd_ch18] PRIMARY KEY  CLUSTERED
  91         (
  92                 [subsnp_id],
  93                 [submitted_ind_id],
  94                 [batch_id],
  95                 [chr]
  96         )
  97 GO
  98
  99
 100 ALTER TABLE [SubInd_ch19] ADD
 101         CONSTRAINT [pk_ch_t_SubInd_ch19] PRIMARY KEY  CLUSTERED
 102         (
 103                 [subsnp_id],
 104                 [submitted_ind_id],
 105                 [batch_id],
 106                 [chr]
 107         )
 108 GO
 109
 110
 111 ALTER TABLE [SubInd_ch20] ADD
 112         CONSTRAINT [pk_ch_t_SubInd_ch20] PRIMARY KEY  CLUSTERED
 113         (
 114                 [subsnp_id],
 115                 [submitted_ind_id],
 116                 [batch_id],
 117                 [chr]
 118         )
 119 GO
 120
 121
 122 ALTER TABLE [SubInd_ch21] ADD
 123         CONSTRAINT [pk_ch_t_SubInd_ch21] PRIMARY KEY  CLUSTERED
 124         (
 125                 [subsnp_id],
 126                 [submitted_ind_id],
 127                 [batch_id],
 128                 [chr]
 129         )
 130 GO
 131
 132
 133 ALTER TABLE [SubInd_ch22] ADD
 134         CONSTRAINT [pk_ch_t_SubInd_ch22] PRIMARY KEY  CLUSTERED
 135         (
 136                 [subsnp_id],
 137                 [submitted_ind_id],
 138                 [batch_id],
 139                 [chr]
 140         )
 141 GO
 142
 143
 144 ALTER TABLE [SubInd_ch8] ADD
 145         CONSTRAINT [pk_ch_t_SubInd_ch8] PRIMARY KEY  CLUSTERED
 146         (
 147                 [subsnp_id],
 148                 [submitted_ind_id],
 149                 [batch_id],
 150                 [chr]
 151         )
 152 GO
 153
 154
 155 ALTER TABLE [SubInd_ch9] ADD
 156         CONSTRAINT [pk_ch_t_SubInd_ch9] PRIMARY KEY  CLUSTERED
 157         (
 158                 [subsnp_id],
 159                 [submitted_ind_id],
 160                 [batch_id],
 161                 [chr]
 162         )
 163 GO
 164
 165
 166 ALTER TABLE [SubInd_chAltOnly] ADD
 167         CONSTRAINT [pk_SubInd_chAltOnly] PRIMARY KEY  CLUSTERED
 168         (
 169                 [subsnp_id],
 170                 [submitted_ind_id],
 171                 [batch_id],
 172                 [chr]
 173         )
 174 GO
 175
 176
 177 ALTER TABLE [SubInd_chMT] ADD
 178         CONSTRAINT [pk_ch_t_SubInd_chMT] PRIMARY KEY  CLUSTERED
 179         (
 180                 [subsnp_id],
 181                 [submitted_ind_id],
 182                 [batch_id],
 183                 [chr]
 184         )
 185 GO
 186
 187
 188 ALTER TABLE [SubInd_chMulti] ADD
 189         CONSTRAINT [pk_SubInd_chMulti] PRIMARY KEY  CLUSTERED
 190         (
 191                 [subsnp_id],
 192                 [submitted_ind_id],
 193                 [batch_id],
 194                 [chr]
 195         )
 196 GO
 197
 198
 199 ALTER TABLE [SubInd_chNewSs] ADD
 200         CONSTRAINT [pk_SubInd_chNewSs] PRIMARY KEY  CLUSTERED
 201         (
 202                 [subsnp_id],
 203                 [submitted_ind_id],
 204                 [batch_id],
 205                 [chr]
 206         )
 207 GO
 208
 209
 210 ALTER TABLE [SubInd_chNotOn] ADD
 211         CONSTRAINT [pk_SubInd_chNotOn] PRIMARY KEY  CLUSTERED
 212         (
 213                 [subsnp_id],
 214                 [submitted_ind_id],
 215                 [batch_id],
 216                 [chr]
 217         )
 218 GO
 219
 220
 221 ALTER TABLE [SubInd_chPAR] ADD
 222         CONSTRAINT [pk_SubInd_chPAR] PRIMARY KEY  CLUSTERED
 223         (
 224                 [subsnp_id],
 225                 [submitted_ind_id],
 226                 [batch_id],
 227                 [chr]
 228         )
 229 GO
 230
 231
 232 ALTER TABLE [SubInd_chUn] ADD
 233         CONSTRAINT [pk_SubInd_chUn] PRIMARY KEY  CLUSTERED
 234         (
 235                 [subsnp_id],
 236                 [submitted_ind_id],
 237                 [batch_id],
 238                 [chr]
 239         )
 240 GO
 241
 242
 243 ALTER TABLE [SubInd_chX] ADD
 244         CONSTRAINT [pk_ch_t_SubInd_chX] PRIMARY KEY  CLUSTERED
 245         (
 246                 [subsnp_id],
 247                 [submitted_ind_id],
 248                 [batch_id],
 249                 [chr]
 250         )
 251 GO
 252
 253
 254 ALTER TABLE [SubInd_chY] ADD
 255         CONSTRAINT [pk_ch_t_SubInd_chY] PRIMARY KEY  CLUSTERED
 256         (
 257                 [subsnp_id],
 258                 [submitted_ind_id],
 259                 [batch_id],
 260                 [chr]
 261         )
 262 GO
 263
 264
 265