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)