erd2

Tables (11)

book

  • id — BIGINT — Primary key — NOT NULL
  • isbn13 — VARCHAR(13) — NOT NULL
  • bookname — VARCHAR(300) — NOT NULL
  • authors — VARCHAR(300)
  • publisher — VARCHAR(200)
  • publication_year — VARCHAR(20)
  • class_nm — VARCHAR(200)
  • book_image_url — VARCHAR(500)
  • description — TEXT
  • loan_count — INT
  • keywords — JSON
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

book_search_document

  • id — BIGINT — Primary key — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • chat_session_id — BIGINT — Foreign key → chat_session.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_session

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_auth.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

library

  • lib_code — VARCHAR(50) — Primary key — NOT NULL
  • lib_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(500)
  • tel — VARCHAR(50)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • homepage — VARCHAR(500)
  • closed — VARCHAR(255)
  • operating_time — VARCHAR(255)
  • book_count — INT

library_book

  • id — BIGINT — Primary key — NOT NULL
  • lib_code — VARCHAR(50) — Foreign key → library.lib_code — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • registration_date — DATE
  • library_loan_count — INT
  • call_no — VARCHAR(100)
  • loan_available — BOOLEAN
  • updated_at — DATETIME — NOT NULL

roadmap

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_auth.id — NOT NULL
  • chat_session_id — BIGINT — Foreign key → chat_session.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

roadmap_book

  • id — BIGINT — Primary key — NOT NULL
  • roadmap_id — BIGINT — Foreign key → roadmap.id — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • order — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • created_at — DATETIME — NOT NULL

saved_book

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_auth.id — NOT NULL
  • book_id — BIGINT — Foreign key → book.id — NOT NULL
  • created_at — DATETIME — NOT NULL

user_auth

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(150) — NOT NULL
  • email — VARCHAR(254)
  • password — VARCHAR(128) — NOT NULL
  • is_staff — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_superuser — BOOLEAN — NOT NULL
  • last_login — DATETIME
  • date_joined — DATETIME — NOT NULL

user_profile

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_auth.id — NOT NULL
  • address — VARCHAR(255)
  • updated_at — DATETIME — NOT NULL