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