library 2
Tables (11)
Untitled (책)
- Key (ISBN) — int(13) — Primary key — NOT NULL
- Field (서명) — char(30)
- Field (출판일자) — date
- Field (가격) — int(10)
- Key (출판사ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (kdc분류번호) — int(3) — Foreign key → Untitled.Key — NOT NULL
Untitled (출판사)
- Key (출판사ID) — char(10) — Primary key — NOT NULL
- Field (출판사명칭) — char(30)
- Field (출판사주소) — char(200)
Untitled (저자)
- Key (주민번호) — char(14) — Primary key — NOT NULL
- Field (저자이름) — char(30)
- Field (저자주소) — char(200)
Untitled (책_저자)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (주민번호) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (KDC)
- Key (kdc분류번호) — int(3) — Primary key — NOT NULL
- Field (설명) — char(30)
Untitled (주제명)
- Key (키워드code) — char(10) — Primary key — NOT NULL
- Field (키워드이름) — char(30)
- Field (키워드설명) — char(100)
Untitled (책_주제)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (키워드code) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (관련인물)
- Key (인물코드) — char(14) — Primary key — NOT NULL
- Field (인물이름) — char(40)
Untitled (관련사건)
- Key (사건코드) — char(10) — Primary key — NOT NULL
- Field (사건이름) — char(40)
Untitled (책_관련인물)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (인물코드) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (책_관련사건)
- Key (ISBN) — int(13) — Foreign key → Untitled.Key — NOT NULL
- Key (사건코드) — char(10) — Foreign key → Untitled.Key — NOT NULL