마당서점
테이블 (3)
Untitled (Book)
- Key (bookid) — NUMBER — 기본 키 — NOT NULL
- Field (bookname) — VARCHAR2(100) — NOT NULL
- Field (publsher) — VARCHAR2(100) — NOT NULL
- Field2 (price) — NUMBER — NOT NULL
Untitled2 (Customer)
- Key (custid) — NUMBER — 기본 키 — NOT NULL
- Field (name) — VARCHAR2(100) — NOT NULL
- Field2 (address) — VARCHAR2(100) — NOT NULL
- Field (phone) — VARCHAR2(100)
Untitled3 (Order)
- Key (orderid) — NUMBER — 기본 키 — NOT NULL
- Key (custid) — NUMBER — 외래 키 → Untitled2.Key — NOT NULL
- Key (bookid) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Field (saleprice) — NUMBER — NOT NULL
- Field (orderdate) — DATE — NOT NULL