DeliveryApp

Tables (5)

Menu (메뉴)

  • id (Key) — big int auto increment — Primary key — NOT NULL
  • store_id (storeId) — big int auto increment — Foreign key → Store.id — NOT NULL
  • name — varchar(100) — NOT NULL
  • price — int — NOT NULL
  • is_deleted (isDeleted) — varchar — NOT NULL
  • created_at (createAt) — datetime — NOT NULL
  • modified_at (modifyAt) — datetime

Order (주문)

  • id (Key) — big int auto increment — Primary key — NOT NULL
  • user_id (userId) — big int auto increment — Foreign key → User.id — NOT NULL
  • menu_id (menuId) — big int auto increment — Foreign key → Menu.id — NOT NULL
  • order_status (orderStatus) — varchar — NOT NULL
  • created_at (createAt) — datetime — NOT NULL
  • modified_at (modifyAt) — datetime

Review (리뷰)

  • id (Key) — big int auto increment — Primary key — NOT NULL
  • order_id (orderId) — big int auto increment — Foreign key → Order.id — NOT NULL
  • star_point (starPoint) — int — NOT NULL
  • content — varchar(300) — NOT NULL
  • created_at (createAt) — datetime — NOT NULL
  • modified_at (modifyAt) — datetime

Store (가게)

  • id (Key) — big int auto increment — Primary key — NOT NULL
  • user_id (userId) — big int auto increment — Foreign key → User.id — NOT NULL
  • name — varchar(30) — NOT NULL
  • store_status (storeStatus) — varchar — NOT NULL
  • minimum_order_price (minimumOrderPrice) — int — NOT NULL
  • open_time (openTime) — time — NOT NULL
  • close_time (closeTime) — time — NOT NULL
  • created_at (createAt) — datetime — NOT NULL
  • modified_at (modifyAt) — datetime

User (사용자)

  • id (Key) — big int auto increment — Primary key — NOT NULL
  • email (emial) — varchar(50) — NOT NULL
  • password — varchar(20) — NOT NULL
  • authority — varchar — NOT NULL
  • user_withdraw (userWithdraw) — varchar — NOT NULL
  • created_at (createAt) — datetime — NOT NULL
  • modified_at (modifyAt) — datetime