ayteee-101.tail9d2b42.ts.net / 127.0.0.1 / prime_hrm

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		prime_hrm account_types
id : int(10) unsigned
name : varchar(100)
slug : varchar(100)
subject_type : enum('person','school','office','system','external')
description : varchar(255)
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm audit_logs
id : bigint(20) unsigned
user_id : int(10) unsigned
action : varchar(120)
entity_type : varchar(100)
entity_id : bigint(20) unsigned
details : text
ip_address : varchar(64)
user_agent : varchar(255)
created_at : timestamp

v		prime_hrm competencies
id : int(10) unsigned
code : varchar(80)
name : varchar(180)
category : enum('core','leadership','functional','technical')
description : text
is_active : tinyint(1)

v		prime_hrm dashboard_widgets
id : int(10) unsigned
name : varchar(120)
slug : varchar(120)
label : varchar(120)
icon : varchar(50)
default_value : varchar(60)
helper_text : varchar(180)
data_source : varchar(255)
is_global : tinyint(1)
is_active : tinyint(1)
sort_order : int(11)

v		prime_hrm documents
id : bigint(20) unsigned
module_slug : varchar(120)
entity_type : varchar(100)
entity_id : bigint(20) unsigned
employee_id : int(10) unsigned
title : varchar(180)
file_name : varchar(255)
file_path : varchar(500)
mime_type : varchar(120)
uploaded_by : int(10) unsigned
uploaded_at : timestamp

v		prime_hrm employees
id : int(10) unsigned
employee_no : varchar(50)
identity_kind : varchar(40)
first_name : varchar(100)
middle_name : varchar(100)
last_name : varchar(100)
suffix : varchar(30)
email : varchar(180)
mobile : varchar(50)
office_id : int(10) unsigned
school_id : int(10) unsigned
position_id : int(10) unsigned
personnel_category_id : int(10) unsigned
employment_status : varchar(80)
date_hired : date
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		prime_hrm employee_assignment_history
id : bigint(20) unsigned
employee_id : int(10) unsigned
position_id : int(10) unsigned
personnel_category_id : int(10) unsigned
office_id : int(10) unsigned
school_id : int(10) unsigned
employment_status : varchar(80)
movement_id : bigint(20) unsigned
effective_from : date
effective_to : date
is_current : tinyint(1)
order_no : varchar(120)
remarks : text
created_at : timestamp

v		prime_hrm employee_competencies
employee_id : int(10) unsigned
competency_id : int(10) unsigned
required_level : decimal(5,2)
assessed_level : decimal(5,2)
assessed_at : date

v		prime_hrm external_content_pages
id : int(10) unsigned
source_id : int(10) unsigned
page_title : varchar(255)
page_heading : varchar(255)
content : longtext
raw_html : longtext
content_hash : varchar(64)
synced_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm external_content_sources
id : int(10) unsigned
module_code : varchar(50)
source_name : varchar(255)
source_url : text
source_type : enum('google_site','google_sheet','google_drive','api')
sync_enabled : tinyint(1)
last_content_hash : varchar(64)
last_sync_at : datetime
status : enum('active','inactive','error')
created_at : timestamp
updated_at : timestamp

v		prime_hrm external_content_sync_logs
id : bigint(20) unsigned
source_id : int(10) unsigned
sync_status : enum('success','no_change','warning','error')
message : text
synced_at : timestamp

v		prime_hrm ld_activities
id : bigint(20) unsigned
activity_no : varchar(80)
program_id : bigint(20) unsigned
title : varchar(220)
plan_year : varchar(20)
start_date : date
end_date : date
venue : varchar(220)
provider : varchar(180)
budget_source : varchar(120)
approved_budget : decimal(14,2)
actual_cost : decimal(14,2)
target_slots : int(11)
status : enum('proposed','for_approval','approved','scheduled','ongoing','completed','cancelled')
approval_remarks : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm ld_development_needs
id : bigint(20) unsigned
employee_id : int(10) unsigned
competency_id : int(10) unsigned
performance_ld_referral_id : bigint(20) unsigned
source_type : enum('performance','competency_assessment','supervisor','employee','organization','mandatory','other')
source_reference : varchar(180)
need_area : varchar(220)
current_level : decimal(8,2)
target_level : decimal(8,2)
priority : enum('low','medium','high','critical')
proposed_intervention : varchar(255)
target_date : date
status : enum('identified','validated','planned','in_progress','completed','carried_forward','cancelled')
evidence_basis : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm ld_idp_items
id : bigint(20) unsigned
idp_id : bigint(20) unsigned
development_need_id : bigint(20) unsigned
development_area : varchar(220)
learning_objective : text
intervention_type : varchar(120)
target_completion : date
success_indicator : text
status : enum('planned','in_progress','completed','deferred','cancelled')
remarks : text
performance_development_plan_item_id : bigint(20) unsigned
created_at : timestamp

