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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
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 
)
GO


