Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Table: cb_in_out_cashbank_cost
- -- DROP TABLE cb_in_out_cashbank_cost;
- CREATE TABLE cb_in_out_cashbank_cost
- (
- in_out_cashbank_cost_id bigint NOT NULL DEFAULT nextval('cb_in_out_cashbank_cost_seq'::regclass),
- tenant_id bigint,
- in_out_cashbank_id bigint,
- line_no bigint,
- activity_gl_id bigint,
- ou_rc_id bigint,
- segment_id bigint,
- curr_code character varying(5),
- cost_amount numeric,
- payment_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_in_out_cashbank_cost_pkey PRIMARY KEY (in_out_cashbank_cost_id)
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE cb_in_out_cashbank_cost
- OWNER TO sts;
- -- Index: idx_cb_in_out_cashbank_02
- -- DROP INDEX idx_cb_in_out_cashbank_02;
- CREATE INDEX idx_cb_in_out_cashbank_02
- ON cb_in_out_cashbank_cost
- USING btree
- (tenant_id, in_out_cashbank_id, activity_gl_id);
- -- Index: idx_cb_in_out_cashbank_cost_01
- -- DROP INDEX idx_cb_in_out_cashbank_cost_01;
- CREATE UNIQUE INDEX idx_cb_in_out_cashbank_cost_01
- ON cb_in_out_cashbank_cost
- USING btree
- (tenant_id, in_out_cashbank_id, line_no);
Add Comment
Please, Sign In to add comment