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