Footprints Data Model

Table
Table Name Team
Table Definition A team is a group of application users that can be used in Team level assignments.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Team Id The automatically generated primary key of the team table. LONG Yes
Team Name The name of the Team. VARCHAR(255) No
Team Email Notification Type Id A Foreign Key to the Team Email Notification Type table. INTEGER No
Team Lead Application User Id A Foreign Key to the Application User table. LONG No
Workspace Definition Id A Foreign Key to the Definition table. LONG Yes