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