tru
Tables (5)
photo (사진)
- id (ID) — uuid — Primary key — NOT NULL
- review_id (리뷰 ID) — uuid — Foreign key → review.user_id — NOT NULL
- user_id (유저 ID) — uuid — Foreign key → user.id — NOT NULL
- is_deleted (삭제여부) — tinyint
- updated_at (수정일자) — datetime
- created_at (생성일자) — datetime
place (장소)
- id (ID) — uuid — Primary key — NOT NULL
- name (이름) — varchar
point_log (포인트 로그)
- id (ID) — uuid — Primary key — NOT NULL
- user_id (유저 ID) — uuid — Foreign key → user.id — NOT NULL
- id (리뷰 ID) — uuid — Foreign key → review.id — NOT NULL
- point (포인트) — int
- point_type (포인트 타입) — varchar
- created_at (생성일자) — datetime
review (리뷰)
- id (ID) — uuid — Primary key — NOT NULL
- user_id (유저ID) — uuid — Foreign key → user.id — NOT NULL
- place_id (장소ID) — uuid — Foreign key → place.id — NOT NULL
- content (내용) — varchar
- is_used (사용여부) — tinyint
- is_deleted (삭제여부) — tinyint
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
user (유저)
- id (ID) — uuid — Primary key — NOT NULL
- name (이름) — varchar