-ALTER TABLE SubInd_ch10 ADD
- CONSTRAINT pk_ch_t_SubInd_ch10 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch11 ADD
- CONSTRAINT pk_ch_t_SubInd_ch11 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch12 ADD
- CONSTRAINT pk_ch_t_SubInd_ch12 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch13 ADD
- CONSTRAINT pk_ch_t_SubInd_ch13 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch14 ADD
- CONSTRAINT pk_ch_t_SubInd_ch14 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch15 ADD
- CONSTRAINT pk_ch_t_SubInd_ch15 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch16 ADD
- CONSTRAINT pk_ch_t_SubInd_ch16 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch17 ADD
- CONSTRAINT pk_ch_t_SubInd_ch17 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch18 ADD
- CONSTRAINT pk_ch_t_SubInd_ch18 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch19 ADD
- CONSTRAINT pk_ch_t_SubInd_ch19 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch20 ADD
- CONSTRAINT pk_ch_t_SubInd_ch20 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch21 ADD
- CONSTRAINT pk_ch_t_SubInd_ch21 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch22 ADD
- CONSTRAINT pk_ch_t_SubInd_ch22 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch8 ADD
- CONSTRAINT pk_ch_t_SubInd_ch8 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_ch9 ADD
- CONSTRAINT pk_ch_t_SubInd_ch9 PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chAltOnly ADD
- CONSTRAINT pk_SubInd_chAltOnly PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chMT ADD
- CONSTRAINT pk_ch_t_SubInd_chMT PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chMulti ADD
- CONSTRAINT pk_SubInd_chMulti PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chNewSs ADD
- CONSTRAINT pk_SubInd_chNewSs PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chNotOn ADD
- CONSTRAINT pk_SubInd_chNotOn PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chPAR ADD
- CONSTRAINT pk_SubInd_chPAR PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chUn ADD
- CONSTRAINT pk_SubInd_chUn PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chX ADD
- CONSTRAINT pk_ch_t_SubInd_chX PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-ALTER TABLE SubInd_chY ADD
- CONSTRAINT pk_ch_t_SubInd_chY PRIMARY KEY
- (
- subsnp_id,
- submitted_ind_id,
- batch_id,
- chr
- )
-;
-
-
+ALTER TABLE SubInd_ch10 ADD CONSTRAINT pk_ch_t_SubInd_ch10 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch11 ADD CONSTRAINT pk_ch_t_SubInd_ch11 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch12 ADD CONSTRAINT pk_ch_t_SubInd_ch12 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch13 ADD CONSTRAINT pk_ch_t_SubInd_ch13 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch14 ADD CONSTRAINT pk_ch_t_SubInd_ch14 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch15 ADD CONSTRAINT pk_ch_t_SubInd_ch15 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch16 ADD CONSTRAINT pk_ch_t_SubInd_ch16 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch17 ADD CONSTRAINT pk_ch_t_SubInd_ch17 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch18 ADD CONSTRAINT pk_ch_t_SubInd_ch18 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch19 ADD CONSTRAINT pk_ch_t_SubInd_ch19 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch20 ADD CONSTRAINT pk_ch_t_SubInd_ch20 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch21 ADD CONSTRAINT pk_ch_t_SubInd_ch21 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch22 ADD CONSTRAINT pk_ch_t_SubInd_ch22 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch8 ADD CONSTRAINT pk_ch_t_SubInd_ch8 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_ch9 ADD CONSTRAINT pk_ch_t_SubInd_ch9 PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chAltOnly ADD CONSTRAINT pk_SubInd_chAltOnly PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chMT ADD CONSTRAINT pk_ch_t_SubInd_chMT PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chMulti ADD CONSTRAINT pk_SubInd_chMulti PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chNewSs ADD CONSTRAINT pk_SubInd_chNewSs PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chNotOn ADD CONSTRAINT pk_SubInd_chNotOn PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chPAR ADD CONSTRAINT pk_SubInd_chPAR PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chUn ADD CONSTRAINT pk_SubInd_chUn PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chX ADD CONSTRAINT pk_ch_t_SubInd_chX PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);
+ALTER TABLE SubInd_chY ADD CONSTRAINT pk_ch_t_SubInd_chY PRIMARY KEY (chr,batch_id,subsnp_id,submitted_ind_id);