기말과제

테이블 (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)