Library System

Tables (4)

Book (Untitled2)

  • Book_ID (PK) — PK — Primary key — NOT NULL
  • Member_ID (PK2) — PK — Foreign key → Member.Member_ID — NOT NULL
  • Rent_ID (PK3) — PK — Foreign key → Rent.Rent_ID — NOT NULL
  • Member_ID (varchar) — varchar — Foreign key → Rent.Member_ID — NOT NULL
  • Member_ID (PK22) — PK — Foreign key → Rent.Member_ID — NOT NULL
  • Book_Name (Field1) — varchar
  • Book_Author (Field2) — varchar
  • Book_PublishedDate (Field3) — timestamp
  • Book_Genre (Field4) — varchar
  • Book_PageCount (Field5) — int
  • Book_ISBN (Field6) — varchar

BookRent (Untitled4)

  • BookRent_ID (PK) — PK — Primary key — NOT NULL
  • Book_ID (PK2) — PK — Foreign key → Book.Book_ID — NOT NULL
  • Rent_ID (PK3) — PK — Foreign key → Book.Rent_ID — NOT NULL
  • Member_ID (PK22) — PK — Foreign key → Book.Member_ID — NOT NULL
  • Rented_Date (Field) — DateTime
  • Returned_Date (Field3) — DateTime

Member (Untitled)

  • Member_ID (PK) — PK — Primary key — NOT NULL
  • Member_Name (Field1) — varchar
  • Member_Phone (Field4) — varchar
  • Member_Email (Field6) — varchar
  • Member_Address (Field5) — varchar
  • Member_JoinedDate (Field2) — DateTime
  • Member_RentID (Field3) — varchar

Rent (Untitled3)

  • Rent_ID (PK) — PK — Primary key — NOT NULL
  • Member_ID (varchar) — varchar — Primary key — NOT NULL
  • Member_ID (PK2) — PK — Foreign key → Member.Member_ID — NOT NULL