자율 프로젝트

테이블 (7)

ForumComment (공론장 댓글)

  • comment_id (PK) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → User.user_id — NOT NULL
  • topic_id (Key) — bigint — 외래 키 → Topic.topic_id — NOT NULL
  • stance (d) — enum('PRO','CON','NEUTRAL')
  • anonymous_id (Field) — varchar
  • content (Field3) — text
  • parent_id (Field4) — bigint
  • upvotes (Field5) — int
  • rebuttal_content (Field6) — int
  • report_count (Field7) — int
  • created_at (Field8) — datetime
  • is_realname_exposed (Field9) — boolean

Report (신고 상세)

  • report_id (PK) — bigint — 기본 키 — NOT NULL
  • comment_id (FK) — bigint
  • user_id (Field) — bigint
  • reason (Field2) — enum('ABUSE', 'SPAM', 'FAKE','OFFTOPIC','OTHER')
  • detail (Field3) — text
  • created_at (Field4) — datetime
  • comment_id (PK2) — bigint — 외래 키 → ForumComment.comment_id — NOT NULL
  • user_id (Key2) — 외래 키 → ForumComment.user_id — NOT NULL
  • topic_id (Key) — bigint — 외래 키 → ForumComment.topic_id — NOT NULL

Topic (토픽)

  • topic_id (Key) — bigint — 기본 키 — NOT NULL
  • category_id (Field) — bigint
  • title (Field2) — varchar
  • description (Field3) — text
  • trending_score (Field4) — float
  • created_at (Field5) — datetime
  • category_id (Key2) — bigint — 외래 키 → TopicCategory.category_id — NOT NULL

TopicCategory (주제)

  • category_id (Key) — bigint — 기본 키 — NOT NULL
  • parent_id (Field) — bigint(nullable)
  • name (Field2) — varchar
  • order_index (Field3) — int

TopicMetric (토픽 메트릭(토픽별 기사 갯수와 댓글 수 등을 취합))

  • topic_id (FK) — bigint
  • article_count (Field2) — int
  • comment_count (Field3) — int
  • view_count (Field) — int
  • last_updated (Field4) — datetime
  • category_id (Key) — bigint — 외래 키 → TopicCategory.category_id — NOT NULL

User (사용자)

  • user_id (Key) — 기본 키 — NOT NULL
  • google_id (Field) — varchar
  • email (Field2) — varchar
  • name (Field3) — varchar
  • nickname (Field4) — varchar
  • profile_image (Field5) — varchar
  • role (Field6) — enum(['USER', 'ADMIN')
  • created_at (Field7) — datetime
  • status (Field8) — enum('ACTIVE', 'SUSPENDED,'BANNED')

article (기사)

  • article_id (PK) — bigint — 기본 키 — NOT NULL
  • topic_id (FK) — bigint
  • title (Field2) — varchar
  • url (Field) — varchar
  • publisher (Field3) — varchar
  • published_at (Field4) — datetime
  • stance (Field5) — enum('PRO','CON','NEUTRAL')
  • confidence (Field6) — float
  • view_count (Field7) — int
  • embedding (Field9) — jsonb
  • topic_id (Key) — bigint — 외래 키 → Topic.topic_id — NOT NULL