lj_update_status

CREATE SEQUENCE update_status_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 10
CACHE 1;

CREATE TABLE lj_update_status (
    update_status_id    bigint NOT NULL DEFAULT  nextval('update_status_seq'),
    nama            character varying(100),
    tanggal         character varying(14),
    status          character varying(256),
    jumlah_like     bigint,
    jumlah_share        bigint,
    jumlah_komentar     bigint,
    create_datetime     character varying(14),
    update_datetime     character varying(14),
    create_user_id      bigint,
    update_user_id      bigint,
    version         bigint,

    CONSTRAINT update_status_pk PRIMARY KEY (update_status_id)
) WITH (
    OIDS = false
)

CREATE UNIQUE INDEX idx_lj_update_status_01
  ON lj_update_status
  USING btree
  (nama, status);