-- Table: tarif_baru

-- DROP TABLE tarif_baru;

CREATE TABLE tarif_baru
(
  kd_propinsi character(2) NOT NULL,
  kd_dati2 character(2) NOT NULL,
  thn_awal character(4) NOT NULL,
  thn_akhir character(4) NOT NULL,
  jns_tarif character(1) NOT NULL,
  njop_min bigint NOT NULL,
  njop_max bigint,
  nilai_tarif real,
  createdby integer NOT NULL DEFAULT (-1),
  createdtime timestamp without time zone NOT NULL DEFAULT now(),
  updatedby integer NOT NULL DEFAULT (-1),
  updatedtime timestamp without time zone NOT NULL DEFAULT now(),
  CONSTRAINT tarif_baru_pkey PRIMARY KEY (kd_propinsi, kd_dati2, thn_awal, thn_akhir, jns_tarif, njop_min),
  CONSTRAINT fk_tarif_baru_users1 FOREIGN KEY (createdby)
      REFERENCES users (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION,
  CONSTRAINT fk_tarif_baru_users2 FOREIGN KEY (updatedby)
      REFERENCES users (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE tarif_baru
  OWNER TO postgres;