Signed up teams: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
The Signed Up Teams table gives information regarding teams that are Signed Up. | The Signed Up Teams table gives information regarding teams that are Signed Up. | ||
== Signed Up Teams Variable Documentation == | == Signed Up Teams Variable Documentation (Reimplementation) == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Name !!Datatype !!Description ! | !Name !!Datatype !!Description ! | ||
|- | |- | ||
! | !id | ||
|int(11) | |int(11) | ||
|Unique ID for each of the record. Primary Key | |Unique ID for each of the record. Primary Key | ||
|- | |- | ||
! | !topic_id | ||
|int(11) | |int(11) | ||
|ID of the topic the team is associated with. | |ID of the topic the team is associated with. | ||
|- | |- | ||
! | !team_id | ||
|int(11) | |int(11) | ||
|ID of the team. | |ID of the team. | ||
|- | |- | ||
! | !is_waitlisted | ||
|tinyint(1) | |tinyint(1) | ||
|Boolean Field to indicate whether the team is waitlisted or not. | |Boolean Field to indicate whether the team is waitlisted or not. | ||
|- | |- | ||
! | !preference_priority_number | ||
|int(11) | |int(11) | ||
|Priority level for this Topic assigned by the team. | |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) == | |||
{| class="wikitable" | |||
!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 == | == E/R diagram for Parents Tables == | ||
Latest revision as of 03:41, 9 December 2025
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.