v		prime_hrm ld_individual_development_plans
id : bigint(20) unsigned
employee_id : int(10) unsigned
plan_year : varchar(20)
career_goal : text
development_objective : text
employee_commitment : text
supervisor_support : text
status : enum('draft','for_review','approved','in_progress','completed','closed')
approved_by : int(10) unsigned
approved_at : datetime
created_by : int(10) unsigned
performance_development_plan_id : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm ld_participations
id : bigint(20) unsigned
activity_id : bigint(20) unsigned
employee_id : int(10) unsigned
development_need_id : bigint(20) unsigned
nomination_source : enum('idp','performance','competency_gap','supervisor','mandatory','self','other')
nomination_status : enum('nominated','for_approval','approved','declined','waitlisted')
attendance_status : enum('not_started','attended','partial','absent')
completion_status : enum('not_started','completed','incomplete','failed','waived')
hours_completed : decimal(8,2)
certificate_reference : varchar(255)
immediate_rating : decimal(8,2)
learning_rating : decimal(8,2)
application_rating : decimal(8,2)
results_rating : decimal(8,2)
reentry_plan : text
application_evidence : text
supervisor_validation : text
completion_date : date
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm ld_programs
id : bigint(20) unsigned
program_code : varchar(80)
title : varchar(220)
program_type : enum('training','workshop','coaching','mentoring','technical_assistance','job_rotation','scholarship','conference','self_directed','other')
competency_id : int(10) unsigned
target_audience : text
objectives : text
provider : varchar(180)
delivery_mode : enum('face_to_face','online','blended','workplace','other')
standard_hours : decimal(8,2)
estimated_cost : decimal(14,2)
is_mandatory : tinyint(1)
is_active : tinyint(1)
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm modules
id : int(10) unsigned
name : varchar(150)
slug : varchar(120)
nav_section : varchar(80)
icon : varchar(50)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp

v		prime_hrm notifications
id : bigint(20) unsigned
user_id : int(10) unsigned
title : varchar(180)
message : text
link_slug : varchar(180)
is_read : tinyint(1)
created_at : timestamp

v		prime_hrm offices
id : int(10) unsigned
code : varchar(50)
name : varchar(180)
office_type : enum('division','office','unit','section')
parent_id : int(10) unsigned
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm organizational_performance_records
id : bigint(20) unsigned
cycle_id : int(10) unsigned
subject_type : enum('school','office')
school_id : int(10) unsigned
office_id : int(10) unsigned
instrument_code : varchar(50)
accountable_employee_id : int(10) unsigned
rater_user_id : int(10) unsigned
approving_user_id : int(10) unsigned
current_phase : enum('planning','monitoring','evaluation','development','closed')
plan_status : enum('not_started','draft','submitted','returned','rater_concurred','approved')
monitoring_status : enum('not_started','active','completed')
evaluation_status : enum('not_started','self_assessment','rater_review','validation','approved','finalized')
overall_rating : decimal(6,2)
adjectival_rating : varchar(80)
legacy_rating_id : int(11)
legacy_rating_source : varchar(50)
notes : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm organization_responsibilities
id : bigint(20) unsigned
organization_type : enum('school','office')
school_id : int(10) unsigned
office_id : int(10) unsigned
employee_id : int(10) unsigned
responsibility_code : varchar(80)
responsibility_name : varchar(150)
effective_from : date
effective_to : date
is_active : tinyint(1)
remarks : varchar(255)
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm pages
id : int(10) unsigned
module_id : int(10) unsigned
parent_id : int(10) unsigned
name : varchar(160)
slug : varchar(180)
route : varchar(255)
icon : varchar(50)
description : varchar(255)
is_menu : tinyint(1)
is_active : tinyint(1)
sort_order : int(11)
created_at : timestamp

