point_api_db
Tables (5)
Location (장소)
- idx (기본키) — uuid — Primary key — NOT NULL
- name (장소명)
Photo (사진)
- idx (기본키) — uuid — Primary key — NOT NULL
- review_id — Foreign key → Review.idx — NOT NULL
Point (포인트)
- idx (기본키) — int — Primary key — NOT NULL
- user_id — Foreign key → User.idx — NOT NULL
- review_id — uuid — Foreign key → Review.idx — NOT NULL
- deleted_at (삭제일)
Review (리뷰)
- idx (기본키) — uuid — Primary key — NOT NULL
- user_id — Foreign key → User.idx — NOT NULL
- location_id — Foreign key → Location.idx — NOT NULL
- content (내용)
- first (첫번째 여부)
- created_at (생성일)
- updated_at (수정일)
- deleted_at (삭제일)
User (유저)
- idx (기본키) — uuid — Primary key — NOT NULL
- name (유저명)