trx_pos_custom

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

CREATE TABLE i_trx_pos_custom
(
  trx_pos_custom_id bigint NOT NULL DEFAULT nextval('i_trx_pos_custom_seq'),
  tenant_id bigint NOT NULL,
  trx_pos_id bigint NOT NULL,
  process_no character varying(100) NOT NULL,
  mekanik_id bigint NOT NULL,
  ref_no text,
  license_number text,
  guest_name text,
  phone text,
  vehicle_km text,
  vehicle_type text,
  remark text,
  flg_termin character varying(1),
  due_date character varying(8),
  price_level character varying(50),
  version bigint,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT i_trx_pos_custom_pkey PRIMARY KEY (trx_pos_custom_id)
)
WITH (
  OIDS=FALSE
);

CREATE UNIQUE INDEX idx_trx_pos_custom_01
  ON i_trx_pos_custom
  USING btree
  (tenant_id, trx_pos_id, process_no);