v		prime_hrm pams_user_links
prime_user_id : int(10) unsigned
legacy_user_id : int(11)
linked_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_action_items
id : bigint(20) unsigned
record_id : bigint(20) unsigned
source_type : enum('conference','coaching','midyear','evaluation','development')
source_id : bigint(20) unsigned
action_item : text
responsible_user_id : int(10) unsigned
responsible_label : varchar(180)
target_date : date
completion_date : date
status : enum('open','ongoing','completed','cancelled','overdue')
completion_note : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_assignment_history
id : bigint(20) unsigned
record_id : bigint(20) unsigned
rater_user_id : int(10) unsigned
approving_user_id : int(10) unsigned
source : enum('legacy_pams','office_rule','school_rule','employee_override','personnel_movement','manual','system')
source_reference : bigint(20) unsigned
effective_from : date
effective_to : date
remarks : varchar(255)
changed_by : int(10) unsigned
created_at : timestamp

v		prime_hrm performance_assignment_rules
id : bigint(20) unsigned
scope_type : enum('office','school','employee')
office_id : int(10) unsigned
school_id : int(10) unsigned
employee_id : int(10) unsigned
rater_employee_id : int(10) unsigned
approving_employee_id : int(10) unsigned
effective_from : date
effective_to : date
reason : varchar(255)
is_active : tinyint(1)
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_coaching_sessions
id : bigint(20) unsigned
record_id : bigint(20) unsigned
session_date : date
session_type : enum('conference','performance_coaching','mentoring','technical_assistance','progress_check','corrective_coaching','development_coaching','positive_feedback')
objective_reference : varchar(255)
purpose : text
observation : text
strengths : text
performance_gap : text
employee_input : text
support_needed : text
agreed_summary : text
follow_up_date : date
status : enum('draft','for_acknowledgment','acknowledged','closed')
created_by : int(10) unsigned
rater_acknowledged_at : datetime
ratee_acknowledged_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_cycles
id : int(10) unsigned
name : varchar(160)
cycle_year : int(11)
framework : varchar(80)
scope_type : enum('all','division','school')
start_date : date
end_date : date
planning_start : date
planning_end : date
monitoring_start : date
monitoring_end : date
midyear_start : date
midyear_end : date
evaluation_start : date
evaluation_end : date
development_start : date
development_end : date
development_approval_mode : enum('inherit','rater_only','approving_authority')
orientation_notes : text
status : enum('draft','active','closed','archived')
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_development_needs
id : bigint(20) unsigned
record_id : bigint(20) unsigned
competency_id : int(10) unsigned
need_type : enum('strength','development_gap')
area : varchar(220)
evidence_basis : text
priority : enum('low','medium','high','critical')
recommended_intervention : varchar(255)
remarks : text
status : enum('identified','confirmed','referred','completed','carried_forward')
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_development_plans
id : bigint(20) unsigned
record_id : bigint(20) unsigned
employee_id : int(10) unsigned
plan_year : varchar(20)
career_goal : text
overall_development_objective : text
employee_commitment : text
supervisor_support : text
employee_comments : text
rater_comments : text
discussion_request_note : text
approval_required : tinyint(1)
status : enum('draft','for_employee_review','discussion_requested','employee_acknowledged','rater_finalized','for_approval','approved','returned','in_progress','completed','closed')
prepared_by : int(10) unsigned
prepared_at : datetime
submitted_at : datetime
employee_acknowledged_by : int(10) unsigned
employee_acknowledged_at : datetime
rater_finalized_by : int(10) unsigned
rater_finalized_at : datetime
approving_user_id : int(10) unsigned
approver_remarks : text
approved_by : int(10) unsigned
approved_at : datetime
returned_by : int(10) unsigned
returned_at : datetime
started_at : datetime
completed_at : datetime
closed_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_development_plan_history
id : bigint(20) unsigned
plan_id : bigint(20) unsigned
action : varchar(80)
from_status : varchar(60)
to_status : varchar(60)
remarks : text
acted_by : int(10) unsigned
acted_at : timestamp

