Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v top1movers accounting_transactions
* id : int(11)
* transaction_no : varchar(40)
* transaction_date : date
* reference_no : varchar(60)
* transaction_type : enum('cash_in','cash_out','expense','receivable','payable','payment','payroll','inventory_cost','journal')
* party_type : enum('customer','supplier','employee','internal','other')
* party_name : varchar(150)
* description : text
* status : enum('draft','posted','void')
* source_module : varchar(50)
* source_record_id : int(11)
* total_debit : decimal(14,2)
* total_credit : decimal(14,2)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers accounts
* id : int(11)
* account_code : varchar(30)
* account_name : varchar(120)
* account_type : enum('asset','liability','equity','income','expense')
* parent_account_id : int(11)
* normal_balance : enum('debit','credit')
* is_cash_account : tinyint(1)
* is_active : tinyint(1)
* notes : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers api_mobile_tokens
* id : bigint(20) unsigned
* user_id : int(11)
* employee_id : int(11)
* token_hash : char(64)
* device_name : varchar(120)
* ip_address : varchar(45)
* user_agent : varchar(255)
* created_at : datetime
* last_used_at : datetime
* expires_at : datetime
* revoked_at : datetime
v top1movers app_rate_limits
* id : int(10) unsigned
* scope : varchar(80)
* identifier_hash : char(64)
* identifier_label : varchar(190)
* window_started_at : datetime
* attempts : int(10) unsigned
* blocked_until : datetime
* last_attempt_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers assets
* id : int(11)
* asset_tag : varchar(60)
* asset_code : varchar(60)
* asset_category_id : int(11)
* item_name : varchar(150)
* brand : varchar(100)
* model : varchar(100)
* serial_number : varchar(120)
* imei_1 : varchar(80)
* imei_2 : varchar(80)
* sim_number : varchar(80)
* mobile_number : varchar(80)
* plan_type : varchar(120)
* processor : varchar(120)
* ram : varchar(80)
* storage : varchar(120)
* operating_system : varchar(120)
* charger_serial_number : varchar(120)
* accessories_included : text
* purchase_date : date
* supplier : varchar(160)
* warranty_date : date
* asset_condition : enum('new','good','fair','needs_repair','damaged','retired')
* status : enum('available','assigned','in_repair','retired','lost','damaged','disposed')
* assigned_employee_id : int(11)
* location : varchar(150)
* purchase_cost : decimal(14,2)
* accountability_form_no : varchar(60)
* notes : text
* asset_photo : varchar(255)
* public_view_token : varchar(80)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers asset_accountability_forms
* id : int(11)
* form_control_no : varchar(80)
* employee_id : int(11)
* revision_no : varchar(40)
* status : enum('generated','printed','void')
* generated_by : int(11)
* printed_by : int(11)
* printed_at : datetime
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers asset_accountability_form_items
* id : int(11)
* form_id : int(11)
* asset_id : int(11)
* assignment_id : int(11)
* asset_tag : varchar(80)
* asset_snapshot : text
* created_at : datetime
v top1movers asset_assignments
* id : int(11)
* asset_id : int(11)
* employee_id : int(11)
* assigned_at : datetime
* expected_return_at : datetime
* condition_upon_issue : varchar(120)
* accessories_included : text
* issued_by_user_id : int(11)
* acknowledged_by : varchar(160)
* returned_at : datetime
* return_condition : varchar(120)
* assignment_notes : text
* received_by_user_id : int(11)
* returned_to_user_id : int(11)
* status : enum('assigned','returned','transferred')
* clearance_status : enum('pending','cleared','blocked','not_applicable')
* created_at : datetime
v top1movers asset_audit_logs
* id : int(11)
* asset_id : int(11)
* action_type : enum('created','updated','assigned','returned','transferred','repair','maintenance','status_update')
* employee_id : int(11)
* reference_table : varchar(60)
* reference_id : int(11)
* remarks : text
* performed_by : int(11)
* created_at : datetime
v top1movers asset_categories
* id : int(11)
* category_name : varchar(80)
* description : varchar(255)
* asset_tag_prefix : varchar(20)
* is_active : tinyint(1)
* created_at : datetime
* updated_at : datetime
v top1movers asset_label_print_logs
* id : int(11)
* asset_id : int(11)
* template_id : int(11)
* label_type : varchar(60)
* reprint_reason : text
* printer_used : varchar(120)
* printed_by : int(11)
* printed_at : datetime
* ip_address : varchar(60)
* user_agent : varchar(255)
v top1movers asset_label_templates
* id : int(11)
* template_name : varchar(120)
* label_size : enum('small','medium','large','custom')
* width_mm : decimal(8,2)
* height_mm : decimal(8,2)
* include_brand_model : tinyint(1)
* include_serial : tinyint(1)
* include_qr : tinyint(1)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers asset_maintenance_logs
* id : int(11)
* asset_id : int(11)
* maintenance_date : date
* maintenance_type : enum('repair','preventive','inspection','upgrade')
* vendor_name : varchar(150)
* cost : decimal(14,2)
* details : text
* status : enum('open','in_progress','completed')
* performed_by_user_id : int(11)
* resolved_at : datetime
* created_at : datetime
v top1movers asset_print_logs
* id : int(11)
* employee_id : int(11)
* asset_id : int(11)
* print_type : enum('accountability_form','asset_label')
* reference_id : int(11)
* label_type : varchar(60)
* assets_included : text
* reprint_reason : text
* printer_used : varchar(120)
* printed_by : int(11)
* printed_at : datetime
* ip_address : varchar(60)
* user_agent : varchar(255)
v top1movers asset_transfers
* id : int(11)
* asset_id : int(11)
* from_employee_id : int(11)
* to_employee_id : int(11)
* from_location : varchar(150)
* to_location : varchar(150)
* transfer_date : datetime
* reason : text
* processed_by : int(11)
* related_assignment_id : int(11)
* created_at : datetime
v top1movers attendance_corrections
* id : int(11)
* employee_id : int(11)
* attendance_id : int(11)
* attendance_date : date
* requested_time_in : datetime
* requested_time_out : datetime
* reason : text
* attachment : varchar(255)
* status : enum('pending','approved','rejected','cancelled')
* created_by : int(11)
* approved_by : int(11)
* approved_at : datetime
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers attributes
* id : int(11)
* name : varchar(255)
* active : int(11)
v top1movers attribute_value
* id : int(11)
* value : varchar(255)
* attribute_parent_id : int(11)
v top1movers audit_logs
* id : bigint(20) unsigned
* user_id : int(11)
* user_name : varchar(160)
* module : varchar(80)
* record_type : varchar(80)
* record_id : int(11)
* action : varchar(120)
* old_value : longtext
* new_value : longtext
* remarks : text
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers auth_access_logs
* id : int(11)
* user_id : int(11)
* username : varchar(100)
* event_type : varchar(50)
* status : varchar(20)
* ip_address : varchar(64)
* ip_source : varchar(40)
* is_internal_ip : tinyint(1)
* is_whitelisted_ip : tinyint(1)
* network_label : varchar(30)
* user_agent : varchar(255)
* browser_name : varchar(100)
* platform : varchar(100)
* device_hash : char(64)
* session_id : varchar(128)
* request_uri : varchar(255)
* notes : varchar(255)
* metadata_text : text
* created_at : datetime
v top1movers brands
* id : int(11)
* name : varchar(255)
* active : int(11)
v top1movers categories
* id : int(11)
* name : varchar(255)
* active : int(11)
v top1movers clearance_items
* id : int(11)
* offboarding_id : int(11)
* clearance_area : enum('department','it','accounting','hr','payroll','custom')
* item_label : varchar(180)
* assigned_to : int(11)
* status : enum('pending','cleared','not_applicable','blocked')
* remarks : text
* cleared_by : int(11)
* cleared_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers company
* id : int(11)
* company_name : varchar(255)
* service_charge_value : varchar(255)
* vat_charge_value : varchar(255)
* address : varchar(255)
* phone : varchar(255)
* payroll_funding_account : varchar(40)
* country : varchar(255)
* message : text
* currency : varchar(255)
v top1movers deliveries
* id : int(11)
* delivery_no : varchar(50)
* supplier_name : varchar(100)
* remarks : text
* created_at : datetime
* user_id : int(11)
* status : tinyint(1)
* cancel_reason : text
* cancelled_at : datetime
* cancelled_by : int(11)
* attachment_path : varchar(255)
v top1movers delivery_items
* id : int(11)
* delivery_id : int(11)
* product_id : int(11)
* qty : int(11)
v top1movers departments
* id : int(10) unsigned
* department_name : varchar(120)
* department_code : varchar(30)
* department_head_id : int(11)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers disciplinary_cases
* id : int(11)
* employee_id : int(11)
* case_type : varchar(100)
* incident_date : date
* description : text
* attachment : varchar(255)
* issued_by : int(11)
* employee_response : text
* hr_remarks : text
* final_action : text
* acknowledgment_date : datetime
* status : enum('draft','issued','for_employee_response','under_review','closed')
* created_at : datetime
* updated_at : datetime
v top1movers document_approvals
* id : int(10) unsigned
* document_code : varchar(80)
* title : varchar(220)
* company : enum('Top1Movers','Bambs Trucking Corp.','Shared / Both')
* department_id : int(10) unsigned
* document_type_id : int(10) unsigned
* other_document_type : varchar(150)
* category : varchar(100)
* uploaded_by : int(11)
* current_approver_id : int(11)
* additional_reviewer_id : int(11)
* priority : enum('Normal','Urgent','Critical')
* due_date : date
* original_filename : varchar(255)
* stored_filename : varchar(255)
* file_path : varchar(500)
* file_size : bigint(20) unsigned
* mime_type : varchar(160)
* is_confidential : tinyint(1)
* status : varchar(60)
* remarks : text
* submitted_at : datetime
* approved_at : datetime
* returned_at : datetime
* rejected_at : datetime
* archived_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers document_approval_logs
* id : int(10) unsigned
* document_id : int(10) unsigned
* action : varchar(120)
* user_id : int(11)
* old_status : varchar(60)
* new_status : varchar(60)
* remarks : text
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers document_approval_remarks
* id : int(10) unsigned
* document_id : int(10) unsigned
* step_id : int(10) unsigned
* user_id : int(11)
* remarks_type : varchar(60)
* remarks : text
* is_private : tinyint(1)
* page_number : int(10) unsigned
* created_at : datetime
v top1movers document_approval_signatures
* id : int(10) unsigned
* document_id : int(10) unsigned
* step_id : int(10) unsigned
* approver_id : int(11)
* signature_file_path : varchar(500)
* page_number : int(10) unsigned
* x_position : decimal(10,2)
* y_position : decimal(10,2)
* width : decimal(10,2)
* height : decimal(10,2)
* signed_at : datetime
* created_at : datetime
v top1movers document_approval_steps
* id : int(10) unsigned
* document_id : int(10) unsigned
* step_order : int(10) unsigned
* approver_id : int(11)
* approver_role : varchar(80)
* status : varchar(60)
* remarks : text
* signature_required : tinyint(1)
* signed_at : datetime
* approved_at : datetime
* returned_at : datetime
* rejected_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers document_approval_versions
* id : int(10) unsigned
* document_id : int(10) unsigned
* version_number : int(10) unsigned
* version_type : varchar(30)
* filename : varchar(255)
* file_path : varchar(500)
* file_size : bigint(20) unsigned
* mime_type : varchar(160)
* uploaded_by : int(11)
* created_at : datetime
v top1movers document_department_users
* id : int(10) unsigned
* department_id : int(10) unsigned
* user_id : int(11)
* can_upload : tinyint(1)
* can_view_department : tinyint(1)
* can_approve : tinyint(1)
* can_view_confidential : tinyint(1)
* can_view_private_remarks : tinyint(1)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers document_types
* id : int(10) unsigned
* department_id : int(10) unsigned
* type_name : varchar(160)
* type_code : varchar(30)
* category : varchar(100)
* requires_signature : tinyint(1)
* requires_approval : tinyint(1)
* default_workflow_id : int(10) unsigned
* default_approver_id : int(11)
* allowed_file_types : varchar(255)
* max_file_size : int(10) unsigned
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers document_workflows
* id : int(10) unsigned
* workflow_name : varchar(160)
* department_id : int(10) unsigned
* document_type_id : int(10) unsigned
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers document_workflow_steps
* id : int(10) unsigned
* workflow_id : int(10) unsigned
* step_order : int(10) unsigned
* approver_role : varchar(80)
* approver_user_id : int(11)
* require_signature : tinyint(1)
* require_remarks : tinyint(1)
* created_at : datetime
* updated_at : datetime
v top1movers employee_201_files
* id : int(11)
* employee_id : int(11)
* completion_percent : decimal(5,2)
* status : enum('open','incomplete','complete','archived')
* last_reviewed_by : int(11)
* last_reviewed_at : datetime
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers employee_aliases
* id : int(11)
* raw_name : varchar(160)
* employee_id : int(11)
* corrected_name : varchar(160)
* created_at : datetime
* updated_at : datetime
v top1movers employee_certifications
* id : int(11)
* employee_id : int(11)
* skill_name : varchar(140)
* certification_name : varchar(180)
* issuing_organization : varchar(180)
* issue_date : date
* expiry_date : date
* attachment : varchar(255)
* status : enum('active','expired','archived')
* created_at : datetime
* updated_at : datetime
v top1movers employee_documents
* id : int(11)
* employee_id : int(11)
* document_type_id : int(11)
* category : varchar(80)
* section : varchar(80)
* is_required : tinyint(1)
* is_confidential : tinyint(1)
* document_title : varchar(160)
* file_path : varchar(255)
* original_filename : varchar(255)
* stored_filename : varchar(255)
* file_extension : varchar(20)
* mime_type : varchar(120)
* file_size : int(11)
* issue_date : date
* version_no : int(11)
* expiry_date : date
* remarks : text
* status : enum('active','archived','replaced')
* uploaded_by : int(11)
* last_updated_by : int(11)
* updated_by : int(11)
* replaced_document_id : int(11)
* archived_by : int(11)
* archived_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers employee_document_access_logs
* id : int(11)
* document_id : int(11)
* employee_id : int(11)
* action_type : enum('upload','replace','archive','delete_attempt','download','preview','view')
* user_id : int(11)
* user_name : varchar(120)
* ip_address : varchar(60)
* user_agent : varchar(255)
* remarks : text
* created_at : datetime
v top1movers employee_document_types
* id : int(11)
* section : varchar(80)
* category : varchar(100)
* document_name : varchar(160)
* is_required : tinyint(1)
* requires_expiry : tinyint(1)
* sort_order : int(11)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers employee_document_versions
* id : int(11)
* document_id : int(11)
* employee_id : int(11)
* version_no : int(11)
* document_type_id : int(11)
* category : varchar(100)
* section : varchar(100)
* document_title : varchar(160)
* original_filename : varchar(255)
* stored_filename : varchar(255)
* file_path : varchar(255)
* file_extension : varchar(20)
* mime_type : varchar(120)
* file_size : int(11)
* issue_date : date
* expiry_date : date
* is_required : tinyint(1)
* is_confidential : tinyint(1)
* remarks : text
* replaced_by : int(11)
* replaced_at : datetime
* created_at : datetime
v top1movers employee_education
* id : int(11)
* employee_id : int(11)
* school : varchar(180)
* course : varchar(180)
* year_graduated : varchar(20)
* awards : varchar(255)
* document_path : varchar(255)
* status : enum('active','archived')
* created_at : datetime
* updated_at : datetime
v top1movers employee_employment_history
* id : int(11)
* employee_id : int(11)
* previous_employer : varchar(180)
* position : varchar(120)
* start_date : date
* end_date : date
* reason_for_leaving : text
* status : enum('active','archived')
* created_at : datetime
* updated_at : datetime
v top1movers employee_family_dependents
* id : int(11)
* employee_id : int(11)
* full_name : varchar(160)
* relationship : varchar(80)
* birthdate : date
* contact_no : varchar(40)
* is_dependent : tinyint(1)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers employee_medical_records
* id : int(11)
* employee_id : int(11)
* medical_exam_date : date
* fit_to_work_status : varchar(80)
* medical_expiry_date : date
* certificate_path : varchar(255)
* remarks : text
* status : enum('active','expired','archived')
* created_at : datetime
* updated_at : datetime
v top1movers employee_movements
* id : int(11)
* employee_id : int(11)
* movement_type : enum('promotion','transfer','salary_adjustment','department_change','position_change','employment_status_change','schedule_change','rest_day_change','other')
* field_name : varchar(80)
* old_value : text
* new_value : text
* effective_date : date
* reason : text
* attachment : varchar(255)
* status : enum('pending','approved','rejected','cancelled')
* created_by : int(11)
* approved_by : int(11)
* approved_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers employee_onboarding_items
* id : int(11)
* employee_id : int(11)
* item_key : varchar(80)
* item_label : varchar(160)
* status : enum('pending','completed','waived')
* completed_by : int(11)
* completed_at : datetime
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers employee_schedule_assignments
* id : int(11)
* employee_id : int(11)
* schedule_id : int(11)
* effective_date : date
* end_date : date
* assigned_by : int(11)
* remarks : text
* status : enum('active','inactive','archived')
* created_at : datetime
* updated_at : datetime
v top1movers expenses
* id : int(11)
* transaction_id : int(11)
* expense_date : date
* expense_type : varchar(80)
* vendor_name : varchar(150)
* amount : decimal(14,2)
* payment_status : enum('unpaid','partial','paid')
* related_inventory_reference : varchar(120)
* notes : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers groups
* id : int(11)
* group_name : varchar(255)
* permission : text
v top1movers holidays
* id : int(11)
* holiday_name : varchar(120)
* holiday_date : date
* holiday_type : enum('Regular Holiday','Special Non-Working Holiday')
* created_at : datetime
v top1movers hr_attendance
* id : int(11)
* employee_id : int(11)
* cutoff_id : int(11)
* schedule_id : int(11)
* scheduled_start_at : datetime
* scheduled_end_at : datetime
* required_work_minutes : int(11)
* break_minutes : int(11)
* grace_period_minutes : int(11)
* attendance_date : date
* time_in : datetime
* time_in_device_time : datetime
* time_in_server_time : datetime
* time_in_time_difference_seconds : int(11)
* time_in_flagged_time_mismatch : tinyint(1)
* time_in_face_distance : decimal(8,5)
* time_in_face_confidence : decimal(8,5)
* time_in_face_source : varchar(40)
* time_out : datetime
* time_out_device_time : datetime
* time_out_server_time : datetime
* time_out_time_difference_seconds : int(11)
* time_out_flagged_time_mismatch : tinyint(1)
* time_out_face_distance : decimal(8,5)
* time_out_face_confidence : decimal(8,5)
* time_out_face_source : varchar(40)
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* photo : varchar(255)
* time_in_latitude : decimal(11,8)
* time_in_longitude : decimal(11,8)
* time_in_photo : varchar(255)
* time_out_latitude : decimal(11,8)
* time_out_longitude : decimal(11,8)
* time_out_photo : varchar(255)
* hours_worked : decimal(5,2)
* late_minutes : int(11)
* undertime_minutes : int(11)
* regular_work_minutes : int(11)
* auto_overtime_hours : decimal(6,2)
* rest_day_work : tinyint(1)
* rest_day_validated : tinyint(1)
* schedule_snapshot_json : longtext
* manual_overtime_hours : decimal(6,2)
* manual_overtime_override : tinyint(1)
* status : enum('present','late','incomplete','absent','leave','holiday')
* created_at : datetime
* updated_at : datetime
v top1movers hr_attendance_edit_logs
* id : int(11)
* attendance_id : int(11)
* employee_id : int(11)
* attendance_date : date
* old_time_in : datetime
* old_time_out : datetime
* new_time_in : datetime
* new_time_out : datetime
* old_hours_worked : decimal(6,2)
* new_hours_worked : decimal(6,2)
* edited_by : int(11)
* ip_address : varchar(64)
* user_agent : varchar(255)
* edit_reason : varchar(255)
* created_at : datetime
v top1movers hr_attendance_time_security_logs
* id : int(11)
* employee_id : int(11)
* action_key : varchar(32)
* source : varchar(64)
* device_time_raw : varchar(64)
* device_time : datetime
* server_time : datetime
* time_difference_seconds : int(11)
* threshold_seconds : int(11)
* flagged_time_mismatch : tinyint(1)
* blocked : tinyint(1)
* warning_message : varchar(255)
* ip_address : varchar(64)
* user_agent : varchar(255)
* extra_json : text
* created_at : datetime
v top1movers hr_checklists
* id : int(11)
* employee_id : int(11)
* checklist_type : enum('pre_employment','onboarding','regularization','offboarding','custom')
* title : varchar(160)
* status : enum('open','in_progress','completed','cancelled')
* completion_percent : decimal(5,2)
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers hr_checklist_items
* id : int(11)
* checklist_id : int(11)
* item_label : varchar(180)
* assigned_to : int(11)
* due_date : date
* status : enum('pending','in_progress','completed','waived','overdue')
* remarks : text
* attachment : varchar(255)
* completed_by : int(11)
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers hr_employees
* id : int(11)
* employee_code : varchar(30)
* bank_account_no : varchar(40)
* bank_account_name : varchar(120)
* payroll_account_status : enum('pending','active','inactive','closed')
* bank_name : varchar(60)
* first_name : varchar(80)
* middle_name : varchar(80)
* last_name : varchar(80)
* suffix : varchar(30)
* nickname : varchar(80)
* position : varchar(120)
* job_title : varchar(120)
* branch_location : varchar(120)
* department : varchar(120)
* payroll_type : varchar(30)
* shift_id : int(11)
* rest_day : varchar(20)
* daily_rate : decimal(12,2)
* salary_type : enum('daily','monthly','hourly')
* monthly_salary : decimal(12,2)
* hourly_rate : decimal(12,4)
* date_hired : date
* date_regularized : date
* contract_start_date : date
* contract_end_date : date
* probationary_end_date : date
* supervisor_id : int(11)
* birthdate : date
* gender : varchar(30)
* civil_status : varchar(40)
* nationality : varchar(80)
* religion : varchar(80)
* contact_no : varchar(40)
* personal_email : varchar(160)
* emergency_contact_name : varchar(120)
* emergency_contact_no : varchar(40)
* emergency_relationship : varchar(80)
* emergency_contact_address : text
* address : text
* sss_no : varchar(40)
* philhealth_no : varchar(40)
* pagibig_no : varchar(40)
* tin_no : varchar(40)
* bir_tax_status : varchar(40)
* rdo_code : varchar(40)
* status : enum('active','inactive')
* employment_status : enum('probationary','regular','project-based','contractual','resigned','terminated')
* active_flag : tinyint(1)
* face_image : varchar(255)
* employee_photo : varchar(255)
* face_descriptor : longtext
* created_at : datetime
* updated_at : datetime
v top1movers hr_payrolls
* id : int(11)
* employee_id : int(11)
* cutoff_id : int(11)
* week_start : date
* week_end : date
* days_worked : decimal(5,2)
* paid_leave_days : decimal(8,2)
* lwop_days : decimal(8,2)
* regular_holiday_worked : decimal(8,2)
* special_holiday_worked : decimal(8,2)
* rate_per_day : decimal(12,2)
* rate_per_min : decimal(12,4)
* late_ut_minutes : decimal(10,2)
* total_tardy : decimal(12,2)
* basic_pay : decimal(12,2)
* gross_pay : decimal(12,2)
* holiday_pay : decimal(12,2)
* leave_pay : decimal(12,2)
* overtime_pay : decimal(12,2)
* total_gp : decimal(12,2)
* cash_advance : decimal(12,2)
* sss_employee : decimal(12,2)
* philhealth_employee : decimal(12,2)
* pagibig_employee : decimal(12,2)
* withholding_tax : decimal(12,2)
* statutory_total : decimal(12,2)
* taxable_income : decimal(12,2)
* formula_version : varchar(30)
* payroll_breakdown_json : longtext
* remarks : varchar(255)
* benefits : decimal(12,2)
* deductions : decimal(12,2)
* net_pay : decimal(12,2)
* adjustment : decimal(12,2)
* total_net : decimal(12,2)
* created_at : datetime
* updated_at : datetime
* regular_overtime_hours : decimal(10,2)
* regular_overtime_pay : decimal(10,2)
* holiday_overtime_hours : decimal(10,2)
* holiday_overtime_pay : decimal(10,2)
* approved_ot_hours : decimal(10,2)
* rest_day_hours : decimal(10,2)
* rest_day_pay : decimal(12,2)
* night_diff_hours : decimal(10,2)
* night_diff_pay : decimal(12,2)
* ob_hours : decimal(10,2)
v top1movers hr_payroll_batches
* id : int(11)
* week_start : date
* week_end : date
* payroll_type : varchar(30)
* status : varchar(20)
* reviewed_by : int(11)
* reviewed_at : datetime
* approved_by : int(11)
* approved_at : datetime
* released_by : int(11)
* released_at : datetime
* locked_by : int(11)
* locked_at : datetime
* is_finalized : tinyint(1)
* is_locked : tinyint(1)
* finalized_by : int(11)
* finalized_at : datetime
* note : varchar(255)
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers hr_payroll_batch_logs
* id : int(11)
* batch_id : int(11)
* week_start : date
* week_end : date
* from_status : varchar(20)
* to_status : varchar(20)
* action_by : int(11)
* note : varchar(255)
* created_at : datetime
v top1movers hr_shifts
* id : int(11)
* work_schedule_id : int(11)
* shift_code : varchar(30)
* shift_name : varchar(100)
* schedule_type : enum('fixed','flexible')
* start_time : time
* end_time : time
* break_minutes : int(11)
* paid_hours : decimal(5,2)
* late_grace_minutes : int(11)
* is_active : tinyint(1)
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers hr_statutory_pagibig
* id : int(11)
* effective_start : date
* effective_end : date
* monthly_salary_from : decimal(12,2)
* monthly_salary_to : decimal(12,2)
* employee_rate : decimal(8,6)
* max_employee_contribution : decimal(12,2)
* notes : varchar(255)
* created_at : datetime
v top1movers hr_statutory_philhealth
* id : int(11)
* effective_start : date
* effective_end : date
* premium_rate : decimal(8,6)
* monthly_salary_floor : decimal(12,2)
* monthly_salary_ceiling : decimal(12,2)
* employee_share_ratio : decimal(8,6)
* notes : varchar(255)
* created_at : datetime
v top1movers hr_statutory_sss
* id : int(11)
* effective_start : date
* effective_end : date
* monthly_salary_from : decimal(12,2)
* monthly_salary_to : decimal(12,2)
* employee_share : decimal(12,2)
* employer_share : decimal(12,2)
* ec_share : decimal(12,2)
* notes : varchar(255)
* created_at : datetime
v top1movers hr_statutory_withholding
* id : int(11)
* effective_start : date
* effective_end : date
* annual_taxable_from : decimal(14,2)
* annual_taxable_to : decimal(14,2)
* base_tax : decimal(14,2)
* over_percent : decimal(8,6)
* notes : varchar(255)
* created_at : datetime
v top1movers hr_thirteenth_month_batches
* id : int(11)
* payout_year : int(4)
* status : varchar(20)
* note : varchar(255)
* generated_by : int(11)
* generated_at : datetime
* released_by : int(11)
* released_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers hr_thirteenth_month_rows
* id : int(11)
* batch_id : int(11)
* employee_id : int(11)
* payout_year : int(4)
* coverage_start : date
* coverage_end : date
* payroll_rows_count : int(11)
* qualifying_days : decimal(10,2)
* basic_salary_base : decimal(12,2)
* thirteenth_month_pay : decimal(12,2)
* taxable_excess : decimal(12,2)
* withholding_tax : decimal(12,2)
* net_amount : decimal(12,2)
* remarks : varchar(255)
* created_at : datetime
* updated_at : datetime
v top1movers leave_balances
* id : int(11)
* employee_id : int(11)
* leave_type_id : int(11)
* year : int(11)
* allocated_days : decimal(8,2)
* used_days : decimal(8,2)
* created_at : datetime
* updated_at : datetime
v top1movers leave_requests
* id : int(11)
* employee_id : int(11)
* leave_type_id : int(11)
* start_date : date
* end_date : date
* total_days : decimal(8,2)
* reason : text
* attachment : varchar(255)
* status : enum('Pending','Approved','Rejected')
* approved_by : int(11)
* approved_date : datetime
* remarks : varchar(255)
* balance_applied : tinyint(1)
* created_at : datetime
v top1movers leave_request_audit_logs
* id : int(11)
* leave_request_id : int(11)
* action : varchar(40)
* from_status : varchar(40)
* to_status : varchar(40)
* acted_by : int(11)
* remarks : varchar(255)
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers leave_types
* id : int(11)
* leave_name : varchar(100)
* description : varchar(255)
* is_paid : tinyint(1)
* default_days : decimal(8,2)
v top1movers logistics_audit_logs
* id : int(11)
* module : varchar(80)
* record_id : int(11)
* action : varchar(80)
* old_value : text
* new_value : text
* remarks : text
* created_by : int(11)
* created_at : datetime
v top1movers logistics_billing
* id : int(11)
* invoice_no : varchar(60)
* client_id : int(11)
* shipment_id : int(11)
* dispatch_id : int(11)
* billing_type : enum('logistics_service','delivery_income','trucking_income','warehousing_income','customs_clearance','forwarding','expense_reimbursement','other')
* income_amount : decimal(14,2)
* expense_amount : decimal(14,2)
* billing_status : enum('draft','billed','posted','paid','void')
* due_date : date
* notes : text
* posted_to_accounting : tinyint(1)
* accounting_reference : varchar(120)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_clients
* id : int(11)
* client_code : varchar(40)
* company_name : varchar(180)
* contact_person : varchar(140)
* contact_number : varchar(60)
* email : varchar(140)
* address : text
* status : enum('active','inactive')
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_consolidation_batches
* id : int(11)
* batch_no : varchar(60)
* batch_name : varchar(180)
* status : enum('planned','consolidating','ready_for_dispatch','dispatched','completed','cancelled')
* dispatch_ref_no : varchar(80)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_consolidation_items
* id : int(11)
* batch_id : int(11)
* shipment_id : int(11)
* created_at : datetime
v top1movers logistics_customs_clearances
* id : int(11)
* shipment_id : int(11)
* customs_status : enum('pending_documents','processing','cleared','hold','released')
* document_checklist : text
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_customs_logs
* id : int(11)
* clearance_id : int(11)
* shipment_id : int(11)
* old_status : varchar(60)
* new_status : varchar(60)
* remarks : text
* updated_by : int(11)
* created_at : datetime
v top1movers logistics_dispatches
* id : int(11)
* dispatch_no : varchar(60)
* batch_id : int(11)
* shipment_id : int(11)
* delivery_schedule : datetime
* truck_id : int(11)
* driver_employee_id : int(11)
* pickup_location : varchar(180)
* delivery_address : text
* delivery_status : enum('scheduled','loading','in_transit','delivered','released','cancelled')
* proof_of_delivery : varchar(255)
* delivery_photo : varchar(255)
* signature_image : varchar(255)
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_shipments
* id : int(11)
* shipment_ref_no : varchar(60)
* client_id : int(11)
* transaction_type : enum('import','export','forwarding','consolidation','warehousing','distribution')
* container_no : varchar(80)
* bl_awb_no : varchar(100)
* cargo_description : text
* quantity : decimal(14,2)
* weight_kg : decimal(14,3)
* cbm : decimal(14,3)
* date_received : date
* warehouse_location : varchar(150)
* current_status : enum('received','stored','for_consolidation','for_customs_clearance','ready_for_dispatch','in_transit','delivered','released')
* remarks : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers logistics_warehouse_movements
* id : int(11)
* shipment_id : int(11)
* movement_type : varchar(60)
* from_location : varchar(150)
* to_location : varchar(150)
* status_from : varchar(60)
* status_to : varchar(60)
* remarks : text
* moved_by : int(11)
* created_at : datetime
v top1movers mobile_push_tokens
* id : bigint(20) unsigned
* user_id : int(11)
* employee_id : int(11)
* expo_push_token : varchar(255)
* platform : varchar(20)
* device_name : varchar(120)
* app_mode : varchar(30)
* is_active : tinyint(1)
* last_seen_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers offboarding_records
* id : int(11)
* employee_id : int(11)
* trigger_type : enum('resignation','termination','end_of_contract')
* resignation_date : date
* last_working_day : date
* reason : text
* final_pay_request_status : enum('not_ready','ready_for_payroll','sent_to_payroll','processed')
* status : enum('for_clearance','pending_it_clearance','pending_accounting_clearance','pending_hr_clearance','completed','cancelled')
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers official_business_requests
* id : int(11)
* employee_id : int(11)
* ob_date : date
* start_time : datetime
* end_time : datetime
* location : varchar(160)
* client_company : varchar(160)
* purpose : text
* attachment : varchar(255)
* credited_hours : decimal(10,2)
* status : enum('pending','supervisor_approved','approved','rejected','cancelled')
* supervisor_by : int(11)
* supervisor_at : datetime
* approved_by : int(11)
* approved_at : datetime
* remarks : text
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers orders
* id : int(11)
* bill_no : varchar(50)
* company_name : varchar(255)
* customer_name : varchar(255)
* customer_address : text
* customer_phone : varchar(20)
* delivery_date : date
* delivery_type : varchar(20)
* date_time : int(11)
* gross_amount : decimal(12,2)
* service_charge_rate : decimal(5,2)
* service_charge : decimal(12,2)
* vat_charge_rate : decimal(5,2)
* vat_charge : decimal(12,2)
* tax_inclusive : decimal(12,2)
* tax_exclusive : decimal(12,2)
* net_amount : decimal(12,2)
* deliveryfee : decimal(12,2)
* discount : decimal(12,2)
* paid_status : int(11)
* return_note : text
* payment_proof : varchar(255)
* modeofpayment : int(11)
* record_type : varchar(20)
* approval_status : tinyint(1)
* approved_at : int(11)
* approved_by : int(11)
* source_quotation_id : int(11)
* quotation_valid_until : date
* user_id : int(11)
* created_at : datetime
v top1movers orders_item
* id : int(11)
* order_id : int(11)
* product_id : int(11)
* product_name : varchar(255)
* qty : varchar(255)
* rate : varchar(255)
* amount : varchar(255)
v top1movers order_deliveries
* id : int(11)
* allocation_no : varchar(40)
* order_id : int(11)
* truck_id : int(11)
* scheduled_date : date
* route_sequence : int(11)
* payment_mode : varchar(40)
* cash_to_collect : decimal(12,2)
* pickup_location : varchar(255)
* dropoff_location : varchar(255)
* trip_type : varchar(20)
* route_profile : varchar(30)
* estimated_one_way_distance_km : decimal(10,2)
* estimated_total_distance_km : decimal(10,2)
* estimated_cargo_weight_kg : decimal(12,2)
* load_utilization_percent : decimal(10,2)
* truck_km_per_liter : decimal(10,2)
* recommended_km_per_liter : decimal(10,2)
* diesel_price_per_liter : decimal(10,2)
* cost_per_km : decimal(10,2)
* estimated_fuel_liters : decimal(10,2)
* estimated_fuel_cost : decimal(12,2)
* actual_start_odometer : decimal(12,2)
* actual_end_odometer : decimal(12,2)
* actual_distance_km : decimal(10,2)
* actual_fuel_liters : decimal(10,2)
* actual_km_per_liter : decimal(10,2)
* actual_fuel_cost : decimal(12,2)
* fuel_variance : decimal(12,2)
* distance_variance : decimal(10,2)
* status : tinyint(1)
* notes : text
* cancel_reason : varchar(255)
* canceled_at : datetime
* canceled_by : int(11)
* proof_path : varchar(255)
* user_id : int(11)
* created_at : datetime
v top1movers order_delivery_expenses
* id : int(11)
* order_delivery_id : int(11)
* expense_name : varchar(120)
* amount : decimal(12,2)
* created_at : datetime
v top1movers order_delivery_items
* id : int(11)
* order_delivery_id : int(11)
* order_item_id : int(11)
* product_id : int(11)
* qty_allocated : int(11)
v top1movers order_delivery_item_returns
* id : int(11)
* order_delivery_id : int(11)
* order_delivery_item_id : int(11)
* product_id : int(11)
* qty_returned : int(11)
* reason : text
* returned_by : int(11)
* returned_at : datetime
v top1movers order_delivery_itinerary
* id : int(11)
* order_delivery_id : int(11)
* stop_no : int(11)
* stop_name : varchar(255)
* created_at : datetime
v top1movers order_delivery_status_logs
* id : int(11)
* order_delivery_id : int(11)
* from_status : tinyint(3)
* to_status : tinyint(3)
* note : varchar(255)
* changed_by : int(11)
* changed_at : datetime
v top1movers overtime_requests
* id : int(11)
* employee_id : int(11)
* ot_date : date
* start_time : datetime
* end_time : datetime
* reason : text
* attachment : varchar(255)
* requested_hours : decimal(10,2)
* approved_hours : decimal(10,2)
* payable_hours : decimal(10,2)
* is_pre_shift : tinyint(1)
* status : enum('pending','supervisor_approved','approved','rejected','cancelled')
* supervisor_by : int(11)
* supervisor_at : datetime
* approved_by : int(11)
* approved_at : datetime
* remarks : text
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payables
* id : int(11)
* supplier_name : varchar(150)
* reference_no : varchar(60)
* delivery_id : int(11)
* due_date : date
* amount : decimal(14,2)
* balance : decimal(14,2)
* status : enum('open','partial','paid','void')
* notes : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payments
* id : int(11)
* payment_no : varchar(40)
* payment_date : date
* direction : enum('receive','pay')
* payer_type : enum('customer','supplier','employee','other')
* payer_name : varchar(150)
* reference_type : enum('receivable','payable','expense','transaction','other')
* reference_id : int(11)
* cash_account_id : int(11)
* counter_account_id : int(11)
* amount : decimal(14,2)
* payment_method : varchar(50)
* reference_no : varchar(60)
* notes : text
* transaction_id : int(11)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payroll_activity_logs
* id : bigint(20) unsigned
* cutoff_id : int(11)
* record_type : varchar(80)
* record_id : int(11)
* action : varchar(120)
* user_id : int(11)
* details_json : longtext
* created_at : datetime
v top1movers payroll_adjustments
* id : int(11)
* payroll_id : int(11)
* cutoff_id : int(11)
* employee_id : int(11)
* adjustment_type : varchar(80)
* amount : decimal(12,2)
* reason : text
* status : enum('pending','approved','rejected','posted')
* created_by : int(11)
* approved_by : int(11)
* approved_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers payroll_details
* id : int(11)
* payroll_id : int(11)
* detail_type : varchar(60)
* label : varchar(160)
* quantity : decimal(12,4)
* rate : decimal(12,4)
* amount : decimal(12,2)
* metadata_json : longtext
* created_at : datetime
v top1movers payroll_office_entries
* id : int(11)
* cutoff_id : int(11)
* employee_id : int(11)
* daily_rate : decimal(12,2)
* paid_days : decimal(8,2)
* late_undertime_deduction : decimal(12,2)
* overtime : decimal(12,2)
* allowance : decimal(12,2)
* incentive : decimal(12,2)
* deduction : decimal(12,2)
* remarks : text
* encoded_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payroll_settings
* id : int(11)
* setting_key : varchar(120)
* setting_value : varchar(255)
* value_type : enum('string','number','boolean','json')
* effective_start : date
* effective_end : date
* description : varchar(255)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payroll_trip_entries
* id : int(11)
* cutoff_id : int(11)
* employee_id : int(11)
* raw_name : varchar(160)
* corrected_name : varchar(160)
* position : varchar(120)
* truck_number : varchar(80)
* container_number : varchar(120)
* area_destination : varchar(160)
* rate : decimal(12,2)
* entry_type : enum('cut_off','adjustment','allowance','deduction','incentive')
* remarks : text
* encoded_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers payroll_trip_rates
* id : int(11)
* destination_area : varchar(160)
* truck_type : varchar(80)
* km : decimal(10,2)
* customer : varchar(160)
* standard_trip_rate : decimal(12,2)
* driver_rate_type : enum('fixed','percentage','manual')
* driver_rate_value : decimal(12,4)
* helper_rate_type : enum('fixed','percentage','manual')
* helper_rate_value : decimal(12,4)
* checker_rate_type : enum('fixed','percentage','manual')
* checker_rate_value : decimal(12,4)
* food_allowance : decimal(12,2)
* toll_other_expense : decimal(12,2)
* status : enum('active','inactive')
* created_at : datetime
* updated_at : datetime
v top1movers payslips
* id : int(11)
* payroll_id : int(11)
* employee_id : int(11)
* cutoff_id : int(11)
* token_hash : varchar(128)
* generated_by : int(11)
* generated_at : datetime
* viewed_at : datetime
* status : enum('generated','void')
v top1movers performance_evaluations
* id : int(11)
* employee_id : int(11)
* evaluation_type : varchar(80)
* period_start : date
* period_end : date
* evaluator_id : int(11)
* final_score : decimal(8,2)
* comments : text
* strengths : text
* areas_for_improvement : text
* recommendation : text
* attachment : varchar(255)
* status : enum('draft','submitted','reviewed','approved','closed')
* created_at : datetime
* updated_at : datetime
v top1movers products
* id : int(11)
* name : varchar(255)
* sku : varchar(255)
* price : decimal(12,2)
* qty : varchar(255)
* image : text
* description : text
* attribute_value_id : text
* brand_id : text
* category_id : text
* store_id : int(11)
* availability : int(11)
* kilogram : varchar(100)
* unit_item : varchar(50)
* dealerprice : decimal(12,2)
* pricing_type : varchar(20)
* dealer_price_per_kg : decimal(10,2)
v top1movers product_history
* id : int(11)
* product_id : int(11)
* user_id : int(11)
* before_data : longtext
* after_data : longtext
* created_at : datetime
* action : varchar(50)
* reference : varchar(50)
* qty_change : int(11)
v top1movers profile_update_requests
* id : int(11)
* employee_id : int(11)
* field_name : varchar(100)
* old_value : text
* new_value : text
* proof_attachment : varchar(255)
* reason : text
* status : enum('pending','approved','rejected','cancelled')
* created_by : int(11)
* reviewed_by : int(11)
* reviewed_at : datetime
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers receivables
* id : int(11)
* customer_name : varchar(150)
* reference_no : varchar(60)
* order_id : int(11)
* due_date : date
* amount : decimal(14,2)
* balance : decimal(14,2)
* status : enum('open','partial','paid','void')
* notes : text
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_applicants
* id : int(11)
* applicant_code : varchar(40)
* first_name : varchar(80)
* middle_name : varchar(80)
* last_name : varchar(80)
* suffix : varchar(30)
* birthdate : date
* gender : varchar(30)
* civil_status : varchar(40)
* contact_number : varchar(40)
* email : varchar(160)
* address : text
* position_id : int(11)
* preferred_company : enum('Top1Movers','Bambs Trucking Corp.','Either company')
* expected_salary : decimal(12,2)
* availability_date : date
* employment_history : text
* educational_background : text
* skills : text
* certifications : text
* driver_license_details : text
* work_experience : text
* referral_source : varchar(160)
* remarks : text
* status : enum('draft','submitted','under_review','for_online_interview','interview_link_sent','online_interview_in_progress','online_interview_completed','for_hr_review','shortlisted','for_final_interview','failed','hired','cancelled','converted_to_employee')
* consent_accepted : tinyint(1)
* consent_accepted_at : datetime
* consent_ip : varchar(64)
* consent_version : varchar(40)
* converted_employee_id : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_applicant_documents
* id : int(11)
* applicant_id : int(11)
* document_type : varchar(80)
* title : varchar(160)
* original_filename : varchar(255)
* stored_filename : varchar(255)
* file_path : varchar(255)
* file_extension : varchar(20)
* mime_type : varchar(120)
* file_size : int(11)
* status : enum('active','archived')
* uploaded_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_email_logs
* id : int(11)
* applicant_id : int(11)
* email_type : varchar(80)
* recipient_email : varchar(190)
* subject : varchar(255)
* body_snapshot : mediumtext
* status : enum('pending','sent','failed')
* error_message : mediumtext
* sent_by : int(11)
* sent_at : datetime
* created_at : datetime
v top1movers recruitment_email_templates
* id : int(11)
* template_name : varchar(160)
* stage : varchar(80)
* subject : varchar(255)
* body : mediumtext
* status : enum('active','inactive')
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_final_interviews
* id : int(11)
* applicant_id : int(11)
* interview_date : date
* interview_time : time
* interview_type : enum('Face-to-face','Phone call','Online meeting')
* interviewer_id : int(11)
* remarks : text
* status : enum('scheduled','completed','rescheduled','cancelled','no_show')
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_interview_event_logs
* id : int(11)
* interview_session_id : int(11)
* applicant_id : int(11)
* question_id : int(11)
* event_type : varchar(80)
* event_time : datetime
* duration_seconds : int(11)
* metadata : text
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers recruitment_interview_integrity_summary
* id : int(11)
* interview_session_id : int(11)
* applicant_id : int(11)
* tab_switch_count : int(11)
* total_away_seconds : int(11)
* fullscreen_exit_count : int(11)
* copy_attempt_count : int(11)
* right_click_attempt_count : int(11)
* suspicious_key_count : int(11)
* device_interruption_count : int(11)
* duplicate_session_count : int(11)
* early_stop_count : int(11)
* too_short_answer_count : int(11)
* failed_upload_count : int(11)
* invalid_step_count : int(11)
* no_face_count : int(11)
* multiple_face_count : int(11)
* risk_score : int(11)
* risk_level : enum('Low','Medium','High')
* hr_review_status : enum('pending','acceptable','questionable')
* hr_integrity_remarks : text
* first_ip_address : varchar(64)
* last_ip_address : varchar(64)
* first_user_agent : varchar(255)
* last_user_agent : varchar(255)
* browser_name : varchar(80)
* operating_system : varchar(120)
* device_type : varchar(60)
* screen_size : varchar(40)
* timezone : varchar(80)
* started_at : datetime
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_interview_progress
* id : int(11)
* interview_session_id : int(11)
* applicant_id : int(11)
* current_question_id : int(11)
* current_question_order : int(11)
* completed_questions_count : int(11)
* status : enum('not_started','in_progress','completed')
* current_step : varchar(40)
* current_question_started_at : datetime
* recording_state : varchar(40)
* last_activity_at : datetime
* updated_at : datetime
v top1movers recruitment_interview_sessions
* id : int(11)
* applicant_id : int(11)
* position_id : int(11)
* token : varchar(120)
* token_expires_at : datetime
* status : enum('pending','in_progress','completed','expired','cancelled')
* expires_at : datetime
* allow_retake : tinyint(1)
* retakes_allowed : int(11)
* allow_preview : tinyint(1)
* require_all_questions : tinyint(1)
* consent_accepted : tinyint(1)
* consent_accepted_at : datetime
* consent_ip : varchar(64)
* consent_user_agent : varchar(255)
* applicant_agreed_interview_rules : tinyint(1)
* rules_agreed_at : datetime
* rules_agreed_ip : varchar(64)
* rules_agreed_user_agent : varchar(255)
* first_client_id : varchar(80)
* active_client_id : varchar(80)
* active_client_seen_at : datetime
* last_device_info : text
* created_by : int(11)
* started_at : datetime
* completed_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_management_review_logs
* id : int(11)
* applicant_id : int(11)
* token_id : int(11)
* action : enum('viewed','rated','remarked','recommended','video_viewed')
* reviewer_name : varchar(160)
* rating : decimal(3,2)
* remarks : text
* recommendation : enum('Recommended','For Final Interview','Not Recommended','For Further Review')
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers recruitment_management_review_tokens
* id : int(11)
* applicant_id : int(11)
* token : varchar(120)
* expires_at : datetime
* status : enum('active','revoked','expired')
* allow_rating : tinyint(1)
* allow_remarks : tinyint(1)
* show_question_videos : tinyint(1)
* show_applicant_details : tinyint(1)
* show_documents : tinyint(1)
* created_by : int(11)
* revoked_by : int(11)
* revoked_at : datetime
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_positions
* id : int(11)
* position_title : varchar(160)
* company : enum('Top1Movers','Bambs Trucking Corp.','Shared')
* department : varchar(120)
* job_description : text
* qualifications : text
* requirements : text
* employment_type : varchar(80)
* vacancy_count : int(11)
* status : enum('open','closed','on_hold')
* created_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_questions
* id : int(11)
* position_id : int(11)
* company : enum('Top1Movers','Bambs Trucking Corp.','Shared')
* question_text : text
* question_type : varchar(80)
* question_mode : enum('text','video','text_video')
* question_video_path : varchar(255)
* question_video_original_filename : varchar(255)
* question_video_stored_filename : varchar(255)
* question_video_mime_type : varchar(120)
* question_video_size : int(11)
* question_video_duration_seconds : int(11)
* show_text_overlay : tinyint(1)
* text_overlay_position : enum('top','bottom')
* answer_time_limit_seconds : int(11)
* allow_replay : tinyint(1)
* max_replay_count : int(11)
* require_full_watch_before_answer : tinyint(1)
* allow_answer_retake : tinyint(1)
* max_answer_retake_count : int(11)
* time_limit_seconds : int(11)
* sort_order : int(11)
* is_required : tinyint(1)
* status : enum('active','inactive')
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_question_video_versions
* id : int(11)
* question_id : int(11)
* question_video_path : varchar(255)
* question_video_original_filename : varchar(255)
* question_video_stored_filename : varchar(255)
* question_video_mime_type : varchar(120)
* question_video_size : int(11)
* question_video_duration_seconds : int(11)
* replaced_by : int(11)
* replaced_at : datetime
v top1movers recruitment_question_view_logs
* id : int(11)
* interview_session_id : int(11)
* applicant_id : int(11)
* question_id : int(11)
* viewed_at : datetime
* completed_full_watch : tinyint(1)
* replay_count : int(11)
* ip_address : varchar(64)
* user_agent : varchar(255)
* created_at : datetime
v top1movers recruitment_reviews
* id : int(11)
* applicant_id : int(11)
* reviewer_id : int(11)
* technical_rating : decimal(3,2)
* communication_rating : decimal(3,2)
* experience_rating : decimal(3,2)
* professionalism_rating : decimal(3,2)
* overall_rating : decimal(3,2)
* recommendation : enum('Highly recommended','Recommended','For further review','Not recommended')
* remarks : text
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_review_scores
* id : int(11)
* review_id : int(11)
* applicant_id : int(11)
* interview_session_id : int(11)
* reviewer_id : int(11)
* question_id : int(11)
* rating : decimal(3,2)
* remarks : text
* pass_fail_status : enum('pending','pass','fail')
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_settings
* id : int(11)
* setting_key : varchar(120)
* setting_value : mediumtext
* value_type : enum('string','number','boolean','json','text')
* description : text
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers recruitment_status_logs
* id : int(11)
* applicant_id : int(11)
* old_status : varchar(60)
* new_status : varchar(60)
* changed_by : int(11)
* remarks : text
* created_at : datetime
v top1movers recruitment_video_answers
* id : int(11)
* interview_session_id : int(11)
* applicant_id : int(11)
* question_id : int(11)
* question_shown_at : datetime
* question_video_started_at : datetime
* question_video_ended_at : datetime
* countdown_started_at : datetime
* recording_started_at : datetime
* recording_ended_at : datetime
* auto_started_recording : tinyint(1)
* recording_stop_reason : varchar(40)
* upload_started_at : datetime
* upload_completed_at : datetime
* uploaded_at : datetime
* is_early_submitted : tinyint(1)
* confirmed_short_answer : tinyint(1)
* answer_video_path : varchar(255)
* answer_video_original_filename : varchar(255)
* answer_video_stored_filename : varchar(255)
* answer_video_mime_type : varchar(120)
* answer_video_size : int(11)
* answer_duration_seconds : int(11)
* retake_count : int(11)
* video_file_path : varchar(255)
* video_filename : varchar(255)
* video_size : int(11)
* mime_type : varchar(120)
* duration_seconds : int(11)
* attempt_no : int(11)
* recorded_at : datetime
* submitted_at : datetime
* upload_status : enum('uploaded','failed','processing')
* status : enum('active','replaced','archived')
* created_at : datetime
* updated_at : datetime
v top1movers schedule_change_logs
* id : int(11)
* employee_id : int(11)
* scope_type : varchar(40)
* scope_value : varchar(160)
* old_schedule_id : int(11)
* new_schedule_id : int(11)
* effective_date : date
* changed_by : int(11)
* reason : text
* created_at : datetime
v top1movers schedule_scope_assignments
* id : int(11)
* scope_type : enum('company','department','branch','position')
* scope_value : varchar(160)
* schedule_id : int(11)
* effective_date : date
* end_date : date
* assigned_by : int(11)
* remarks : text
* status : enum('active','inactive','archived')
* created_at : datetime
* updated_at : datetime
v top1movers stock_adjustments
* id : int(11)
* product_id : int(11)
* old_qty : int(11)
* new_qty : int(11)
* difference : int(11)
* reason : varchar(255)
* user_id : int(11)
* created_at : datetime
v top1movers stores
* id : int(11)
* name : varchar(255)
* active : int(11)
v top1movers system_settings
* id : int(11)
* setting_key : varchar(120)
* setting_value : text
* value_type : enum('string','number','boolean','json')
* description : varchar(255)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers transaction_lines
* id : int(11)
* transaction_id : int(11)
* account_id : int(11)
* line_type : enum('debit','credit')
* amount : decimal(14,2)
* memo : varchar(255)
* created_at : datetime
v top1movers trucks
* id : int(11)
* name : varchar(120)
* plate_no : varchar(60)
* capacity_kg : decimal(12,2)
* capacity_cbm : decimal(12,2)
* gps_device_id : varchar(120)
* active : tinyint(1)
* created_at : datetime
v top1movers truck_locations
* id : int(11)
* truck_id : int(11)
* latitude : decimal(10,7)
* longitude : decimal(10,7)
* speed_kph : decimal(8,2)
* captured_at : datetime
* source : varchar(50)
* created_at : timestamp
v top1movers users
* id : int(11)
* username : varchar(255)
* password : varchar(255)
* must_change_password : tinyint(1)
* email : varchar(255)
* employee_id : int(11)
* firstname : varchar(255)
* lastname : varchar(255)
* phone : varchar(255)
* gender : int(11)
v top1movers user_group
* id : int(11)
* user_id : int(11)
* group_id : int(11)
v top1movers user_notifications
* id : bigint(20) unsigned
* user_id : int(11)
* type : varchar(60)
* title : varchar(160)
* message : text
* payload_json : text
* is_read : tinyint(1)
* created_at : datetime
* read_at : datetime
v top1movers website_inquiries
* id : int(10) unsigned
* product_id : int(11)
* product_name : varchar(255)
* client_name : varchar(190)
* company_name : varchar(190)
* email : varchar(190)
* phone : varchar(80)
* subject : varchar(255)
* message : text
* source_page : varchar(255)
* ip_address : varchar(64)
* user_agent : varchar(255)
* status : varchar(20)
* created_at : datetime
* updated_at : datetime
v top1movers work_schedules
* id : int(11)
* schedule_code : varchar(30)
* schedule_name : varchar(120)
* schedule_type : enum('fixed','flexible')
* start_time : time
* end_time : time
* break_minutes : int(11)
* required_work_minutes : int(11)
* grace_period_minutes : int(11)
* is_overnight : tinyint(1)
* effective_date : date
* status : enum('active','inactive')
* remarks : text
* legacy_shift_id : int(11)
* created_by : int(11)
* updated_by : int(11)
* created_at : datetime
* updated_at : datetime
v top1movers work_schedule_days
* id : int(11)
* schedule_id : int(11)
* day_of_week : tinyint(1)
* is_working_day : tinyint(1)
* is_rest_day : tinyint(1)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship