cb_payment_order_cost

-- Table: cb_payment_order_cost

-- DROP TABLE cb_payment_order_cost;

CREATE TABLE cb_payment_order_cost
(
  payment_order_cost_id bigint NOT NULL DEFAULT nextval('cb_payment_order_cost_seq'::regclass),
  tenant_id bigint,
  payment_order_id bigint,
  line_no bigint,
  activity_gl_id bigint,
  ou_rc_id bigint,
  segment_id bigint,
  curr_code character varying(5),
  add_amount numeric,
  remark character varying(1024),
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT cb_payment_order_cost_pkey PRIMARY KEY (payment_order_cost_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cb_payment_order_cost
  OWNER TO sts;

-- Index: idx_cb_payment_order_02

-- DROP INDEX idx_cb_payment_order_02;

CREATE INDEX idx_cb_payment_order_02
  ON cb_payment_order_cost
  USING btree
  (tenant_id, payment_order_id, activity_gl_id);

-- Index: idx_cb_payment_order_cost_01

-- DROP INDEX idx_cb_payment_order_cost_01;

CREATE UNIQUE INDEX idx_cb_payment_order_cost_01
  ON cb_payment_order_cost
  USING btree
  (tenant_id, payment_order_id, line_no);