test

Tables (3)

NewBook (신규 책)

  • bookid — INT — Primary key — NOT NULL
  • bookname (VARCHAR(40)) — VARCHAR(40)
  • price (Field2) — INT
  • pubname (Key) — VARCHAR(40) — Foreign key → newPublisher.pubname — NOT NULL

NewCustomer (신규고객)

  • custid (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(40)
  • addresss — VARCHAR(40)
  • phone — VARCHAR(30)

newPublisher (신규출판사)

  • pubname (Key) — VARCHAR(40) — Primary key — NOT NULL
  • stname — VARCHAR(40)
  • officePhone — VARCHAR(30)