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