CREATE TABLE twomass_scn (
    scan_key integer,
    hemis character(1),
    date date,
    scan smallint,
    tile integer,
    ra double precision,
    decl double precision,
    glon real,
    glat real,
    ra_1 double precision,
    dec_1 double precision,
    ra_2 double precision,
    dec_2 double precision,
    ra_3 double precision,
    dec_3 double precision,
    ra_4 double precision,
    dec_4 double precision,
    sd character(1),
    qual smallint,
    hgl smallint,
    cld smallint,
    xph smallint,
    anom smallint,
    ut double precision,
    jdate double precision,
    airm real,
    zd real,
    ha double precision,
    rh smallint,
    air_temp real,
    tel_temp real,
    focus smallint,
    hry smallint,
    c_strat smallint,
    j_zp_ap real,
    h_zp_ap real,
    k_zp_ap real,
    h_zperr_ap real,
    k_zperr_ap real,
    j_n_snr10 integer,
    h_n_snr10 integer,
    k_n_snr10 integer,
    n_ext integer,
    j_shape_avg real,
    h_shape_avg real,
    k_shape_avg real,
    j_shape_rms real,
    h_shape_rms real,
    k_shape_rms real,
    j_2mrat real,
    h_2mrat real,
    k_2mrat real,
    j_psp real,
    h_psp real,
    k_psp real,
    j_pts_noise real,
    h_pts_noise real,
    k_pts_noise real,
    j_msnr10 real,
    h_msnr10 real,
    k_msnr10 real,
    rel0 smallint,
    rel1 smallint,
    rel2 smallint
) WITHOUT OIDS;