Exe6- 006
Tables (4)
Untitled (책)
- Key (책ID) — char(10) — Primary key — NOT NULL
- Key (출판사ID) — char(20) — Foreign key → Untitled2.Key — NOT NULL
- Field (서명) — char(10)
- Field (가격) — char(10)
- Field (출판일) — char(10)
- Field
Untitled2 (출판사)
- Key (출판사ID) — char(20) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field (주소) — char(30)
- Field (전화) — char(11)
- Field
Untitled3 (저자)
- Field (주민번호) — char(10)
- Field (이름) — char(10)
- Field (주소) — char(10)
- Field (전화) — char(10)
- Key (책ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (출판사ID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field
Untitled5 (인쇄소)
- Key (인쇄소ID) — char(10) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field (주소) — char(10)
- Field (전화) — char(11)
- Field
- Key (책ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (출판사ID) — char(20) — Foreign key → Untitled.Key — NOT NULL