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