queosk

Tables (8)

comment (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • content (Field) — varchar
  • review_id (Key2) — int — Foreign key → review.id — NOT NULL
  • restaurant_id (Key22) — int — Foreign key → restaurant.id — NOT NULL
  • created_at (Field2) — DATETIME
  • updated_at (Field3)

menu (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • restaurant_id (Key22) — int — Foreign key → restaurant.id — NOT NULL
  • name (Field) — varchar
  • image_url (Field5) — varchar
  • price (Field2) — int
  • status (Field4) — varchar
  • created_at (Field3) — DATETIME
  • updated_at (Field6) — DATETIME

order

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key4) — int — Foreign key → user.id — NOT NULL
  • table_id (Key5) — int — Foreign key → table.id — NOT NULL
  • restaurant_id (Key3) — int — Foreign key — NOT NULL
  • menu_id (Key2) — int — Foreign key → menu.id — NOT NULL
  • status (Field) — varchar
  • count (Field2) — int
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME

restaurant (Untitled)

  • id (Key2) — int — Primary key — NOT NULL
  • owner_id (Field13) — varchar
  • name (Field9) — varchar
  • password (Field11) — varchar
  • email (Field10) — varchar
  • phone (Field12) — varchar
  • restorant_phone (Field4) — varchar
  • category (Field8) — varchar
  • business_number (Field3) — varchar
  • manager_name (Field14) — varchar
  • business_start_date (Field15) — DATETIME
  • address (Field5) — varchar
  • latitude (Field6) — double
  • longitude (Field7) — double
  • rating_average (Field) — double
  • image_url (Field2) — varchar
  • operation_status (Field16) — varchar
  • max_waiting (Field17) — int
  • careate_at (Field18) — DATETIME
  • updated_at (Field19) — DATETIME

review (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • subject (Field) — varchar
  • content (Field2) — varchar
  • restaurant_id (Key2) — int — Foreign key — NOT NULL
  • rate (Field3) — double
  • user_id (Key3) — varchar — Foreign key → user.id — NOT NULL
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

settlement (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • date (Field) — DATETIME
  • order_id (Key2) — int — Foreign key → order.id — NOT NULL
  • restaurant_id (Key22) — int — Foreign key → restaurant.id — NOT NULL
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME
  • income (Field4) — int

table (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • status (Field) — varchar
  • restaurant_id (Key22) — int — Foreign key → restaurant.id — NOT NULL
  • created_at (Field2) — DATETIME
  • updated_time (Field3) — DATETIME

user (CopyOfCopyOfUntitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • nickname (Field2) — varchar
  • password (Field10) — varchar
  • phone (Field4) — varchar
  • login_api (Field11) — varchar
  • verified (Field3) — varchar
  • image_url (Field5) — varchar
  • created_at (Field6) — DATETIME
  • updated_at (Field7) — DATETIME