Footprints Data Model

Table
Table Name Agent Team
Table Definition The list of Agent team members for a given team.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Agent Team Id The automatically generated primary key of the agent_team table. LONG Yes
Team Id A Foreign Key to the Team table. LONG Yes
Gets Individual Assignment for Team 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 BOOLEAN No
Application User Id A Foreign Key to the Application User table. LONG No