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)