BackOfiice

Tables (6)

menu (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • store_id (Key2) — BIGINT — Foreign key → store.id — NOT NULL
  • menu_name (Field) — VARCHAR(50) — NOT NULL
  • price (Field2) — BIGINT — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • modified_at (Field4) — DATETIME — NOT NULL

order_menu (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • orders_id (Key2) — BIGINT — Foreign key → orders.id — NOT NULL
  • menu_id (Key3) — BIGINT — Foreign key → menu.id — NOT NULL
  • quantity (Field) — INT — NOT NULL

orders (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
  • store_id (Key3) — BIGINT — Foreign key → store.id — NOT NULL
  • status (Field) — ENUM — NOT NULL
  • total_price (Field2) — BIGINT — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • modified_at (Field4) — DATETIME — NOT NULL
  • delivery_at (Field5) — DATETIME

review (Untitled3)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • customer_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
  • store_id (Key3) — BIGINT — Foreign key → store.id — NOT NULL
  • rating (Field) — INT — NOT NULL
  • comment (Field2) — VARCHAR(255) — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • modified_at (Field4) — DATETIME — NOT NULL

store (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • owner_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
  • store_name (Field) — VARCHAR(255) — NOT NULL
  • address (Field2) — VARCHAR(255) — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL
  • modified_at (Field4) — DATETIME — NOT NULL

user (사용자)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255) — NOT NULL
  • password (Field2) — VARCHAR(255) — NOT NULL
  • username (Field3) — VARCHAR(255) — NOT NULL
  • points (Field7) — BIGINT
  • role (Field4) — ENUM — NOT NULL
  • created_at (Field5) — DATETIME — NOT NULL
  • modified_at (Field6) — DATETIME — NOT NULL