trp

Tables (4)

ReviewAttachedPhotos

  • id — int — Primary key — NOT NULL
  • review_id — varchar(36) — NOT NULL
  • attached_photo_id — varchar(36) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • index — (review_id)

ReviewPointIncreaseLogs

  • user_id — varchar(36) — Primary key — NOT NULL
  • point_increase — int — NOT NULL
  • review_id — varchar(36) — NOT NULL
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

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
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • index — (place_id)

Users

  • user_id — varchar(36) — Primary key — NOT NULL
  • point — int
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL