dx_snapshot_teams
History of teams at the time a snapshot occurred.
-
id
Primary key - Unique identifier for the row.
-
source_id
Foreign key - DX ID of the snapshot team.
-
source_parent_id
Foreign key - DX ID of the parent to this team.
-
snapshot_id
Foreign key - ID of the snapshot associated with this snapshot team.
-
team_id
Foreign key - ID of the dx team associated with this snapshot team.
-
name
string - Name of the team.
-
parent
boolean - Boolean indicating if this is a parent team.
-
flattened_parent
string - String showing a hierarchy of the parents preceding this team. i.e. "ALL » Sub-Team » Sub-Sub-Team".
-
contributors
number - Count of contributors on the team.
-
participation_rate
number - Rate of snapshot participation for this team. 1 is 100%, 0.93 is 93%, etc.