B4 After
Tables (4)
Book (Untitled3)
- id (book_id) — int — Primary key — NOT NULL
- title (Field)
Profile (Untitled2)
- id (profile_id) — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → User.id — NOT NULL
- user (username) — one to one
- bio — text
- image — image
- favorite — many to many
Review (Untitled4)
- id (review_id) — int — Primary key — NOT NULL
- id (book_id) — int — Foreign key → Book.id — NOT NULL
- id (user_id) — int — Foreign key → User.id — NOT NULL
- Field
- Field2
User (Untitled)
- id (user_id) — int — Primary key — NOT NULL
- username — varchar
- password — varchar
- nickname — varchar