my

Tables (4)

BOOK (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • RENTAL_FEE (Field2)

CUSTOMER (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • PHONE (Field2)
  • ADDRESS (Field3)
  • PASSWORD (Field4)
  • LATE_COUNT (Field5)
  • BLACKLIST (Field6)

RENTAL (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → BOOK.ID — NOT NULL
  • ID (Key3) — Foreign key → CUSTOMER.ID — NOT NULL
  • RENTAL_DATE (Field3)
  • PLANED_RETURN_DATE (Field4)
  • RENTAL_FEE (Field5)

RETURN (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → BOOK.ID — NOT NULL
  • ID (Key3) — Foreign key → CUSTOMER.ID — NOT NULL
  • RENTAL_DATE (Field3)
  • PLANED_RETURN_DATE (Field4)
  • FINAL_RETURN_DATE (Field5)
  • RENTAL_FEE (Field6)
  • UNPAID_FEE (Field7)