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