북 메이트
테이블 (9)
Book (book)
- book_id (Key) — INTEGER — 기본 키 — NOT NULL
- title (Field) — varchar(100)
- author (Field2) — varchar(50)
- publisher (Field3) — varchar(50)
- published_date (Field4) — date
- cover_image (Field5) — varchar(255)
- description (Field6) — text
- genre (Field7) — varchar(50)
- page_count (Field9) — integer
BookGenre (book genre)
- book_id (Key) — INTEGER — 외래 키 → Book.book_id — NOT NULL
- genre_id (Key2) — INTEGER — 외래 키 → Genre.genre_id — NOT NULL
Friendship (friendship)
- friendship_id (Key) — INTEGER — 기본 키 — NOT NULL
- user_id (Key2) — INTEGER — 외래 키 → User.user_id — NOT NULL
- status (Field) — VARCHAR(10)
- created_at (Field2) — TIMESTAMP
Genre (genre)
- genre_id (Key) — INTEGER — 기본 키 — NOT NULL
- name (Field) — varchar(50)
Note (note)
- note_id (Key) — INTEGER — 기본 키 — NOT NULL
- user_book_id (Key2) — INTEGER — 외래 키 → UserBook.user_book_id — NOT NULL
- content (Field) — text
- created_at (Field2) — timestamp
- updated_at (Field3) — timestamp
Recommendation (recommendation)
- recommendation_id (Key) — INTEGER — 기본 키 — NOT NULL
- user_id (Key2) — INTEGER — 외래 키 → User.user_id — NOT NULL
- book_id (Key3) — INTEGER — 외래 키 → Book.book_id — NOT NULL
- message (Field) — text
- created_at (Field2) — TIMESTAMP
Statistics (statistics)
- stat_id (Key) — INTEGER — 기본 키 — NOT NULL
- user_id (Key2) — INTEGER — 외래 키 → User.user_id — NOT NULL
- book_id (Key3) — INTEGER — 외래 키 → Book.book_id — NOT NULL
- books_read_count (Field) — integer
- pages_read_count (Field2) — integer
- most_read_genre (Field3) — VARCHAR(50)
- favorite_book (Field4) — INTEGER
- monthly_reading_trend (Field5) — JSON
User (users)
- user_id (Key) — INTEGER — 기본 키 — NOT NULL
- user_name (Field2) — varchar(20)
- email (Field3) — varchar(30)
- profile_picture (Field5) — varchar(250)
- create_at (Field) — varchar(250)
- update_at (Field4) — timestamp
- bio (Field6) — text
UserBook (user book)
- user_book_id (Key) — INTEGER — 기본 키 — NOT NULL
- book_id (Key2) — INTEGER — 외래 키 → Book.book_id — NOT NULL
- user_id (Key3) — INTEGER — 외래 키 → User.user_id — NOT NULL
- status (Field) — varchar(10)
- start_date (Field2) — date
- end_date (Field3) — date
- rating (Field4) — integer
- review (Field5) — text
- progress (Field6) — integer