schema/human_9606_schema/human_gty2_constraint_postgresql.sql

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