쿠폰/ 마일리지 관리
테이블 (6)
branch_coupon_print (Untitled)
- coupon_print_code (Key) — varchar(20) — 기본 키 — NOT NULL
- coupon_print_code (Field) — varchar(20)
- member_id (Field2) — varchar(20)
- branch_code (Field3) — varchar(20)
- member_id (Field4) — varchar(20)
- coupon_code (Field5) — varchar(20)
- coupon_name (Field6) — CHAR(3)
- coupon_price (Field7) — INT
- coupon-issue-date (Field8) — DATE
- coupon-expire-date (Field9) — DATE
- coupon-state (Field10) — varchar(20)
- cooupon_register_time (Field11) — DATETIME
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
- branch_code (Key3) — VARCHAR(20) — 외래 키 → branch_management.branch_code — NOT NULL
- coupon_code (Key4) — VARCHAR(20) — 외래 키 → event_coupon_kind.coupon_code — NOT NULL
branch_management
- branch_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- branch_name — VARCHAR(20)
- branch_addr — VARCHAR(20)
- branch_phone — VARCHAR(20)
- branch_representative — VARCHAR(20)
- branch_start_date — DATE
- branch_end_date — DATE
- Penalty_payment_standards (Field) — VARCHAR(20)
- branch_image — VARCHAR(20)
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
event_coupon_kind
- coupon_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- coupon_name — VARCHAR(20)
- coupon_price — INT
- coupon_due_date — VARCHAR(20)
- coupon_kind_register_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
member
- member_id (Key) — varchar(50) — 기본 키 — NOT NULL
- mem_level_code — varchar(50)
- mem_position — varchar(50)
- member_pw — varchar(50)
- member_email — varchar(50)
- member_name — varchar(50)
- member_birth — DATE
- member_gender — varchar(50)
- member_phone — varchar(50)
- member_addr — varchar(50)
- member_regdate — DATE
- final_mileage — INT
- accumulated_payment_amount — INT
- memberState — varchar(50)
review_mileage_criteria
- mileage_criteria_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- mileage_kind — VARCHAR(20)
- mileage_amount — INT
- mileage_criteria_register_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL
roompay_mileage_rate
- roompay_mileage_rate_code (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- member_id — VARCHAR(20)
- mileage_grade_name — VARCHAR(20)
- payment_criteria_mileage_percent — VARCHAR(20)
- payment_criteria_upgrade — INT
- mileage_rate_register_date — DATE
- member_id (Key2) — varchar(50) — 외래 키 → member.member_id — NOT NULL