1 CREATE TABLE [SubInd_ch1]
3 [chr] [varchar](3) NOT NULL ,
4 [batch_id] [int] NOT NULL ,
5 [subsnp_id] [int] NOT NULL ,
6 [submitted_ind_id] [int] NOT NULL ,
7 [submitted_strand_code] [int] NULL ,
8 [allele_flag] [int] NULL ,
10 [submitted_rs] [int] NULL
14 CREATE TABLE [SubInd_ch2]
16 [chr] [varchar](3) NOT NULL ,
17 [batch_id] [int] NOT NULL ,
18 [subsnp_id] [int] NOT NULL ,
19 [submitted_ind_id] [int] NOT NULL ,
20 [submitted_strand_code] [int] NULL ,
21 [allele_flag] [int] NULL ,
23 [submitted_rs] [int] NULL
27 CREATE TABLE [SubInd_ch3]
29 [chr] [varchar](3) NOT NULL ,
30 [batch_id] [int] NOT NULL ,
31 [subsnp_id] [int] NOT NULL ,
32 [submitted_ind_id] [int] NOT NULL ,
33 [submitted_strand_code] [int] NULL ,
34 [allele_flag] [int] NULL ,
36 [submitted_rs] [int] NULL
40 CREATE TABLE [SubInd_ch4]
42 [chr] [varchar](3) NOT NULL ,
43 [batch_id] [int] NOT NULL ,
44 [subsnp_id] [int] NOT NULL ,
45 [submitted_ind_id] [int] NOT NULL ,
46 [submitted_strand_code] [int] NULL ,
47 [allele_flag] [int] NULL ,
49 [submitted_rs] [int] NULL
53 CREATE TABLE [SubInd_ch5]
55 [chr] [varchar](3) NOT NULL ,
56 [batch_id] [int] NOT NULL ,
57 [subsnp_id] [int] NOT NULL ,
58 [submitted_ind_id] [int] NOT NULL ,
59 [submitted_strand_code] [int] NULL ,
60 [allele_flag] [int] NULL ,
62 [submitted_rs] [int] NULL
66 CREATE TABLE [SubInd_ch6]
68 [chr] [varchar](3) NOT NULL ,
69 [batch_id] [int] NOT NULL ,
70 [subsnp_id] [int] NOT NULL ,
71 [submitted_ind_id] [int] NOT NULL ,
72 [submitted_strand_code] [int] NULL ,
73 [allele_flag] [int] NULL ,
75 [submitted_rs] [int] NULL
79 CREATE TABLE [SubInd_ch7]
81 [chr] [varchar](3) NOT NULL ,
82 [batch_id] [int] NOT NULL ,
83 [subsnp_id] [int] NOT NULL ,
84 [submitted_ind_id] [int] NOT NULL ,
85 [submitted_strand_code] [int] NULL ,
86 [allele_flag] [int] NULL ,
88 [submitted_rs] [int] NULL
92 CREATE TABLE [dn_table_rowcount]
94 [tabname] [varchar](64) NOT NULL ,
95 [row_cnt] [int] NOT NULL ,
96 [build_id] [int] NOT NULL ,
97 [update_time] [datetime] NOT NULL ,
98 [rows_in_spaceused] [int] NULL ,
99 [reserved_KB_spaceused] [int] NULL ,
100 [data_KB_spaceused] [int] NULL ,
101 [index_size_KB_spaceused] [int] NULL ,
102 [unused_KB_spaceused] [int] NULL