baranguardph.win / 127.0.0.1 / baranguard_uiseed

There are no favorite tables.

New
baranguard
- baranguard
- baranguard_uiseed
information_schema
mysql
performance_schema
phpmyadmin
test

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		baranguard_uiseed ai_evaluation_run
evaluation_run_id : bigint(20) unsigned
dataset_name : varchar(128)
dataset_version : varchar(64)
model_version : varchar(128)
task_type : varchar(64)
sample_count : int(10) unsigned
precision_score : decimal(6,5)
recall_score : decimal(6,5)
metric_a_name : varchar(32)
metric_a_value : decimal(8,5)
metric_b_name : varchar(32)
metric_b_value : decimal(8,5)
created_at : datetime
notes : text

v		baranguard_uiseed ai_processing_log
log_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
requested_by_user_id : bigint(20) unsigned
pipeline_run_id : char(36)
task_type : enum('summarization','redaction','translation','extraction','blotter_assist','classification','sms_compose','threat_analysis')
model_version : varchar(128)
prompt_template_version : varchar(32)
source_language : varchar(16)
target_language : varchar(16)
draft_redacted_narrative : text
draft_summary : text
draft_summary_stale : tinyint(1)
draft_version : int(10) unsigned
translated_text : text
status : enum('queued','processing','completed','failed','superseded')
error_code : varchar(128)
processed_at : datetime
created_at : datetime
draft_complainant_name : varchar(255)
draft_respondent_name : varchar(255)
draft_complainant_contact_number : varchar(32)
tool_input : text
tool_output : text

v		baranguard_uiseed audit_log
audit_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
actor_user_id : bigint(20) unsigned
action : varchar(128)
entity_type : varchar(64)
entity_id : bigint(20) unsigned
metadata_json : longtext
ip_address : varchar(45)
user_agent : varchar(512)
created_at : datetime
idempotency_key : varchar(64)

v		baranguard_uiseed auth_session
session_id : bigint(20) unsigned
user_id : bigint(20) unsigned
jti : char(36)
issued_at : datetime
expires_at : datetime
revoked_at : datetime
ip_address : varchar(45)
user_agent : varchar(512)
session_kind : enum('web','device')
last_seen_at : datetime
last_renewed_at : datetime

v		baranguard_uiseed barangay
barangay_id : smallint(5) unsigned
name : varchar(128)
municipality : varchar(128)
province : varchar(128)
population : int(10) unsigned
boundary_geojson : longtext
created_at : datetime

v		baranguard_uiseed blotter_record
blotter_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
recorded_by : bigint(20) unsigned
approved_by : bigint(20) unsigned
narrative_summary : text
finalized_at : datetime
revision_no : int(10) unsigned
amended_at : datetime
amended_by : bigint(20) unsigned
complainant_name : varchar(255)
respondent_name : varchar(255)
complainant_contact_number : varchar(32)
case_status : enum('active','under_investigation','settled','resolved')
display_id : varchar(20)

v		baranguard_uiseed blotter_revision
revision_id : bigint(20) unsigned
blotter_id : bigint(20) unsigned
revision_no : int(10) unsigned
narrative_summary : text
reason : varchar(1000)
amended_by : bigint(20) unsigned
superseded_at : datetime
complainant_name : varchar(255)
respondent_name : varchar(255)
complainant_contact_number : varchar(32)
case_status : enum('active','under_investigation','settled','resolved')

v		baranguard_uiseed citizen_report
report_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
incident_id : bigint(20) unsigned
contact_number : varchar(32)
description : text
latitude : decimal(10,7)
longitude : decimal(10,7)
submitted_at : datetime
converted_at : datetime
retention_expires_at : datetime
legal_hold : tinyint(1)

v		baranguard_uiseed dispatch
dispatch_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
dispatched_by : bigint(20) unsigned
tanod_id : bigint(20) unsigned
priority : enum('normal','high','critical')
route_json : longtext
route_status : enum('available','unavailable','stale')
status : enum('assigned','en_route','arrived','completed','cancelled')
dispatched_at : datetime
en_route_at : datetime
arrived_at : datetime
completed_at : datetime
cancelled_at : datetime
cancelled_by : bigint(20) unsigned
created_client_request_id : char(36)

