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