xero1991lottery.com / 127.0.0.1 / prison_db_8080

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		prison_db_8080 activity_audit
id : bigint(20) unsigned
occurred_at : datetime
user_id : int(11)
username : varchar(150)
action_type : varchar(16)
entity_type : varchar(50)
entity_id : varchar(100)
summary : varchar(255)
details_json : longtext

v		prison_db_8080 bookings
id : int(11)
inmate_name : varchar(255)
relative_name : varchar(255)
booking_date : date
booking_round : varchar(100)
booking_round_id : int(11)
booking_note : text
created_at : datetime

v		prison_db_8080 booking_visitors
id : bigint(20)
booking_id : bigint(20)
visitor_name : varchar(255)
id_card : varchar(80)
created_at : timestamp

v		prison_db_8080 booking_visitor_history
visitor_record_id : bigint(20)
booking_id : bigint(20)
id_card : varchar(80)
visitor_name : varchar(255)
inmate_name : varchar(255)
booking_date : date
booking_round : varchar(255)
recorded_at : datetime

v		prison_db_8080 inmates
id : int(11)
inmate_fullname : varchar(255)
inmate_gender : varchar(10)
inmate_code : varchar(50)
deposit_account_no : varchar(100)
inmate_id_card : varchar(13)
inmate_race : varchar(100)
inmate_nationality : varchar(100)
inmate_age : int(3)
inmate_address : text
relative_name_1 : varchar(255)
relative_name_2 : varchar(255)
relative_name_3 : varchar(255)
relative_name_4 : varchar(255)
relative_name_5 : varchar(255)
relative_name_6 : varchar(255)
relative_name_7 : varchar(255)
relative_name_8 : varchar(255)
relative_name_9 : varchar(255)
relative_name_10 : varchar(255)
photo_path : varchar(255)
created_at : timestamp
rel_updated_1 : date
rel_updated_2 : date
rel_updated_3 : date
rel_updated_4 : date
rel_updated_5 : date
rel_updated_6 : date
rel_updated_7 : date
rel_updated_8 : date
rel_updated_9 : date
rel_updated_10 : date
relative_updated_1 : date
relative_updated_2 : date
relative_updated_3 : date
relative_updated_4 : date
relative_updated_5 : date
relative_updated_6 : date
relative_updated_7 : date
relative_updated_8 : date
relative_updated_9 : date
relative_updated_10 : date
relative_name_11 : varchar(255)
relative_updated_11 : date
relative_name_12 : varchar(255)
relative_updated_12 : date
relative_name_13 : varchar(255)
relative_updated_13 : date
relative_name_14 : varchar(255)
relative_updated_14 : date
relative_name_15 : varchar(255)
relative_updated_15 : date
relative_name_16 : varchar(255)
relative_updated_16 : date

v		prison_db_8080 inmate_deletion_archive
id : bigint(20) unsigned
inmate_id : int(11)
inmate_code : varchar(100)
inmate_name : varchar(255)
record_json : longtext
deleted_by : varchar(255)
deleted_at : datetime

v		prison_db_8080 inmate_relative_history
id : bigint(20) unsigned
inmate_id : int(11)
inmate_name : varchar(255)
event_day : date
recorded_at : datetime
actor_id : int(11)
before_json : longtext
after_json : longtext

v		prison_db_8080 inmate_relative_relationships
id : bigint(20) unsigned
inmate_code : varchar(100)
inmate_name : varchar(255)
slot_no : tinyint(3) unsigned
relative_name : varchar(255)
relationship : varchar(120)
created_at : datetime
updated_at : datetime

v		prison_db_8080 inmate_review_relatives
id : bigint(20) unsigned
roster_key : varchar(40)
relative_no : int(11)
relative_name : varchar(255)
relationship : varchar(120)
created_at : datetime

v		prison_db_8080 inmate_review_roster
id : bigint(20) unsigned
roster_key : varchar(40)
source_sheet : varchar(100)
source_row : int(11)
source_seq : varchar(50)
inmate_prefix : varchar(30)
inmate_name : varchar(255)
sex : varchar(20)
review_status : enum('pending','confirmed','not_present')
reviewed_at : datetime
created_at : datetime

v		prison_db_8080 relatives
id : int(11)
id_card : varchar(13)
fullname : varchar(255)
race : varchar(100)
nationality : varchar(100)
age : int(3)
address : text
phone : varchar(10)
inmate_name : varchar(255)
photo : longtext
created_at : timestamp
updated_at : timestamp
inmate_code : varchar(100)
relationship : varchar(120)

v		prison_db_8080 users
id : int(11)
id_card : varchar(13)
username : varchar(100)
password : varchar(255)
firstname : varchar(100)
lastname : varchar(100)
phone : varchar(10)
role : varchar(20)
created_at : timestamp

v		prison_db_8080 user_permissions
id : int(10) unsigned
user_id : int(10) unsigned
permission_key : varchar(50)
is_allowed : tinyint(1)
updated_at : timestamp

v		prison_db_8080 vip_visit_audit
id : bigint(20) unsigned
user_id : int(11)
username : varchar(255)
action : varchar(40)
details : longtext
created_at : datetime

v		prison_db_8080 vip_visit_grants
id : bigint(20) unsigned
inmate_id : int(11)
inmate_code : varchar(255)
inmate_name : varchar(255)
visit_date : date
note : text
granted_by : int(11)
granted_username : varchar(255)
granted_at : datetime
revoked_at : datetime
revoked_by : int(11)

v		prison_db_8080 visitors
id : int(11)
fullname : varchar(255)
race : varchar(100)
nationality : varchar(100)
age : int(3)
address : text
phone : varchar(10)
inmate_name : varchar(255)
photo : longtext
created_at : timestamp

v		prison_db_8080 visit_discipline_suspensions
id : bigint(20) unsigned
inmate_name : varchar(255)
inmate_code : varchar(100)
offense : text
start_date : date
end_date : date
order_no : varchar(150)
note : text
created_at : datetime
updated_at : datetime

v		prison_db_8080 visit_rounds
id : int(11)
period : enum('morning','afternoon')
round_no : int(11)
start_time : time
end_time : time
gender : enum('male','female')
capacity : int(11)
is_active : tinyint(1)
sort_order : int(11)

v		prison_db_8080 visit_settings
setting_key : varchar(80)
setting_value : varchar(255)
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update