postico_polling_places_test

CREATE TABLE test (
    id SERIAL PRIMARY KEY,
    "StateCo" character varying,
    "StateAb" character varying,
    "DivName" character varying,
    "DivId" character varying,
    "DivCo" character varying,
    "PPName" character varying,
    "Status" character varying,
    "PremisesName" character varying,
    "Address1" character varying,
    "Address2" character varying,
    "Address3" character varying,
    "Locality" character varying,
    "AddrStateAb" character varying,
    "Postcode" character varying,
    "PPId" character varying,
    "AdvPremisesName" character varying,
    "AdvAddress" character varying,
    "AdvLocality" character varying,
    "AdvBoothLocation" character varying,
    "AdvGateAccess" character varying,
    "EntrancesDesc" character varying,
    "Lat" character varying,
    "Long" character varying,
    "CCD" character varying,
    "WheelchairAccess" character varying,
    "OrdVoteEst" character varying,
    "DecVoteEst" character varying,
    "NoOrdIssuingOff" character varying,
    "NoOfDecIssuingOff" character varying
);

-- Indices -------------------------------------------------------

CREATE UNIQUE INDEX test_pkey ON test(id int4_ops);