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
editsub_id
editPrimary key for the table.
sub_author_id
editForeign key to the speakers table(speaker_id). More than one rows in this table can point to the same speaker_id.
sub_title
editThe title of the proposal as set by the speaker.
sub_type
editThe type of the proposal. It would be one of the following values (workshop,presentation,tutorial,panel)
abstract
editThe abstract for the proposal.
track
editThe track type it belongs to.
length
editThe length of the presentation ( in mins).
slides_info
editExtra information about the slides.
slot_req
editSome preference for the slot
sub_ref_id
editReferences 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
editDESCRIBE 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 | | +-----------------------+---------------------+------+-----+---------+----------------+