book-palette
Tables (11)
book
- id — INTEGER — Primary key
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(100)
- publisher — VARCHAR(100)
- isbn — VARCHAR(20)
- published_at — DATE
- cover_image — VARCHAR(255)
- description — TEXT
book_genre
- id — INTEGER — Primary key
- book_id — INTEGER — NOT NULL
- genre_id — INTEGER — NOT NULL
- UNIQUE(book_id, — genre_id)
color_history
- id — INTEGER — Primary key
- user_id — INTEGER — NOT NULL
- genre_id — INTEGER — NOT NULL
- count — INTEGER — NOT NULL
- UNIQUE(user_id, — genre_id)
comment
- id — INTEGER — Primary key
- thread_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
comment_like
- id — INTEGER — Primary key
- comment_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- UNIQUE(comment_id, — user_id)
genre
- id — INTEGER — Primary key
- name — VARCHAR(50) — NOT NULL
- color — CHAR(7) — NOT NULL
thread
- id — INTEGER — Primary key
- book_id — INTEGER
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
thread_like
- id — INTEGER — Primary key
- thread_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- UNIQUE(thread_id, — user_id)
user
- id — INTEGER — Primary key
- username — VARCHAR(30) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- profile_image — VARCHAR(255)
- bio — TEXT
- represent_color — CHAR(7)
- created_at — DATETIME
user_book
- id — INTEGER — Primary key
- book_id — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- finished_at — DATE
- personal_note — TEXT
- UNIQUE(user_id, — book_id)
- user_id — INTEGER — NOT NULL
user_follow
- id — INTEGER — Primary key
- follower_id — INTEGER — NOT NULL
- following_id — INTEGER — NOT NULL
- created_at — DATETIME
- UNIQUE(follower_id, — following_id)
- CHECK — (follower_id <> following_id)