library

Tables (3)

Book (Untitled)

  • b_id (Key) — Primary key — NOT NULL
  • b_name (Field)
  • b_type (Field2)
  • publisher (Field3)
  • state (Field4)

Customer (Untitled2)

  • c_id (Key) — Primary key — NOT NULL
  • c_name (Field)
  • c_phonenum (Field2)

Order (Untitled3)

  • O_id (Key) — Primary key — NOT NULL
  • start_date (Field)
  • end_date (Field2)
  • c_id (Key2) — Foreign key → Customer.c_id — NOT NULL
  • b_id (Key3) — Foreign key → Book.b_id — NOT NULL