Monew-ERD

Tables (10)

article_interests (기사 관심사 매핑)

  • article_id (FK1) — UUID — Foreign key → articles.id — NOT NULL
  • interest_id (FK2) — UUID — Foreign key → interests.id — NOT NULL

article_view_histories (최근 본 뉴스 기사)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (FK1) — UUID — Foreign key → users.id — NOT NULL
  • article_id (FK2) — UUID — Foreign key → articles.id — NOT NULL
  • created_at (생성일) — TIMESTAMPTZ

articles (뉴스 기사)

  • id (PK) — UUID — Primary key — NOT NULL
  • source_url (원본 기사 링크) — VARCHAR(2048)
  • source (기사 타입) — VARCHAR(50)
  • title (제목) — VARCHAR(200)
  • publish_date (날짜) — TIMESTAMPTZ
  • summary (요약) — TEXT — NOT NULL
  • created_at (생성 시간) — TIMESTAMPTZ
  • updated_at (수정 시간) — TIMESTAMPTZ
  • deleted_at (논리 삭제된 시점) — TIMESTAMPTZ

comments (댓글)

  • id (PK) — UUID — Primary key — NOT NULL
  • article_id (FK1) — UUID — Foreign key → articles.id — NOT NULL
  • user_id (FK2) — UUID — Foreign key → users.id — NOT NULL
  • content (댓글 내용) — VARCHAR(500)
  • like_count (좋아요 수) — BIGINT
  • version (Field2) — BIGINt
  • deleted_at (논리 삭제된 시점) — TIMESTAMPTZ
  • created_at (작성일) — TIMESTAMPTZ
  • updated_at (수정일) — TIMESTAMPTZ

commit_likes (좋아요 이력)

  • id (PK) — UUID — Primary key — NOT NULL
  • comment_id (FK1) — UUID — Foreign key → comments.id — NOT NULL
  • user_id (FK2) — UUID — Foreign key → users.id — NOT NULL
  • created_at (생성 시간) — TIMESTAMPTZ

interests (관심사)

  • id (PK) — UUID — Primary key — NOT NULL
  • name (이름) — VARCHAR(50) (NOT NULL)
  • subscriber_count (구독자 수) — BIGINT
  • created_at (생성 시각) — TIMESTAMPTZ

keywords (키워드)

  • id (PK) — UUID — Primary key — NOT NULL
  • interest_id (FK) — UUID — Foreign key → interests.id — NOT NULL
  • name (키워드 이름) — VARCHAR(20)
  • created_at (생성일) — TIMESTAMPTZ

notifications (알림 이력)

  • id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2, FK) — UUID — Foreign key → users.id — NOT NULL
  • content (알림 메시지 내용) — VARCHAR(255)
  • resource_type (관련 도메인) — VARCHAR(50)
  • resource_id (해당 리소스의 id) — UUID
  • confirmed_at (사용자 확인 시간) — TIMESTAMPTZ
  • created_at (알림 생성 시간) — TIMESTAMPTZ
  • updated_at (알림 수정 시간) — TIMESTAMPTZ

subscriptions (구독)

  • id (PK) — UUID — Primary key — NOT NULL
  • user_id (FK1) — UUID — Foreign key → users.id — NOT NULL
  • interest_id (FK2) — UUID — Foreign key → interests.id — NOT NULL
  • created_at (구독한 날짜) — TIMESTAMPTZ

users (사용자)

  • id (PK) — UUID — Primary key — NOT NULL
  • created_at (생성시간) — TIMESTAMPTZ
  • updated_at (수정시간) — TIMESTAMPTZ
  • email (이메일) — VARCHAR(255)
  • nickname (닉네임) — VARCHAR(20)
  • password (비밀번호) — VARCHAR(20)
  • deleted_at (삭제시간) — TIMESTAMPTZ