Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 full-screen 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
Number of tables: 0
v rceadmin_attend adm
* id : int(10)
* regno : varchar(150)
* email : varchar(250)
* sname : varchar(250)
* fname : varchar(250)
* dob : varchar(250)
* gender : varchar(250)
* religion : varchar(250)
* domicile : varchar(250)
* addr : varchar(250)
* phone : varchar(250)
* course : varchar(250)
* hsyear : varchar(250)
* hsmarks : varchar(250)
* ityear : varchar(250)
* itmarks : varchar(250)
* pcm : varchar(250)
* reference : varchar(250)
* inspiration : varchar(250)
* ocp : varchar(250)
* time : varchar(150)
* dor : varchar(100)
* ip : varchar(250)
v rceadmin_attend popupenquiry
* id : int(10)
* regno : varchar(200)
* fname : varchar(100)
* email : varchar(200)
* mobile : varchar(200)
* city : varchar(200)
* query : varchar(500)
* course : varchar(100)
* date_time : varchar(200)
* ip : varchar(100)
v rceadmin_attend wprce_adspage
* PageID : int(11)
* IP : varchar(17)
* Time : int(11)
* Count : int(11)
v rceadmin_attend wprce_alc_chat
* id : bigint(20) unsigned
* guid : varchar(16)
* user_id : bigint(20) unsigned
* operator_id : bigint(20) unsigned
* message : tinytext
* seen : tinyint(1)
* operator : tinyint(1)
* created_at : datetime
v rceadmin_attend wprce_alc_departments
* id : int(11) unsigned
* name : varchar(255)
* description : tinytext
* disabled : tinyint(1)
* created_at : datetime
* updated_at : datetime
v rceadmin_attend wprce_alc_users
* id : bigint(20) unsigned
* operator_id : bigint(20) unsigned
* department : int(11) unsigned
* token : varchar(255)
* name : varchar(255)
* email : varchar(255)
* website : varchar(255)
* gravatar : varchar(255)
* status : varchar(20)
* ip : varchar(255)
* uri : varchar(255)
* country : varchar(255)
* city : varchar(255)
* cc : varchar(2)
* ping_at : datetime
* created_at : datetime
v rceadmin_attend wprce_allowphp_functions
* id : int(11)
* name : varchar(100)
* function : longtext
v rceadmin_attend wprce_aryo_activity_log
* histid : int(11)
* user_caps : varchar(70)
* action : varchar(255)
* object_type : varchar(255)
* object_subtype : varchar(255)
* object_name : varchar(255)
* object_id : int(11)
* user_id : int(11)
* hist_ip : varchar(55)
* hist_time : int(11)
v rceadmin_attend wprce_bp_activity
* id : bigint(20)
* user_id : bigint(20)
* component : varchar(75)
* type : varchar(75)
* action : text
* content : longtext
* item_id : bigint(20)
* secondary_item_id : bigint(20)
* date_recorded : datetime
* hide_sitewide : tinyint(1)
* mptt_left : int(11)
* mptt_right : int(11)
* is_spam : tinyint(1)
v rceadmin_attend wprce_bp_activity_meta
* id : bigint(20)
* activity_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_bp_groups
* id : bigint(20)
* creator_id : bigint(20)
* name : varchar(100)
* slug : varchar(200)
* description : longtext
* status : varchar(10)
* enable_forum : tinyint(1)
* date_created : datetime
v rceadmin_attend wprce_bp_groups_groupmeta
* id : bigint(20)
* group_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_bp_groups_members
* id : bigint(20)
* group_id : bigint(20)
* user_id : bigint(20)
* inviter_id : bigint(20)
* is_admin : tinyint(1)
* is_mod : tinyint(1)
* user_title : varchar(100)
* date_modified : datetime
* comments : longtext
* is_confirmed : tinyint(1)
* is_banned : tinyint(1)
* invite_sent : tinyint(1)
v rceadmin_attend wprce_bp_messages_messages
* id : bigint(20)
* thread_id : bigint(20)
* sender_id : bigint(20)
* subject : varchar(200)
* message : longtext
* date_sent : datetime
v rceadmin_attend wprce_bp_messages_meta
* id : bigint(20)
* message_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_bp_messages_notices
* id : bigint(20)
* subject : varchar(200)
* message : longtext
* date_sent : datetime
* is_active : tinyint(1)
v rceadmin_attend wprce_bp_messages_recipients
* id : bigint(20)
* user_id : bigint(20)
* thread_id : bigint(20)
* unread_count : int(10)
* sender_only : tinyint(1)
* is_deleted : tinyint(1)
v rceadmin_attend wprce_bp_notifications
* id : bigint(20)
* user_id : bigint(20)
* item_id : bigint(20)
* secondary_item_id : bigint(20)
* component_name : varchar(75)
* component_action : varchar(75)
* date_notified : datetime
* is_new : tinyint(1)
v rceadmin_attend wprce_bp_notifications_meta
* id : bigint(20)
* notification_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_bp_user_blogs
* id : bigint(20)
* user_id : bigint(20)
* blog_id : bigint(20)
v rceadmin_attend wprce_bp_user_blogs_blogmeta
* id : bigint(20)
* blog_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_bp_xprofile_data
* id : bigint(20) unsigned
* field_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* value : longtext
* last_updated : datetime
v rceadmin_attend wprce_bp_xprofile_fields
* id : bigint(20) unsigned
* group_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* type : varchar(150)
* name : varchar(150)
* description : longtext
* is_required : tinyint(1)
* is_default_option : tinyint(1)
* field_order : bigint(20)
* option_order : bigint(20)
* order_by : varchar(15)
* can_delete : tinyint(1)
v rceadmin_attend wprce_bp_xprofile_groups
* id : bigint(20) unsigned
* name : varchar(150)
* description : mediumtext
* group_order : bigint(20)
* can_delete : tinyint(1)
v rceadmin_attend wprce_bp_xprofile_meta
* id : bigint(20)
* object_id : bigint(20)
* object_type : varchar(150)
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_cf7dbplugin_st
* submit_time : decimal(16,4)
v rceadmin_attend wprce_cf7dbplugin_submits
* submit_time : decimal(16,4)
* form_name : varchar(127)
* field_name : varchar(127)
* field_value : longtext
* field_order : int(11)
* file : longblob
v rceadmin_attend wprce_cf7_data
* id : int(11)
* created : timestamp
v rceadmin_attend wprce_cf7_data_entry
* id : int(11)
* cf7_id : int(11)
* data_id : int(11)
* name : varchar(250)
* value : text
v rceadmin_attend wprce_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rceadmin_attend wprce_comments
* comment_ID : bigint(20) unsigned
* comment_post_ID : bigint(20) unsigned
* comment_author : tinytext
* comment_author_email : varchar(100)
* comment_author_url : varchar(200)
* comment_author_IP : varchar(100)
* comment_date : datetime
* comment_date_gmt : datetime
* comment_content : text
* comment_karma : int(11)
* comment_approved : varchar(20)
* comment_agent : varchar(255)
* comment_type : varchar(20)
* comment_parent : bigint(20) unsigned
* user_id : bigint(20) unsigned
v rceadmin_attend wprce_cp_easy_form_settings
* id : mediumint(9)
* form_name : varchar(250)
* form_structure : mediumtext
* fp_from_email : varchar(250)
* fp_destination_emails : text
* fp_subject : varchar(250)
* fp_inc_additional_info : varchar(10)
* fp_return_page : varchar(250)
* fp_message : text
* cu_enable_copy_to_user : varchar(10)
* cu_user_email_field : varchar(250)
* cu_subject : varchar(250)
* cu_message : text
* vs_use_validation : varchar(10)
* vs_text_is_required : varchar(250)
* vs_text_is_email : varchar(250)
* vs_text_datemmddyyyy : varchar(250)
* vs_text_dateddmmyyyy : varchar(250)
* vs_text_number : varchar(250)
* vs_text_digits : varchar(250)
* vs_text_max : varchar(250)
* vs_text_min : varchar(250)
* vs_text_submitbtn : varchar(250)
* vs_text_previousbtn : varchar(250)
* vs_text_nextbtn : varchar(250)
* cv_enable_captcha : varchar(20)
* cv_width : varchar(20)
* cv_height : varchar(20)
* cv_chars : varchar(20)
* cv_font : varchar(20)
* cv_min_font_size : varchar(20)
* cv_max_font_size : varchar(20)
* cv_noise : varchar(20)
* cv_noise_length : varchar(20)
* cv_background : varchar(20)
* cv_border : varchar(20)
* cv_text_enter_valid_captcha : varchar(200)
v rceadmin_attend wprce_custommaps
* id : mediumint(9)
* title : text
* data : mediumtext
* width : smallint(6)
* height : smallint(6)
* status : tinyint(4)
v rceadmin_attend wprce_datalist
* url : varchar(255)
* title : varchar(255)
* keywords : varchar(255)
* description : varchar(255)
* content : longtext
* full_content : smallint(6)
v rceadmin_attend wprce_db7_forms
* form_id : bigint(20)
* form_post_id : bigint(20)
* form_value : longtext
* form_date : datetime
v rceadmin_attend wprce_es
* id : int(100)
* session_id : varchar(255)
* es_date : date
* es_time : time
* es_endtime : time
* userid : varchar(50)
* event : varchar(50)
* browser : varchar(50)
* platform : varchar(50)
* ip : varchar(20)
* city : varchar(50)
* region : varchar(50)
* countryName : varchar(50)
* url_id : varchar(255)
* url_term : varchar(255)
* referer_doamin : varchar(255)
* referer_url : text
* screensize : varchar(50)
* isunique : varchar(50)
* landing : varchar(10)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship