-- Type: marketing_test

-- DROP TYPE marketing_test;

CREATE TYPE marketing_test AS
   (tableoid oid,
    cmax cid,
    xmax xid,
    cmin cid,
    xmin xid,
    ctid tid,
    state character varying,
    dob character varying,
    mdmaud character varying,
    "domain" character varying,
    age character varying,
    homeownr character varying,
    numchld character varying,
    income character varying,
    gender character varying,
    wealth1 character varying,
    hit character varying,
    mbgarden character varying,
    mbbooks character varying,
    mbcolect character varying,
    magfaml character varying,
    magmale character varying,
    pubgardn character varying,
    pubhlth character varying,
    pubdoity character varying,
    pubnewfn character varying,
    pubphoto character varying,
    malemili character varying,
    malevet character varying,
    vietvets character varying,
    wwiivets character varying,
    wealth2 character varying,
    veterans character varying,
    ic1 character varying,
    ic2 character varying,
    ic3 character varying,
    ic4 character varying,
    ic5 character varying,
    ic6 character varying,
    ic7 character varying,
    ic8 character varying,
    ic9 character varying,
    ic10 character varying,
    ic11 character varying,
    ic12 character varying,
    ic13 character varying,
    ic14 character varying,
    ic15 character varying,
    ic16 character varying,
    ic17 character varying,
    ic18 character varying,
    ic19 character varying,
    ic20 character varying,
    ic21 character varying,
    ic22 character varying,
    ic23 character varying,
    hhas1 character varying,
    hhas2 character varying,
    hhas3 character varying,
    hhas4 character varying,
    mc1 character varying,
    mc2 character varying,
    mc3 character varying,
    pec1 character varying,
    pec2 character varying,
    tpe10 character varying,
    tpe11 character varying,
    tpe12 character varying,
    tpe13 character varying,
    lfc1 character varying,
    lfc2 character varying,
    lfc3 character varying,
    lfc4 character varying,
    lfc5 character varying,
    lfc6 character varying,
    lfc7 character varying,
    lfc8 character varying,
    lfc9 character varying,
    lfc10 character varying,
    occ1 character varying,
    occ2 character varying,
    occ3 character varying,
    occ4 character varying,
    occ5 character varying,
    occ6 character varying,
    occ7 character varying,
    occ8 character varying,
    occ9 character varying,
    occ10 character varying,
    occ11 character varying,
    occ12 character varying,
    occ13 character varying,
    eic1 character varying,
    eic2 character varying,
    eic3 character varying,
    eic4 character varying,
    eic5 character varying,
    eic6 character varying,
    eic7 character varying,
    eic8 character varying,
    eic9 character varying,
    eic10 character varying,
    eic11 character varying,
    eic12 character varying,
    eic13 character varying,
    eic14 character varying,
    eic15 character varying,
    eic16 character varying,
    oedc1 character varying,
    oedc2 character varying,
    oedc3 character varying,
    oedc4 character varying,
    oedc5 character varying,
    oedc6 character varying,
    oedc7 character varying,
    ec1 character varying,
    ec3 character varying,
    ec4 character varying,
    ec5 character varying,
    ec6 character varying,
    ec7 character varying,
    ec8 character varying,
    sec1 character varying,
    sec2 character varying,
    sec3 character varying,
    sec4 character varying,
    sec5 character varying,
    afc1 character varying,
    afc2 character varying,
    afc4 character varying,
    afc5 character varying,
    afc6 character varying,
    vc1 character varying,
    vc2 character varying,
    vc3 character varying,
    vc4 character varying,
    ramnt_6 character varying,
    ramnt_7 character varying,
    ramnt_8 character varying,
    ramnt_9 character varying,
    ramnt_10 character varying,
    ramnt_11 character varying,
    ramnt_12 character varying,
    ramnt_13 character varying,
    ramnt_14 character varying,
    ramnt_15 character varying,
    ramnt_16 character varying,
    ramnt_17 character varying,
    ramnt_18 character varying,
    ramnt_19 character varying,
    ramnt_20 character varying,
    ramnt_21 character varying,
    ramnt_22 character varying,
    ramnt_23 character varying,
    ramnt_24 character varying,
    ramntall character varying,
    ngiftall character varying,
    cardgift character varying,
    minramnt character varying,
    maxramnt character varying,
    lastgift character varying,
    avggift character varying,
    controln character varying,
    hphone_d character varying,
    rfa_2f character varying,
    rfa_2a character varying,
    cluster2 character varying,
    geocode2 character varying);
ALTER TYPE marketing_test OWNER TO sa;