게시판 테스트
테이블 (3)
Untitled (BOOK)
- Key (BOOKID) — NUMBER — 기본 키 — NOT NULL
- Field (BOOKNAME) — VARCHAR(100) — NOT NULL
- Field (PUBLISHER) — VARCHAR(100) — NOT NULL
- Field (PRICE) — NUMBER — NOT NULL
Untitled (CUSTOMER)
- Key (CUSTID) — NUMBER — 기본 키 — NOT NULL
- Field (NAME) — VARCHAR(100) — NOT NULL
- Field (ADDRES) — VARCHAR(100) — NOT NULL
- Field (PHONE) — VARCHAR(100)
Untitled (ORDERS)
- Key (ORDERID) — NUMBER — 기본 키 — NOT NULL
- Field (SALEPRICE) — NUMBER — NOT NULL
- Field (ORDERDATE) — DATE — NOT NULL
- Key (BOOKID) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
- Key (CUSTID) — NUMBER — 외래 키 → Untitled.Key — NOT NULL