알쓸논잡 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