newssion
Tables (18)
badges (뱃지)
- role (Key) — ENUM — Primary key — NOT NULL
- icon (Field) — VARCHAR
- title (Field2) — VARCHAR
board_likes (게시판 좋아요)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- board_id (Field2) — INT
board_reports (게시글 신고)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- board_id (Field2) — INT
boards (게시판)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — TEXT
- category_id (Field3) — INT
- create_at (Field4) — DATETIME
- user_id (Field5) — INT
- image (Field6) — VARCHAR
- view (Field7) — INT
- news_id (Field8) — INT
- is_reported (Field9) — BOOLEAN
categories (카테고리)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
comment_reports (댓글 신고)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- comment_id (Field2) — INT
comments (댓글)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- board_id (Field2) — INT
- is_reported (Field3) — BOOLEAN
follow (팔로우)
- id (Key) — INT — Primary key — NOT NULL
- following_id (Field) — INT
- follwer_id (Field2) — INT
gpt_news (ChatGPT 요약 뉴스)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — TEXT
- created_at (Field4) — DATETIME
naver_news (네이버 뉴스)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR
- description (Field2) — TEXT
- link (Field3) — VARCHAR
- created_at (Field4) — DATETIME
news (뉴스)
- id (PK) — INT — Primary key — NOT NULL
- user_id (FK) — INT — Foreign key → users.id — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — TEXT
- view (Field5) — INT
- image (Field3) — VARCHAR
- create_at (Field4) — DATETIME
- category_id (Field6) — INT
news_likes (뉴스 좋아요)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- news_id (Field2) — INT
notice (알림)
- id (Key) — INT — Primary key — NOT NULL
- send_id (Field) — INT
- receive_id (Field2) — INT
- content (Field3) — VARCHAR
- create_at (Field4) — DATETIME
- is_read (Field5) — BOOLEAN
- notice_category_id (Field6) — INT
poll_votes (투표 선택 기록)
- id (Key) — Primary key — NOT NULL
- voted_at (Field)
- user_id (Field3) — INT
- option_id (Key2) — INT — Foreign key → polls_options.id — NOT NULL
polls (투표)
- id (Key) — Primary key — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — TEXT
- created_at (Field3) — DATETIME
- expired_at (Field4) — DATETIME
- user_id (Field5) — INT
polls_options (투표 선택)
- id (Key) — Primary key — NOT NULL
- polls_id (Key2) — INT — Foreign key → polls.id — NOT NULL
- content (Field) — VARCHAR
- count (Field2) — INT
scraps (스크랩)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- news_id (Field2) — INT
users (유저)
- id (Key) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- nickname (Field3) — VARCHAR
- create_at (Field4) — DATETIME
- introduce (Field5) — VARCHAR
- image (Field6) — VARCHAR
- role (Field7) — ENUM
- provider (Field8) — ENUM
- provider_id (Field9) — VARCHAR
- is_paid (Field10) — BOOLEAN