색인초록 기말

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