-- Table: pad.t_wp_pengecualian

-- DROP TABLE pad.t_wp_pengecualian;

CREATE TABLE pad.t_wp_pengecualian
(
  id serial NOT NULL,
  npwpd character varying(15) NOT NULL,
  kd_usaha character varying(4) NOT NULL,
  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 t_wp_pengecualian_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE pad.t_wp_pengecualian
  OWNER TO postgres;

-- Table: pad.t_wp_pengecualian_detail

-- DROP TABLE pad.t_wp_pengecualian_detail;

CREATE TABLE pad.t_wp_pengecualian_detail
(
  id serial NOT NULL,
  id_wp_pengecualian integer NOT NULL,
  th_spt character varying(4) NOT NULL,
  masaspt character varying(6) NOT NULL,
  batas_lapor_bayar date NOT NULL,
  batas_lapor_spt date NOT NULL,
  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 t_wp_pengecualian_detail_pkey PRIMARY KEY (id),
  CONSTRAINT t_wp_pengecualian_detail_id_wp_pengecualian_fkey FOREIGN KEY (id_wp_pengecualian)
      REFERENCES pad.t_wp_pengecualian (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE
)
WITH (
  OIDS=FALSE
);
ALTER TABLE pad.t_wp_pengecualian_detail
  OWNER TO postgres;