ref.negara.sql

CREATE TABLE ref.negara
(
  negara_id character(2) NOT NULL,
  nama character varying(45) NOT NULL,
  luar_negeri numeric(1,0) NOT NULL,
  create_date timestamp(0) without time zone NOT NULL,
  last_update timestamp(0) without time zone NOT NULL,
  expired_date timestamp(0) without time zone,
  last_sync timestamp(0) without time zone NOT NULL,
  CONSTRAINT negara_pkey PRIMARY KEY (negara_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE ref.negara
  OWNER TO postgres;
GRANT ALL ON TABLE ref.negara TO postgres;