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.