sinchonthon

Tables (7)

categories

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • slug — VARCHAR(30) — NOT NULL
  • icon_name — VARCHAR(50)
  • sort_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

places

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • created_by — BIGINT — Foreign key → users.id
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • phone — VARCHAR(30)
  • external_source — VARCHAR(20) — kakao, naver, user
  • external_place_id — VARCHAR(100)
  • status — VARCHAR(20) — 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
  • parent_comment_id — BIGINT — Foreign key → tip_comments.id
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — 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
  • reaction_type — VARCHAR(20) — NOT NULL — helpful, inaccurate
  • created_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
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • tip_type — VARCHAR(30) — NOT NULL — general, price, warning, discount, recommendation, job
  • price — INT
  • visited_at — DATE
  • status — VARCHAR(20) — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_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
  • school_name — VARCHAR(100)
  • is_school_verified — BOOLEAN — NOT NULL
  • profile_image_url — VARCHAR(1000)
  • trust_score — DECIMAL(5,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL