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