homework

Tables (7)

article

  • article_id — INT — Primary key — NOT NULL — 본문요약
  • issue_id — INT — Foreign key → issue.issue_id — NOT NULL — 논조
  • newspaper_id — INT — Foreign key → newspaper.newspaper_id — NOT NULL — 이해관계자
  • headline — VARCHAR(300) — NOT NULL — 원문링크
  • summary — TEXT — 회원ID(FK)
  • tone — VARCHAR(500) — 매체ID(FK)
  • stakeholders — VARCHAR(500) — 찜한날짜
  • article_url — VARCHAR(500) — 댓글ID
  • =기사(매체별 — 헤드라인/논조

cmt

  • comment_id — INT — NOT NULL — 댓글ID(FK)
  • issue_id — INT — Foreign key → issue.issue_id — NOT NULL — 반응(UP=추천/DOWN=반대)
  • member_id — INT — Foreign key → member.member_id — NOT NULL — 반응일
  • content — VARCHAR(1000) — NOT NULL

cmt_reaction

  • member_id — INT — Foreign key → member.member_id — NOT NULL

issue

  • issue_id — INT — Primary key — NOT NULL — AI통합요약
  • issue_date — DATE — NOT NULL — 중요도순위
  • title — VARCHAR(200) — NOT NULL — 다룬매체수
  • ai_summary — TEXT — 생성일
  • importance_rank — INT — NOT NULL — 기사ID
  • media_count — INT — NOT NULL — 이슈ID(FK)
  • created_at — DATETIME — NOT NULL — 매체ID(FK)

member

  • member_id — INT — Primary key — NOT NULL — 로그인아이디
  • login_id — VARCHAR(50) — NOT NULL — 비밀번호
  • password — VARCHAR(100) — NOT NULL — 닉네임
  • nickname — VARCHAR(50) — NOT NULL — 가입일
  • created_at — DATETIME — NOT NULL — 매체ID

member_favorite

  • member_id — INT — Foreign key → member.member_id — NOT NULL — 작성자ID(FK)
  • newspaper_id — INT — Foreign key → newspaper.newspaper_id — NOT NULL — 댓글내용
  • created_at — DATETIME — NOT NULL — 작성일

newspaper

  • newspaper_id — INT — Primary key — NOT NULL — 성향ID(FK)
  • newspaper_name — VARCHAR(50) — NOT NULL — 이슈ID
  • orientation_id — INT — NOT NULL — 보도날짜