sqlite-web 0.7.2
bobifantasy.db
player_stats
Create
Query
__drizzle_migrations
competitions
draft_bids
draft_tokens
drafts
manager_budgets
managers
matchdays
matches
player_stats
players
scores
sqlite_sequence
standings
team_selections
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into player_stats
match_id
INTEGER NOT NULL
player_id
INTEGER NOT NULL
minutes_played
INTEGER NOT NULL (default 0)
was_starter
INTEGER NOT NULL (default false)
api_rating
REAL
goals
INTEGER NOT NULL (default 0)
assists
INTEGER NOT NULL (default 0)
key_passes
INTEGER NOT NULL (default 0)
penalty_missed
INTEGER NOT NULL (default 0)
penalty_won
INTEGER NOT NULL (default 0)
saves
INTEGER NOT NULL (default 0)
penalty_saved
INTEGER NOT NULL (default 0)
clean_sheet
INTEGER NOT NULL (default false)
goals_conceded
INTEGER NOT NULL (default 0)
tackles
INTEGER NOT NULL (default 0)
interceptions
INTEGER NOT NULL (default 0)
clearances
INTEGER NOT NULL (default 0)
yellow_cards
INTEGER NOT NULL (default 0)
red_cards
INTEGER NOT NULL (default 0)
second_yellow
INTEGER NOT NULL (default 0)
own_goals
INTEGER NOT NULL (default 0)
fouls_committed
INTEGER NOT NULL (default 0)
fetched_at
TEXT (default datetime('now'))
Insert
Cancel