final_project
Tables (9)
Book
- id — int — Primary key — NOT NULL
- category_id — int — Foreign key → Category.id — NOT NULL
- title — varchar(255)
- subTitle — varchar(255)
- description — text
- isbn — varchar(255)
- cover — text
- publisher — varchar(255)
- pub_date — date
- author — varchar(255)
- author_info — text
- customer_review_rank — int
- author_photo — text
BookLike
- user_id — int — Foreign key → User.id — NOT NULL
- book_id — int — Foreign key → Book.id — NOT NULL
BookVector
- id — int — Primary key — NOT NULL
- book_id — int — Foreign key → Book.id — NOT NULL
- vector_data — longtext
Category
- id — int — Primary key — NOT NULL
- name — varchar(255)
Comment
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- thread_id — int — Foreign key → Thread.id — NOT NULL
- content — varchar(255)
- created_at — datetime
- updated_at — datetime
Thread
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- book_id — int — Foreign key → Book.id — NOT NULL
- title — varchar(255)
- content — text
- reading_date — date
- image — text
- created_at — datetime
- updated_at — datetime
ThreadLike
- user_id — int — Foreign key → User.id — NOT NULL
- thread_id — int — Foreign key → Thread.id — NOT NULL
User
- id — int — Primary key — NOT NULL
- username — varchar(255)
- password — varchar(255)
- nickname — varchar(255)
- age — int
- gender — varchar(50)
- bio — text
- profile_img — text
- weekly_reading_time — int
- annual_reading_amount — int
- ai_image_generation_count — int
- ai_image_last_reset_date — date
UserFollowing
- from_user_id — int — Foreign key → User.id — NOT NULL
- to_user_id — int — Foreign key → User.id — NOT NULL