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