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