ERD
Tables (4)
Untitled (도서)
- Key (도서번호) — INTEGER — Primary key — NOT NULL
- Field (도서이름) — VARCHAR(100)
- Field (도서단가) — INTEGER
- Key (출판사이름) — VARCHAR(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (출판사)
- Key (출판사이름) — VARCHAR(100) — Primary key — NOT NULL
- Field (담당자이름) — VARCHAR(50)
- Field (전화번호) — VARCHAR(20)
Untitled (주문)
- Key (주문번호) — INTEGER — Primary key — NOT NULL
- Field (주문일자) — DATE — NOT NULL
- Field (주문금액) — INTEGER — NOT NULL
- Key (도서번호) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Key (key) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (고객)
- Key (key) — INTEGER — Primary key — NOT NULL
- Field (고객이름) — VARCHAR(50) — NOT NULL
- Field (주소) — VARCHAR(100)
- Field (전화번호) — VARCHAR(20)