북 메이트

테이블 (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