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