쿠폰/ 마일리지 관리

테이블 (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