v		baranguard_uiseed duty_status
status_id : bigint(20) unsigned
user_id : bigint(20) unsigned
status : enum('on_duty','responding','off_duty')
channel : enum('app','sms')
client_event_id : char(36)
changed_at : datetime

v		baranguard_uiseed evidence_attachment
attachment_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
type : enum('photo','voice')
file_path : varchar(512)
uploaded_by : bigint(20) unsigned
uploaded_at : datetime
sha256 : char(64)
byte_size : bigint(20) unsigned
mime_type : varchar(100)
original_filename : varchar(255)
retention_expires_at : datetime
legal_hold : tinyint(1)
client_request_id : char(36)

v		baranguard_uiseed fatigue_flag
flag_id : bigint(20) unsigned
user_id : bigint(20) unsigned
shift_id : bigint(20) unsigned
hours_worked_7day : decimal(5,2)
calculation_basis : enum('scheduled_hours')
flagged_at : datetime
acknowledged_by : bigint(20) unsigned
acknowledged_at : datetime

v		baranguard_uiseed gps_track
track_id : bigint(20) unsigned
user_id : bigint(20) unsigned
dispatch_id : bigint(20) unsigned
latitude : decimal(10,7)
longitude : decimal(10,7)
accuracy_m : decimal(8,2)
recorded_at : datetime
received_at : datetime
synced_at : datetime
client_event_id : char(36)

v		baranguard_uiseed health_check_log
log_id : bigint(20) unsigned
recorded_at : datetime
db_status : varchar(16)
osrm_status : varchar(16)
ors_status : varchar(16)
ollama_status : varchar(16)
gsm_status : varchar(16)
fcm_status : varchar(16)
sms_status : varchar(16)

v		baranguard_uiseed incident
incident_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
reported_by : bigint(20) unsigned
device_id : varchar(64)
incident_type : enum('theft','physical_injury','disturbance','domestic_dispute','vandalism','traffic_incident','fire','medical_emergency','missing_person','animal_complaint','other')
priority : enum('normal','high','critical')
raw_narrative : text
redacted_narrative : text
redaction_approved_by : bigint(20) unsigned
redaction_approved_at : datetime
status : enum('pending','dispatched','resolved','duplicate','invalid','cancelled','reopened')
duplicate_of_incident_id : bigint(20) unsigned
lifecycle_changed_by : bigint(20) unsigned
lifecycle_changed_at : datetime
source : enum('app','sms','web')
latitude : decimal(10,7)
longitude : decimal(10,7)
created_at : datetime
device_offline_created_at : datetime
client_event_id : char(36)
synced_at : datetime
updated_at : datetime
legal_hold : tinyint(1)
raw_narrative_purged_at : datetime
complainant_name : varchar(255)
respondent_name : varchar(255)
complainant_contact_number : varchar(32)
location_description : varchar(255)
display_id : varchar(20)

v		baranguard_uiseed mobile_device
device_id : varchar(64)
user_id : bigint(20) unsigned
platform : enum('android')
fcm_token : text
device_secret_ref : varchar(255)
device_public_key_pem : text
app_version : varchar(64)
last_seen_at : datetime
is_active : tinyint(1)
created_at : datetime
deactivated_at : datetime
secrets_scrubbed_at : datetime

v		baranguard_uiseed notification
notification_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
notification_type : enum('dispatch','sos','priority_alert','other')
dispatch_id : bigint(20) unsigned
sos_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
created_by : bigint(20) unsigned
created_at : datetime
expires_at : datetime

v		baranguard_uiseed notification_delivery
delivery_id : bigint(20) unsigned
notification_id : bigint(20) unsigned
notification_target_id : bigint(20) unsigned
channel : enum('fcm','sms')
attempt_no : tinyint(3) unsigned
status : enum('initiated','sent','failed','ack_timeout')
provider_message_id : varchar(128)
initiated_at : datetime
sent_at : datetime
ack_timeout_at : datetime
failure_reason : varchar(255)
metadata_json : longtext

v		baranguard_uiseed notification_target
notification_target_id : bigint(20) unsigned
notification_id : bigint(20) unsigned
user_id : bigint(20) unsigned
device_id : varchar(64)
targeted_at : datetime
acknowledged_at : datetime
ack_status : enum('pending','acknowledged','not_required')

