GFL Global Football League

Backend Preview

Model the content before locking the database.

The frontend now shows the shape of teams, rosters, news categories, draft picks, trades, gameplans, and admin access. The next backend pass can turn the proven structures into editing tools.

Content model preview

Publish League Post

Create official releases, retroactive archive posts, team notices, draft reports, and recaps.

Current priority

Manage Team Records

Edit franchise identity, colors, ownership, status, alignment, stadiums, and profile completion.

Next priority

Manage Draft Room

Edit pick ownership, prospects, trades, selections, and public draft board states.

Private workflow planned

Collect Gameplans

Receive private owner submissions before the commissioner resolves games.

Commissioner-only later

Post Results

Publish winners, scores, summaries, and play-by-play without exposing the engine.

Access Model

Three roles, clean boundaries.

Super Admin owns the site. Admin owns the game operation. Manager owns only assigned-team updates and private gameplan submissions.

Site Admin

Super Admin

Owns the website, publishing system, user access, and public data structure without needing access to the secret game engine.

Audience
You and any future trusted site operators
Scope
Global site control

Permissions

  • Site settings and deployments site

    Control public navigation, feature flags, environment setup, and Cloudflare deployment settings.

  • User and role administration site

    Invite users, assign roles, connect managers to owned teams, and remove stale access.

  • Publish league content league

    Create and edit public news, retroactive archive posts, event updates, and team releases.

  • Manage franchise records league

    Edit canonical team identity, status, ownership, colors, divisions, stadiums, and public profiles.

  • Manage draft room league

    Edit prospects, pick ownership, trade chains, draft order, selection status, and public board toggles.

  • Publish results league

    Turn private resolutions into public scores, recaps, standings changes, and official records.

Restrictions

  • Does not see proprietary game-resolution mechanics unless also assigned Admin.
  • Does not impersonate managers or rewrite private gameplans as that manager.
Game Admin

Admin

Controls the confidential football operation: gameplan intake, rolls, mechanics, outcomes, and official result publishing.

Audience
Commissioner or league head running games
Scope
Commissioner game operations

Permissions

  • Manage draft room league

    Edit prospects, pick ownership, trade chains, draft order, selection status, and public board toggles.

  • Review submitted gameplans game

    Open private weekly manager submissions for games the commissioner is resolving.

  • Resolve games game / proprietary

    Run commissioner-only game mechanics, rolls, outcomes, and internal result notes.

  • Publish results league

    Turn private resolutions into public scores, recaps, standings changes, and official records.

  • Publish league content league

    Create and edit public news, retroactive archive posts, event updates, and team releases.

Restrictions

  • Does not change deployment settings or global role assignments by default.
  • Keeps proprietary mechanics private from managers and public pages.
Team Manager

Manager

Self-service access for an assigned franchise: public profile updates, team-release drafts, and weekly gameplan submissions.

Audience
Friend-league team owners
Scope
Assigned team only

Permissions

  • Edit owned team team

    Update approved public fields for the manager's assigned franchise only.

  • Submit gameplan team

    Send private weekly gameplan choices to the commissioner before lock.

  • Propose team news team

    Draft team statements, quotes, and releases for site-admin or commissioner approval.

Restrictions

  • Can edit only teams explicitly assigned to their account.
  • Cannot view other managers' private gameplans, commissioner notes, or resolution mechanics.
  • Cannot publish directly to league-wide pages without approval.

Auth-Backed Tables

The admin foundation now has persistence.

These records support real login-backed permissions once a session provider is connected. Until then, this page remains a public blueprint while protected writes wait behind route guards.

users

Stores site accounts, provider identity, display name, status, and last login.

user_roles

Stores Super Admin, Admin, and Manager role grants with assignment and revocation dates.

team_manager_assignments

Connects manager accounts to the specific franchises they can edit or submit for.

admin_audit_log

Records important admin actions across users, teams, draft changes, results, and settings.

Manager Guardrails

Team edits need an allowlist.