v		prime_hrm performance_development_plan_items
id : bigint(20) unsigned
plan_id : bigint(20) unsigned
development_need_id : bigint(20) unsigned
development_area : varchar(220)
source_type : enum('performance_gap','midyear','coaching','competency','self_assessment','career_goal','organizational','other')
source_reference : varchar(255)
priority : enum('low','medium','high','critical')
development_objective : text
intervention_type : enum('training','coaching','mentoring','job_shadowing','job_rotation','self_directed','technical_assistance','stretch_assignment','workshop','seminar','online_course','other')
intervention_description : text
expected_outcome : text
success_indicator : text
target_completion : date
responsible_type : enum('employee','rater','ld','shared','other')
responsible_user_id : int(10) unsigned
requires_ld : tinyint(1)
performance_ld_referral_id : bigint(20) unsigned
ld_development_need_id : bigint(20) unsigned
status : enum('planned','for_ld','in_progress','completed','deferred','cancelled')
completion_note : text
effectiveness_rating : decimal(6,2)
effectiveness_notes : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_ld_referrals
id : bigint(20) unsigned
development_need_id : bigint(20) unsigned
record_id : bigint(20) unsigned
employee_id : int(10) unsigned
recommended_intervention : varchar(255)
priority : enum('low','medium','high','critical')
status : enum('new','accepted','planned','completed','declined')
referred_by : int(10) unsigned
referred_at : timestamp
updated_at : timestamp

v		prime_hrm performance_midyear_reviews
id : bigint(20) unsigned
record_id : bigint(20) unsigned
review_date : date
major_accomplishments : text
strengths : text
challenges : text
performance_gaps : text
support_needed : text
agreed_adjustments : text
second_half_actions : text
employee_comments : text
rater_comments : text
status : enum('draft','submitted','acknowledged','completed')
created_by : int(10) unsigned
employee_acknowledged_at : datetime
rater_acknowledged_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_plan_amendments
id : bigint(20) unsigned
record_id : bigint(20) unsigned
item_reference : varchar(255)
original_value : text
proposed_value : text
reason : text
status : enum('pending','approved','returned','rejected')
requested_by : int(10) unsigned
reviewed_by : int(10) unsigned
reviewed_at : datetime
review_remarks : text
created_at : timestamp

v		prime_hrm performance_praise_referrals
id : bigint(20) unsigned
record_id : bigint(20) unsigned
employee_id : int(10) unsigned
award_category : varchar(180)
notable_achievement : text
rationale : text
status : enum('recommended','endorsed','screening','accepted','declined','awarded')
referred_by : int(10) unsigned
referred_at : timestamp
updated_at : timestamp

v		prime_hrm performance_progress_updates
id : bigint(20) unsigned
record_id : bigint(20) unsigned
update_date : date
objective_reference : varchar(255)
accomplishment : text
progress_percent : decimal(5,2)
issues : text
assistance_needed : text
health_status : enum('on_track','needs_attention','at_risk','completed')
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_records
id : bigint(20) unsigned
cycle_id : int(10) unsigned
employee_id : int(10) unsigned
rater_user_id : int(10) unsigned
approving_user_id : int(10) unsigned
legacy_rating_id : int(11)
legacy_rating_source : varchar(40)
current_phase : enum('planning','monitoring','evaluation','development','closed')
plan_status : enum('not_started','draft','submitted','returned','rater_concurred','approved')
monitoring_status : enum('not_started','active','completed')
midyear_status : enum('not_started','draft','submitted','acknowledged','completed')
evaluation_status : enum('not_started','self_assessment','rater_review','validation','approved','finalized')
development_status : enum('not_started','draft','for_employee_review','discussion_requested','employee_acknowledged','rater_finalized','for_approval','approved','returned','referred','in_progress','completed','closed')
overall_rating : decimal(6,2)
adjectival_rating : varchar(80)
plan_submitted_at : datetime
plan_approved_at : datetime
finalized_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm performance_self_assessment_entries
id : bigint(20) unsigned
record_id : bigint(20) unsigned
pams_objective_id : int(11)
actual_results : text
self_rating_q : decimal(5,2)
self_rating_e : decimal(5,2)
self_rating_t : decimal(5,2)
employee_comments : text
submitted_at : datetime
updated_at : timestamp

