기말과제
테이블 (10)
Untitled (PERSON)
- Key (pID) — char(12) — 기본 키 — NOT NULL
- Field (pName) — char(20)
- Field (pContact) — char(50)
- Field (pBirthYear) — year
- Field (pGender) — char(1)
Untitled (CULTURE_INFO)
- Key (ciID) — char(10) — 기본 키 — NOT NULL
- Field (ciTitle) — char(50)
- Field (ciDiv) — char(10)
- Field (ciGenre) — char(10)
- Field (ciStartDate) — date
- Field (ciEndDate) — date
- Field (ciTime) — time
- Field (ciRunningTime) — time
- Field2 (ciPlace) — char(30)
- Field (ciPrice) — int(6)
- Field (ciDescription) — text
- Key (istID) — char(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (LIFE_FRIENDLY_INFO)
- Key (lfiID) — char(10) — 기본 키 — NOT NULL
- Field (lfiTitle) — char(50)
- Field (lfiDiv) — char(10)
- Field (lfiTarget) — char(10)
- Field (lfiDescription) — texxt
- Field (lfiStartDate) — date
- Field (lfiEndDate) — date
- Key (istID) — char(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (LIB_COLLECTION)
- Key (lcID) — char(12) — 기본 키 — NOT NULL
- Field (lcTitle) — char(50)
- Field (lcISBN) — char(13)
- Field (lcPublishedYear) — year
- Field (lcEdition) — char(10)
- Field (lcPrinting) — int(3)
- Field (lcCallNumber) — char(20)
- Field (lcPrice) — int(7)
- Field (lcKDC6Code) — char(20)
Untitled (INSTITUTION)
- Key (istID) — char(6) — 기본 키 — NOT NULL
- Field (istName) — char(50)
- Field (istContactPhone) — char(20)
- Field (istWebAddress) — char(50)
- Field (istAddress) — char(50)
- Field (istContactFax) — char(20)
Untitled (AUTHOR)
- Key (lcID) — char(12) — 외래 키 → Untitled.Key — NOT NULL
- Key (pID) — char(12) — 외래 키 → Untitled.Key — NOT NULL
- Field (roles) — char(10)
Untitled (CI_SUBJECT)
- Key (ciID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (sbjID) — char(13) — 외래 키 → Untitled4.Key — NOT NULL
Untitled2 (LFI_SUBJECT)
- Key (lfiID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (sbjID) — char(13) — 외래 키 → Untitled4.Key — NOT NULL
Untitled3 (LC_SUBJECT)
- Key (lcID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Key (sbjID) — char(13) — 외래 키 → Untitled4.Key — NOT NULL
Untitled4 (SUBJECT_DSCRT)
- Key (sbjID) — char(13) — 기본 키 — NOT NULL
- Field (sbjName) — char(30)