fms2

Tables (9)

chat

  • id — INT — Primary key — NOT NULL
  • content — TEXT
  • match_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

location

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

match

  • id — INT — Primary key — NOT NULL
  • date — DATE
  • time — TIME
  • team_id — INT
  • weather_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

notification

  • id — INT — Primary key — NOT NULL
  • content — TEXT
  • user_id — INT
  • team_id — INT
  • match_id — INT
  • chat_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

player

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • position — VARCHAR(50)
  • team_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

team

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • logo_url — VARCHAR(255)
  • location_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

tournament

  • id — INT
  • name — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

user

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • age — INT
  • weight — DECIMAL(5, 2)
  • height — DECIMAL(5, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

weather

  • id — INT — Primary key — NOT NULL
  • condition — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP