cb_in_out_cashbank_payment

-- Table: cb_in_out_cashbank_payment

-- DROP TABLE cb_in_out_cashbank_payment;

CREATE TABLE cb_in_out_cashbank_payment
(
  in_out_cashbank_payment_id bigint NOT NULL DEFAULT nextval('cb_in_out_cashbank_payment_seq'::regclass),
  tenant_id bigint,
  in_out_cashbank_id bigint,
  cashbank_id bigint,
  mode_payment character varying(10),
  bank_payment character varying(20),
  no_payment character varying(50),
  date_payment character varying(8),
  curr_code character varying(5),
  cashbank_amount numeric,
  payment_amount numeric,
  version bigint NOT NULL,
  create_datetime character varying(14),
  create_user_id bigint,
  update_datetime character varying(14),
  update_user_id bigint,
  CONSTRAINT cb_in_out_cashbank_payment_pkey PRIMARY KEY (in_out_cashbank_payment_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cb_in_out_cashbank_payment
  OWNER TO sts;

-- Index: idx_cb_in_out_cashbank_payment_01

-- DROP INDEX idx_cb_in_out_cashbank_payment_01;

CREATE UNIQUE INDEX idx_cb_in_out_cashbank_payment_01
  ON cb_in_out_cashbank_payment
  USING btree
  (tenant_id, in_out_cashbank_id, cashbank_id);