0415
Tables (3)
Untitled (Book)
- Key (bookid) — NUMBER — Primary key — NOT NULL
- Field (bookname) — VARCHAR2(100) — NOT NULL
- Field (publisher) — VARCHAT2(100) — NOT NULL
- Field (pricen) — NUMBER — NOT NULL
Untitled (Customer)
- Key (custid) — NUMBER — Primary key — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field (address) — VARCHAR2(100) — NOT NULL
- Field (phone) — VARCHAR2(100)
Untitled (Orders)
- Key (orderidN) — NUMBER — Primary key — NOT NULL
- Key (custid) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (bookid) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (salepriceN) — NUMBER — NOT NULL
- Field (orderdate) — DATE — NOT NULL