NookBook
Tables (16)
BaseEntity (Untitled)
- createdAt (Field)
- updatedAt (Field2)
- Status (Field3)
BestSeller (Untitled5)
- bestseller_id (Key) — Primary key — NOT NULL
- book_id (Key2) — Foreign key → Book.book_id — NOT NULL
- rank (Field)
Book (Untitled4)
- book_id (Key) — Primary key — NOT NULL
- title (Field)
- author (Field2)
- page (Field3)
- isbn (Field4)
- published_date (Field5)
- info (Field6)
- index (Field7)
- category (Field8)
- image (Field9)
- publisher (Field10)
BookStatus (Untitled15)
- Before (Field)
- After (Field2)
Challenge (Untitled8)
- challenge_id (Key) — Primary key — NOT NULL
- title (Field)
- start (Field2)
- end (Field3)
- goal (Field5)
Collection (Untitled2)
- collection_id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.user_id — NOT NULL
- book_id (Key2) — Foreign key → Book.book_id — NOT NULL
- title (Field)
Library (Untitled3)
- library_id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → User_Book.id — NOT NULL
- book_id (Key22) — Foreign key → User_Book.book_id — NOT NULL
- user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL
Mate (Untitled11)
- id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.user_id — NOT NULL
- Mate_Status (Field)
- mate_id (Field2)
Mate_Status (Untitled12)
- Send (Field)
- Complete (Field2)
- Recieve (Field3)
Note (Untitled6)
- note_id (Key3) — Primary key — NOT NULL
- id (Key) — Foreign key → User_Book.id — NOT NULL
- book_id (Key2) — Foreign key → User_Book.book_id — NOT NULL
- user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL
- content (Field)
Notice (Untitled13)
- notice_id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.user_id — NOT NULL
- content (Field)
Participant (Untitled14)
- id (Key) — Primary key — NOT NULL
- challenge_id (Key2) — Foreign key → Challenge.challenge_id — NOT NULL
- user_id (id) — Long — Foreign key → User.user_id — NOT NULL
- User_Status (Field)
- total_time (Field2)
Timer (Untitled7)
- timer_id (Key3) — Primary key — NOT NULL
- id (Key) — Foreign key → User_Book.id — NOT NULL
- book_id (Key2) — Foreign key → User_Book.book_id — NOT NULL
- user_id (id) — Long — Foreign key → User_Book.user_id — NOT NULL
- timestamp (Field)
User (Member)
- user_id (id) — Long — Primary key — NOT NULL
- email (Field)
- password (Field2)
- nickname_id (Field5)
- nickname (Field3)
- login_type (Field4)
User_Book (Untitled9)
- id (Key) — Primary key — NOT NULL
- book_id (Key2) — Foreign key → Book.book_id — NOT NULL
- user_id (id) — Long — Foreign key → User.user_id — NOT NULL
- Book_Status (Field)
User_Status (Untitled10)
- In_Progress (Field)
- Rest (Field2)