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)