CONTOH TABLE UNIQUE INDEX

-- Pencatatan Journal dari Transaksi Module2 yang lain
CREATE SEQUENCE gl_journal_trx_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 10
  CACHE 1;

/*
 * journal type : lihat di data combo JOURNALTYPE
 * journal type : dibuat berdasarkan jenis doc_type_id ( dari table m_document_jurnal ) contoh : STOCK.PURCH, AP.CLAIM, dll
 * doc_type_id : transaksi ERP yang akan dijurnal
 * doc_id : receive goods id, purch invoice id, pos id, dll
 * untuk pos_id nilai bisa -99, maka doc_no diperlukan supaya data tidak duplikat
 * status_doc :
 * 1. DRAFT : saat submit dan saat input jv manual
 * 2. RELEASE : sudah dilakukan perhitungan rate
 * 3. FINAL : sudah dilakukan posting ( proses bulanan G/L )
 *
 * flg_fix : Y artinya jurnal tersbut tidak akan dihapus
 *
 */
CREATE TABLE gl_journal_trx
(
  journal_trx_id bigint NOT NULL DEFAULT nextval('gl_journal_trx_seq'),
  tenant_id bigint,
  journal_type character varying(20),
  doc_type_id bigint,
  doc_id bigint,
  doc_no character varying(30),
  doc_date character varying(8),
  ou_id bigint,
  sub_ou_id bigint,
  partner_id bigint,
  cashbank_id bigint,
  warehouse_id bigint,
  ext_doc_no character varying(30),
  ext_doc_date character varying(8),
  ref_doc_type_id bigint,
  ref_id bigint,
  ref_doc_no character varying(30),
  ref_doc_date character varying(8),
  due_date character varying(8),
  curr_code character varying(5),
  remark character varying(1024),
  status_doc character varying(1),
  workflow_status character varying(50),
  flg_fix character varying(1) DEFAULT 'Y',
  "version" bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT gl_journal_trx_pkey PRIMARY KEY (journal_trx_id)
)
WITH (
  OIDS=FALSE
);

CREATE UNIQUE INDEX idx_gl_journal_trx_01
  ON gl_journal_trx
  USING btree
 (tenant_id, journal_type, doc_type_id, doc_id, doc_no, ou_id, sub_ou_id);

CREATE INDEX idx_gl_journal_trx_02
  ON gl_journal_trx
  USING btree
  (tenant_id, doc_type_id, doc_no, doc_date, ou_id);