abirama62

trx_pos_custom

May 18th, 2020
259
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE SEQUENCE i_trx_pos_custom_seq
  2.   INCREMENT 1
  3.   MINVALUE 1
  4.   MAXVALUE 9223372036854775807
  5.   START 10
  6.   CACHE 1;
  7.  
  8. CREATE TABLE i_trx_pos_custom
  9. (
  10.   trx_pos_custom_id bigint NOT NULL DEFAULT nextval('i_trx_pos_custom_seq'),
  11.   tenant_id bigint NOT NULL,
  12.   trx_pos_id bigint NOT NULL,
  13.   process_no character varying(100) NOT NULL,
  14.   mekanik_id bigint NOT NULL,
  15.   ref_no text,
  16.   license_number text,
  17.   guest_name text,
  18.   phone text,
  19.   vehicle_km text,
  20.   vehicle_type text,
  21.   remark text,
  22.   flg_termin character varying(1),
  23.   due_date character varying(8),
  24.   price_level character varying(50),
  25.   version bigint,
  26.   create_datetime character varying(14),
  27.   create_user_id bigint,
  28.   update_datetime character varying(14),
  29.   update_user_id bigint,
  30.   CONSTRAINT i_trx_pos_custom_pkey PRIMARY KEY (trx_pos_custom_id)
  31. )
  32. WITH (
  33.   OIDS=FALSE
  34. );
  35.  
  36. CREATE UNIQUE INDEX idx_trx_pos_custom_01
  37.   ON i_trx_pos_custom
  38.   USING btree
  39.   (tenant_id, trx_pos_id, process_no);
RAW Paste Data