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)