toyProject

Tables (6)

FESTIVAL (페스티벌)

  • fetsival_id (페스티벌ID) — BIGINT — Primary key — NOT NULL
  • name (페스티벌명) — VARCHAR(255)
  • start_date (시작날짜) — DATETIME(6)
  • end_date (종료날짜) — DATETIME(6)

ITEM (음식)

  • item_id (음식ID) — BIGINT — Primary key — NOT NULL
  • store_id (가게ID) — BIGINT — Foreign key → STORE.store_id — NOT NULL
  • name (이름) — VARCHAR(255)
  • price (가격) — BIGINT
  • image_file_name (사진명) — LONGTEXT
  • image_file_url (사진주소) — LONGTEXT

MEMBER (사용자)

  • member_id (사용자ID) — BIGINT — Primary key — NOT NULL
  • type (사용자유형) — VARCHAR(30)
  • name (사용자명) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • phone (휴대펀번호) — VARCHAR(255)

ORDER (주문)

  • order_id (주문ID) — BIGINT — Primary key — NOT NULL
  • member_id (사용자ID) — BIGINT — Foreign key → MEMBER.member_id — NOT NULL
  • store_id (가게ID) — BIGINT
  • request (요청사항) — VARCHAR(255)
  • status (주문상태) — VARCHAR(30)
  • payment (결제종류) — VARCHAR(30)
  • order_date (주문시간) — DATETIME(6)
  • pay_date (결제시간) — DATETIME(6)

ORDER_ITEM (주문_음식)

  • order_item_id (주문음식ID) — BIGINT — Primary key — NOT NULL
  • order_id (주문ID) — BIGINT — Foreign key → ORDER.order_id — NOT NULL
  • item_id (Key) — BIGINT — Foreign key → ITEM.item_id — NOT NULL
  • orderprice (주문가격) — BIGINT
  • count (음식수) — BIGINT

STORE (가게)

  • store_id (가게ID) — BIGINT — Primary key — NOT NULL
  • fetsival_id (페스티벌ID) — BIGINT — Foreign key → FESTIVAL.fetsival_id — NOT NULL
  • name (가게명) — VARCHAR(255)
  • phone (가게대표번호) — VARCHAR(255)