꼬끼오

테이블 (17)

Copy Of Copy Of Untitled22 (contents_supplier)

  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (type)

  • Key (typeID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)

Untitled (contents_member)

  • Key (memberID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (member)

  • Key (memberID) — int(30) — 기본 키 — NOT NULL
  • Field (ssn) — int(13)
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — int(11)
  • Field (enrollDate) — date

Untitled (supplier_type)

  • Key (supplierID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (typeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (contents_type)

  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (typeID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (contents_kdc)

  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (kdcCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (kdc)

  • Key (kdcCode) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)

Untitled (contents_genre)

  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subjectID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (genre)

  • Key (genreID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)

Untitled (work)

  • Key (workID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(50)

Untitled (person)

  • Key (personID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (role) — char(20)
  • Field (gender) — char(10)
  • Field (nationality) — char(30)

Untitled (contents_person)

  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (personID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (work_author)

  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (supplier)

  • Key (supplierID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (department) — char(10)
  • Field (depPhone) — int(11)
  • Field (grade) — int(3)

Untitled (author)

  • Key (authorID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (nationality) — char(30)

Untitled (contents)

  • Key (ID) — char(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (episode) — int(4)
  • Field (uci) — char(30)
  • Field (isbn) — char(13)
  • Field (ageLimit) — int(3)
  • Field (capacity) — int(3)
  • Field (isuueYear) — int(4)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL