Sign up topics: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 7: | Line 7: | ||
!id | !id | ||
|int(11) | |int(11) | ||
|Unique ID for each of the | |Unique ID for each of the record. Primary Key | ||
|- | |- | ||
!topic_name | !topic_name | ||
| Line 44: | Line 44: | ||
|varchar(255) | |varchar(255) | ||
|URL of the Topic Details Page. | |URL of the Topic Details Page. | ||
|} | |} | ||
== E/R diagram for Parents Tables == | == E/R diagram for Parents Tables == | ||
Revision as of 00:08, 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 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 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.