v		baranguard_uiseed offline_map_package
package_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
version : varchar(64)
file_path : varchar(512)
checksum_sha256 : char(64)
byte_size : bigint(20) unsigned
created_by : bigint(20) unsigned
created_at : datetime
is_published : tinyint(1)

v		baranguard_uiseed offline_queue
queue_id : bigint(20) unsigned
device_id : varchar(64)
client_event_id : char(36)
payload_type : enum('incident','gps','duty_status','sos','dispatch_status')
sync_metadata_json : longtext
created_offline_at : datetime
received_at : datetime
synced_at : datetime
reconciliation_status : enum('pending','success','duplicate','failed')
failure_reason : varchar(255)

v		baranguard_uiseed rate_limit_counter
limiter_key : varchar(191)
window_start : datetime
request_count : int(10) unsigned

v		baranguard_uiseed shift_schedule
shift_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
user_id : bigint(20) unsigned
patrol_zone : varchar(128)
start_at : datetime
end_at : datetime
created_by : bigint(20) unsigned
version : int(10) unsigned
client_request_id : char(36)
updated_at : datetime

v		baranguard_uiseed shift_swap_request
request_id : bigint(20) unsigned
requesting_user_id : bigint(20) unsigned
shift_id : bigint(20) unsigned
target_user_id : bigint(20) unsigned
reason : varchar(1000)
status : enum('pending','approved','denied')
requested_at : datetime
resolved_at : datetime
resolved_by : bigint(20) unsigned
version : int(10) unsigned
client_request_id : char(36)

v		baranguard_uiseed sms_envelope_replay
message_id : char(36)
device_id : varchar(64)
received_at : datetime

v		baranguard_uiseed sms_log
log_id : bigint(20) unsigned
report_id : bigint(20) unsigned
incident_id : bigint(20) unsigned
dispatch_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
sender_number : varchar(32)
receiver_number : varchar(32)
transport : enum('gsm_modem','semaphore')
message_type : enum('incident','dispatch','priority_alert','coord_ping','confirmation','duty_status','sos','manual')
direction : enum('inbound','outbound')
gateway_message_id : varchar(128)
modem_message_id : varchar(128)
correlation_id : char(36)
status : enum('queued','pending','sent','failed','refunded','received','rejected','deduplicated')
sent_at : datetime
received_at : datetime
failure_reason : varchar(255)
created_at : datetime
message_body : text
read_at : datetime
legal_hold : tinyint(1)

v		baranguard_uiseed sms_subscriber
subscriber_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
contact_number : varchar(32)
consent_at : datetime
consent_source : enum('walk_in','staff_entry','sms_keyword')
consent_note : varchar(255)
opted_out_at : datetime
created_by_user_id : bigint(20) unsigned
created_at : datetime

v		baranguard_uiseed system_settings
setting_key : varchar(100)
setting_value : text
updated_at : datetime
updated_by : bigint(20) unsigned

v		baranguard_uiseed tanod_sos
sos_id : bigint(20) unsigned
user_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
dispatch_id : bigint(20) unsigned
latitude : decimal(10,7)
longitude : decimal(10,7)
location_source : enum('live','last_known','no_fix')
location_recorded_at : datetime
triggered_at : datetime
received_at : datetime
status : enum('active','acknowledged','resolved')
acknowledged_by : bigint(20) unsigned
acknowledged_at : datetime
resolved_by : bigint(20) unsigned
resolved_at : datetime
client_event_id : char(36)
fallback_channel : enum('app','sms')

v		baranguard_uiseed user
user_id : bigint(20) unsigned
barangay_id : smallint(5) unsigned
username : varchar(64)
password_hash : varchar(255)
full_name : varchar(255)
role : enum('admin','secretary','tanod','punong_barangay','lupon')
contact_number : varchar(32)
is_active : tinyint(1)
failed_login_attempts : int(10) unsigned
login_failure_window_started_at : datetime
locked_until : datetime
created_at : datetime
updated_at : datetime
is_suspended : tinyint(1)
suspended_reason : varchar(255)
suspended_at : datetime

Create relationship
FOREIGN KEY
on delete
on update