li

Tables (3)

Customer (Untitled2)

  • c_id (Key) — Primary key — NOT NULL
  • c_name (Field)
  • c_phone (Field2)
  • b_id (Key2) — Foreign key → book.b_id — NOT NULL

book (Untitled)

  • b_id (Key) — Primary key — NOT NULL
  • b_name (Field)
  • b_genre (Field2)
  • b_publisher (Field3)
  • b_state (Field4)

rent (Untitled3)

  • r_id (Key3) — Primary key — NOT NULL
  • r_startdate (Field)
  • r_enddate (Field2)
  • b_id (Key) — Foreign key → book.b_id — NOT NULL
  • c_id (Key2) — Foreign key → Customer.c_id — NOT NULL