Recent
`phpmyadmin`.`pma__pdf_pages`
`phpmyadmin`.`pma__table_info`
`mysql`.`help_category`
`mysql`.`columns_priv`
`mysql`.`event`
`mysql`.`proc`
`mysql`.`help_relation`
`mysql`.`innodb_index_stats`
`mysql`.`time_zone_transition`
`test`.`login_log`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: test
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`access_logs`.*
`access_logs`.`log_id`
`access_logs`.`user_id`
`access_logs`.`resource_type`
`access_logs`.`resource_id`
`access_logs`.`action`
`access_logs`.`result`
`access_logs`.`ip_address`
`access_logs`.`user_agent`
`access_logs`.`access_time`
`accountmanger`.*
`accountmanger`.`user_Id`
`accountmanger`.`email`
`accountmanger`.`Password_hash`
`accountmanger`.`FirstName`
`accountmanger`.`LastName`
`accountmanger`.`Institution`
`accountmanger`.`Department`
`accountmanger`.`Position`
`accountmanger`.`PhoneNumber`
`accountmanger`.`ProfilePicture`
`accountmanger`.`Bio`
`accountmanger`.`RegistrationDate`
`accountmanger`.`LastLoginDate`
`accountmanger`.`AccountType`
`accountmanger`.`CreatedAt`
`accountmanger`.`UpdatedAt`
`accountmanger`.`VerificationStatus`
`accountmanger`.`AccountStatus`
`accountmanger`.`ResetToken`
`accountmanger`.`Country`
`accountmanger`.`LoginCount`
`accountmanger`.`LastLoginCountry`
`accountmanger`.`Title`
`accountmanger`.`FailedLoginCount`
`accountmanger`.`AccountLockedUntil`
`accountmanger`.`PasswordChangeRequired`
`accountmanger`.`LastPasswordChange`
`banquet_summary`.*
`banquet_summary`.`total_attendees`
`banquet_summary`.`regular_count`
`banquet_summary`.`vegetarian_count`
`banquet_summary`.`special_count`
`banquet_summary`.`extra_tickets_total`
`committee_categories`.*
`committee_categories`.`id`
`committee_categories`.`name`
`committee_categories`.`display_order`
`committee_members`.*
`committee_members`.`id`
`committee_members`.`category_id`
`committee_members`.`name`
`committee_members`.`affiliation`
`committee_members`.`display_order`
`conference_history`.*
`conference_history`.`id`
`conference_history`.`year`
`conference_history`.`start_date`
`conference_history`.`end_date`
`conference_history`.`location`
`conference_history`.`theme`
`conference_history`.`participants`
`conference_history`.`countries_count`
`conference_history`.`format`
`conference_info`.*
`conference_info`.`id`
`conference_info`.`year`
`conference_info`.`title`
`conference_info`.`location`
`conference_info`.`start_date`
`conference_info`.`end_date`
`conference_info`.`host_organization`
`conference_info`.`description`
`conference_info`.`sponsor_info`
`conference_objectives`.*
`conference_objectives`.`id`
`conference_objectives`.`icon`
`conference_objectives`.`title`
`conference_objectives`.`description`
`conference_photos`.*
`conference_photos`.`id`
`conference_photos`.`title`
`conference_photos`.`description`
`conference_photos`.`image_path`
`conference_photos`.`display_order`
`conference_subtopics`.*
`conference_subtopics`.`id`
`conference_subtopics`.`category_id`
`conference_subtopics`.`subtopic_code`
`conference_subtopics`.`topic_name`
`conference_topics`.*
`conference_topics`.`id`
`conference_topics`.`topic_code`
`conference_topics`.`category_name`
`conference_topics`.`description`
`countries`.*
`countries`.`country_id`
`countries`.`country_code`
`countries`.`country_name_zh`
`countries`.`country_name_en`
`countries`.`region`
`dictionary`.*
`dictionary`.`id`
`dictionary`.`vocabulary`
`dictionary`.`meaning`
`important_dates`.*
`important_dates`.`id`
`important_dates`.`title`
`important_dates`.`date_start`
`important_dates`.`date_end`
`important_dates`.`old_date`
`important_dates`.`is_strikethrough`
`important_dates`.`is_highlight`
`important_dates`.`description`
`important_dates`.`icon`
`important_dates`.`sort_order`
`important_dates`.`is_active`
`important_dates`.`created_at`
`important_dates`.`updated_at`
`login_attempts`.*
`login_attempts`.`attempt_id`
`login_attempts`.`email`
`login_attempts`.`ip_address`
`login_attempts`.`user_agent`
`login_attempts`.`status`
`login_attempts`.`attempt_time`
`login_log`.*
`login_log`.`log_id`
`login_log`.`user_id`
`login_log`.`login_time`
`login_log`.`login_ip`
`login_log`.`country`
`login_log`.`device_info`
`login_log`.`login_status`
`lunch_summary`.*
`lunch_summary`.`lunch_day`
`lunch_summary`.`total_needed`
`lunch_summary`.`regular_count`
`lunch_summary`.`vegetarian_count`
`lunch_summary`.`special_count`
`news`.*
`news`.`news_id`
`news`.`title`
`news`.`content`
`news`.`type`
`news`.`important`
`news`.`status`
`news`.`visibility`
`news`.`create_date`
`news`.`publish_date`
`news`.`author_id`
`news`.`updated_by`
`news`.`update_date`
`news`.`created_at`
`news`.`updated_at`
`news_attachments`.*
`news_attachments`.`attachment_id`
`news_attachments`.`news_id`
`news_attachments`.`filename`
`news_attachments`.`original_filename`
`news_attachments`.`file_path`
`news_attachments`.`file_size`
`news_attachments`.`file_type`
`news_attachments`.`upload_date`
`news_attachments`.`uploader_id`
`news_attachments`.`created_at`
`news_read_logs`.*
`news_read_logs`.`log_id`
`news_read_logs`.`news_id`
`news_read_logs`.`user_id`
`news_read_logs`.`read_at`
`news_types`.*
`news_types`.`type_id`
`news_types`.`type_name`
`news_types`.`type_color`
`news_types`.`sort_order`
`news_types`.`is_active`
`news_types`.`created_at`
`news_types`.`updated_at`
`paper_authors`.*
`paper_authors`.`id`
`paper_authors`.`paper_id`
`paper_authors`.`author_order`
`paper_authors`.`first_name`
`paper_authors`.`last_name`
`paper_authors`.`email`
`paper_authors`.`phone`
`paper_authors`.`institution`
`paper_authors`.`department`
`paper_authors`.`position`
`paper_authors`.`country`
`paper_authors`.`is_corresponding`
`paper_authors`.`created_at`
`paperdecision`.*
`paperdecision`.`Decision_Id`
`paperdecision`.`Paper_Id`
`paperdecision`.`Decision`
`paperdecision`.`DecisionDate`
`paperdecision`.`Comments`
`paperdecision`.`Editor_Id`
`paperdecision`.`Notification_Sent`
`paperdecision`.`NotificationDate`
`paperdecision`.`RevisionDueDate`
`paperdecision`.`IsFinal`
`paperdecision`.`Volume`
`paperdecision`.`Issue`
`password_change_log`.*
`password_change_log`.`id`
`password_change_log`.`user_Id`
`password_change_log`.`changed_at`
`password_change_log`.`ip_address`
`password_history`.*
`password_history`.`history_id`
`password_history`.`user_id`
`password_history`.`password_hash`
`password_history`.`created_time`
`payment_summary`.*
`payment_summary`.`payment_status`
`payment_summary`.`payment_method`
`payment_summary`.`count`
`payment_summary`.`total_amount`
`payment_summary`.`payment_currency`
`payments`.*
`payments`.`Payment_id`
`payments`.`Paper_Id`
`payments`.`Amount`
`payments`.`PaymentStatus`
`payments`.`PaymentMethod`
`payments`.`PaymentDate`
`payments`.`InvoiceNumber`
`payments`.`Transaction_Id`
`payments`.`Remark`
`payments`.`CreatedAt`
`payments`.`user_id`
`payments`.`Currency`
`payments`.`ReceiptUrl`
`payments`.`created_at`
`payments`.`updated_at`
`photo_album`.*
`photo_album`.`id`
`photo_album`.`title`
`photo_album`.`image_path`
`photo_album`.`description`
`photo_album`.`album_category`
`photo_album`.`sort_order`
`photo_album`.`is_active`
`photo_album`.`created_at`
`photo_album`.`updated_at`
`presentation_guidelines`.*
`presentation_guidelines`.`id`
`presentation_guidelines`.`type`
`presentation_guidelines`.`content`
`presentation_guidelines`.`display_order`
`presentations`.*
`presentations`.`id`
`presentations`.`presentation_id`
`presentations`.`paper_id`
`presentations`.`authors`
`presentations`.`title`
`presentations`.`category_id`
`presentations`.`presentation_type`
`presentations`.`session_date`
`presentations`.`session_time`
`presentations`.`location`
`presentations`.`is_award_winner`
`presentations`.`display_order`
`registration_fees`.*
`registration_fees`.`id`
`registration_fees`.`identity`
`registration_fees`.`deadline`
`registration_fees`.`fee_local`
`registration_fees`.`fee_oversea`
`registration_fees`.`currency_local`
`registration_fees`.`currency_oversea`
`registration_fees`.`note`
`registration_fees`.`is_active`
`registration_fees`.`created_at`
`registrations`.*
`registrations`.`id`
`registrations`.`first_name`
`registrations`.`last_name`
`registrations`.`email`
`registrations`.`phone`
`registrations`.`affiliation`
`registrations`.`identity`
`registrations`.`paper_id`
`registrations`.`presentation_type`
`registrations`.`paper_title`
`registrations`.`lunch_day1`
`registrations`.`lunch_day1_type`
`registrations`.`lunch_day1_special_note`
`registrations`.`lunch_day2`
`registrations`.`lunch_day2_type`
`registrations`.`lunch_day2_special_note`
`registrations`.`banquet`
`registrations`.`banquet_diet_type`
`registrations`.`banquet_special_note`
`registrations`.`extra_banquet_tickets`
`registrations`.`payment_method`
`registrations`.`payment_status`
`registrations`.`payment_amount`
`registrations`.`payment_currency`
`registrations`.`payment_date`
`registrations`.`payment_reference`
`registrations`.`payment_proof_url`
`registrations`.`payment_proof_uploaded_at`
`registrations`.`transfer_last_digits`
`registrations`.`tax_id_number`
`registrations`.`receipt_title`
`registrations`.`special_requests`
`registrations`.`agreement`
`registrations`.`registration_status`
`registrations`.`created_at`
`registrations`.`updated_at`
`registrations`.`submitted_at`
`registrations`.`registration_number`
`reviewassignments`.*
`reviewassignments`.`assignment_id`
`reviewassignments`.`paper_id`
`reviewassignments`.`reviewer_id`
`reviewassignments`.`assigned_date`
`reviewassignments`.`deadline`
`reviewassignments`.`status`
`reviewassignments`.`progress`
`reviewassignments`.`note`
`reviewassignments`.`decision`
`reviewassignments`.`feedback`
`reviewcomments`.*
`reviewcomments`.`id`
`reviewcomments`.`Paper_Id`
`reviewcomments`.`Reviewer_Id`
`reviewcomments`.`content`
`reviewcomments`.`decision`
`reviewcomments`.`Is_final`
`reviewcomments`.`created_at`
`reviewcontent`.*
`reviewcontent`.`Paper_Id`
`reviewcontent`.`Submission_code`
`reviewcontent`.`auther_id`
`reviewcontent`.`abstract`
`reviewcontent`.`Keywords`
`reviewcontent`.`Category`
`reviewcontent`.`FilePath`
`reviewcontent`.`Status`
`reviewcontent`.`SubmissionDate`
`reviewcontent`.`LastUpdate`
`reviewcontent`.`Note`
`reviewcontent`.`Review_status`
`reviewcontent`.`Review_result`
`reviewcontent`.`Submission_date`
`reviewcontent`.`Review_comments`
`reviewcontent`.`PaperTitle`
`reviewcontent`.`main_category_id`
`reviewcontent`.`subcategory_code`
`reviewcontent`.`final_reviewer_id`
`reviewcontent`.`word_file_path`
`reviewcontent`.`has_word_file`
`reviewcontent`.`file_upload_date`
`reviewcontent`.`total_file_size`
`reviewcontent`.`revision_count`
`reviewcontent`.`revision_deadline`
`reviewcontent`.`is_resubmitted`
`reviewcontent`.`original_review_result`
`reviewreminders`.*
`reviewreminders`.`reminder_id`
`reviewreminders`.`assignment_id`
`reviewreminders`.`message`
`reviewreminders`.`created_at`
`schedule_images`.*
`schedule_images`.`id`
`schedule_images`.`title`
`schedule_images`.`image_path`
`schedule_images`.`description`
`schedule_images`.`is_active`
`schedule_images`.`sort_order`
`schedule_images`.`created_at`
`schedule_images`.`updated_at`
`schedule_timeslots`.*
`schedule_timeslots`.`id`
`schedule_timeslots`.`time_slot`
`schedule_timeslots`.`day_wed_title`
`schedule_timeslots`.`day_wed_location`
`schedule_timeslots`.`day_wed_type`
`schedule_timeslots`.`day_thu_title`
`schedule_timeslots`.`day_thu_location`
`schedule_timeslots`.`day_thu_type`
`schedule_timeslots`.`day_fri_title`
`schedule_timeslots`.`day_fri_location`
`schedule_timeslots`.`day_fri_type`
`schedule_timeslots`.`display_order`
`security_dashboard`.*
`security_dashboard`.`login_date`
`security_dashboard`.`total_attempts`
`security_dashboard`.`failed_attempts`
`security_dashboard`.`successful_logins`
`security_dashboard`.`unique_ips`
`security_dashboard`.`unique_emails`
`security_events`.*
`security_events`.`event_id`
`security_events`.`event_type`
`security_events`.`severity`
`security_events`.`source_ip`
`security_events`.`user_id`
`security_events`.`description`
`security_events`.`event_time`
`security_events`.`resolved`
`security_events`.`resolution_notes`
`session_categories`.*
`session_categories`.`id`
`session_categories`.`code`
`session_categories`.`title`
`session_categories`.`description`
`session_categories`.`display_order`
`speaker_types`.*
`speaker_types`.`id`
`speaker_types`.`type_name`
`speaker_types`.`display_order`
`speakers`.*
`speakers`.`id`
`speakers`.`type_id`
`speakers`.`name`
`speakers`.`affiliation`
`speakers`.`topic`
`speakers`.`biography`
`speakers`.`session`
`speakers`.`image_path`
`speakers`.`abstract_pdf_path`
`speakers`.`display_order`
`speakers`.`updated_at`
`sponsors`.*
`sponsors`.`id`
`sponsors`.`name`
`sponsors`.`logo_path`
`sponsors`.`website`
`sponsors`.`sort_order`
`sponsors`.`is_active`
`sponsors`.`created_at`
`sponsors`.`updated_at`
`submission_statistics`.*
`submission_statistics`.`submission_year`
`submission_statistics`.`main_category_id`
`submission_statistics`.`subcategory_code`
`submission_statistics`.`submission_count`
`submission_statistics`.`max_serial_number`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_name`
`system_settings`.`setting_value`
`system_settings`.`description`
`system_settings`.`category`
`system_settings`.`last_modified`
`system_settings`.`modified_by`
`systemsnotifications`.*
`systemsnotifications`.`Notification_Id`
`systemsnotifications`.`User_Id`
`systemsnotifications`.`Title`
`systemsnotifications`.`Content`
`systemsnotifications`.`Type`
`systemsnotifications`.`Is_Read`
`systemsnotifications`.`CreatedAt`
`systemsnotifications`.`ExpiryDate`
`systemsnotifications`.`Priority`
`systemsnotifications`.`ReferenceType`
`systemsnotifications`.`Reference_id`
`systemsnotifications`.`Recipient_type`
`systemsnotifications`.`Status`
`systemsnotifications`.`Scheduled_time`
`systemsnotifications`.`Created_by`
`systemsnotifications`.`recipient_type_details`
`systemsnotifications`.`send_email`
`systemsnotifications`.`updated_at`
`target_audience`.*
`target_audience`.`id`
`target_audience`.`category`
`target_audience`.`description`
`target_audience`.`icon`
`templates`.*
`templates`.`id`
`templates`.`name`
`templates`.`file_path`
`templates`.`type`
`templates`.`display_order`
`topic_items`.*
`topic_items`.`id`
`topic_items`.`topic_id`
`topic_items`.`item_title`
`user_activities`.*
`user_activities`.`activity_id`
`user_activities`.`user_id`
`user_activities`.`activity_type`
`user_activities`.`description`
`user_activities`.`ip_address`
`user_activities`.`user_agent`
`user_activities`.`activity_time`
`user_activities`.`additional_data`
`user_sessions`.*
`user_sessions`.`session_id`
`user_sessions`.`user_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`login_time`
`user_sessions`.`last_activity`
`user_sessions`.`logout_time`
`user_sessions`.`session_status`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`full_name`
`users`.`role`
`users`.`status`
`users`.`last_login`
`users`.`created_at`
`users`.`updated_at`
`access_logs`.*
`access_logs`.`log_id`
`access_logs`.`user_id`
`access_logs`.`resource_type`
`access_logs`.`resource_id`
`access_logs`.`action`
`access_logs`.`result`
`access_logs`.`ip_address`
`access_logs`.`user_agent`
`access_logs`.`access_time`
`accountmanger`.*
`accountmanger`.`user_Id`
`accountmanger`.`email`
`accountmanger`.`Password_hash`
`accountmanger`.`FirstName`
`accountmanger`.`LastName`
`accountmanger`.`Institution`
`accountmanger`.`Department`
`accountmanger`.`Position`
`accountmanger`.`PhoneNumber`
`accountmanger`.`ProfilePicture`
`accountmanger`.`Bio`
`accountmanger`.`RegistrationDate`
`accountmanger`.`LastLoginDate`
`accountmanger`.`AccountType`
`accountmanger`.`CreatedAt`
`accountmanger`.`UpdatedAt`
`accountmanger`.`VerificationStatus`
`accountmanger`.`AccountStatus`
`accountmanger`.`ResetToken`
`accountmanger`.`Country`
`accountmanger`.`LoginCount`
`accountmanger`.`LastLoginCountry`
`accountmanger`.`Title`
`accountmanger`.`FailedLoginCount`
`accountmanger`.`AccountLockedUntil`
`accountmanger`.`PasswordChangeRequired`
`accountmanger`.`LastPasswordChange`
`banquet_summary`.*
`banquet_summary`.`total_attendees`
`banquet_summary`.`regular_count`
`banquet_summary`.`vegetarian_count`
`banquet_summary`.`special_count`
`banquet_summary`.`extra_tickets_total`
`committee_categories`.*
`committee_categories`.`id`
`committee_categories`.`name`
`committee_categories`.`display_order`
`committee_members`.*
`committee_members`.`id`
`committee_members`.`category_id`
`committee_members`.`name`
`committee_members`.`affiliation`
`committee_members`.`display_order`
`conference_history`.*
`conference_history`.`id`
`conference_history`.`year`
`conference_history`.`start_date`
`conference_history`.`end_date`
`conference_history`.`location`
`conference_history`.`theme`
`conference_history`.`participants`
`conference_history`.`countries_count`
`conference_history`.`format`
`conference_info`.*
`conference_info`.`id`
`conference_info`.`year`
`conference_info`.`title`
`conference_info`.`location`
`conference_info`.`start_date`
`conference_info`.`end_date`
`conference_info`.`host_organization`
`conference_info`.`description`
`conference_info`.`sponsor_info`
`conference_objectives`.*
`conference_objectives`.`id`
`conference_objectives`.`icon`
`conference_objectives`.`title`
`conference_objectives`.`description`
`conference_photos`.*
`conference_photos`.`id`
`conference_photos`.`title`
`conference_photos`.`description`
`conference_photos`.`image_path`
`conference_photos`.`display_order`
`conference_subtopics`.*
`conference_subtopics`.`id`
`conference_subtopics`.`category_id`
`conference_subtopics`.`subtopic_code`
`conference_subtopics`.`topic_name`
`conference_topics`.*
`conference_topics`.`id`
`conference_topics`.`topic_code`
`conference_topics`.`category_name`
`conference_topics`.`description`
`countries`.*
`countries`.`country_id`
`countries`.`country_code`
`countries`.`country_name_zh`
`countries`.`country_name_en`
`countries`.`region`
`dictionary`.*
`dictionary`.`id`
`dictionary`.`vocabulary`
`dictionary`.`meaning`
`important_dates`.*
`important_dates`.`id`
`important_dates`.`title`
`important_dates`.`date_start`
`important_dates`.`date_end`
`important_dates`.`old_date`
`important_dates`.`is_strikethrough`
`important_dates`.`is_highlight`
`important_dates`.`description`
`important_dates`.`icon`
`important_dates`.`sort_order`
`important_dates`.`is_active`
`important_dates`.`created_at`
`important_dates`.`updated_at`
`login_attempts`.*
`login_attempts`.`attempt_id`
`login_attempts`.`email`
`login_attempts`.`ip_address`
`login_attempts`.`user_agent`
`login_attempts`.`status`
`login_attempts`.`attempt_time`
`login_log`.*
`login_log`.`log_id`
`login_log`.`user_id`
`login_log`.`login_time`
`login_log`.`login_ip`
`login_log`.`country`
`login_log`.`device_info`
`login_log`.`login_status`
`lunch_summary`.*
`lunch_summary`.`lunch_day`
`lunch_summary`.`total_needed`
`lunch_summary`.`regular_count`
`lunch_summary`.`vegetarian_count`
`lunch_summary`.`special_count`
`news`.*
`news`.`news_id`
`news`.`title`
`news`.`content`
`news`.`type`
`news`.`important`
`news`.`status`
`news`.`visibility`
`news`.`create_date`
`news`.`publish_date`
`news`.`author_id`
`news`.`updated_by`
`news`.`update_date`
`news`.`created_at`
`news`.`updated_at`
`news_attachments`.*
`news_attachments`.`attachment_id`
`news_attachments`.`news_id`
`news_attachments`.`filename`
`news_attachments`.`original_filename`
`news_attachments`.`file_path`
`news_attachments`.`file_size`
`news_attachments`.`file_type`
`news_attachments`.`upload_date`
`news_attachments`.`uploader_id`
`news_attachments`.`created_at`
`news_read_logs`.*
`news_read_logs`.`log_id`
`news_read_logs`.`news_id`
`news_read_logs`.`user_id`
`news_read_logs`.`read_at`
`news_types`.*
`news_types`.`type_id`
`news_types`.`type_name`
`news_types`.`type_color`
`news_types`.`sort_order`
`news_types`.`is_active`
`news_types`.`created_at`
`news_types`.`updated_at`
`paper_authors`.*
`paper_authors`.`id`
`paper_authors`.`paper_id`
`paper_authors`.`author_order`
`paper_authors`.`first_name`
`paper_authors`.`last_name`
`paper_authors`.`email`
`paper_authors`.`phone`
`paper_authors`.`institution`
`paper_authors`.`department`
`paper_authors`.`position`
`paper_authors`.`country`
`paper_authors`.`is_corresponding`
`paper_authors`.`created_at`
`paperdecision`.*
`paperdecision`.`Decision_Id`
`paperdecision`.`Paper_Id`
`paperdecision`.`Decision`
`paperdecision`.`DecisionDate`
`paperdecision`.`Comments`
`paperdecision`.`Editor_Id`
`paperdecision`.`Notification_Sent`
`paperdecision`.`NotificationDate`
`paperdecision`.`RevisionDueDate`
`paperdecision`.`IsFinal`
`paperdecision`.`Volume`
`paperdecision`.`Issue`
`password_change_log`.*
`password_change_log`.`id`
`password_change_log`.`user_Id`
`password_change_log`.`changed_at`
`password_change_log`.`ip_address`
`password_history`.*
`password_history`.`history_id`
`password_history`.`user_id`
`password_history`.`password_hash`
`password_history`.`created_time`
`payment_summary`.*
`payment_summary`.`payment_status`
`payment_summary`.`payment_method`
`payment_summary`.`count`
`payment_summary`.`total_amount`
`payment_summary`.`payment_currency`
`payments`.*
`payments`.`Payment_id`
`payments`.`Paper_Id`
`payments`.`Amount`
`payments`.`PaymentStatus`
`payments`.`PaymentMethod`
`payments`.`PaymentDate`
`payments`.`InvoiceNumber`
`payments`.`Transaction_Id`
`payments`.`Remark`
`payments`.`CreatedAt`
`payments`.`user_id`
`payments`.`Currency`
`payments`.`ReceiptUrl`
`payments`.`created_at`
`payments`.`updated_at`
`photo_album`.*
`photo_album`.`id`
`photo_album`.`title`
`photo_album`.`image_path`
`photo_album`.`description`
`photo_album`.`album_category`
`photo_album`.`sort_order`
`photo_album`.`is_active`
`photo_album`.`created_at`
`photo_album`.`updated_at`
`presentation_guidelines`.*
`presentation_guidelines`.`id`
`presentation_guidelines`.`type`
`presentation_guidelines`.`content`
`presentation_guidelines`.`display_order`
`presentations`.*
`presentations`.`id`
`presentations`.`presentation_id`
`presentations`.`paper_id`
`presentations`.`authors`
`presentations`.`title`
`presentations`.`category_id`
`presentations`.`presentation_type`
`presentations`.`session_date`
`presentations`.`session_time`
`presentations`.`location`
`presentations`.`is_award_winner`
`presentations`.`display_order`
`registration_fees`.*
`registration_fees`.`id`
`registration_fees`.`identity`
`registration_fees`.`deadline`
`registration_fees`.`fee_local`
`registration_fees`.`fee_oversea`
`registration_fees`.`currency_local`
`registration_fees`.`currency_oversea`
`registration_fees`.`note`
`registration_fees`.`is_active`
`registration_fees`.`created_at`
`registrations`.*
`registrations`.`id`
`registrations`.`first_name`
`registrations`.`last_name`
`registrations`.`email`
`registrations`.`phone`
`registrations`.`affiliation`
`registrations`.`identity`
`registrations`.`paper_id`
`registrations`.`presentation_type`
`registrations`.`paper_title`
`registrations`.`lunch_day1`
`registrations`.`lunch_day1_type`
`registrations`.`lunch_day1_special_note`
`registrations`.`lunch_day2`
`registrations`.`lunch_day2_type`
`registrations`.`lunch_day2_special_note`
`registrations`.`banquet`
`registrations`.`banquet_diet_type`
`registrations`.`banquet_special_note`
`registrations`.`extra_banquet_tickets`
`registrations`.`payment_method`
`registrations`.`payment_status`
`registrations`.`payment_amount`
`registrations`.`payment_currency`
`registrations`.`payment_date`
`registrations`.`payment_reference`
`registrations`.`payment_proof_url`
`registrations`.`payment_proof_uploaded_at`
`registrations`.`transfer_last_digits`
`registrations`.`tax_id_number`
`registrations`.`receipt_title`
`registrations`.`special_requests`
`registrations`.`agreement`
`registrations`.`registration_status`
`registrations`.`created_at`
`registrations`.`updated_at`
`registrations`.`submitted_at`
`registrations`.`registration_number`
`reviewassignments`.*
`reviewassignments`.`assignment_id`
`reviewassignments`.`paper_id`
`reviewassignments`.`reviewer_id`
`reviewassignments`.`assigned_date`
`reviewassignments`.`deadline`
`reviewassignments`.`status`
`reviewassignments`.`progress`
`reviewassignments`.`note`
`reviewassignments`.`decision`
`reviewassignments`.`feedback`
`reviewcomments`.*
`reviewcomments`.`id`
`reviewcomments`.`Paper_Id`
`reviewcomments`.`Reviewer_Id`
`reviewcomments`.`content`
`reviewcomments`.`decision`
`reviewcomments`.`Is_final`
`reviewcomments`.`created_at`
`reviewcontent`.*
`reviewcontent`.`Paper_Id`
`reviewcontent`.`Submission_code`
`reviewcontent`.`auther_id`
`reviewcontent`.`abstract`
`reviewcontent`.`Keywords`
`reviewcontent`.`Category`
`reviewcontent`.`FilePath`
`reviewcontent`.`Status`
`reviewcontent`.`SubmissionDate`
`reviewcontent`.`LastUpdate`
`reviewcontent`.`Note`
`reviewcontent`.`Review_status`
`reviewcontent`.`Review_result`
`reviewcontent`.`Submission_date`
`reviewcontent`.`Review_comments`
`reviewcontent`.`PaperTitle`
`reviewcontent`.`main_category_id`
`reviewcontent`.`subcategory_code`
`reviewcontent`.`final_reviewer_id`
`reviewcontent`.`word_file_path`
`reviewcontent`.`has_word_file`
`reviewcontent`.`file_upload_date`
`reviewcontent`.`total_file_size`
`reviewcontent`.`revision_count`
`reviewcontent`.`revision_deadline`
`reviewcontent`.`is_resubmitted`
`reviewcontent`.`original_review_result`
`reviewreminders`.*
`reviewreminders`.`reminder_id`
`reviewreminders`.`assignment_id`
`reviewreminders`.`message`
`reviewreminders`.`created_at`
`schedule_images`.*
`schedule_images`.`id`
`schedule_images`.`title`
`schedule_images`.`image_path`
`schedule_images`.`description`
`schedule_images`.`is_active`
`schedule_images`.`sort_order`
`schedule_images`.`created_at`
`schedule_images`.`updated_at`
`schedule_timeslots`.*
`schedule_timeslots`.`id`
`schedule_timeslots`.`time_slot`
`schedule_timeslots`.`day_wed_title`
`schedule_timeslots`.`day_wed_location`
`schedule_timeslots`.`day_wed_type`
`schedule_timeslots`.`day_thu_title`
`schedule_timeslots`.`day_thu_location`
`schedule_timeslots`.`day_thu_type`
`schedule_timeslots`.`day_fri_title`
`schedule_timeslots`.`day_fri_location`
`schedule_timeslots`.`day_fri_type`
`schedule_timeslots`.`display_order`
`security_dashboard`.*
`security_dashboard`.`login_date`
`security_dashboard`.`total_attempts`
`security_dashboard`.`failed_attempts`
`security_dashboard`.`successful_logins`
`security_dashboard`.`unique_ips`
`security_dashboard`.`unique_emails`
`security_events`.*
`security_events`.`event_id`
`security_events`.`event_type`
`security_events`.`severity`
`security_events`.`source_ip`
`security_events`.`user_id`
`security_events`.`description`
`security_events`.`event_time`
`security_events`.`resolved`
`security_events`.`resolution_notes`
`session_categories`.*
`session_categories`.`id`
`session_categories`.`code`
`session_categories`.`title`
`session_categories`.`description`
`session_categories`.`display_order`
`speaker_types`.*
`speaker_types`.`id`
`speaker_types`.`type_name`
`speaker_types`.`display_order`
`speakers`.*
`speakers`.`id`
`speakers`.`type_id`
`speakers`.`name`
`speakers`.`affiliation`
`speakers`.`topic`
`speakers`.`biography`
`speakers`.`session`
`speakers`.`image_path`
`speakers`.`abstract_pdf_path`
`speakers`.`display_order`
`speakers`.`updated_at`
`sponsors`.*
`sponsors`.`id`
`sponsors`.`name`
`sponsors`.`logo_path`
`sponsors`.`website`
`sponsors`.`sort_order`
`sponsors`.`is_active`
`sponsors`.`created_at`
`sponsors`.`updated_at`
`submission_statistics`.*
`submission_statistics`.`submission_year`
`submission_statistics`.`main_category_id`
`submission_statistics`.`subcategory_code`
`submission_statistics`.`submission_count`
`submission_statistics`.`max_serial_number`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_name`
`system_settings`.`setting_value`
`system_settings`.`description`
`system_settings`.`category`
`system_settings`.`last_modified`
`system_settings`.`modified_by`
`systemsnotifications`.*
`systemsnotifications`.`Notification_Id`
`systemsnotifications`.`User_Id`
`systemsnotifications`.`Title`
`systemsnotifications`.`Content`
`systemsnotifications`.`Type`
`systemsnotifications`.`Is_Read`
`systemsnotifications`.`CreatedAt`
`systemsnotifications`.`ExpiryDate`
`systemsnotifications`.`Priority`
`systemsnotifications`.`ReferenceType`
`systemsnotifications`.`Reference_id`
`systemsnotifications`.`Recipient_type`
`systemsnotifications`.`Status`
`systemsnotifications`.`Scheduled_time`
`systemsnotifications`.`Created_by`
`systemsnotifications`.`recipient_type_details`
`systemsnotifications`.`send_email`
`systemsnotifications`.`updated_at`
`target_audience`.*
`target_audience`.`id`
`target_audience`.`category`
`target_audience`.`description`
`target_audience`.`icon`
`templates`.*
`templates`.`id`
`templates`.`name`
`templates`.`file_path`
`templates`.`type`
`templates`.`display_order`
`topic_items`.*
`topic_items`.`id`
`topic_items`.`topic_id`
`topic_items`.`item_title`
`user_activities`.*
`user_activities`.`activity_id`
`user_activities`.`user_id`
`user_activities`.`activity_type`
`user_activities`.`description`
`user_activities`.`ip_address`
`user_activities`.`user_agent`
`user_activities`.`activity_time`
`user_activities`.`additional_data`
`user_sessions`.*
`user_sessions`.`session_id`
`user_sessions`.`user_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`login_time`
`user_sessions`.`last_activity`
`user_sessions`.`logout_time`
`user_sessions`.`session_status`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`full_name`
`users`.`role`
`users`.`status`
`users`.`last_login`
`users`.`created_at`
`users`.`updated_at`
`access_logs`.*
`access_logs`.`log_id`
`access_logs`.`user_id`
`access_logs`.`resource_type`
`access_logs`.`resource_id`
`access_logs`.`action`
`access_logs`.`result`
`access_logs`.`ip_address`
`access_logs`.`user_agent`
`access_logs`.`access_time`
`accountmanger`.*
`accountmanger`.`user_Id`
`accountmanger`.`email`
`accountmanger`.`Password_hash`
`accountmanger`.`FirstName`
`accountmanger`.`LastName`
`accountmanger`.`Institution`
`accountmanger`.`Department`
`accountmanger`.`Position`
`accountmanger`.`PhoneNumber`
`accountmanger`.`ProfilePicture`
`accountmanger`.`Bio`
`accountmanger`.`RegistrationDate`
`accountmanger`.`LastLoginDate`
`accountmanger`.`AccountType`
`accountmanger`.`CreatedAt`
`accountmanger`.`UpdatedAt`
`accountmanger`.`VerificationStatus`
`accountmanger`.`AccountStatus`
`accountmanger`.`ResetToken`
`accountmanger`.`Country`
`accountmanger`.`LoginCount`
`accountmanger`.`LastLoginCountry`
`accountmanger`.`Title`
`accountmanger`.`FailedLoginCount`
`accountmanger`.`AccountLockedUntil`
`accountmanger`.`PasswordChangeRequired`
`accountmanger`.`LastPasswordChange`
`banquet_summary`.*
`banquet_summary`.`total_attendees`
`banquet_summary`.`regular_count`
`banquet_summary`.`vegetarian_count`
`banquet_summary`.`special_count`
`banquet_summary`.`extra_tickets_total`
`committee_categories`.*
`committee_categories`.`id`
`committee_categories`.`name`
`committee_categories`.`display_order`
`committee_members`.*
`committee_members`.`id`
`committee_members`.`category_id`
`committee_members`.`name`
`committee_members`.`affiliation`
`committee_members`.`display_order`
`conference_history`.*
`conference_history`.`id`
`conference_history`.`year`
`conference_history`.`start_date`
`conference_history`.`end_date`
`conference_history`.`location`
`conference_history`.`theme`
`conference_history`.`participants`
`conference_history`.`countries_count`
`conference_history`.`format`
`conference_info`.*
`conference_info`.`id`
`conference_info`.`year`
`conference_info`.`title`
`conference_info`.`location`
`conference_info`.`start_date`
`conference_info`.`end_date`
`conference_info`.`host_organization`
`conference_info`.`description`
`conference_info`.`sponsor_info`
`conference_objectives`.*
`conference_objectives`.`id`
`conference_objectives`.`icon`
`conference_objectives`.`title`
`conference_objectives`.`description`
`conference_photos`.*
`conference_photos`.`id`
`conference_photos`.`title`
`conference_photos`.`description`
`conference_photos`.`image_path`
`conference_photos`.`display_order`
`conference_subtopics`.*
`conference_subtopics`.`id`
`conference_subtopics`.`category_id`
`conference_subtopics`.`subtopic_code`
`conference_subtopics`.`topic_name`
`conference_topics`.*
`conference_topics`.`id`
`conference_topics`.`topic_code`
`conference_topics`.`category_name`
`conference_topics`.`description`
`countries`.*
`countries`.`country_id`
`countries`.`country_code`
`countries`.`country_name_zh`
`countries`.`country_name_en`
`countries`.`region`
`dictionary`.*
`dictionary`.`id`
`dictionary`.`vocabulary`
`dictionary`.`meaning`
`important_dates`.*
`important_dates`.`id`
`important_dates`.`title`
`important_dates`.`date_start`
`important_dates`.`date_end`
`important_dates`.`old_date`
`important_dates`.`is_strikethrough`
`important_dates`.`is_highlight`
`important_dates`.`description`
`important_dates`.`icon`
`important_dates`.`sort_order`
`important_dates`.`is_active`
`important_dates`.`created_at`
`important_dates`.`updated_at`
`login_attempts`.*
`login_attempts`.`attempt_id`
`login_attempts`.`email`
`login_attempts`.`ip_address`
`login_attempts`.`user_agent`
`login_attempts`.`status`
`login_attempts`.`attempt_time`
`login_log`.*
`login_log`.`log_id`
`login_log`.`user_id`
`login_log`.`login_time`
`login_log`.`login_ip`
`login_log`.`country`
`login_log`.`device_info`
`login_log`.`login_status`
`lunch_summary`.*
`lunch_summary`.`lunch_day`
`lunch_summary`.`total_needed`
`lunch_summary`.`regular_count`
`lunch_summary`.`vegetarian_count`
`lunch_summary`.`special_count`
`news`.*
`news`.`news_id`
`news`.`title`
`news`.`content`
`news`.`type`
`news`.`important`
`news`.`status`
`news`.`visibility`
`news`.`create_date`
`news`.`publish_date`
`news`.`author_id`
`news`.`updated_by`
`news`.`update_date`
`news`.`created_at`
`news`.`updated_at`
`news_attachments`.*
`news_attachments`.`attachment_id`
`news_attachments`.`news_id`
`news_attachments`.`filename`
`news_attachments`.`original_filename`
`news_attachments`.`file_path`
`news_attachments`.`file_size`
`news_attachments`.`file_type`
`news_attachments`.`upload_date`
`news_attachments`.`uploader_id`
`news_attachments`.`created_at`
`news_read_logs`.*
`news_read_logs`.`log_id`
`news_read_logs`.`news_id`
`news_read_logs`.`user_id`
`news_read_logs`.`read_at`
`news_types`.*
`news_types`.`type_id`
`news_types`.`type_name`
`news_types`.`type_color`
`news_types`.`sort_order`
`news_types`.`is_active`
`news_types`.`created_at`
`news_types`.`updated_at`
`paper_authors`.*
`paper_authors`.`id`
`paper_authors`.`paper_id`
`paper_authors`.`author_order`
`paper_authors`.`first_name`
`paper_authors`.`last_name`
`paper_authors`.`email`
`paper_authors`.`phone`
`paper_authors`.`institution`
`paper_authors`.`department`
`paper_authors`.`position`
`paper_authors`.`country`
`paper_authors`.`is_corresponding`
`paper_authors`.`created_at`
`paperdecision`.*
`paperdecision`.`Decision_Id`
`paperdecision`.`Paper_Id`
`paperdecision`.`Decision`
`paperdecision`.`DecisionDate`
`paperdecision`.`Comments`
`paperdecision`.`Editor_Id`
`paperdecision`.`Notification_Sent`
`paperdecision`.`NotificationDate`
`paperdecision`.`RevisionDueDate`
`paperdecision`.`IsFinal`
`paperdecision`.`Volume`
`paperdecision`.`Issue`
`password_change_log`.*
`password_change_log`.`id`
`password_change_log`.`user_Id`
`password_change_log`.`changed_at`
`password_change_log`.`ip_address`
`password_history`.*
`password_history`.`history_id`
`password_history`.`user_id`
`password_history`.`password_hash`
`password_history`.`created_time`
`payment_summary`.*
`payment_summary`.`payment_status`
`payment_summary`.`payment_method`
`payment_summary`.`count`
`payment_summary`.`total_amount`
`payment_summary`.`payment_currency`
`payments`.*
`payments`.`Payment_id`
`payments`.`Paper_Id`
`payments`.`Amount`
`payments`.`PaymentStatus`
`payments`.`PaymentMethod`
`payments`.`PaymentDate`
`payments`.`InvoiceNumber`
`payments`.`Transaction_Id`
`payments`.`Remark`
`payments`.`CreatedAt`
`payments`.`user_id`
`payments`.`Currency`
`payments`.`ReceiptUrl`
`payments`.`created_at`
`payments`.`updated_at`
`photo_album`.*
`photo_album`.`id`
`photo_album`.`title`
`photo_album`.`image_path`
`photo_album`.`description`
`photo_album`.`album_category`
`photo_album`.`sort_order`
`photo_album`.`is_active`
`photo_album`.`created_at`
`photo_album`.`updated_at`
`presentation_guidelines`.*
`presentation_guidelines`.`id`
`presentation_guidelines`.`type`
`presentation_guidelines`.`content`
`presentation_guidelines`.`display_order`
`presentations`.*
`presentations`.`id`
`presentations`.`presentation_id`
`presentations`.`paper_id`
`presentations`.`authors`
`presentations`.`title`
`presentations`.`category_id`
`presentations`.`presentation_type`
`presentations`.`session_date`
`presentations`.`session_time`
`presentations`.`location`
`presentations`.`is_award_winner`
`presentations`.`display_order`
`registration_fees`.*
`registration_fees`.`id`
`registration_fees`.`identity`
`registration_fees`.`deadline`
`registration_fees`.`fee_local`
`registration_fees`.`fee_oversea`
`registration_fees`.`currency_local`
`registration_fees`.`currency_oversea`
`registration_fees`.`note`
`registration_fees`.`is_active`
`registration_fees`.`created_at`
`registrations`.*
`registrations`.`id`
`registrations`.`first_name`
`registrations`.`last_name`
`registrations`.`email`
`registrations`.`phone`
`registrations`.`affiliation`
`registrations`.`identity`
`registrations`.`paper_id`
`registrations`.`presentation_type`
`registrations`.`paper_title`
`registrations`.`lunch_day1`
`registrations`.`lunch_day1_type`
`registrations`.`lunch_day1_special_note`
`registrations`.`lunch_day2`
`registrations`.`lunch_day2_type`
`registrations`.`lunch_day2_special_note`
`registrations`.`banquet`
`registrations`.`banquet_diet_type`
`registrations`.`banquet_special_note`
`registrations`.`extra_banquet_tickets`
`registrations`.`payment_method`
`registrations`.`payment_status`
`registrations`.`payment_amount`
`registrations`.`payment_currency`
`registrations`.`payment_date`
`registrations`.`payment_reference`
`registrations`.`payment_proof_url`
`registrations`.`payment_proof_uploaded_at`
`registrations`.`transfer_last_digits`
`registrations`.`tax_id_number`
`registrations`.`receipt_title`
`registrations`.`special_requests`
`registrations`.`agreement`
`registrations`.`registration_status`
`registrations`.`created_at`
`registrations`.`updated_at`
`registrations`.`submitted_at`
`registrations`.`registration_number`
`reviewassignments`.*
`reviewassignments`.`assignment_id`
`reviewassignments`.`paper_id`
`reviewassignments`.`reviewer_id`
`reviewassignments`.`assigned_date`
`reviewassignments`.`deadline`
`reviewassignments`.`status`
`reviewassignments`.`progress`
`reviewassignments`.`note`
`reviewassignments`.`decision`
`reviewassignments`.`feedback`
`reviewcomments`.*
`reviewcomments`.`id`
`reviewcomments`.`Paper_Id`
`reviewcomments`.`Reviewer_Id`
`reviewcomments`.`content`
`reviewcomments`.`decision`
`reviewcomments`.`Is_final`
`reviewcomments`.`created_at`
`reviewcontent`.*
`reviewcontent`.`Paper_Id`
`reviewcontent`.`Submission_code`
`reviewcontent`.`auther_id`
`reviewcontent`.`abstract`
`reviewcontent`.`Keywords`
`reviewcontent`.`Category`
`reviewcontent`.`FilePath`
`reviewcontent`.`Status`
`reviewcontent`.`SubmissionDate`
`reviewcontent`.`LastUpdate`
`reviewcontent`.`Note`
`reviewcontent`.`Review_status`
`reviewcontent`.`Review_result`
`reviewcontent`.`Submission_date`
`reviewcontent`.`Review_comments`
`reviewcontent`.`PaperTitle`
`reviewcontent`.`main_category_id`
`reviewcontent`.`subcategory_code`
`reviewcontent`.`final_reviewer_id`
`reviewcontent`.`word_file_path`
`reviewcontent`.`has_word_file`
`reviewcontent`.`file_upload_date`
`reviewcontent`.`total_file_size`
`reviewcontent`.`revision_count`
`reviewcontent`.`revision_deadline`
`reviewcontent`.`is_resubmitted`
`reviewcontent`.`original_review_result`
`reviewreminders`.*
`reviewreminders`.`reminder_id`
`reviewreminders`.`assignment_id`
`reviewreminders`.`message`
`reviewreminders`.`created_at`
`schedule_images`.*
`schedule_images`.`id`
`schedule_images`.`title`
`schedule_images`.`image_path`
`schedule_images`.`description`
`schedule_images`.`is_active`
`schedule_images`.`sort_order`
`schedule_images`.`created_at`
`schedule_images`.`updated_at`
`schedule_timeslots`.*
`schedule_timeslots`.`id`
`schedule_timeslots`.`time_slot`
`schedule_timeslots`.`day_wed_title`
`schedule_timeslots`.`day_wed_location`
`schedule_timeslots`.`day_wed_type`
`schedule_timeslots`.`day_thu_title`
`schedule_timeslots`.`day_thu_location`
`schedule_timeslots`.`day_thu_type`
`schedule_timeslots`.`day_fri_title`
`schedule_timeslots`.`day_fri_location`
`schedule_timeslots`.`day_fri_type`
`schedule_timeslots`.`display_order`
`security_dashboard`.*
`security_dashboard`.`login_date`
`security_dashboard`.`total_attempts`
`security_dashboard`.`failed_attempts`
`security_dashboard`.`successful_logins`
`security_dashboard`.`unique_ips`
`security_dashboard`.`unique_emails`
`security_events`.*
`security_events`.`event_id`
`security_events`.`event_type`
`security_events`.`severity`
`security_events`.`source_ip`
`security_events`.`user_id`
`security_events`.`description`
`security_events`.`event_time`
`security_events`.`resolved`
`security_events`.`resolution_notes`
`session_categories`.*
`session_categories`.`id`
`session_categories`.`code`
`session_categories`.`title`
`session_categories`.`description`
`session_categories`.`display_order`
`speaker_types`.*
`speaker_types`.`id`
`speaker_types`.`type_name`
`speaker_types`.`display_order`
`speakers`.*
`speakers`.`id`
`speakers`.`type_id`
`speakers`.`name`
`speakers`.`affiliation`
`speakers`.`topic`
`speakers`.`biography`
`speakers`.`session`
`speakers`.`image_path`
`speakers`.`abstract_pdf_path`
`speakers`.`display_order`
`speakers`.`updated_at`
`sponsors`.*
`sponsors`.`id`
`sponsors`.`name`
`sponsors`.`logo_path`
`sponsors`.`website`
`sponsors`.`sort_order`
`sponsors`.`is_active`
`sponsors`.`created_at`
`sponsors`.`updated_at`
`submission_statistics`.*
`submission_statistics`.`submission_year`
`submission_statistics`.`main_category_id`
`submission_statistics`.`subcategory_code`
`submission_statistics`.`submission_count`
`submission_statistics`.`max_serial_number`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_name`
`system_settings`.`setting_value`
`system_settings`.`description`
`system_settings`.`category`
`system_settings`.`last_modified`
`system_settings`.`modified_by`
`systemsnotifications`.*
`systemsnotifications`.`Notification_Id`
`systemsnotifications`.`User_Id`
`systemsnotifications`.`Title`
`systemsnotifications`.`Content`
`systemsnotifications`.`Type`
`systemsnotifications`.`Is_Read`
`systemsnotifications`.`CreatedAt`
`systemsnotifications`.`ExpiryDate`
`systemsnotifications`.`Priority`
`systemsnotifications`.`ReferenceType`
`systemsnotifications`.`Reference_id`
`systemsnotifications`.`Recipient_type`
`systemsnotifications`.`Status`
`systemsnotifications`.`Scheduled_time`
`systemsnotifications`.`Created_by`
`systemsnotifications`.`recipient_type_details`
`systemsnotifications`.`send_email`
`systemsnotifications`.`updated_at`
`target_audience`.*
`target_audience`.`id`
`target_audience`.`category`
`target_audience`.`description`
`target_audience`.`icon`
`templates`.*
`templates`.`id`
`templates`.`name`
`templates`.`file_path`
`templates`.`type`
`templates`.`display_order`
`topic_items`.*
`topic_items`.`id`
`topic_items`.`topic_id`
`topic_items`.`item_title`
`user_activities`.*
`user_activities`.`activity_id`
`user_activities`.`user_id`
`user_activities`.`activity_type`
`user_activities`.`description`
`user_activities`.`ip_address`
`user_activities`.`user_agent`
`user_activities`.`activity_time`
`user_activities`.`additional_data`
`user_sessions`.*
`user_sessions`.`session_id`
`user_sessions`.`user_id`
`user_sessions`.`ip_address`
`user_sessions`.`user_agent`
`user_sessions`.`login_time`
`user_sessions`.`last_activity`
`user_sessions`.`logout_time`
`user_sessions`.`session_status`
`users`.*
`users`.`user_id`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`full_name`
`users`.`role`
`users`.`status`
`users`.`last_login`
`users`.`created_at`
`users`.`updated_at`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
access_logs
accountmanger
banquet_summary
committee_categories
committee_members
conference_history
conference_info
conference_objectives
conference_photos
conference_subtopics
conference_topics
countries
dictionary
important_dates
login_attempts
login_log
lunch_summary
news
news_attachments
news_read_logs
news_types
paper_authors
paperdecision
password_change_log
password_history
payment_summary
payments
photo_album
presentation_guidelines
presentations
registration_fees
registrations
reviewassignments
reviewcomments
reviewcontent
reviewreminders
schedule_images
schedule_timeslots
security_dashboard
security_events
session_categories
speaker_types
speakers
sponsors
submission_statistics
system_settings
systemsnotifications
target_audience
templates
topic_items
user_activities
user_sessions
users
SQL query on database
test
: