p

Tables (3)

Book (Untitled2)

  • Book Number (book_number) — INT(11) — Primary key — NOT NULL
  • Book Name (book_name) — VARCHAR(255)
  • Author (author) — VARCHAR(255)
  • Publisher (publisher) — VARCHAR(255)
  • ISBN (isbn) — INT(13)

Borrow (Untitled3)

  • Rental Number (rental_number) — Primary key — NOT NULL

member (Untitled)

  • Contact Id (contact_id) — INT(11) — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)