X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty1_table_postgresql.sql;fp=schema%2Fhuman_9606_schema%2Fhuman_gty1_table_postgresql.sql;h=de00c19127eaa20147ef3be63b89be614bc5d94f;hb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;hp=0000000000000000000000000000000000000000;hpb=6b2ac925d51c30ffa1811f6d5e44fba29a94ff4b;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_gty1_table_postgresql.sql b/schema/human_9606_schema/human_gty1_table_postgresql.sql
new file mode 100644
index 0000000..de00c19
--- /dev/null
+++ b/schema/human_9606_schema/human_gty1_table_postgresql.sql
@@ -0,0 +1,57 @@
+CREATE TABLE SubInd (
+	chr CHAR 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_ch1 CHECK (chr = '1') INHERITS SubInd;
+CREATE TABLE SubInd_ch2 CHECK (chr = '2') INHERITS SubInd;
+CREATE TABLE SubInd_ch3 CHECK (chr = '3') INHERITS SubInd;
+CREATE TABLE SubInd_ch4 CHECK (chr = '4') INHERITS SubInd;
+CREATE TABLE SubInd_ch5 CHECK (chr = '5') INHERITS SubInd;
+CREATE TABLE SubInd_ch6 CHECK (chr = '6') INHERITS SubInd;
+CREATE TABLE SubInd_ch7 CHECK (chr = '7') INHERITS SubInd;
+CREATE TABLE SubInd_ch8 CHECK (chr = '8') INHERITS SubInd;
+CREATE TABLE SubInd_ch9 CHECK (chr = '9') INHERITS SubInd;
+CREATE TABLE SubInd_ch10 CHECK (chr = '10') INHERITS SubInd;
+CREATE TABLE SubInd_ch11 CHECK (chr = '11') INHERITS SubInd;
+CREATE TABLE SubInd_ch12 CHECK (chr = '12') INHERITS SubInd;
+CREATE TABLE SubInd_ch13 CHECK (chr = '13') INHERITS SubInd;
+CREATE TABLE SubInd_ch14 CHECK (chr = '14') INHERITS SubInd;
+CREATE TABLE SubInd_ch15 CHECK (chr = '15') INHERITS SubInd;
+CREATE TABLE SubInd_ch16 CHECK (chr = '16') INHERITS SubInd;
+CREATE TABLE SubInd_ch17 CHECK (chr = '17') INHERITS SubInd;
+CREATE TABLE SubInd_ch18 CHECK (chr = '18') INHERITS SubInd;
+CREATE TABLE SubInd_ch19 CHECK (chr = '19') INHERITS SubInd;
+CREATE TABLE SubInd_ch20 CHECK (chr = '20') INHERITS SubInd;
+CREATE TABLE SubInd_ch21 CHECK (chr = '21') INHERITS SubInd;
+CREATE TABLE SubInd_ch22 CHECK (chr = '22') INHERITS SubInd;
+CREATE TABLE SubInd_chAltOnly CHECK (chr = 'AltOnly') INHERITS SubInd;
+CREATE TABLE SubInd_chMT CHECK (chr = 'MT') INHERITS SubInd;
+CREATE TABLE SubInd_chMulti CHECK (chr = 'Multi') INHERITS SubInd;
+CREATE TABLE SubInd_chNewSs CHECK (chr = 'NewSs') INHERITS SubInd;
+CREATE TABLE SubInd_chNotOn CHECK (chr = 'NotOn') INHERITS SubInd;
+CREATE TABLE SubInd_chPAR CHECK (chr = 'PAR') INHERITS SubInd;
+CREATE TABLE SubInd_chUn CHECK (chr = 'Un') INHERITS SubInd;
+CREATE TABLE SubInd_chX CHECK (chr = 'X') INHERITS SubInd;
+CREATE TABLE SubInd_chY CHECK (chr = 'Y') INHERITS SubInd;
+
+
+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 
+)
+;
+