중간고사
테이블 (6)
Book_Subject (Untitled2)
- Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
- subID (Key) — int — 외래 키 → Subject.subID — NOT NULL
Subject (Untitled)
- subID (Key) — int — 기본 키 — NOT NULL
- KDCNumber (Field) — int
- subKeyword (Field2) — char(20)
Untitled (Publisher)
- Key (pubID) — int — 기본 키 — NOT NULL
- Field (pubName) — char(20)
- Field (pubAddress) — text
Untitled (Book)
- Key (ISBN) — int — 기본 키 — NOT NULL
- Field (booTitle) — char(30)
- Field (booPublicationDate) — date
- Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Author)
- Key (AutID) — int — 기본 키 — NOT NULL
- Field (autName) — char(20)
- Field (autAddress) — text
Untitled (Book_Author)
- Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (AutID) — int — 외래 키 → Untitled.Key — NOT NULL