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