Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: quiz
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
quiz.ci_sessions
quiz.class_coment
quiz.class_gid
quiz.live_class
quiz.savsoft_answers
quiz.savsoft_category
quiz.savsoft_feed
quiz.savsoft_group
quiz.savsoft_level
quiz.savsoft_notification
quiz.savsoft_options
quiz.savsoft_payment
quiz.savsoft_qbank
quiz.savsoft_qcl
quiz.savsoft_quiz
quiz.savsoft_result
quiz.savsoft_users
Number of tables: 17
v quiz ci_sessions
* id : varchar(40)
* ip_address : varchar(45)
* data : text
* timestamp : timestamp
v quiz class_coment
* content_id : int(11)
* generated_time : int(11)
* content : longtext
* content_by : int(11)
* published : int(11)
* class_id : int(11)
v quiz class_gid
* clgid : int(11)
* class_id : int(11)
* gid : int(11)
v quiz live_class
* class_id : int(11)
* class_name : varchar(1000)
* initiated_by : int(11)
* initiated_time : int(11)
* closed_time : int(11)
* content : longtext
v quiz savsoft_answers
* aid : int(11)
* qid : int(11)
* q_option : text
* uid : int(11)
* score_u : float
* rid : int(11)
v quiz savsoft_category
* cid : int(11)
* category_name : varchar(1000)
v quiz savsoft_feed
* quiz_id : int(11)
* user_id : int(11)
* feed1 : int(11)
* feed2 : int(11)
* feed3 : int(11)
* feed4 : int(11)
* feed5 : int(11)
* feed6 : int(11)
* feed7 : int(11)
* feed8 : int(11)
* description1 : varchar(100)
* description2 : varchar(100)
* description3 : varchar(100)
v quiz savsoft_group
* gid : int(11)
* group_name : varchar(1000)
* price : float
* valid_for_days : int(11)
* description : text
v quiz savsoft_level
* lid : int(11)
* level_name : varchar(1000)
v quiz savsoft_notification
* nid : int(11)
* notification_date : timestamp
* title : varchar(100)
* message : varchar(1000)
* click_action : varchar(100)
* notification_to : varchar(1000)
* response : text
* uid : int(11)
v quiz savsoft_options
* oid : int(11)
* qid : int(11)
* q_option : text
* q_option_match : varchar(1000)
* score : float
v quiz savsoft_payment
* pid : int(11)
* uid : int(11)
* gid : int(11)
* amount : float
* paid_date : int(11)
* payment_gateway : varchar(100)
* payment_status : varchar(100)
* transaction_id : varchar(1000)
* other_data : text
v quiz savsoft_qbank
* qid : int(11)
* question_type : varchar(100)
* question : text
* description : text
* cid : int(11)
* lid : int(11)
* no_time_served : int(11)
* no_time_corrected : int(11)
* no_time_incorrected : int(11)
* no_time_unattempted : int(11)
v quiz savsoft_qcl
* qcl_id : int(11)
* quid : int(11)
* cid : int(11)
* lid : int(11)
* noq : int(11)
* i_correct : text
* i_incorrect : text
v quiz savsoft_quiz
* quid : int(11)
* quiz_name : varchar(1000)
* description : text
* start_date : int(11)
* end_date : int(11)
* gids : text
* qids : text
* noq : int(11)
* correct_score : text
* incorrect_score : text
* ip_address : text
* duration : int(11)
* maximum_attempts : int(11)
* pass_percentage : float
* view_answer : int(11)
* camera_req : int(11)
* question_selection : int(11)
* gen_certificate : int(11)
* certificate_text : text
* with_login : int(11)
* quiz_template : varchar(100)
v quiz savsoft_result
* rid : int(11)
* quid : int(11)
* uid : int(11)
* result_status : varchar(100)
* start_time : int(11)
* end_time : int(11)
* categories : text
* category_range : text
* r_qids : text
* individual_time : text
* total_time : int(11)
* score_obtained : float
* percentage_obtained : float
* attempted_ip : varchar(100)
* score_individual : text
* photo : varchar(100)
* manual_valuation : int(11)
v quiz savsoft_users
* uid : int(11)
* password : varchar(1000)
* email : varchar(100)
* first_name : varchar(100)
* last_name : varchar(100)
* contact_no : varchar(1000)
* connection_key : varchar(1000)
* gid : int(11)
* su : int(11)
* subscription_expired : int(11)
* verify_code : int(11)
* wp_user : varchar(100)
* registered_date : timestamp
* photo : varchar(1000)
* user_status : varchar(100)
* web_token : varchar(1000)
* android_token : varchar(1000)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship