123
Tables (8)
Cart (장바구니)
- id (장바구니키) — BIGINT
- menu_id (메뉴키) — BIGINT
- totalprice (총가격) — BIGINT
- flag (장바구니상태) — INT (1~3)
- count (주문수량) — TEXT
Menu (메뉴)
- id (메뉴키) — BIGINT — Primary key — NOT NULL
- store_id (가게키) — BIGINT — Foreign key → Store.id — NOT NULL
- menuname (메뉴명) — VARCHAR(255)
- price (메뉴가격) — INT UNSIGNED NOT NULL
- description (메뉴설명) — TEXT
- status (메뉴상태) — ENUM('판매중', '품절')
- imagepath (메뉴이미지) — VARCHAR(255)
- created_at (메뉴등록일) — DATETIME
- modified_at (메뉴수정일) — DATETIME
- deleted_at (메뉴삭제일) — DATETIME NULL
Order (주문)
- id (주문키) — BIGINT — Primary key — NOT NULL
- user_id (사용자키) — BIGINT — Foreign key → User.id — NOT NULL
- store_id (가게키) — BIGINT — Foreign key → Store.id — NOT NULL
- status (주문상태) — ENUM('주문 접수', '조리 중', '배달 중', '완료')
- created_at (주문생성일) — DATETIME
- modified_at (주문수정일) — DATETIME
Owner (사장님)
- id (사장님키) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) UNIQUE
- password (비밀번호) — VARCHAR(255)
- nickname (닉네임) — VARCHAR(50), UNIQUE
- phonenumber (연락처) — VARCHAR(20), UNIQUE
- imagepath (이미지) — VARCHAR(255)
- created_at (가입일) — DATETIME
- modified_at (수정일) — DATETIME
Review (리뷰)
- id (리뷰키) — BIGINT — Primary key — NOT NULL
- store_id (가게키) — BIGINT — Foreign key → Store.id — NOT NULL
- order_id (주문키) — BIGINT — Foreign key → Order.id — NOT NULL
- star (별점) — INT (1~3)
- content (리뷰내용) — TEXT
- imagepath (리뷰이미지) — VARCHAR(255)
- created_at (리뷰등록일) — DATETIME
- modified_at (리뷰수정일) — DATETIME
Store (가게)
- id (가게키) — BIGINT — Primary key — NOT NULL
- owner_id (사장님키) — BIGINT — Foreign key → Owner.id — NOT NULL
- storename (가게명) — VARCHAR(255)
- storenumber (가게번호) — VARCHAR(20), UNIQUE
- opentime (오픈시간) — TIME
- closetime (마감시간) — TIME
- status (운영상태) — ENUM('운영중', '폐업')
- imagepath (가게이미지) — VARCHAR(255)
- minprice (최소주문금액) — INT UNSIGNED NOT NULL
- created_at (가게등록일) — DATETIME
- modified_at (가게수정일) — DATETIME
Token (토큰)
- id (토큰키) — BIGINT — Primary key — NOT NULL
- user_id (해당 토큰을 소유한 사용자 ID) — BIGINT — Foreign key → User.id — NOT NULL
- refreshtoken (refresh Token) — VARCHAR(512)
- expirydate (refreshtoken의 만료시간) — DATETIME
- created_at (토큰생성시간) — DATETIME
- modified_at (토큰갱신시간) — DATETIME
User (유저)
- id (사용자키) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(255) UNIQUE
- password (비밀번호) — VARCHAR(255)
- nickname (닉네임) — VARCHAR(50), UNIQUE
- address (주소) — VARCHAR(255)
- role (권한) — ENUM('USER', 'OWNER')
- phonenumber (연락처) — VARCHAR(20), UNIQUE
- imagepath (유저이미지) — VARCHAR(255)
- created_at (가입일) — DATETIME
- modified_at (수정일) — DATETIME