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