{
    "php_working": true,
    "timestamp": "2026-04-17 12:41:26",
    "connection_attempt": {
        "host": "localhost",
        "username": "nsaorg_mobileapp",
        "password_empty": false,
        "database": "nsaorg_mobileapp"
    },
    "connection_success": true,
    "table_exists": true,
    "record_count": 9,
    "table_structure": [
        {
            "Field": "id",
            "Type": "bigint(20) unsigned",
            "Null": "NO",
            "Key": "PRI",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Field": "title",
            "Type": "varchar(255)",
            "Null": "NO",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "description",
            "Type": "text",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "report_date",
            "Type": "date",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "file_url",
            "Type": "text",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "category",
            "Type": "bigint(20) unsigned",
            "Null": "YES",
            "Key": "MUL",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "created_at",
            "Type": "timestamp",
            "Null": "NO",
            "Key": "",
            "Default": "current_timestamp()",
            "Extra": ""
        },
        {
            "Field": "user_id",
            "Type": "bigint(20) unsigned",
            "Null": "YES",
            "Key": "MUL",
            "Default": null,
            "Extra": ""
        }
    ],
    "sample_data": [
        {
            "id": 60,
            "title": "Census Main Report 2023",
            "description": "Census Main Report 2023",
            "report_date": "2025-11-24",
            "file_url": "https:\/\/nsa.org.na\/wp-content\/uploads\/2024\/07\/Namibia-2011-Population-and-Housing-Census-Main-Report.pdf",
            "category": 40,
            "created_at": "2025-11-24 00:00:00",
            "user_id": null
        },
        {
            "id": 61,
            "title": "Strategic Plan for Agriculture",
            "description": "Strategic Plan for Agriculture",
            "report_date": "2025-11-04",
            "file_url": "https:\/\/nsa.org.na\/wp-content\/uploads\/2025\/02\/STRATEGIC-PLAN-FOR-AGRICULTURAL-AND-RURAL-STATISTICS-2024_25-%E2%80%93-2028_29-.pdf",
            "category": 39,
            "created_at": "2025-11-04 00:00:00",
            "user_id": null
        }
    ]
}