add human 9606 schema

[dbsnp.git] / schema / human_9606_schema / human_gty2_table_postgresql.sql

diff --git a/schema/human_9606_schema/human_gty2_table_postgresql.sql b/schema/human_9606_schema/human_gty2_table_postgresql.sql
new file mode 100644 (file)
index 0000000..616818f
--- /dev/null
+++ b/schema/human_9606_schema/human_gty2_table_postgresql.sql
@@ -0,0 +1,301 @@
+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 
+)
+;
+