ERD2

Tables (12)

auth_user

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

books_book

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

books_booksearchdocument

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

books_chatmessage

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

books_chatrecommendation

  • id — BIGINT — Primary key — NOT NULL
  • chat_session_id — BIGINT — Foreign key → books_chatsession.id — NOT NULL
  • book_id — BIGINT — Foreign key → books_book.id — NOT NULL
  • order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

books_chatsession

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

books_library

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

books_librarybook

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

books_roadmap

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

books_roadmapbook

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

books_savedbook

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
  • book_id — BIGINT — Foreign key → books_book.id — NOT NULL
  • created_at — DATETIME — NOT NULL

books_userprofile

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