isnst.eng.stust.edu.tw / 127.0.0.1 / test

There are no favorite tables.

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`).
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.

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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

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 :

Untitled *

v		test access_logs
log_id : int(11)
user_id : int(11)
resource_type : varchar(50)
resource_id : varchar(100)
action : varchar(50)
result : enum('ALLOW','DENY')
ip_address : varchar(45)
user_agent : text
access_time : datetime

v		test accountmanger
user_Id : int(11)
email : varchar(255)
Password_hash : varchar(255)
FirstName : varchar(50)
LastName : varchar(50)
Institution : varchar(100)
Department : varchar(100)
Position : varchar(50)
PhoneNumber : varchar(20)
ProfilePicture : varchar(255)
Bio : text
RegistrationDate : datetime
LastLoginDate : datetime
AccountType : enum('管理員','審查者','投稿者','最終審稿者','admin','reviewer','author','super_reviewer')
CreatedAt : datetime
UpdatedAt : datetime
VerificationStatus : enum('Active','Inactive','Suspended')
AccountStatus : tinyint(1)
ResetToken : varchar(255)
Country : varchar(50)
LoginCount : int(11)
LastLoginCountry : varchar(50)
Title : enum('Mr.','Mrs.','Ms.','Dr.','Prof.')
FailedLoginCount : int(11)
AccountLockedUntil : datetime
PasswordChangeRequired : tinyint(1)
LastPasswordChange : datetime

v		test banquet_summary
total_attendees : decimal(22,0)
regular_count : decimal(22,0)
vegetarian_count : decimal(22,0)
special_count : decimal(22,0)
extra_tickets_total : decimal(32,0)

v		test committee_categories
id : int(11)
name : varchar(100)
display_order : int(11)

v		test committee_members
id : int(11)
category_id : int(11)
name : varchar(100)
affiliation : varchar(255)
display_order : int(11)

v		test conference_history
id : int(11)
year : int(11)
start_date : date
end_date : date
location : varchar(255)
theme : varchar(255)
participants : varchar(100)
countries_count : int(11)
format : varchar(100)

v		test conference_info
id : int(11)
year : int(11)
title : varchar(255)
location : varchar(255)
start_date : date
end_date : date
host_organization : varchar(255)
description : text
sponsor_info : text

v		test conference_objectives
id : int(11)
icon : varchar(100)
title : varchar(255)
description : text

v		test conference_photos
id : int(11)
title : varchar(255)
description : text
image_path : varchar(255)
display_order : int(11)

v		test conference_subtopics
id : int(11)
category_id : int(11)
subtopic_code : int(11)
topic_name : varchar(255)

v		test conference_topics
id : int(11)
topic_code : int(11)
category_name : varchar(255)
description : text

v		test countries
country_id : int(11)
country_code : varchar(2)
country_name_zh : varchar(50)
country_name_en : varchar(50)
region : varchar(50)

v		test dictionary
id : int(11)
vocabulary : varchar(255)
meaning : varchar(255)

v		test important_dates
id : int(11)
title : varchar(255)
date_start : date
date_end : date
old_date : varchar(255)
is_strikethrough : tinyint(1)
is_highlight : tinyint(1)
description : text
icon : varchar(100)
sort_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		test login_attempts
attempt_id : int(11)
email : varchar(255)
ip_address : varchar(45)
user_agent : text
status : enum('ATTEMPT','SUCCESS','FAILED_INVALID_PASSWORD','FAILED_USER_NOT_FOUND','FAILED_ACCOUNT_INACTIVE')
attempt_time : datetime

v		test login_log
log_id : int(11)
user_id : int(11)
login_time : datetime
login_ip : varchar(50)
country : varchar(50)
device_info : varchar(255)
login_status : tinyint(1)

v		test lunch_summary
lunch_day : varchar(13)
total_needed : decimal(22,0)
regular_count : decimal(22,0)
vegetarian_count : decimal(22,0)
special_count : decimal(22,0)

v		test news
news_id : int(10) unsigned
title : varchar(255)
content : text
type : varchar(50)
important : tinyint(1)
status : varchar(20)
visibility : varchar(50)
create_date : date
publish_date : date
author_id : int(10) unsigned
updated_by : int(10) unsigned
update_date : date
created_at : timestamp
updated_at : timestamp

v		test news_attachments
attachment_id : int(10) unsigned
news_id : int(10) unsigned
filename : varchar(255)
original_filename : varchar(255)
file_path : varchar(255)
file_size : int(10) unsigned
file_type : varchar(100)
upload_date : date
uploader_id : int(10) unsigned
created_at : timestamp

v		test news_read_logs
log_id : int(10) unsigned
news_id : int(10) unsigned
user_id : int(10) unsigned
read_at : timestamp

v		test news_types
type_id : int(10) unsigned
type_name : varchar(50)
type_color : varchar(20)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		test paperdecision
Decision_Id : int(11)
Paper_Id : int(11)
Decision : enum('accept','minor_revision','major_revision','reject','revise_and_resubmit')
DecisionDate : datetime
Comments : text
Editor_Id : int(11)
Notification_Sent : tinyint(1)
NotificationDate : datetime
RevisionDueDate : date
IsFinal : tinyint(1)
Volume : varchar(20)
Issue : varchar(20)

v		test paper_authors
id : int(11)
paper_id : int(11)
author_order : int(11)
first_name : varchar(100)
last_name : varchar(100)
email : varchar(255)
phone : varchar(20)
institution : varchar(255)
department : varchar(100)
position : varchar(100)
country : varchar(50)
is_corresponding : tinyint(1)
created_at : datetime

v		test password_change_log
id : int(11)
user_Id : int(11)
changed_at : datetime
ip_address : varchar(45)

v		test password_history
history_id : int(11)
user_id : int(11)
password_hash : varchar(255)
created_time : datetime

v		test payments
Payment_id : int(11)
Paper_Id : int(11)
Amount : decimal(10,2)
PaymentStatus : enum('未繳費','已繳費','待確認')
PaymentMethod : enum('')
PaymentDate : timestamp
InvoiceNumber : varchar(50)
Transaction_Id : varchar(100)
Remark : text
CreatedAt : timestamp
user_id : int(11)
Currency : char(3)
ReceiptUrl : varchar(255)
created_at : timestamp
updated_at : timestamp

v		test payment_summary
payment_status : enum('pending','paid','failed','refunded','proof_uploaded')
payment_method : enum('invited','overseas','taiwan')
count : bigint(21)
total_amount : decimal(32,2)
payment_currency : varchar(3)

v		test photo_album
id : int(10) unsigned
title : varchar(255)
image_path : varchar(500)
description : text
album_category : varchar(100)
sort_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		test presentations
id : int(11)
presentation_id : varchar(20)
paper_id : varchar(20)
authors : varchar(255)
title : varchar(255)
category_id : int(11)
presentation_type : enum('oral','poster')
session_date : date
session_time : varchar(50)
location : varchar(255)
is_award_winner : tinyint(4)
display_order : int(11)

v		test presentation_guidelines
id : int(11)
type : varchar(50)
content : text
display_order : int(11)

v		test registrations
id : int(11)
first_name : varchar(100)
last_name : varchar(100)
email : varchar(255)
phone : varchar(50)
affiliation : varchar(255)
identity : varchar(100)
paper_id : varchar(50)
presentation_type : varchar(20)
paper_title : text
lunch_day1 : enum('yes','no')
lunch_day1_type : enum('regular','vegetarian','special')
lunch_day1_special_note : text
lunch_day2 : enum('yes','no')
lunch_day2_type : enum('regular','vegetarian','special')
lunch_day2_special_note : text
banquet : tinyint(1)
banquet_diet_type : enum('regular','vegetarian','special')
banquet_special_note : text
extra_banquet_tickets : int(11)
payment_method : enum('invited','overseas','taiwan')
payment_status : enum('pending','paid','failed','refunded','proof_uploaded')
payment_amount : decimal(10,2)
payment_currency : varchar(3)
payment_date : datetime
payment_reference : varchar(255)
payment_proof_url : varchar(500)
payment_proof_uploaded_at : timestamp
transfer_last_digits : varchar(10)
tax_id_number : varchar(20)
receipt_title : varchar(255)
special_requests : text
agreement : tinyint(1)
registration_status : enum('draft','submitted','confirmed','cancelled')
created_at : timestamp
updated_at : timestamp
submitted_at : timestamp
registration_number : varchar(20)

v		test registration_fees
id : int(11)
identity : varchar(100)
deadline : varchar(100)
fee_local : int(11)
fee_oversea : int(11)
currency_local : varchar(3)
currency_oversea : varchar(3)
note : char(1)
is_active : tinyint(1)
created_at : timestamp

v		test reviewassignments
assignment_id : int(11)
paper_id : int(11)
reviewer_id : int(11)
assigned_date : datetime
deadline : date
status : enum('pending','in_progress','completed','declined')
progress : int(11)
note : text
decision : varchar(50)
feedback : text

v		test reviewcomments
id : int(11)
Paper_Id : int(11)
Reviewer_Id : int(11)
content : text
decision : enum('accept','minor_revision','major_revision','reject')
Is_final : tinyint(1)
created_at : timestamp

v		test reviewcontent
Paper_Id : int(11)
Submission_code : varchar(50)
auther_id : int(11)
abstract : text
Keywords : varchar(255)
Category : varchar(100)
FilePath : varchar(255)
Status : enum('submitted','under review','accepted','rejected','revised')
SubmissionDate : datetime
LastUpdate : datetime
Note : text
Review_status : enum('pending','in_progress','completed','declined')
Review_result : enum('accept','minor_revision','major_revision','reject')
Submission_date : datetime
Review_comments : text
PaperTitle : varchar(255)
main_category_id : int(11)
subcategory_code : varchar(10)
final_reviewer_id : int(11)
word_file_path : varchar(500)
has_word_file : tinyint(1)
file_upload_date : datetime
total_file_size : int(11)
revision_count : int(11)
revision_deadline : date
is_resubmitted : tinyint(1)
original_review_result : varchar(50)

v		test reviewreminders
reminder_id : int(11)
assignment_id : int(11)
message : text
created_at : datetime

v		test schedule_images
id : int(11)
title : varchar(255)
image_path : varchar(255)
description : mediumtext
is_active : tinyint(1)
sort_order : int(11)
created_at : datetime
updated_at : datetime

v		test schedule_timeslots
id : int(11)
time_slot : varchar(50)
day_wed_title : varchar(255)
day_wed_location : varchar(255)
day_wed_type : varchar(50)
day_thu_title : varchar(255)
day_thu_location : varchar(255)
day_thu_type : varchar(50)
day_fri_title : varchar(255)
day_fri_location : varchar(255)
day_fri_type : varchar(50)
display_order : int(11)

v		test security_dashboard
login_date : date
total_attempts : bigint(21)
failed_attempts : decimal(22,0)
successful_logins : decimal(22,0)
unique_ips : bigint(21)
unique_emails : bigint(21)

v		test security_events
event_id : int(11)
event_type : varchar(50)
severity : enum('LOW','MEDIUM','HIGH','CRITICAL')
source_ip : varchar(45)
user_id : int(11)
description : text
event_time : datetime
resolved : tinyint(1)
resolution_notes : text

v		test session_categories
id : int(11)
code : varchar(10)
title : varchar(255)
description : text
display_order : int(11)

v		test speakers
id : int(11)
type_id : int(11)
name : varchar(100)
affiliation : varchar(255)
topic : varchar(255)
biography : text
session : varchar(100)
image_path : varchar(255)
abstract_pdf_path : varchar(255)
display_order : int(11)
updated_at : timestamp

v		test speaker_types
id : int(11)
type_name : varchar(50)
display_order : int(11)

v		test sponsors
id : int(11)
name : varchar(255)
logo_path : varchar(255)
website : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime

v		test submission_statistics
submission_year : int(4)
main_category_id : int(11)
subcategory_code : varchar(10)
submission_count : bigint(21)
max_serial_number : bigint(20) unsigned

v		test systemsnotifications
Notification_Id : int(11)
User_Id : int(11)
Title : varchar(255)
Content : text
Type : enum('submission','review','decision','system','payment')
Is_Read : tinyint(1)
CreatedAt : datetime
ExpiryDate : datetime
Priority : enum('low','normal','high','urgent')
ReferenceType : varchar(50)
Reference_id : int(11)
Recipient_type : varchar(50)
Status : enum('pending','sent','processed','cancelled')
Scheduled_time : datetime
Created_by : int(11)
recipient_type_details : text
send_email : tinyint(1)
updated_at : datetime

v		test system_settings
setting_id : int(11)
setting_name : varchar(100)
setting_value : text
description : text
category : varchar(50)
last_modified : datetime
modified_by : int(11)

v		test target_audience
id : int(11)
category : varchar(100)
description : text
icon : varchar(100)

v		test templates
id : int(11)
name : varchar(255)
file_path : varchar(255)
type : varchar(50)
display_order : int(11)

v		test topic_items
id : int(11)
topic_id : int(11)
item_title : varchar(255)

v		test users
user_id : int(10) unsigned
username : varchar(50)
password : varchar(255)
email : varchar(100)
full_name : varchar(100)
role : varchar(50)
status : tinyint(1)
last_login : timestamp
created_at : timestamp
updated_at : timestamp

v		test user_activities
activity_id : int(11)
user_id : int(11)
activity_type : varchar(50)
description : text
ip_address : varchar(45)
user_agent : text
activity_time : datetime
additional_data : longtext

v		test user_sessions
session_id : varchar(64)
user_id : int(11)
ip_address : varchar(45)
user_agent : text
login_time : datetime
last_activity : datetime
logout_time : datetime
session_status : enum('Active','Expired','Terminated')

Create relationship
FOREIGN KEY
on delete
on update