voucher promotion - 2021-10-14 04:52:33
Tables (5)
ms_crd_bal_dtl_list
- crd_seq — int8 — Primary key — NOT NULL — credit
- crd_id — varchar(36) — Primary key — NOT NULL — credit
- usr_acc_id — int8 — Primary key — NOT NULL — flowfy
- shp_no — varchar(30) — Primary key — NOT NULL — shipment
- pkg_seq — int4 — Primary key — NOT NULL — package
- crd_seq (crd_seq2) — int8 — Foreign key — NOT NULL — credit
- crd_id (crd_id2) — varchar(36) — Foreign key — NOT NULL — credit
- usr_acc_id (usr_acc_id2) — int8 — Foreign key — NOT NULL — flowfy
- crd_id (crd_id22) — varchar(36) — Foreign key — NOT NULL — credit
- usr_acc_id (usr_acc_id22) — int8 — Foreign key — NOT NULL — flowfy
- crd_cd (crd_cd2) — varchar(32) — Foreign key — NOT NULL — credit
- crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key — NOT NULL — credit
- rule_id (rule_id2) — varchar(30) — Foreign key — NOT NULL — rule
- crd_typ_cd — varchar — NOT NULL — credit
- crd_use_dt — varchar(8) — NOT NULL — credit
- crd_use_typ_cd — varchar(2) — NOT NULL — credit
- trk_no — varchar(30) — tracking
- chg_tk — varchar(100) — charge
- chg_pub_rate — numeric — ups
- chg_bal_amt — numeric — balance
- chg_amt — numeric — charge
- cap_pub_rate — numeric — invoice
- cap_bal_amt — numeric — balance
- cap_amt — numeric — capture
- curr_row — varchar(1) — NOT NULL — current
- inp_usr — int8 — Input
- inp_dt — timestamp — NOT NULL — Input
- upd_usr — int8 — Update
- upd_dt — timestamp — Update
- reg_inp_dt — timestamptz — NOT NULL — Region
- reg_upd_dt — timestamptz — Region
ms_crd_bal_list
- crd_seq — int8 — Primary key — NOT NULL — credit
- crd_id — varchar(36) — Primary key — NOT NULL — credit
- usr_acc_id — int8 — Primary key — NOT NULL — flowfy
- crd_id (crd_id2) — varchar(36) — Foreign key — NOT NULL — credit
- usr_acc_id (usr_acc_id2) — int8 — Foreign key — NOT NULL — flowfy
- crd_cd (crd_cd2) — varchar(32) — Foreign key — NOT NULL — credit
- crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key — NOT NULL — credit
- rule_id (rule_id2) — varchar(30) — Foreign key — NOT NULL — rule
- crd_typ_cd — varchar — NOT NULL — credit
- tot_crd_amt — numeric — NOT NULL — Total
- chg_used_bal_amt — numeric — used
- chg_bal_amt — numeric — current
- cap_used_bal_amt — numeric — used
- cap_bal_amt — numeric — current
- curr_row — varchar(1) — NOT NULL — current
- inp_usr — int8 — Input
- inp_dt — timestamp — NOT NULL — Input
- upd_usr — int8 — Update
- upd_dt — timestamp — Update
- reg_inp_dt — timestamptz — NOT NULL — Region
- reg_upd_dt — timestamptz — Region
- crd_per — numeric — credit
ms_crd_iss_list
- crd_id — varchar(36) — Primary key — NOT NULL — credit
- usr_acc_id — int8 — Primary key — NOT NULL — flowfy
- crd_cd (crd_cd2) — varchar(32) — Foreign key — NOT NULL — credit
- crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key — NOT NULL — credit
- rule_id (rule_id2) — varchar(30) — Foreign key — NOT NULL — rule
- crd_typ_cd — varchar(1) — NOT NULL — credit
- crd_cd — varchar(32) — NOT NULL — credit
- apply_crd_dt — varchar(8) — credit
- use_yn — varchar(1) — NOT NULL — use
- snd_email_dt — varchar(8) — send
- snd_email_yn — varchar(1) — NOT NULL — send
- inp_usr — int8 — Input
- inp_dt — timestamp — NOT NULL — Input
- upd_usr — int8 — Update
- upd_dt — timestamp — Update
- reg_inp_dt — timestamptz — NOT NULL — Region
- reg_upd_dt — timestamptz — Region
- range_min_dt — varchar(8) — Credit
- range_max_dt — varchar(8) — Credit
- red_exp_fm_dt — varchar(8) — redeem
- red_exp_to_dt — varchar(8) — redeem
ms_crd_mst
- crd_cd — varchar(32) — Primary key — NOT NULL — credit
- crd_typ_cd — varchar(1) — Primary key — NOT NULL — credit
- rule_id (rule_id2) — varchar(30) — Foreign key — NOT NULL — rule
- rule_id — varchar(30) — NOT NULL — rule
- apply_fm_dt — varchar(8) — credit
- apply_to_dt — varchar(8) — credit
- use_yn — varchar(1) — NOT NULL — use
- inp_usr — int8 — Input
- inp_dt — timestamp — NOT NULL — Input
- upd_usr — int8 — Update
- upd_dt — timestamp — Update
- reg_inp_dt — timestamptz — NOT NULL — Region
- reg_upd_dt — timestamptz — Region
- red_exp_day — int8 — Redeem
ms_rule_mst
- rule_id — varchar(30) — Primary key — NOT NULL — rule
- apply_typ_cd — varchar(2) — NOT NULL — apply
- cond_fm_amt — varchar(8) — condition
- cond_to_amt — varchar(8) — condition
- tot_crd_amt — numeric — total
- crd_per — numeric — credit
- desc_rmk — text — description
- use_yn — varchar(1) — NOT NULL — use
- inp_usr — int8 — Input
- inp_dt — timestamp — NOT NULL — Input
- upd_usr — int8 — Update
- upd_dt — timestamp — Update
- reg_inp_dt — timestamptz — NOT NULL — Region
- reg_upd_dt — timestamptz — Region
- cond_day — int8 — increase