3team_Book
Tables (5)
Book (Type)
- PK (book_id) — Not Null — Primary key — NOT NULL
- FK (author_id) — Not Null — Foreign key → author.PK — NOT NULL
- Field (title) — NotNull
- Field (description) — NULL
- Field (publication_date) — NULL
- Field (created_at) — NotNull
Review (Untitled3)
- PK (review_id) — Not Null — Primary key — NOT NULL
- FK (user_id) — NotNull — Foreign key → User.PK — NOT NULL
- FK (book_id) — Not Null — Foreign key → Book.PK — NOT NULL
- Field (created_at) — NotNull
- Field (rating) — Null
- Field (content) — NotNull
User (Untitled2)
- PK (user_id) — NotNull — Primary key — NOT NULL
- Field (username) — NotNull
- Field (email) — NotNull
- Field (pwd) — NotNull
author (Untitled)
- PK (author_id) — int — Primary key — NOT NULL
- field (author_name) — NotNull