stadiums
Tables (6)
blocks (Untitled4)
- Block ID (block_id) — INT — Primary key — NOT NULL
- Zone ID (zone_id) — INT — Foreign key → zones.Zone ID — NOT NULL
- Stadium ID (stadium_id) — INT — Foreign key → zones.Stadium ID — NOT NULL
- Block Number (block_num) — INT
- RAIN YN (rain_yn)
price (Untitled6)
- Price ID (price_id) — INT — Primary key — NOT NULL
- Zone ID (zone_id) — INT — Foreign key → zones.Zone ID — NOT NULL
- Stadium ID (stadium_id) — INT — Foreign key → zones.Stadium ID — NOT NULL
- Price Type (price_type) — VARCHAR
- Price (price) — INT
review (Untitled5)
- Review ID (rev_id) — INT — Primary key — NOT NULL
- Seat ID (seat_id) — INT — Foreign key → seats.Seat ID — NOT NULL
- Block ID (block_id) — INT — Foreign key → seats.Block ID — NOT NULL
- Zone ID (zone_id) — INT — Foreign key → seats.Zone ID — NOT NULL
- Stadium ID (stadium_id) — INT — Foreign key → seats.Stadium ID — NOT NULL
- Sight (rev_sight) — INT
- Participation (rev_participation) — INT
- Convenience (rev_convenience) — INT
- Average (rev_avg) — INT
seats (Untitled3)
- Seat ID (seat_id) — INT — Primary key — NOT NULL
- Block ID (block_id) — INT — Foreign key → blocks.Block ID — NOT NULL
- Zone ID (zone_id) — INT — Foreign key → blocks.Zone ID — NOT NULL
- Stadium ID (stadium_id) — INT — Foreign key → blocks.Stadium ID — NOT NULL
- Seat Number (seat_num)
stadium (Untitled2)
- Stadium ID (stadium_id) — INT — Primary key — NOT NULL
- Stadium Name (stadium_name) — VARCHAR
- Stadium Location (stadium_location) — VARCHAR
- Home Team (home_team) — VARCHAR
- Field
zones (Untitled)
- Zone ID (zone_id) — INT — Primary key — NOT NULL
- Stadium ID (stadium_id) — INT — Foreign key → stadium.Stadium ID — NOT NULL
- Zone Name (zone_name) — VARCHAR