User:Chughakshay16/submissions
The submissions table holds the information of all the proposals submitted during the conference. A speaker can have more than one submissions for a particular conference. Speaker is supposed to register just once, and then he/she can submit as many proposals he/she can.
Fields
[edit]sub_id
[edit]Primary key for the table.
sub_author_id
[edit]Foreign key to the speakers table(speaker_id). More than one rows in this table can point to the same speaker_id.
sub_title
[edit]The title of the proposal as set by the speaker.
sub_type
[edit]The type of the proposal. It would be one of the following values (workshop,presentation,tutorial,panel)
abstract
[edit]The abstract for the proposal.
track
[edit]The track type it belongs to.
length
[edit]The length of the presentation ( in mins).
slides_info
[edit]Extra information about the slides.
slot_req
[edit]Some preference for the slot
sub_ref_id
[edit]References the page_id(page table) which holds the information about this submission.Its a wiki page but all its displayed information will be fetched from this table.
Note: This field cant be empty , If a submission page is deleted then its corresponding entry here should be deleted as well.
Schema summary
[edit]DESCRIBE submissions; :
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | sub_id | int(8) unsigned | NO | PRI | NULL | auto_increment | | sub_author_id | int(8) unsigned | NO | UNI | NULL | | | sub_title | varbinary(255) | NO | UNI | NULL | | | sub_type | varchar(15) | NO | | NULL | | | sub_track | varchar(25) | NO | | NULL | | | sub_abstract | blob | NO | | NULL | | | sub_length | int(3) unsigned | NO | | 25 | | | sub_slides_info | blob | NO | | NULL | | | sub_slot_req | int(8) unsigned | NO | | NULL | | | sub_ref_id | int(8) unsigned | NO | UNI | NULL | | +-----------------------+---------------------+------+-----+---------+----------------+