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 (유저명)