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