CREATE TABLE snp138 (
    bin INT NOT NULL,
    chrom TEXT NOT NULL,
    chromStart  INT NOT NULL,
    chromEnd    INT NOT NULL,
    name    TEXT NOT NULL,
    score   INT,
    strand  TEXT NOT NULL,
    refNCBI TEXT,
    refUCSC TEXT,
    observed TEXT,
    molType TEXT,
    class   TEXT,
    valid   TEXT,
    avHet   FLOAT,
    avHetSE FLOAT,
    func    TEXT,
    locType TEXT,
    weight  INT,
    exceptions  TEXT,
    submitterCount  INT,
    submitters  TEXT,
    alleleFreqCount INT,
    alleles     TEXT,
    alleleNs     TEXT,
    alleleFreqs  TEXT,
    bitfields TEXT
) ;

