색인초록 기말
테이블 (8)
Untitled (audience)
- Key (audid) — int — 기본 키 — NOT NULL
- Field (name) — VARCHAR(10)
- Field (phone) — VARCHAR(13)
- Field (email) — TEXT
- Field (addres) — TEXT
Untitled (musical work)
- Key (musicalid) — VARCHAR(3) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(20)
- Field (production date) — VARCHAR(10)
- Field (genre) — VARCHAR(10)
- Field (runtime) — int
Untitled (ticket booking)
- Key (audid) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (musicalid) — VARCHAR(3) — 외래 키 → Untitled.Key — NOT NULL
- Field (booking date) — VARCHAR(10)
- Field (episord) — int
Untitled (musical_dir)
- Key (musicalid) — VARCHAR(3) — 외래 키 → Untitled.Key — NOT NULL
- Key (dirid) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (role) — VARCHAR(10)
Untitled (director)
- Key (dirid) — int — 기본 키 — NOT NULL
- Field (name) — VARCHAR(10)
- Field (nationality) — VARCHAR(10)
Untitled (debut information)
- Key (debutinforid) — int — 기본 키 — NOT NULL
- Field (debutplace) — VARCHAR(30)
- Field (production company) — VARCHAR(30)
- Key (musicalid) — VARCHAR(3) — 외래 키 → Untitled.Key — NOT NULL
Untitled (casting)
- Key (musicalid) — VARCHAR(3) — 외래 키 → Untitled.Key — NOT NULL
- Key (actid) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (role) — VARCHAR(10)
Untitled (actor)
- Key (actid) — int — 기본 키 — NOT NULL
- Field (name) — VARCHAR(10)
- Field (birth) — VARCHAR(10)
- Field (nationality) — VARCHAR(10)