project1

Tables (3)

books (Untitled2)

  • bookId (Key) — Primary key — NOT NULL
  • name (Field)
  • category (Field2)

rental (Untitled3)

  • id (Key) — Foreign key → user.id — NOT NULL
  • bookId (Key2) — Foreign key → books.bookId — NOT NULL
  • date (Field)

user (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • password (Field2)
  • email (Field3)