Signed up teams

From Expertiza_Wiki
Jump to navigation Jump to search

The Signed Up Teams table gives information regarding teams that are Signed Up.

Signed Up Teams Variable Documentation (Reimplementation)

Name Datatype Description !
id   int(11) Unique ID for each of the record. Primary Key
topic_id   int(11)   ID of the topic the team is associated with.
team_id   int(11)   ID of the team.
is_waitlisted  tinyint(1)   Boolean Field to indicate whether the team is waitlisted or not. 
preference_priority_number   int(11)   Priority level for this Topic assigned by the team.
comments_for_advertisement TEXT Comments provided by the team regarding the advertisement for partners.
advertising_for_partner BOOLEAN Indicates whether the team is currently advertising for a partner.

Signed Up Teams Variable Documentation (2023 version)

Name Datatype Description !
id   int(11) Unique ID for each of the record. Primary Key
topic_id   int(11)   ID of the topic the team is associated with.
team_id   int(11)   ID of the team.
is_waitlisted  tinyint(1)   Boolean Field to indicate whether the team is waitlisted or not. 
preference_priority_number   int(11)   Priority level for this Topic assigned by the team.

E/R diagram for Parents Tables

Tables referred by the Signed Up Teams Table as Foreign Key Relationship.


E/R diagram for Child Tables

No Tables were referred by the Signed Up Teams Table as Foreign Key Relationship.


Back to Database Tables Main page.