Manager accounts should be connected to one or more assigned franchises and limited to public-facing fields. Roster changes, draft assets, results, standings, and game mechanics stay under Admin or Super Admin control.

Manager-editable team fields

  • ownerName
  • coachName
  • generalManagerName
  • stadiumName
  • stadiumCity
  • shortDescription
  • logoUrl
  • wordmarkUrl

Next Backend Step

Team records come first.

Teams are the root records for rosters, draft picks, trades, news, standings, gameplans, and future results. This admin surface establishes the fields before we turn them into editable database-backed forms.

Team model fields

  • id
  • slug
  • displayName
  • abbreviation
  • status
  • profileState
  • foundedSeason
  • joinedLeagueSeason
  • ownerName
  • conferenceId
  • divisionId
  • primaryColor
  • secondaryColor
  • textColor
  • stadiumName
  • shortDescription

Structured Teams

Franchise records admin preview.

19 franchise records are defined. 16 have full public-profile data, while 3 are placeholders waiting on imported context or league-office updates.

TeamAbbrStatusProfileOwnerAlignmentColorsSeasons
Los Angeles Devils los-angeles-devilsLADactivecompleteBill Moranwestern north-american#e935352181
New York Towers new-york-towersNYTactivecompleteJohno / Locke LaMoranwestern north-american#9aa1aa2181
Toronto Frost toronto-frostTORactiveplaceholderTBDwestern north-american#9fe8ff2181
Chicago Wolves chicago-wolvesCHIactiveplaceholderTBDwestern north-american#7e87942181
Buenos Aires Condors buenos-aires-condorsBUEactivecompleteJason Morganwestern ocean#71c7ec2181
Tokyo Steel tokyo-steelTOKactivecompleteKarlwestern ocean#d923232181
Seoul White Tigers seoul-white-tigersSEOactivecompleteLeague Officewestern ocean#f4f4f42181
Sydney Swagmen sydney-swagmenSYDactivecompleteLeague Officewestern ocean#f0c64c2181
Dublin Shamrocks dublin-shamrocksDUBactivecompleteLindsay Howelleastern ancients#1fb5632181
Cairo Scarabs cairo-scarabsCAIactivecompleteJustin Ramseyeastern ancients#c99b372181
Paris Revolution paris-revolutionPARactivecompleteLeague Officeeastern ancients#3d92d92181
London Lions london-lionsLONactivecompleteLeague Officeeastern ancients#1d5f8f2181
Oslo Vikings oslo-vikingsOSLdefunctplaceholderTBDeastern central#7aa2ff2181 Exited 2182
Cape Town Great White cape-town-great-whiteCAPactivecompleteLiameastern central#45d1df2181
Moscow Red Army moscow-red-armyMOSactivecompleteLeague Officeeastern central#cc20292181
Amsterdam Galleons amsterdam-galleonsAMSactivecompleteLeague Officeeastern central#f27f2f2181
Auckland Jade auckland-jadeAUKpromotedcompleteEd Pfaffdraft 2182-entrant#33b66a2182
Anchorage Orcas anchorage-orcasANCexpansioncompleteLeague Officedraft 2182-entrant#8bd3ff2182
Bratislava Oathbound bratislava-oathboundBRAexpansioncompleteLeague Officedraft 2182-entrant#9a78ff2182

News Categories

Team records will connect to posts next.

Once teams are editable, news can attach to one or more franchise records while still keeping league-office and commissioner categories available.

News categories

  • League Office
  • Global Bowl
  • Draft
  • Transactions
  • Team Release
  • Game Preview
  • Commissioner Notes

Gameplan Form Shape

Nine points owners submit each week.

01

Base offensive strategy for first half

02

Special offensive notations

03

Base defensive strategy for first half

04

Special defensive notations

05

Offensive change if ahead in second half

06

Offensive change if behind in second half

07

Defensive change if ahead in second half

08

Defensive change if behind in second half

09

Unusual notes and optional ownership favor