v		prime_hrm personnel_categories
id : int(10) unsigned
code : varchar(60)
name : varchar(150)
description : varchar(255)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		prime_hrm personnel_movements
id : bigint(20) unsigned
employee_id : int(10) unsigned
movement_type : enum('promotion','transfer','reassignment','designation','detail','change_of_station','salary_adjustment','demotion','return_to_assignment','other')
previous_position_id : int(10) unsigned
new_position_id : int(10) unsigned
previous_office_id : int(10) unsigned
new_office_id : int(10) unsigned
previous_school_id : int(10) unsigned
new_school_id : int(10) unsigned
previous_employment_status : varchar(80)
new_employment_status : varchar(80)
effective_date : date
order_no : varchar(120)
order_date : date
remarks : text
status : enum('scheduled','effective','cancelled')
applied_at : datetime
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm positions
id : int(10) unsigned
item_no : varchar(80)
title : varchar(180)
salary_grade : varchar(20)
employment_classification : varchar(100)
plantilla_status : enum('filled','vacant','reserved','abolished')
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm prime_hrm_readiness_evidence
id : bigint(20) unsigned
readiness_item_id : bigint(20) unsigned
evidence_title : varchar(220)
evidence_reference : varchar(255)
period_covered : varchar(100)
validation_status : enum('submitted','verified','needs_revision','archived')
validated_by : int(10) unsigned
validated_at : datetime
remarks : text
created_at : timestamp

v		prime_hrm prime_hrm_readiness_items
id : bigint(20) unsigned
pillar : enum('RSP','PM','LD','RR')
maturity_level : tinyint(3) unsigned
indicator_code : varchar(100)
indicator_text : text
evidence_expected : text
responsible_employee_id : int(10) unsigned
target_date : date
status : enum('not_started','in_progress','for_validation','compliant','gap','not_applicable')
remarks : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm roles
id : int(10) unsigned
name : varchar(120)
slug : varchar(120)
scope : enum('system','division','office','school','self','external')
description : varchar(255)
is_system : tinyint(1)
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm role_dashboard_widgets
role_id : int(10) unsigned
widget_id : int(10) unsigned
sort_order : int(11)

v		prime_hrm role_page_permissions
role_id : int(10) unsigned
page_id : int(10) unsigned
can_view : tinyint(1)
can_create : tinyint(1)
can_edit : tinyint(1)
can_delete : tinyint(1)
can_approve : tinyint(1)
can_export : tinyint(1)
can_manage : tinyint(1)

v		prime_hrm rr_awards
id : bigint(20) unsigned
nomination_id : bigint(20) unsigned
award_date : date
citation_text : text
incentive_type : enum('none','non_monetary','monetary','both')
incentive_description : text
monetary_amount : decimal(14,2)
funding_source : varchar(180)
certificate_reference : varchar(255)
status : enum('approved','conferred','released','cancelled')
recorded_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rr_award_calls
id : bigint(20) unsigned
category_id : bigint(20) unsigned
call_title : varchar(220)
award_year : varchar(20)
opening_date : date
closing_date : date
ceremony_date : date
status : enum('draft','open','screening','deliberation','approved','awarded','closed','cancelled')
guidelines : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rr_award_categories
id : bigint(20) unsigned
code : varchar(80)
name : varchar(220)
subject_type : enum('person','team','school','office','any')
description : text
eligibility : text
criteria : text
award_form : enum('formal','informal','on_the_spot')
incentive_type : enum('non_monetary','monetary','both','none')
is_active : tinyint(1)
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rr_committee_scores
id : bigint(20) unsigned
nomination_id : bigint(20) unsigned
evaluator_user_id : int(10) unsigned
criterion_name : varchar(180)
weight_percent : decimal(8,2)
score : decimal(10,4)
weighted_score : decimal(10,4)
remarks : text
scored_at : datetime

