X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty2_table_postgresql.sql;h=c4714cde25cf840afbe5d49322f791eb0e4ddacb;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=616818f6f4e6c6bd79a23250db7931a9e4ab9aed;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_gty2_table_postgresql.sql b/schema/human_9606_schema/human_gty2_table_postgresql.sql
index 616818f..c4714cd 100644
--- a/schema/human_9606_schema/human_gty2_table_postgresql.sql
+++ b/schema/human_9606_schema/human_gty2_table_postgresql.sql
@@ -1,301 +1,276 @@
-CREATE TABLE SubInd_ch10 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch11 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch12 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch13 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch14 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch15 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch16 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch17 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch18 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch19 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch20 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch21 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch22 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch8 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_ch9 (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chAltOnly (
-	chr varchar (8) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chMT (
-	chr varchar (8) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chMulti (
-	chr varchar (8) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chNewSs (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag smallint NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chNotOn (
-	chr varchar (8) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chPAR (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chUn (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chX (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE SubInd_chY (
-	chr varchar (3) NOT NULL ,
-	batch_id int NOT NULL ,
-	subsnp_id int NOT NULL ,
-	submitted_ind_id int NOT NULL ,
-	submitted_strand_code int NULL ,
-	allele_flag int NULL ,
-	gty_id int NULL ,
-	submitted_rs int NULL 
-)
-;
-
-CREATE TABLE dn_table_rowcount (
-	tabname varchar (64) NOT NULL ,
-	row_cnt int NOT NULL ,
-	build_id int NOT NULL ,
-	update_time TIMESTAMP NOT NULL ,
-	rows_in_spaceused int NULL ,
-	reserved_KB_spaceused int NULL ,
-	data_KB_spaceused int NULL ,
-	index_size_KB_spaceused int NULL ,
-	unused_KB_spaceused int NULL 
-)
-;
-
+CREATE TABLE SubInd_ch10
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch11
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch12
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch13
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch14
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch15
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch16
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch17
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch18
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch19
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch20
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch21
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch22
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch8
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_ch9
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chAltOnly
+(
+chr varchar(8) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chMT
+(
+chr varchar(8) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chMulti
+(
+chr varchar(8) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chNewSs
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag smallint NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chNotOn
+(
+chr varchar(8) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chPAR
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chUn
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chX
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE SubInd_chY
+(
+chr varchar(3) NOT NULL ,
+batch_id int NOT NULL ,
+subsnp_id int NOT NULL ,
+submitted_ind_id int NOT NULL ,
+submitted_strand_code int NULL ,
+allele_flag int NULL ,
+gty_id int NULL ,
+submitted_rs int NULL
+);
+CREATE TABLE dn_table_rowcount
+(
+tabname varchar(64) NOT NULL ,
+row_cnt int NOT NULL ,
+build_id int NOT NULL ,
+update_time TIMESTAMP NOT NULL ,
+rows_in_spaceused int NULL ,
+reserved_KB_spaceused int NULL ,
+data_KB_spaceused int NULL ,
+index_size_KB_spaceused int NULL ,
+unused_KB_spaceused int NULL
+);