LibraryDB

Tables (5)

Authors (DB_Authors)

  • author_id — INT — Primary key — NOT NULL
  • author_name — VARCHAR(100) — NOT NULL
  • birth_year — DATE

Books (DB_Books)

  • book_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • publication_year — INT
  • isbn — VARCHAR(20)
  • author_id — INT — Foreign key → Authors.author_id — NOT NULL
  • publisher_id — INT — Foreign key → Publishers.publisher_id — NOT NULL

Loans (DB_Loans)

  • loan_id — INT — Primary key — NOT NULL
  • loan_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE
  • member_id — INT — Foreign key → Members.member_id — NOT NULL
  • book_id — INT — Foreign key → Books.book_id — NOT NULL

Members (DB_Members)

  • member_id — INT — Primary key — NOT NULL
  • member_name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • join_date — DATE — NOT NULL

Publishers (DB_Publishers)

  • publisher_id — INT — Primary key — NOT NULL
  • publisher_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)