v		prime_hrm rr_deliberations
id : bigint(20) unsigned
nomination_id : bigint(20) unsigned
deliberation_date : date
total_score : decimal(10,4)
findings : text
committee_recommendation : enum('pending','finalist','recommended','not_recommended','deferred')
approving_decision : enum('pending','approved','not_approved','returned')
approved_by : int(10) unsigned
approved_at : datetime
remarks : text
created_at : timestamp
updated_at : timestamp

v		prime_hrm rr_nominations
id : bigint(20) unsigned
nomination_no : varchar(80)
call_id : bigint(20) unsigned
category_id : bigint(20) unsigned
subject_type : enum('person','team','school','office')
employee_id : int(10) unsigned
school_id : int(10) unsigned
office_id : int(10) unsigned
team_name : varchar(220)
source_type : enum('manual','performance','organizational_performance','client_commendation','innovation','service','other')
source_id : bigint(20) unsigned
achievement_title : varchar(255)
achievement_summary : text
justification : text
documentary_summary : text
status : enum('draft','submitted','screening','eligible','ineligible','committee_review','finalist','approved','declined','awarded','closed')
nominated_by : int(10) unsigned
submitted_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm rr_nomination_evidence
id : bigint(20) unsigned
nomination_id : bigint(20) unsigned
evidence_type : varchar(150)
reference_text : varchar(255)
validation_status : enum('pending','valid','invalid','not_applicable')
validated_by : int(10) unsigned
validated_at : datetime
remarks : text
created_at : timestamp

v		prime_hrm rsp_applicants
id : bigint(20) unsigned
applicant_no : varchar(80)
first_name : varchar(100)
middle_name : varchar(100)
last_name : varchar(100)
suffix : varchar(30)
sex : varchar(30)
birth_date : date
email : varchar(180)
mobile_no : varchar(60)
address : text
highest_education : text
eligibility : text
years_experience : decimal(8,2)
current_employer : varchar(180)
source : varchar(100)
status : enum('active','hired','withdrawn','inactive')
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rsp_applications
id : bigint(20) unsigned
applicant_id : bigint(20) unsigned
vacancy_id : bigint(20) unsigned
application_date : date
documentary_status : enum('pending','incomplete','complete','validated')
initial_screening : enum('pending','qualified','not_qualified')
assessment_status : enum('not_started','ongoing','completed')
total_score : decimal(10,4)
rank_no : int(11)
hrmpsb_recommendation : enum('pending','recommended','not_recommended','reserve')
selection_status : enum('pending','shortlisted','selected','not_selected','withdrawn')
remarks : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rsp_application_documents
id : bigint(20) unsigned
application_id : bigint(20) unsigned
document_type : varchar(150)
document_reference : varchar(255)
validation_status : enum('pending','valid','invalid','waived')
validated_by : int(10) unsigned
validated_at : datetime
remarks : text
created_at : timestamp

v		prime_hrm rsp_appointments
id : bigint(20) unsigned
application_id : bigint(20) unsigned
employee_id : int(10) unsigned
appointment_no : varchar(100)
appointment_type : varchar(100)
appointment_date : date
assumption_date : date
position_id : int(10) unsigned
office_id : int(10) unsigned
school_id : int(10) unsigned
item_no : varchar(100)
salary_grade : varchar(30)
step_no : varchar(30)
status : enum('preparing','for_signature','issued','assumed','completed','cancelled')
onboarding_status : enum('not_started','ongoing','completed')
remarks : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rsp_assessment_components
id : bigint(20) unsigned
vacancy_id : bigint(20) unsigned
component_name : varchar(160)
weight_percent : decimal(8,2)
max_score : decimal(10,2)
sort_order : int(11)
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm rsp_assessment_scores
id : bigint(20) unsigned
application_id : bigint(20) unsigned
component_id : bigint(20) unsigned
evaluator_user_id : int(10) unsigned
raw_score : decimal(10,4)
weighted_score : decimal(10,4)
remarks : text
scored_at : datetime

v		prime_hrm rsp_onboarding_tasks
id : bigint(20) unsigned
appointment_id : bigint(20) unsigned
task_name : varchar(220)
task_group : varchar(100)
due_date : date
status : enum('pending','in_progress','completed','waived')
completed_at : datetime
remarks : text
created_at : timestamp

