마당서점
테이블 (3)
Untitled (Book)
- Key (Bookid) — NUMBER — 기본 키 — NOT NULL
- Field (Bookname) — VARCHAR2(100) — NOT NULL
- Field (publisher) — VARCHAR2(100) — NOT NULL
- Field (price) — NUMBER — NOT NULL
Untitled (Orders)
- Key (orderid) — NUMBER — 기본 키 — NOT NULL
- Key (Bookid) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (custid) — NUMBER — 외래 키 → Untitled2.Key — NOT NULL
- Field (saleprice) — NUMBER — NOT NULL
- Field (orderdate) — DATE — NOT NULL
Untitled2 (Customer)
- Key (custid) — NUMBER — 기본 키 — NOT NULL
- Field (name) — VARCHAR2(100 — NOT NULL
- Field (address) — VARCHAR2(100) — NOT NULL
- Field (phone) — VARCHAR2(100)