cinema

Tables (6)

Untitled (screen)

  • Key (no) — TINYINT UNSIGNED — Primary key — NOT NULL
  • id (theater_id) — SMALLINT UNSIGNED — Foreign key → theater.id — NOT NULL
  • Field (total_row) — TINYINT UNSIGNED — NOT NULL
  • Field (total_column) — TINYINT UNSIGNED — NOT NULL

Untitled (unselectable_seat)

  • Key (row) — TINYINT UNSIGNED — Primary key — NOT NULL
  • Key2 (column) — TINYINT UNSIGNED — Primary key — NOT NULL
  • Key (screen_no) — TINYINT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • id (theater_id) — SMALLINT UNSIGNED — Foreign key → Untitled.id — NOT NULL
  • Key (unselectable_seat_type_id) — TINYINT UNSIGNED — Foreign key → Untitled.Key — NOT NULL

Untitled (unselectable_seat_type)

  • Key (id) — TINYINT UNSIGNED — Primary key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL

Untitled (aisle)

  • Key (no) — TINYINT UNSIGNED — Primary key — NOT NULL
  • Key (screen_no) — TINYINT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
  • id (theater_id) — SMALLINT UNSIGNED — Foreign key → Untitled.id — NOT NULL
  • Key (aisle_type_id) — TINYINT UNSIGNED — Foreign key → Untitled.Key — NOT NULL

Untitled (aisle_type)

  • Key (id) — TINYINT UNSIGNED — Primary key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL

theater

  • id — SMALLINT UNSIGNED — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • street_address — VARCHAR(200) — NOT NULL
  • google_maps_place_id — VARCHAR(1000)
  • subway — VARCHAR(1000)
  • bus — VARCHAR(1000)
  • car — VARCHAR(1000)
  • parking — VARCHAR(1000)