Sign up topics: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
(Created page with "''A table description is required'' ==Sign Up Topics variable documentation== {| class="wikitable" !Field Name !!Type !!Description |- !id |int(11) |The unique record id |- !...")
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
''A table description is required''
The Sign Up Topics table gives information regarding topics that are associated to a particular assignment.
 
== Sign Up Topics Variable Documentation ==
==Sign Up Topics variable documentation==


{| class="wikitable"  
{| class="wikitable"  
!Field Name !!Type !!Description  
!Name !!Datatype !!Description !
|-
|-  
!id
!id
|int(11)
|The unique record id
|-
!topic_name
|text
|''The name of the topic that teams can sign up for''
|-
!assignment_id
|int(11)
|''The assignment to which this topic applies''
|-
!max_choosers
|int(11)
|int(11)
|''The number of slots for this topic, i.e., the max number of teams that can be signed up for the topic at once without any of them being waitlisted''
|Unique ID for each of the record. Primary Key
|-
|-
!category
!topic_name 
|text
|text 
|''Topics can be classified into categories; this is optional, so the category field is often blank''
|Name of the topic.
|-
|-
!topic_identifier
!assignment_id 
|varchar(10)
|int(11) 
|''A short number or tag for the topic, e.g., "E803"''
|ID of the assignment the topic is associated with.
|-
|-
!start_date
!max_choosers 
|datetime
|int(11) 
|''I think this is unused, though it might have something to do with due dates''
|Number of teams that can acquire this topic.
|-
|-  
!due_date
!category
|datetime
|text
|''Since the topic has more than one due date (submission, review, etc.), I (efg) do not think this is used.''
|Category this topic belongs to.
|-  
!topic_identifier
|varchar(10)
|Number or short name of this topic, e.g., E1915.
|-  
!micropayment 
|int(11) 
|Micropayment value for the topic. ********************
|-
!private_to 
|int(11) 
|ID of the User this topic is private to.
|-  
!description 
|text 
|Description of the Topic.
|-
!link 
|varchar(255)
|URL of the Topic Details Page.
|}
|}


Back to the [[Documentation_on_Database_Tables|database documentation]]
== E/R diagram for Parents Tables ==
Tables referred by the Sign Up Topics Table as Foreign Key Relationship.
 
[[File:sign_up_topics_imported.png]]
 
 
 
== E/R diagram for Child Tables ==
Tables referred by the Sign Up Topics Table as Foreign Key Relationship.
 
[[File:sign_up_topics_exported.png]]
 
 
 
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Latest revision as of 01:44, 4 October 2024

The Sign Up Topics table gives information regarding topics that are associated to a particular assignment.

Sign Up Topics Variable Documentation

Name Datatype Description !
id int(11) Unique ID for each of the record. Primary Key
topic_name text Name of the topic.
assignment_id int(11) ID of the assignment the topic is associated with.
max_choosers int(11) Number of teams that can acquire this topic.
category text Category this topic belongs to.
topic_identifier varchar(10) Number or short name of this topic, e.g., E1915.
micropayment int(11) Micropayment value for the topic. ********************
private_to int(11) ID of the User this topic is private to.
description text Description of the Topic.
link varchar(255) URL of the Topic Details Page.

E/R diagram for Parents Tables

Tables referred by the Sign Up Topics Table as Foreign Key Relationship.


E/R diagram for Child Tables

Tables referred by the Sign Up Topics Table as Foreign Key Relationship.


Back to Database Tables Main page.

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Sign_up_topics&oldid=157229"