football
Tables (13)
chat_messages
- id — BIGSERIAL
- chat_room_id — BIGINT
- user_id — BIGINT
- message — TEXT
- created_at — TIMESTAMP — NOT NULL
chat_rooms
- id — BIGSERIAL
- draft_room_id — BIGINT
draft_picks
- id — BIGSERIAL
- draft_room_id — BIGINT
- user_id — BIGINT
- player_id — INTEGER
- pick_order — INTEGER
- picked_at — TIMESTAMP — NOT NULL
draft_room_users
- draft_room_id — BIGINT
- user_id — BIGINT
- joined_at — TIMESTAMP — NOT NULL
draft_rooms
- id — BIGSERIAL
- round_no — INTEGER — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
element_types
- id — INTEGER
- singular_name — VARCHAR(20)
- plural_name — VARCHAR(20)
- short_name — VARCHAR(5)
formations
- id — BIGSERIAL
- draft_room_id — BIGINT
- user_id — BIGINT
- lineup — JSONB
- created_at — TIMESTAMP — NOT NULL
match_events
- id — BIGSERIAL
- player_id — INTEGER
- round_no — INTEGER
- type — VARCHAR(20)
- minute — INTEGER
- raw_data — JSONB
- created_at — TIMESTAMP — NOT NULL
notifications
- id — BIGSERIAL
- draft_room_id — BIGINT
- user_id — BIGINT
- event_id — BIGINT
- type — VARCHAR(20)
- payload — JSONB
- sent_at — TIMESTAMP — NOT NULL
players
- id — INTEGER
- web_name — VARCHAR(50)
- team_id — INTEGER
- element_type_id — INTEGER
- now_cost — INTEGER
- status — CHAR(1)
- news — TEXT
round_results
- id — BIGSERIAL
- draft_room_id — BIGINT
- user_id — BIGINT
- score — INTEGER
- computed_at — TIMESTAMP — NOT NULL
teams
- id — INTEGER
- name — VARCHAR(50) — NOT NULL
- short_name — VARCHAR(10)
- unavailable — BOOLEAN — NOT NULL
users
- id — BIGSERIAL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL