Footprints Data Model |
Table |
Name | team |
Comment |
A team is a group of application users that can be used in Team level assignments. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
team_id | bigint | The automatically generated primary key of the team table. | Yes | No |
team_name | varchar(255) | The name of the Team. | No | No |
wksp_defn_id | bigint | A Foreign Key to the Definition table. | No | Yes |
team_email_notifn_type_id | int | A Foreign Key to the Team Email Notification Type table. | No | Yes |
team_lead_app_user_id | bigint | A Foreign Key to the Application User table. | No | Yes |