Footprints Data Model

Table
Name agent_team
Comment The list of Agent team members for a given team.

Column
Name Datatype Comment Is PK Is FK
agent_team_id bigint The automatically generated primary key of the agent_team table. Yes No
team_id bigint A Foreign Key to the Team table. No Yes
gets_individual_asgnmt_for_tea bit
Indicates if this Agent Team() row is logically deleted.

Igor S asked that this be nullable, and has not been able to find a place in
the current Java code where it is being set at all. If the column will be used
in the future a null can mean false, or the code can be changed to explicily set
it to false.
dnoble 12-4-12
No No
app_user_id bigint A Foreign Key to the Application User table. No Yes