v		prime_hrm rsp_position_profiles
id : bigint(20) unsigned
position_id : int(10) unsigned
job_summary : text
duties : text
education_requirement : text
training_requirement : text
experience_requirement : text
eligibility_requirement : text
competency_notes : text
document_version : varchar(40)
effective_from : date
effective_to : date
updated_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm rsp_selection_decisions
id : bigint(20) unsigned
application_id : bigint(20) unsigned
hrmpsb_findings : text
recommendation : varchar(180)
appointing_authority_decision : enum('pending','approved','not_approved','returned')
decision_date : date
decided_by : int(10) unsigned
remarks : text
created_at : timestamp
updated_at : timestamp

v		prime_hrm rsp_vacancies
id : bigint(20) unsigned
vacancy_no : varchar(80)
position_id : int(10) unsigned
office_id : int(10) unsigned
school_id : int(10) unsigned
plantilla_item_no : varchar(100)
vacancy_reason : varchar(180)
date_vacated : date
requested_by : int(10) unsigned
approved_by : int(10) unsigned
approval_date : date
publication_date : date
closing_date : date
status : enum('draft','for_approval','approved','published','screening','assessment','deliberation','selected','appointed','closed','cancelled')
remarks : text
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm schools
id : int(10) unsigned
school_id : varchar(30)
name : varchar(180)
district : varchar(120)
school_head : varchar(180)
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm system_settings
id : int(10) unsigned
setting_key : varchar(150)
setting_value : text
setting_group : varchar(100)
is_public : tinyint(1)
updated_at : timestamp

v		prime_hrm users
id : int(10) unsigned
account_type_id : int(10) unsigned
subject_type : enum('person','school','office','system','external')
employee_id : int(10) unsigned
school_id : int(10) unsigned
office_id : int(10) unsigned
username : varchar(100)
email : varchar(180)
password_hash : varchar(255)
status : enum('active','inactive','locked')
last_login_at : datetime
created_at : timestamp
updated_at : timestamp

v		prime_hrm user_page_permissions
user_id : int(10) unsigned
page_id : int(10) unsigned
can_view : tinyint(1)
can_create : tinyint(1)
can_edit : tinyint(1)
can_delete : tinyint(1)
can_approve : tinyint(1)
can_export : tinyint(1)
can_manage : tinyint(1)

v		prime_hrm user_roles
user_id : int(10) unsigned
role_id : int(10) unsigned
office_id : int(10) unsigned
school_id : int(10) unsigned
starts_at : datetime
ends_at : datetime

v		prime_hrm user_scope_assignments
id : bigint(20) unsigned
user_id : int(10) unsigned
role_id : int(10) unsigned
scope_type : enum('school','office')
school_id : int(10) unsigned
office_id : int(10) unsigned
starts_at : datetime
ends_at : datetime
is_active : tinyint(1)
remarks : varchar(255)
created_by : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		prime_hrm workflow_actions
id : bigint(20) unsigned
instance_id : bigint(20) unsigned
step_no : int(11)
acted_by : int(10) unsigned
action : varchar(80)
remarks : text
acted_at : timestamp

v		prime_hrm workflow_definitions
id : int(10) unsigned
module_id : int(10) unsigned
name : varchar(160)
slug : varchar(160)
entity_type : varchar(100)
is_active : tinyint(1)
created_at : timestamp

v		prime_hrm workflow_instances
id : bigint(20) unsigned
workflow_id : int(10) unsigned
entity_id : bigint(20) unsigned
initiated_by : int(10) unsigned
current_step_no : int(11)
status : enum('draft','pending','approved','rejected','returned','cancelled')
created_at : timestamp
updated_at : timestamp

v		prime_hrm workflow_steps
id : int(10) unsigned
workflow_id : int(10) unsigned
step_no : int(11)
name : varchar(160)
role_id : int(10) unsigned
action_required : varchar(80)
can_return : tinyint(1)
can_reject : tinyint(1)
is_final : tinyint(1)

Create relationship
FOREIGN KEY
on delete
on update