sinchonthon

Tables (8)

categories

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL

places

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tip_comments

  • id — BIGINT — Primary key — NOT NULL
  • tip_id — BIGINT — Foreign key → tips.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tip_reactions

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • tip_id — BIGINT — Foreign key → tips.id — NOT NULL
  • is_like — BOOLEAN — NOT NULL — TRUE: 좋아요, FALSE: 싫어요
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tip_scraps

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • tip_id — BIGINT — Foreign key → tips.id — NOT NULL
  • created_at — DATETIME — NOT NULL

tips

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL — 가격 정보도 본문에 작성
  • visited_at — DATE
  • valid_until — DATETIME — NOT NULL — 등록 시 created_at 기준 1년 후 저장
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_follows

  • follower_id — BIGINT — Foreign key → users.id — NOT NULL — 팔로우하는 사용자
  • following_id — BIGINT — Foreign key → users.id — NOT NULL — 팔로우 대상 사용자
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • trust_score — DECIMAL(5,2) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL