웹데이터베이스 중간고사
테이블 (5)
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (bKDC) — char(3)
- Field (bName) — char(50)
- Field (bdate) — date
- Field (bPerson) — char(50)
- Field (bCase) — text
- Key (pID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (kID) — int(3) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AUTHOR)
- Key (ssn) — char(30) — 기본 키 — NOT NULL
- Field (aName) — char(30)
- Field (aBdate) — date
- Field (aAddress) — char(50)
- Field (aPhonenumber) — char(13)
Untitled (PUBLISHER)
- Key (pID) — char(30) — 기본 키 — NOT NULL
- Field (pName) — char(30)
- Field (pAddress) — char(30)
- Field (pPhonenumber) — char(13)
- Field (pOwner) — char(30)
Untitled (BOOK_AUTHOR)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (ssn) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOKKEYWORD)
- Key (kID) — int(3) — 기본 키 — NOT NULL
- Field (kWord) — char(10)