week10

Tables (3)

Book (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • Id (Key2) — Foreign key → Rental.Id — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field3)

Member (Untitled)

  • Id (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • joined_at (Field3)

Rental (Untitled3)

  • Id (Key2) — Foreign key → Member.Id — NOT NULL
  • member_id (Field)
  • book_id (Field2)
  • due_date (Field3)