ERD 간단 버전_민식
테이블 (18)
book_demand_features
- as_of_month — CHAR(7) — 기본 키 — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- loan_cum — BIGINT
- loan_3m — INTEGER
- loan_12m — INTEGER
- loan_24m — INTEGER
- trending_score — NUMERIC(5,2)
- steady_score — NUMERIC(5,2)
- holder_libs — INTEGER
- feature_version — VARCHAR(20) — NOT NULL
book_keywords
- keyword — VARCHAR(100) — 기본 키 — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- weight — NUMERIC(8,2)
- rank — SMALLINT — NOT NULL
book_loaned_top20
- id — BIGINT — 기본 키 — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- gender — CHAR(1) — NOT NULL
- age_group — VARCHAR(2) — NOT NULL
- ranking — SMALLINT — NOT NULL
- loan_count — INTEGER
- period — CHAR(6) — NOT NULL
book_relations
- id — BIGINT — 기본 키 — NOT NULL
- source_book_id — BIGINT — 외래 키 → books.id — NOT NULL
- target_book_id — BIGINT — 외래 키 → books.id
- target_isbn13 — CHAR(13) — NOT NULL
- relation_type — VARCHAR(12) — NOT NULL
- rank — SMALLINT — NOT NULL
- collected_at — DATE — NOT NULL
book_tags
- id — BIGINT — 기본 키 — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- tag_code — VARCHAR(30) — 외래 키 → tags.tag_code — NOT NULL
book_world_cup_sessions
- session_id — UUID — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- status — VARCHAR(12) — NOT NULL
- round_size — SMALLINT — NOT NULL
- round_number — SMALLINT — NOT NULL
- match_index — SMALLINT — NOT NULL
- round_participants — JSONB — NOT NULL
- round_winners — JSONB — NOT NULL
- champion_isbn13 — CHAR(13) — 외래 키 → books.isbn13
- expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
book_world_cup_synopses
- isbn13 — CHAR(13) — 외래 키 → books.isbn13 — NOT NULL
- loan_rank — SMALLINT — NOT NULL
- loan_count — BIGINT — NOT NULL
- synopsis — TEXT — NOT NULL
- source_hash — CHAR(64) — NOT NULL
- input_hash — CHAR(64) — NOT NULL
- source_name — VARCHAR(40) — NOT NULL
- source_period — VARCHAR(20)
- selection_rule — VARCHAR(64) — NOT NULL
- summary_version — VARCHAR(64) — NOT NULL
- model_version — VARCHAR(64) — NOT NULL
- generated_at — TIMESTAMPTZ — NOT NULL
books
- id — BIGINT — 기본 키 — NOT NULL
- isbn13 — CHAR(13) — NOT NULL
- title — VARCHAR(500) — NOT NULL
- author — VARCHAR(300)
- publisher — VARCHAR(200)
- pub_year — SMALLINT
- category_code — VARCHAR(10)
- description — TEXT
- cover_url — VARCHAR(500)
- embedding_version — VARCHAR(30)
- description_source — VARCHAR(20)
- description_kakao — TEXT
- text_hash — CHAR(64)
- catalog_layer — CHAR(4)
- is_candidate — BOOLEAN — NOT NULL
- is_searchable — BOOLEAN — NOT NULL
- candidate_exclusion — VARCHAR(12)
- vol — VARCHAR(20)
- set_isbn — VARCHAR(13)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
kdc_codes
- code — VARCHAR(10) — 기본 키 — NOT NULL
- label — VARCHAR(200) — NOT NULL
- parent_code — VARCHAR(10) — 외래 키 → kdc_codes.code
- depth — SMALLINT — NOT NULL
recommendation_items
- id — BIGINT — 기본 키 — NOT NULL
- recommendation_id — BIGINT — 외래 키 → recommendations.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- rank — SMALLINT — NOT NULL
- score — NUMERIC(5,2) — NOT NULL
- tags — JSONB — NOT NULL
- feature_scores — JSONB — NOT NULL
- reason_type — VARCHAR(20) — NOT NULL
- reason_text — TEXT — NOT NULL
recommendations
- id — BIGINT — 기본 키 — NOT NULL
- public_id — VARCHAR(64) — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- mode — VARCHAR(15) — NOT NULL
- fallback — BOOLEAN — NOT NULL
- based_on_count — SMALLINT — NOT NULL
- weights — JSONB — NOT NULL
- input_tags — JSONB — NOT NULL
- feature_version — VARCHAR(128)
- index_version — VARCHAR(128)
- created_at — TIMESTAMPTZ — NOT NULL
refresh_tokens
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- family_id — UUID — NOT NULL
- token_hash — CHAR(64) — NOT NULL
- issued_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- rotated_at — TIMESTAMPTZ
- revoked_at — TIMESTAMPTZ
tags
- tag_code — VARCHAR(30) — 기본 키 — NOT NULL
- label — VARCHAR(50) — NOT NULL
- kind — VARCHAR(10) — NOT NULL
user_actions
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id
- recommendation_id — BIGINT — 외래 키 → recommendations.id
- event_type — VARCHAR(15) — NOT NULL
- rank — SMALLINT
- display_position — SMALLINT
- context — VARCHAR(20)
- session_id — VARCHAR(36)
- client_event_id — VARCHAR(64)
- payload — JSONB — NOT NULL
- occurred_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
user_dna_profiles
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- library_fingerprint — VARCHAR(64) — NOT NULL
- request_id — VARCHAR(128) — NOT NULL
- dna_version — VARCHAR(64) — NOT NULL
- model_version — VARCHAR(128) — NOT NULL
- index_version — VARCHAR(128) — NOT NULL
- tag_version — VARCHAR(128) — NOT NULL
- profile — JSONB — NOT NULL
- unresolved_isbns — JSONB — NOT NULL
- generated_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_interests
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- tag_code — VARCHAR(30) — 외래 키 → tags.tag_code — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
user_library
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- book_id — BIGINT — 외래 키 → books.id — NOT NULL
- status — VARCHAR(15) — NOT NULL
- rating — SMALLINT
- review_text — VARCHAR(300)
- finished_at — DATE
- source — VARCHAR(15) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL
- oauth_subject — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- birth_year — SMALLINT
- gender — CHAR(1)
- onboarding_status — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL