databaseAssignment1
Tables (7)
BOOK_CATEGORY (Untitled3)
- book_info_id (Key3) — int — Foreign key → BOOK_INFO.book_info_id — NOT NULL
- category_id (Key) — int — Foreign key → CATEGORY.category_id — NOT NULL
BOOK_COPY (Untitled2)
- book_copy_id (Key) — int — Primary key — NOT NULL
- book_info_id (Key2) — int — Foreign key → BOOK_INFO.book_info_id — NOT NULL
- status (Field) — enum
BOOK_INFO (Untitled)
- book_info_id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar
- author (Field2) — varchar
- publisher (Field3) — varchar
- publication_date (Field4) — date
- description (Field5)
CATEGORY (Untitled4)
- category_id (Key) — int — Primary key — NOT NULL
- category_name (Field) — varchar
LOAN (Untitled5)
- loan_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- book_copy_id (Key3) — int — Foreign key → BOOK_COPY.book_copy_id — NOT NULL
- loan_date (Field) — timestamp
- due_date (Field2) — timestamp
- return_date (Field3) — timestamp
REVIEW (Untitled6)
- review_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- book_info_id (Key3) — int — Foreign key → BOOK_INFO.book_info_id — NOT NULL
- rating (Field) — int
- comment (Field2) — text
- created_at (Field3) — int
USER
- user_id (Key) — Primary key — NOT NULL
- password (Field2) — varchar
- name (Field3) — varchar
- role (Field) — enum
- created_at (Field4) — timestamp