알쓸논잡 ERD

인하대 컴퓨터종합설계 25-02 2조 알쓸논잡 팀

테이블 (9)

Untitled (interests)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Key (users_id) — BIGINT — 외래 키 → member.Key — NOT NULL
  • Key (categories_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (categories)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (code) — VARCHAR — NOT NULL
  • Field (depth) — SMALLINT — NOT NULL
  • Field (sort_order) — INT
  • Field (create_at) — TIMESTAMP — NOT NULL
  • Key (parent_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (papers)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (arvix_id) — string — NOT NULL
  • Field (title) — string
  • Field (authors) — array
  • Field (abstract) — string
  • Field (categories) — array
  • Field (keywords) — array
  • Field (published_date) — date
  • Field2 (journal_ref) — string
  • Field (doi) — string
  • Field (pdf_url) — string
  • Field (page_count) — numeric
  • Field (summary) — dictionary
  • Field (embedding) — array
  • Field (stats) — dictionary
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL

Untitled (user_activities)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (activity_type) — string
  • Field (metadata) — dictionary
  • Field (timestamp) — date
  • Key (users_id) — numeric — 외래 키 → member.Key — NOT NULL
  • Key (paper_id) — objectId — 외래 키 → Untitled.Key — NOT NULL

Untitled (bookmarks)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (bookmarked_at) — date — NOT NULL
  • Field (notes) — string
  • Key (users_id) — numeric — 외래 키 → member.Key — NOT NULL
  • Key (paper_id) — objectId — 외래 키 → Untitled.Key — NOT NULL

Untitled (search_history)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (query) — string
  • Field (filters) — dictionary
  • Field (result_count) — numeric
  • Field (searched_at) — date
  • Key (users_id) — numeric — 외래 키 → member.Key — NOT NULL

Untitled (paper_recommendations)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (recommendation_type) — string
  • Field (score) — numeric
  • Field (features) — dictionary
  • Field (context) — dictionary
  • Field (was_clicked) — boolean
  • Field (recommended_at) — date — NOT NULL
  • Key (users_id) — numeric — 외래 키 → member.Key — NOT NULL
  • Key (paper_id) — objectId — 외래 키 → Untitled.Key — NOT NULL

Untitled (category_names)

  • Key (locale) — VARCHAR — 기본 키 — NOT NULL
  • Key2 (name) — VARCHAR — 기본 키 — NOT NULL
  • Key (category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

member (users)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR — NOT NULL
  • Field (password) — VARCGAR — NOT NULL
  • Field (is_active) — VARCHAR — NOT NULL
  • Field (create_at) — TIMESTAMP
  • Field2 (update_at) — TIMESTAMP