LetsEatAll

Tables (12)

Untitled (franchise)

  • Key — bigint — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Key (category_id) — int — Foreign key → category.Key — NOT NULL

Untitled (image_file)

  • Key — bigint — Primary key — NOT NULL
  • Field2 (stored_name) — varchar(255)
  • Field (upload_name) — varchar(255)
  • Field (url) — varchar(255)
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (like_history)

  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (menu)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (price) — int
  • Field (score) — double
  • Field (info) — varchar(255)
  • Field (url) — varchar(255)
  • Key (restaurant_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (franchise_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (menu_image_file)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (stored_name) — varchar(255)
  • Field (url) — varchar(255)
  • Key (menu_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (preference)

  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (cate_id) — int — Foreign key → category.Key — NOT NULL
  • Field (score) — int

Untitled (restaurant)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (addr) — varchar(255)
  • Field (name) — varchar(255)
  • Field (score) — double
  • Key (category_id) — int — Foreign key → category.Key — NOT NULL
  • Key (franchise_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (content) — varchar
  • Field (score) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (like_cnt) — int
  • Field (unlike_cnt) — int
  • Key (menu_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (writer_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (birth_date) — datetime
  • Field (name) — varchar(255)
  • Field (password) — varchar(255)
  • Field (score) — int
  • Field (uid) — varchar(255) — unique

Untitled (user_roles)

  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (roles) — varchar(255)

Untitled (youtube)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (content) — varchar(255)
  • Field (url) — varchar(255)
  • Key (menu_id) — bigint — Foreign key → Untitled.Key — NOT NULL

category

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(255)