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