KFA

Tables (4)

Accommodation (Untitled2)

  • AccommodationKey — Primary key — NOT NULL
  • HotelName
  • Contact
  • Capacity — Integer
  • Field
  • CompetitionKey — Foreign key → competition.CompetitionKey — NOT NULL
  • SportVenueKey — Foreign key → SportVenue.SportVenueKey — NOT NULL

Game

  • GameKey — Primary key — NOT NULL
  • GameName

SportVenue (Untitled)

  • SportVenueKey — Primary key — NOT NULL
  • VenueName (VenueNM) — TEXT
  • Location — TEXT
  • FunctionRoom
  • Contact — NUMBER
  • Capacity — INTEGER

competition (Untitled3)

  • CompetitionKey — Primary key — NOT NULL
  • CompetitionName — NOT NULL
  • CompetitionOverview
  • CompetitionScheduleStart — Date — NOT NULL
  • CompetitionScheduleEnd — Date — NOT NULL
  • SportVenueKey — Foreign key → SportVenue.SportVenueKey — NOT NULL
  • Field