DROP TABLE IF EXISTS "answer"."lhr";

CREATE SEQUENCE IF NOT EXISTS answer.lhr_id_seq;

-- Table Definition
CREATE TABLE "answer"."lhr" (
    "id" int8 NOT NULL DEFAULT nextval('answer.lhr_id_seq'::regclass),
    "wp_id" int8 NOT NULL,
    "date" date,
    "pelanggaran_kendaraan_masuk" int8,
    "pelanggaran_peringatan" int8,
    "tilang_uppkb_lain" int8,
    "tilang_kepolisian" int8,
    "tilang_dokumen" int8,
    "tilang_teknis" int8,
    "tilang_tata_cara" int8,
    "tilang_penurunan_muatan" int8,
    "tilang_transfer_muatan" int8,
    "tilang_penandaan" int8,
    "tilang_normalisasi" int8,
    "tilang_p21" int8,
    "jumlah_penindakan" int8,
    "keterangan" text,
    "created_at" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp,
    PRIMARY KEY ("id")
);
