-- Table: njkp

-- DROP TABLE njkp;

CREATE TABLE njkp
(
  kd_propinsi character(2) NOT NULL,
  kd_dati2 character(2) NOT NULL,
  thn_awal character(4) NOT NULL,
  thn_akhir character(4) NOT NULL,
  njop_min bigint NOT NULL,
  njop_max bigint,
  nilai_njkp 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 njkp_pkey PRIMARY KEY (kd_propinsi, kd_dati2, thn_awal, thn_akhir, njop_min),
  CONSTRAINT fk_njkp_users1 FOREIGN KEY (createdby)
      REFERENCES users (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION,
  CONSTRAINT fk_njkp_users2 FOREIGN KEY (updatedby)
      REFERENCES users (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE njkp
  OWNER TO postgres;