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)