library
Tables (13)
Author (Untitled8)
- author_id (Key) — Primary key — NOT NULL
- name (Field)
- birth_date (Field2)
- death_date (Field3)
- nationality (Field4)
Book (Untitled)
- isbn (Key) — Primary key — NOT NULL
- title (Field)
- edition (Field2)
- language (Field3)
- publish_year (Field4)
- total_copies (Field5)
- category_id (Field6)
- publisher_id (Field7)
- author_id (Field8)
- donor_id (Field9)
- category_id (Key2) — Foreign key → Category.category_id — NOT NULL
- publisher_idn (Key3) — Foreign key → Publisher.publisher_idn — NOT NULL
- author_id (Key4) — Foreign key → Author.author_id — NOT NULL
Book_copy (Untitled2)
- book_copy_id (Key) — Primary key — NOT NULL
- isbn (Field)
- status (Field2)
- shelf_id (Field3)
- shelf_location (Field4)
Category (Untitled9)
- category_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
Donor (Untitled11)
- donor_id (Key) — Primary key — NOT NULL
- name (Field)
- contact_info (Field2)
Loan (Untitled6)
- loan_id (Key) — Primary key — NOT NULL
- member_id (Field)
- book_copy_id (Field2)
- loan_date (Field3)
- due_date (Field4)
- return_date (Field5)
- returned_date (Field6)
Magazine (Untitled3)
- magazine_id (Key) — Primary key — NOT NULL
- title (Field)
- issue (Field2)
- publication_date (Field3)
- publisher_id (Field4)
- shelf_id (Field5)
Member (Untitled5)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- birth_date (Field2)
- email (Field3)
- member_type (Field4)
- position (Field5)
- join_date (Field6)
- is_active (Field7)
Newspaper (Untitled4)
- newspaper_id (Key) — Primary key — NOT NULL
- title (Field)
- date (Field2)
- publisher_id (Field3)
- shelf_id (Field4)
Publisher (Untitled12)
- publisher_idn (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- contact_info (Field3)
Reservation (Untitled7)
- reservation_id (Key) — Primary key — NOT NULL
- member_id (Field)
- isbn (Field2)
- reserved_date (Field3)
- expiration_date (Field4)
- status (Field5)
Shelf (Untitled10)
- shelf_id (Key) — Primary key — NOT NULL
- location (Field)
- capacity (Field2)
Supplier (Untitled13)
- supplier_id (Key) — Primary key — NOT NULL
- name (Field)
- contact_info (Field2)