test2
Tables (9)
book_likes
- id — INT — NOT NULL
- book_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — DATETIME
book_vectors
- id — INT — NOT NULL
- book_id — INT — NOT NULL
- vector_data — TEXT — NOT NULL
books
- id — INT — NOT NULL
- category_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- sub_title — VARCHAR(100)
- description — TEXT — NOT NULL
- isbn — VARCHAR(20) — NOT NULL
- cover — TEXT
- publisher — VARCHAR(100) — NOT NULL
- pub_date — DATE — NOT NULL
- author — VARCHAR(100) — NOT NULL
- author_info — TEXT
- customer_review_rank — INT
- author_photo — TEXT
categories
- id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
comments
- id — INT — NOT NULL
- user_id — INT — NOT NULL
- thread_id — INT — NOT NULL
- content — VARCHAR(200) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
thread_likes
- id — INT — NOT NULL
- thread_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — DATETIME
threads
- id — INT — NOT NULL
- user_id — INT — NOT NULL
- book_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- reading_date — DATE
- image — TEXT
- created_at — DATETIME
- updated_at — DATETIME
user_follows
- id — INT — NOT NULL
- from_user_id — INT — NOT NULL
- to_user_id — INT — NOT NULL
- created_at — DATETIME
users
- id — INT — NOT NULL
- username — VARCHAR(150) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- age — INT
- gender — VARCHAR(10)
- bio — TEXT
- profile_img — VARCHAR(255)
- weekly_reading_time — INT
- annual_reading_amount — INT
- ai_image_generation_count — INT
- ai_image_last_reset_date — DATE
- date_joined — DATETIME — NOT NULL
- last_login — DATETIME