schema/human_9606_schema/human_gty1_constraint_postgresql.sql

   1 ALTER TABLE SubInd_ch1 ADD
   2         CONSTRAINT pk_ch_t_SubInd_ch1 PRIMARY KEY
   3         (
   4                 subsnp_id,
   5                 submitted_ind_id,
   6                 batch_id,
   7                 chr
   8         )
   9 ;
  10
  11 ALTER TABLE SubInd_ch2 ADD
  12         CONSTRAINT pk_ch_t_SubInd_ch2 PRIMARY KEY
  13         (
  14                 subsnp_id,
  15                 submitted_ind_id,
  16                 batch_id,
  17                 chr
  18         )
  19 ;
  20
  21 ALTER TABLE SubInd_ch3 ADD
  22         CONSTRAINT pk_ch_t_SubInd_ch3 PRIMARY KEY
  23         (
  24                 subsnp_id,
  25                 submitted_ind_id,
  26                 batch_id,
  27                 chr
  28         )
  29 ;
  30
  31 ALTER TABLE SubInd_ch4 ADD
  32         CONSTRAINT pk_ch_t_SubInd_ch4 PRIMARY KEY
  33         (
  34                 subsnp_id,
  35                 submitted_ind_id,
  36                 batch_id,
  37                 chr
  38         )
  39 ;
  40
  41 ALTER TABLE SubInd_ch5 ADD
  42         CONSTRAINT pk_ch_t_SubInd_ch5 PRIMARY KEY
  43         (
  44                 subsnp_id,
  45                 submitted_ind_id,
  46                 batch_id,
  47                 chr
  48         )
  49 ;
  50
  51 ALTER TABLE SubInd_ch6 ADD
  52         CONSTRAINT pk_ch_t_SubInd_ch6 PRIMARY KEY
  53         (
  54                 subsnp_id,
  55                 submitted_ind_id,
  56                 batch_id,
  57                 chr
  58         )
  59 ;
  60
  61 ALTER TABLE SubInd_ch7 ADD
  62         CONSTRAINT pk_ch_t_SubInd_ch7 PRIMARY KEY
  63         (
  64                 subsnp_id,
  65                 submitted_ind_id,
  66                 batch_id,
  67                 chr
  68         )
  69 ;
  70
  71