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)