zz

Tables (4)

places

  • place_id — varchar(36) — Primary key — NOT NULL
  • name — text — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • INDEX — `place_id`

reviewattachedphotos

  • attached_photo_id — varchar(36) — Primary key — NOT NULL
  • review_id — varchar(36) — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • INDEX — `review_id`

reviewpointincreaselogs

  • id — int — Primary key — NOT NULL
  • review_id — varchar(36) — NOT NULL
  • user_id — varchar(36) — NOT NULL
  • point_increase — int — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • INDEX — `user_id`

reviews

  • review_id — varchar(36) — Primary key — NOT NULL
  • content — text — NOT NULL
  • user_id — varchar(36) — NOT NULL
  • place_id — varchar(36) — NOT NULL
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • INDEX — `place_id`