Database Diagnostic Report

Document Types:

Array
(
    [0] => Array
        (
            [id_document_type] => 1
            [type_name] => Policy
            [description] => Company policies and policy statements
            [icon_class] => fa-file-contract
            [display_order] => 1
            [created_date] => 2026-06-04 15:02:12
        )

    [1] => Array
        (
            [id_document_type] => 2
            [type_name] => Procedure
            [description] => Company procedures and work instructions
            [icon_class] => fa-file-lines
            [display_order] => 2
            [created_date] => 2026-06-04 15:02:12
        )

    [2] => Array
        (
            [id_document_type] => 3
            [type_name] => Form
            [description] => Standard forms and templates
            [icon_class] => fa-file-pdf
            [display_order] => 3
            [created_date] => 2026-06-04 15:02:12
        )

    [3] => Array
        (
            [id_document_type] => 4
            [type_name] => COSHH
            [description] => COSHH assessments and chemical safety data
            [icon_class] => fa-flask-vial
            [display_order] => 4
            [created_date] => 2026-06-04 15:02:12
        )

    [4] => Array
        (
            [id_document_type] => 5
            [type_name] => Risk Assessment
            [description] => Risk assessment documents
            [icon_class] => fa-exclamation-triangle
            [display_order] => 5
            [created_date] => 2026-06-04 15:02:12
        )

    [5] => Array
        (
            [id_document_type] => 6
            [type_name] => Standard
            [description] => Standards and specifications
            [icon_class] => fa-book
            [display_order] => 6
            [created_date] => 2026-06-04 15:02:12
        )

    [6] => Array
        (
            [id_document_type] => 7
            [type_name] => Technical Library
            [description] => Technical documents and references
            [icon_class] => fa-book-open
            [display_order] => 7
            [created_date] => 2026-06-04 15:02:12
        )

)

HS Documents (first 10):

Array
(
    [0] => Array
        (
            [id_hs_document] => 71
            [document_code] => MCP-001
            [document_title] => Abnormal Loads Policy
            [id_document_type] => 1
            [status] => Active
        )

    [1] => Array
        (
            [id_hs_document] => 72
            [document_code] => MCP-002
            [document_title] => Anti-bribery & corruption Policy
            [id_document_type] => 1
            [status] => Active
        )

    [2] => Array
        (
            [id_hs_document] => 73
            [document_code] => MCP-003
            [document_title] => Avoiding and reporting Bridge Strikes Policy
            [id_document_type] => 1
            [status] => Active
        )

    [3] => Array
        (
            [id_hs_document] => 74
            [document_code] => MCP-004
            [document_title] => Behavioural Management & Behavioural Safety Program Policy
            [id_document_type] => 1
            [status] => Active
        )

    [4] => Array
        (
            [id_hs_document] => 75
            [document_code] => MCP-005
            [document_title] => Competency & Training Policy
            [id_document_type] => 1
            [status] => Active
        )

    [5] => Array
        (
            [id_hs_document] => 76
            [document_code] => MCP-006
            [document_title] => CSR Policy
            [id_document_type] => 1
            [status] => Active
        )

    [6] => Array
        (
            [id_hs_document] => 77
            [document_code] => MCP-007
            [document_title] => Cyber Security Policy
            [id_document_type] => 1
            [status] => Active
        )

    [7] => Array
        (
            [id_hs_document] => 78
            [document_code] => MCP-008
            [document_title] => Data Protection Policy
            [id_document_type] => 1
            [status] => Active
        )

    [8] => Array
        (
            [id_hs_document] => 79
            [document_code] => MCP-009
            [document_title] => Disciplinary Policy
            [id_document_type] => 1
            [status] => Active
        )

    [9] => Array
        (
            [id_hs_document] => 80
            [document_code] => MCP-010
            [document_title] => Driver Eligibility Policy
            [id_document_type] => 1
            [status] => Active
        )

)

HS Documents with JOIN (first 5):

Array
(
    [0] => Array
        (
            [id_hs_document] => 71
            [document_code] => MCP-001
            [document_title] => Abnormal Loads Policy
            [id_document_type] => 1
            [type_name] => Policy
            [status] => Active
        )

    [1] => Array
        (
            [id_hs_document] => 72
            [document_code] => MCP-002
            [document_title] => Anti-bribery & corruption Policy
            [id_document_type] => 1
            [type_name] => Policy
            [status] => Active
        )

    [2] => Array
        (
            [id_hs_document] => 73
            [document_code] => MCP-003
            [document_title] => Avoiding and reporting Bridge Strikes Policy
            [id_document_type] => 1
            [type_name] => Policy
            [status] => Active
        )

    [3] => Array
        (
            [id_hs_document] => 74
            [document_code] => MCP-004
            [document_title] => Behavioural Management & Behavioural Safety Program Policy
            [id_document_type] => 1
            [type_name] => Policy
            [status] => Active
        )

    [4] => Array
        (
            [id_hs_document] => 75
            [document_code] => MCP-005
            [document_title] => Competency & Training Policy
            [id_document_type] => 1
            [type_name] => Policy
            [status] => Active
        )

)

Risk Assessments:

Array
(
)

COSHH Products:

Array
(
    [0] => Array
        (
            [id_product] => 1
            [coshh_id] => 001
            [product_name] => Mechoil
            [status] => Active
            [last_reviewed] => 2026-06-05
        )

    [1] => Array
        (
            [id_product] => 2
            [coshh_id] => 002
            [product_name] => Multi-use maintenance spray
            [status] => Active
            [last_reviewed] => 2026-06-05
        )

    [2] => Array
        (
            [id_product] => 3
            [coshh_id] => 003
            [product_name] => Fuel Injector Cleaner
            [status] => Active
            [last_reviewed] => 2026-06-05
        )

    [3] => Array
        (
            [id_product] => 4
            [coshh_id] => 005
            [product_name] => Total Antifreeze
            [status] => Active
            [last_reviewed] => 2026-06-05
        )

    [4] => Array
        (
            [id_product] => 5
            [coshh_id] => 006
            [product_name] => Fuchs Renolin VG 46 Hydraulic Oil
            [status] => Active
            [last_reviewed] => 2026-06-05
        )

)