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