자율 프로젝트
테이블 (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