게시판 테스트

테이블 (3)

Copy Of Untitled (CopyOfBook)

  • Key (custid) — NUMBER — 기본 키 — NOT NULL
  • Field (name) — VARCHAR2(100) — NOT NULL
  • Field (address) — VARCHAR2(100) — NOT NULL
  • Field (phone) — VARCHAR2(100)

Orders

  • orderid — NUMBER — 기본 키 — NOT NULL
  • saleprice (Field) — NUMBER
  • Field2 (orderdate) — DATE — NOT NULL
  • Key (custid) — NUMBER — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (bookid) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

Untitled (Book)

  • Key (bookid) — NUMBER — 기본 키 — NOT NULL
  • Field (bookname) — VARCHAR2(100) — NOT NULL
  • Field (publisher) — VARCHAR2(100) — NOT NULL
  • Field — NUMBER — NOT NULL