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 — 보도날짜