fms
Tables (9)
chat
- id — INT
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
location
- id — INT
- name — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
match
- id — INT — Primary key — NOT NULL
- date — DATE
- time — TIME
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
notification
- id — INT
- content — TEXT
- 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
- condition — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP