postcodes_schema.sql

CREATE TABLE IF NOT EXISTS postcodes_tbl (
    pcd VARCHAR,
    pcd2 VARCHAR,
    pcds VARCHAR,
    dointr INTEGER,
    doterm INTEGER,
    oscty VARCHAR,
    ced VARCHAR,
    oslaua VARCHAR,
    osward VARCHAR,
    parish VARCHAR,
    usertype INTEGER,
    oseast1m INTEGER,
    osnrth1m INTEGER,
    osgrdind INTEGER,
    oshlthau VARCHAR,
    nhser VARCHAR,
    ctry VARCHAR,
    rgn VARCHAR,
    streg VARCHAR,
    pcon VARCHAR,
    eer VARCHAR,
    teclec VARCHAR,
    ttwa VARCHAR,
    pct VARCHAR,
    itl VARCHAR,
    statsward VARCHAR,
    oa01 VARCHAR,
    casward VARCHAR,
    npark VARCHAR,
    lsoa01 VARCHAR,
    msoa01 VARCHAR,
    ur01ind VARCHAR,
    oac01 VARCHAR,
    oa11 VARCHAR,
    lsoa11 VARCHAR,
    msoa11 VARCHAR,
    wz11 VARCHAR,
    sicbl VARCHAR,
    bua11 VARCHAR,
    buasd11 VARCHAR,
    ru11ind VARCHAR,
    oac11 VARCHAR,
    lat DOUBLE,
    long DOUBLE,
    lep1 VARCHAR,
    lep2 VARCHAR,
    pfa VARCHAR,
    imd INTEGER,
    calncv VARCHAR,
    icb VARCHAR,
    oa21 VARCHAR,
    lsoa21 VARCHAR,
    msoa21 VARCHAR,
    filename VARCHAR,
);