coupon
Tables (3)
coupon
- seq — INT — Primary key — NOT NULL
- name — VARCHAR
- prmo — INT
- valid_day — INT
- min_pay_price — INT
- max_disc_price — INT
- able_chk — CHAR
- disc_type — VARCHAR
- comt — VARCHAR
- remark — VARCHAR
- reg_date — DATETIME
- reg_id — VARCHAR
- up_date — DATETIME
- up_id — VARCHAR
cust
- id — INT — Primary key — NOT NULL
cust_coupons
- seq — INT — Primary key — NOT NULL
- coupon_seq — INT — Foreign key → coupon.seq — NOT NULL
- cust_id — INT — Foreign key → cust.id — NOT NULL
- issue_date — DATE
- exp_date — DATE
- coupon_state — VARCHAR
- reg_date — DATE
- reg_id — VARCHAR
- up_date — DATE
- up_id — VARCHAR