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

diff --git a/schema/human_9606_schema/human_gty2_table.sql b/schema/human_9606_schema/human_gty2_table.sql
index a5ff4d0..d310b64 100644
--- a/schema/human_9606_schema/human_gty2_table.sql
+++ b/schema/human_9606_schema/human_gty2_table.sql
@@ -1,326 +1,326 @@
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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] [tinyint] 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] [tinyint] NULL ,
+[gty_id] [int] NULL ,
+[submitted_rs] [int] NULL
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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_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
+)
 GO
 
-
-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 [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
+)
 GO
 
-
-CREATE TABLE [dn_table_rowcount] (
-	[tabname] [varchar] (64) NOT NULL ,
-	[row_cnt] [int] NOT NULL ,
-	[build_id] [int] NOT NULL ,
-	[update_time] [datetime] 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 [dn_table_rowcount]
+(
+[tabname] [varchar](64) NOT NULL ,
+[row_cnt] [int] NOT NULL ,
+[build_id] [int] NOT NULL ,
+[update_time] [datetime] 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
+)
 GO
 
-