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