게시판 테스트

테이블 (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