UMC-Week2
Tables (7)
Users
- user_id — VARCHAR(50) — Primary key — NOT NULL
- nickname — VARCHAR(50)
book
- Key2 (book_id) — Primary key — NOT NULL
- Field (title)
- Field (is_available)
- Key (category_id) — Foreign key → category.Key — NOT NULL
- Field (description)
book_like
- Key (user_id) — Foreign key → Users.user_id — NOT NULL
- Key2 (book_id) — Foreign key → book.Key2 — NOT NULL
book_tag
- Key2 (book_id) — Foreign key → book.Key2 — NOT NULL
- Key (tag_id) — Foreign key → tag.Key — NOT NULL
category
- Key (category_id) — Primary key — NOT NULL
- Field (name)
rental
- Key (rental_id) — Primary key — NOT NULL
- Field (rented_at)
- Field (due_at)
- Field (returned_at)
- Key (user_id) — Foreign key → Users.user_id — NOT NULL
- Key2 (book_id) — Foreign key → book.Key2 — NOT NULL
tag
- Key (tag_id) — Primary key — NOT NULL
- Field (name)