readBuddy
Tables (5)
Diary (diaries)
- id (Key2) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- user_book_id (FK2) — bigint — Foreign key → UserBook.id — NOT NULL
- content (Field) — varchar(500)
- uploadDate (Field2) — timestamp
HeartBook (heart_books)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- name (Field) — varchar
ReadAmount (read_amounts)
- id (Key) — bigint — Primary key — NOT NULL
- user_book_id (FK) — bigint — Foreign key → UserBook.id — NOT NULL
- user_id (FK@) — bigint — Foreign key → User.id — NOT NULL
- total_pages (Field) — int
- days (Field2) — int
User (users)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- genre (Field2) — varchar
UserBook (user_books)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK3) — bigint — Foreign key → User.id — NOT NULL
- name (Field) — varchar
- status (Field2) — varchar
- startDate (Field3) — timestamp
- finishDate (Field4) — timestamp
- pages (Field5) — int