library
Tables (4)
book
- book_id — int — Primary key — NOT NULL
- category_id — int — Foreign key → category.category_id — NOT NULL
- title — varchar — NOT NULL
- author — varchar — NOT NULL
- publisher — varchar — NOT NULL
borrow
- borrow_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.user_id — NOT NULL
- book_id — int — Foreign key → book.book_id — NOT NULL
- borrowed_at — date — NOT NULL
- due_date — date — NOT NULL
- is_returned — boolean — NOT NULL
category
- category_id — int — Primary key — NOT NULL
- category_name — varchar — NOT NULL
users
- user_id — int — Primary key — NOT NULL
- username — varchar — NOT NULL
- name — varchar — NOT NULL
- phone — varchar — NOT NULL