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 |- !...")
 
No edit summary
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)
|int(11)
|The unique record id
|Unique ID for each of the session. Primary Key
|-
|-  
!topic_name
!topic_name
|text
|text
|''The name of the topic that teams can sign up for''
|Name of the topic.
|-
|-  
!assignment_id
!assignment_id
|int(11)
|int(11)
|''The assignment to which this topic applies''
|ID of the assignment the topic is associated with.
|-
|-  
!max_choosers
!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''
|Number of people that can take this particular topic.
|-
|-  
!category
!category
|text
|text
|''Topics can be classified into categories; this is optional, so the category field is often blank''
|Category this topic belongs to.
|-
|-  
!topic_identifier
!topic_identifier
|varchar(10)
|varchar(10)
|''A short number or tag for the topic, e.g., "E803"''
|Identifier for each of the topics.
|-
|-
!start_date
!micropayment 
|datetime
|int(11) 
|''I think this is unused, though it might have something to do with due dates''
|Micropayment value for the topic. ********************
|-
|-  
!due_date
!private_to 
|datetime
|int(11) 
|''Since the topic has more than one due date (submission, review, etc.), I (efg) do not think this is used.''
|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.
 
[[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 the [[Documentation_on_Database_Tables|database documentation]]
Back to [http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables Database Tables] Main page.

Revision as of 00:05, 25 April 2018

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 session. 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 people that can take this particular topic.
category text Category this topic belongs to.
topic_identifier varchar(10) Identifier for each of the topics.
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=116855"