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