oneDay
Tables (7)
like (Untitled3)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (shop_id) — Foreign key → shop.Key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Field (create_time)
- Field2 (update_time)
nail (Untitled2)
- Key (id) — Primary key — NOT NULL
- Field (image)
- Field2 (description)
- Field3 (price)
- Field4 (like_count)
- Field5 (review_count)
- Field (rank_count)
- Key (shop_id) — Foreign key → shop.Key — NOT NULL
- Field (create_time)
- Field (update_time)
operationTime (Untitled7)
- Key (id) — Primary key — NOT NULL
- Field (time)
- Field2 (reservation_check)
- Key (shop_id) — Foreign key → shop.Key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Field (create_time)
- Field2 (update_time)
rank (Untitled4)
- Key (id) — Primary key — NOT NULL
- Key (shop_id) — Foreign key → shop.Key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Field (create_time)
- Field2 (update_time)
review (Untitled5)
- Key (id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Key (shop_id) — Foreign key → shop.Key — NOT NULL
- Field (content)
- Field (create_time)
- Field2 (update_time)
shop (Untitled)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field2 (name)
- Field3 (location)
- Field4 (phone_num)
- Field5 (operating_time)
- Field (create_time) — datetime
- Field (update_time)
user (Untitled6)
- Key (id) — Primary key — NOT NULL