참견도치

테이블 (10)

comment

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME

community_post

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • vote_type — ENUM('AGREE', 'DISAGREE')

conflict_analysis

  • id — BIGINT
  • conflict_id — BIGINT — NOT NULL
  • summary — TEXT
  • ai_comment — TEXT — EX
  • created_at — DATETIME

conflict_card

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • goal — VARCHAR(200)
  • created_at — DATETIME
  • updated_at — DATETIME

emotion_log

  • id — BIGINT
  • conflict_id — BIGINT — NOT NULL
  • emotion_type — ENUM('ANGER', 'SAD', 'HAPPY', 'NEUTRAL') — NOT NULL
  • intensity — INT
  • timestamp — DATETIME — NOT NULL

notice

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • admin_id — BIGINT — NOT NULL
  • created_at — DATETIME

rtc_session

  • id — BIGINT
  • conflict_id — BIGINT — NOT NULL
  • host_user_id — BIGINT — NOT NULL
  • session_code — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN
  • started_at — DATETIME
  • ended_at — DATETIME

session_participant

  • id — BIGINT
  • session_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — ENUM('USER', 'OBSERVER')
  • joined_at — DATETIME

session_summary

  • id — BIGINT
  • session_id — BIGINT — NOT NULL
  • summary_text — TEXT
  • final_comment — TEXT — EX

user

  • id — BIGINT
  • social_id — VARCHAR(100) — NOT NULL
  • provider — ENUM('KAKAO', 'GOOGLE') — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • role — ENUM('USER', 'ADMIN')
  • created_at — DATETIME
  • deleted — BOOLEAN