과제

테이블 (5)

Untitled (movie)

  • Key (code) — bigint — 기본 키 — NOT NULL
  • Field (subject) — varchar(255)
  • Field2 (yearOfManufacture) — YEAR(4)
  • Field (countryOfOrigin) — varchar(255)
  • Field (showTime) — varchar(255)
  • Field (openingDate) — datetime(6)
  • Field (producer) — varchar(255)
  • Field (distributor) — varchar(255)

Untitled (director)

  • Key (code) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (gender) — bit(1)
  • Field (birthDate) — datetime(6)
  • Field (birthPlace) — varchar(255)
  • Field (educationalHistory) — varchar(255)

Untitled (actor)

  • Key — bigint — 기본 키 — NOT NULL
  • Field (birthDate) — datetime(6)
  • 이름 (name) — varchar(255)
  • Field3 (gender) — bit(1)
  • Field4 (birthPlace) — varchar(255)
  • Field5 (stature) — varchar(255)
  • Field6 (weight) — varchar(255)
  • Field6 (bloodType) — varchar(10)

Untitled (영화 배역정보)

  • Key (code) — bigint — 기본 키 — NOT NULL
  • Key (movieCode) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (actorCode) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (role) — varchar(255)

Untitled (영화 감독정보)

  • Key (code) — bigint — 기본 키 — NOT NULL
  • Key (movieCode) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (directorCode) — bigint — 외래 키 → Untitled.Key — NOT NULL