coupon

Tables (13)

Brand (브랜드)

  • brand_id — Long — Primary key — NOT NULL
  • store_category_id — Long — Foreign key → StoreCategory.store_category_id — NOT NULL
  • 브랜드명 (name) — String
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Coupon (쿠폰)

  • coupon_id — Long — Primary key — NOT NULL
  • promotion_id — Long — Foreign key → promotion.promotion_id — NOT NULL
  • 할인 종류 (discount_type) — VARCHAR
  • 할인 금액 (discount_value) — Integer
  • 쿠폰 발행 최대 수량 (max_quantity) — Integer
  • 발행 시작 시간 (start_time) — TIMESTAMP
  • 발행 종료 시간 (end_time) — TIMESTAMP
  • 쿠폰 사용 시작 시간 (usage_start_time) — TIMESTAMP
  • 쿠폰 사용 종료 시간 (usage_end_time) — TIMESTAMP
  • 상태 (couponstatus) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Menu (메뉴)

  • menu_id — Long — Primary key — NOT NULL
  • store_id — Long — Foreign key → Store.store_id — NOT NULL
  • menu_category_id — Long — Foreign key → MenuCategory.menu_category_id — NOT NULL
  • 메뉴명 (name) — String
  • 가격 (price) — Long
  • 메뉴상태 (menuStatus) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

MenuCategory (메뉴카테고리)

  • menu_category_id — Long — Primary key — NOT NULL
  • store_category_id — Long — Foreign key → StoreCategory.store_category_id — NOT NULL
  • 카테고리명 (name) — String
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Order (주문)

  • order_id — Long — Primary key — NOT NULL
  • member_id — Long — Foreign key → member.member_id — NOT NULL
  • store_id — Long — Foreign key → Store.store_id — NOT NULL
  • coupon_issue_id — Long — Foreign key → coupon_issue.발급고유 — NOT NULL
  • 원가 (original_price) — Long
  • 할인금액 (discount_amount) — Long
  • 총합가격 (final_price) — Long
  • 배달주소 (delivery_address) — String
  • 주문시간 (order_time) — TIMESTAMP
  • 내용 (comment) — String
  • 주문상태 (order_status) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

OrderMenu (주문메뉴)

  • order_menu_id — Long — Primary key — NOT NULL
  • order_id — Long — Foreign key → Order.order_id — NOT NULL
  • menu_id (menu_id2) — Long — Foreign key → Menu.menu_id — NOT NULL
  • 개수 (quantity) — String
  • 단일가격 (price) — Long
  • 총합가격 (total_price) — Long
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Payment (결제)

  • payment_id — Long — Primary key — NOT NULL
  • order_id — Long — Foreign key → Order.order_id — NOT NULL
  • 결제수단 (payment_method) — ENUM
  • 결제금액 (amount) — Long
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Store (가게)

  • store_id — Long — Primary key — NOT NULL
  • brand_id — Long — Foreign key → Brand.brand_id — NOT NULL
  • 점주id (owner_id) — Long — Foreign key → member.member_id — NOT NULL
  • store_category_id — Long — Foreign key → StoreCategory.store_category_id — NOT NULL
  • 가게명 (name) — String
  • 가게번호 (store_phone_number) — String
  • 주소 (address) — String
  • 가게상태 (status) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

StoreCategory (가게카테고리)

  • store_category_id — Long — Primary key — NOT NULL
  • 카테고리명 (name) — String
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

coupon_Issue_log (발급이력)

  • coupon_issue_log_id — Long — Primary key — NOT NULL
  • member_pk (member_id) — Long
  • coupon_pk (coupon_id) — Long
  • 이벤트상태 (event_type) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

coupon_issue (쿠폰 발급)

  • 발급고유 (coupon_issue_id) — Long — Primary key — NOT NULL
  • coupon_id — Long — Foreign key → Coupon.coupon_id — NOT NULL
  • member_id (userId) — Long — Foreign key → member.member_id — NOT NULL
  • 발급시간 (issued_at) — TIMESTAMP
  • 쿠폰 발급 상태 (status) — ENUM
  • 생성일 (craeted_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

member (유저테이블)

  • member_id — Long — Primary key — NOT NULL
  • email — String
  • password — String
  • name — String
  • phone (phone_num) — String
  • 생성일 (createAt) — TIMESTAMP
  • 수정일 (updateAt) — TIMESTAMP
  • Field

promotion (이벤트)

  • promotion_id — Long — Primary key — NOT NULL
  • event_name (name) — String
  • 이벤트 시작 시간 (start_date) — TIMESTAMP
  • 이벤트 종료 시간 (end_date) — TIMESTAMP
  • 매일 쿠폰 발급 시작 시간 (예: 오후 1시) (daily_start_time) — TIME
  • 매일 쿠폰 발급 종료 시간 (예: 오후 2시) (daily_end_time) — TIME
  • 쿠폰 상태 (promotionStatus) — ENUM
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP