1 CREATE TABLE [SubInd_ch1] (
2 [chr] [varchar] (3) NOT NULL ,
3 [batch_id] [int] NOT NULL ,
4 [subsnp_id] [int] NOT NULL ,
5 [submitted_ind_id] [int] NOT NULL ,
6 [submitted_strand_code] [int] NULL ,
7 [allele_flag] [int] NULL ,
9 [submitted_rs] [int] NULL
14 CREATE TABLE [SubInd_ch2] (
15 [chr] [varchar] (3) NOT NULL ,
16 [batch_id] [int] NOT NULL ,
17 [subsnp_id] [int] NOT NULL ,
18 [submitted_ind_id] [int] NOT NULL ,
19 [submitted_strand_code] [int] NULL ,
20 [allele_flag] [int] NULL ,
22 [submitted_rs] [int] NULL
27 CREATE TABLE [SubInd_ch3] (
28 [chr] [varchar] (3) NOT NULL ,
29 [batch_id] [int] NOT NULL ,
30 [subsnp_id] [int] NOT NULL ,
31 [submitted_ind_id] [int] NOT NULL ,
32 [submitted_strand_code] [int] NULL ,
33 [allele_flag] [int] NULL ,
35 [submitted_rs] [int] NULL
40 CREATE TABLE [SubInd_ch4] (
41 [chr] [varchar] (3) NOT NULL ,
42 [batch_id] [int] NOT NULL ,
43 [subsnp_id] [int] NOT NULL ,
44 [submitted_ind_id] [int] NOT NULL ,
45 [submitted_strand_code] [int] NULL ,
46 [allele_flag] [int] NULL ,
48 [submitted_rs] [int] NULL
53 CREATE TABLE [SubInd_ch5] (
54 [chr] [varchar] (3) NOT NULL ,
55 [batch_id] [int] NOT NULL ,
56 [subsnp_id] [int] NOT NULL ,
57 [submitted_ind_id] [int] NOT NULL ,
58 [submitted_strand_code] [int] NULL ,
59 [allele_flag] [int] NULL ,
61 [submitted_rs] [int] NULL
66 CREATE TABLE [SubInd_ch6] (
67 [chr] [varchar] (3) NOT NULL ,
68 [batch_id] [int] NOT NULL ,
69 [subsnp_id] [int] NOT NULL ,
70 [submitted_ind_id] [int] NOT NULL ,
71 [submitted_strand_code] [int] NULL ,
72 [allele_flag] [int] NULL ,
74 [submitted_rs] [int] NULL
79 CREATE TABLE [SubInd_ch7] (
80 [chr] [varchar] (3) NOT NULL ,
81 [batch_id] [int] NOT NULL ,
82 [subsnp_id] [int] NOT NULL ,
83 [submitted_ind_id] [int] NOT NULL ,
84 [submitted_strand_code] [int] NULL ,
85 [allele_flag] [int] NULL ,
87 [submitted_rs] [int] NULL
92 CREATE TABLE [dn_table_rowcount] (
93 [tabname] [varchar] (64) NOT NULL ,
94 [row_cnt] [int] NOT NULL ,
95 [build_id] [int] NOT NULL ,
96 [update_time] [datetime] NOT NULL ,
97 [rows_in_spaceused] [int] NULL ,
98 [reserved_KB_spaceused] [int] NULL ,
99 [data_KB_spaceused] [int] NULL ,
100 [index_size_KB_spaceused] [int] NULL ,
101 [unused_KB_spaceused] [int] NULL