odte

Tables (5)

comments

  • id (댓글 고유 ID) — BIGINT — Primary key — NOT NULL
  • prosncons_id (찬반 고유 ID) — BIGINT — Foreign key → prosncons.id — NOT NULL
  • user_id (유저 고유 ID) — BIGINT — Foreign key → user.id — NOT NULL
  • content (댓글 내용) — TEXT — NOT NULL
  • created_at (작성 일시) — DATETIME — NOT NULL
  • choice (입장) — VARCHAR(10) — NOT NULL
  • like (공감 수) — BIGINT
  • hate (비공감 수) — BIGINT

news

  • id (뉴스 고유 ID) — BIGINT — Primary key — NOT NULL
  • created_by (유저 고유 ID) — BIGINT — Foreign key → user.id — NOT NULL
  • title (토픽 제목) — VARCHAR(200) — NOT NULL
  • description (토픽 설명) — TEXT
  • category (카테고리(예: 정치, 경제)) — VARCHAR(50) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • views (조회수) — BIGINT — NOT NULL
  • teaser_text (티저 텍스트(짧은 제목)) — VARCHAR(255) — NOT NULL
  • image_url (뉴스 이미지) — VARCHAR(255)

prosncons

  • id (찬반 고유 ID) — BIGINT — Primary key — NOT NULL
  • news_id (뉴스 고유 ID) — BIGINT — Foreign key → news.id — NOT NULL
  • created_by (유저 고유 ID) — BIGINT — Foreign key → news.created_by — NOT NULL
  • summary (요약) — TEXT — NOT NULL
  • link (원본 링크) — VARCHAR(255) — NOT NULL
  • pros (찬성 의견) — TEXT — NOT NULL
  • neutral (중립 의견) — TEXT — NOT NULL
  • cons (반대 의견) — TEXT — NOT NULL
  • bias (편향률) — INT — NOT NULL

user

  • id (유저 고유 ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • username (사용자명) — VARCHAR(50) — NOT NULL
  • birth_year (탄생년도(연령대)) — SMALLINT
  • sex (성별) — VARCHAR(20) — NOT NULL
  • job (신분) — VARCHAR(255)
  • created_at (가입일) — DATETIME — NOT NULL

votes

  • id (투표 고유 ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저 고유 ID) — BIGINT — Foreign key → user.id — NOT NULL
  • news_id (뉴스 고유 ID) — BIGINT — Foreign key → prosncons.news_id — NOT NULL
  • choice (입장) — VARCHAR(10) — NOT NULL
  • created_at (투표 시간) — DATETIME — NOT NULL