CREATE TABLE ingest (
    ocode            CHAR(8)       NOT NULL,  -- USGS "ocode" identifier
    title            VARCHAR(255)  NOT NULL,  -- fully formed title,
                                              -- mixed case
    mapname          VARCHAR(80)   NOT NULL,  -- map's city or region name,
                                              -- all uppercase
    state            CHAR(2)       NOT NULL,  -- two-character state code,
                                              -- uppercase
    n_b_coord        SMALLFLOAT    NOT NULL,  -- bounding coordinates
    s_b_coord        SMALLFLOAT    NOT NULL,
    e_b_coord        SMALLFLOAT    NOT NULL,
    w_b_coord        SMALLFLOAT    NOT NULL,
    year             INTEGER       NOT NULL,  -- year of last field check
    mbytesize_tif    SMALLFLOAT    NOT NULL,  -- size of TIFF image in
                                              -- megabytes
    bytesize_browse  INTEGER       NOT NULL,  -- size of browse image in bytes
    bytesize_thumb   INTEGER       NOT NULL,  -- size of thumbnail in bytes
    local_call_num   VARCHAR(255)  NOT NULL,  -- local call number
    PRIMARY KEY (ocode)
);