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)