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)