test2

Tables (4)

NewBook (Untitled2)

  • bookid (Key) — INT — Primary key — NOT NULL
  • pubname (Key2) — varcher(40) — Foreign key → NewPublisher.pubname — NOT NULL
  • bookname (Field) — archer(40)
  • price (Field2) — INT

NewCustomer (Untitled4)

  • custid (Key) — INT — Primary key — NOT NULL
  • name (Field) — varcher(40)
  • address (Field2) — varcher(40)
  • phone (Field3) — varcher(30)

NewOrder (Untitled3)

  • custid (Key) — INT — Foreign key → NewCustomer.custid — NOT NULL
  • bookid (Key2) — INT — Foreign key → NewBook.bookid — NOT NULL
  • pubname (Key22) — varcher(40) — Foreign key → NewBook.pubname — NOT NULL

NewPublisher (Untitled)

  • pubname (Key) — varcher(40) — Primary key — NOT NULL
  • stname (Field) — varcher(40)
  • officephone (Field2) — varcher(30)