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