test
Tables (10)
book_vectors
- book_id — INT — Primary key — NOT NULL
- vector_data — JSON — NOT NULL
books
- book_id — INT — Primary key — NOT NULL
- category_id — INT
- isbn13 — VARCHAR(13) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- subtitle — VARCHAR(255)
- author — VARCHAR(100) — NOT NULL
- publisher — VARCHAR(50)
- pub_date — DATE
- description — TEXT
- cover_url — VARCHAR(2083)
categories
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
comments
- comment_id — INT — Primary key — NOT NULL
- thread_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — VARCHAR(500) — NOT NULL
- created_at — DATETIME
follows
- follower_id — INT — Primary key — NOT NULL
- following_id — INT — Primary key — NOT NULL
- created_at — DATETIME
thread_likes
- user_id — INT — Primary key — NOT NULL
- thread_id — INT — Primary key — NOT NULL
threads
- thread_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- book_id — INT — NOT NULL
- title — VARCHAR(100)
- content — TEXT — NOT NULL
- view_count — INT
- like_count — INT
- image_url — VARCHAR(2083)
- created_at — DATETIME
- updated_at — DATETIME
user_book_likes
- user_id — INT — Primary key — NOT NULL
- book_id — INT — Primary key — NOT NULL
- created_at — DATETIME
user_preferred_categories
- user_id — INT — Primary key — NOT NULL
- category_id — INT — Primary key — NOT NULL
users
- user_id — INT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50)
- gender — VARCHAR(10)
- age — INT
- weekly_reading_time — INT
- yearly_reading_cnt — INT
- profile_img — VARCHAR(2083)
- created_at — DATETIME