voucher promotion

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 → ms_crd_bal_list.crd_seq — NOT NULL — credit
  • crd_id (crd_id2) — varchar(36) — Foreign key → ms_crd_bal_list.crd_id — NOT NULL — credit
  • usr_acc_id (usr_acc_id2) — int8 — Foreign key → ms_crd_bal_list.usr_acc_id — NOT NULL — flowfy
  • crd_id (crd_id22) — varchar(36) — Foreign key → ms_crd_bal_list.crd_id — NOT NULL — credit
  • usr_acc_id (usr_acc_id22) — int8 — Foreign key → ms_crd_bal_list.usr_acc_id — NOT NULL — flowfy
  • crd_cd (crd_cd2) — varchar(32) — Foreign key → ms_crd_bal_list.crd_cd — NOT NULL — credit
  • crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key → ms_crd_bal_list.crd_typ_cd — NOT NULL — credit
  • rule_id (rule_id2) — varchar(30) — Foreign key → ms_crd_bal_list.rule_id — 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 → ms_crd_iss_list.crd_id — NOT NULL — credit
  • usr_acc_id (usr_acc_id2) — int8 — Foreign key → ms_crd_iss_list.usr_acc_id — NOT NULL — flowfy
  • crd_cd (crd_cd2) — varchar(32) — Foreign key → ms_crd_iss_list.crd_cd — NOT NULL — credit
  • crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key → ms_crd_iss_list.crd_typ_cd — NOT NULL — credit
  • rule_id (rule_id2) — varchar(30) — Foreign key → ms_crd_iss_list.rule_id — 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 → ms_crd_mst.crd_cd — NOT NULL — credit
  • crd_typ_cd (crd_typ_cd2) — varchar(1) — Foreign key → ms_crd_mst.crd_typ_cd — NOT NULL — credit
  • rule_id (rule_id2) — varchar(30) — Foreign key → ms_crd_mst.rule_id — 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 → ms_rule_mst.rule_id — 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