=== property_inspections ===
[
    {
        "Field": "id",
        "Type": "int(10) unsigned",
        "Null": "NO",
        "Key": "PRI",
        "Default": null,
        "Extra": "auto_increment"
    },
    {
        "Field": "inspection_case_no",
        "Type": "varchar(60)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "unit_id",
        "Type": "int(10) unsigned",
        "Null": "NO",
        "Key": "MUL",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "inspector_id",
        "Type": "int(10) unsigned",
        "Null": "NO",
        "Key": "MUL",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "assigned_officer_id",
        "Type": "int(10) unsigned",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "inspection_date",
        "Type": "date",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "physical_status",
        "Type": "enum('RUNNING_SMOOTHLY','CLOSED_SHUTTER','SUB_LETTED','UNAUTHORIZED_ALTERATION','STRUCTURAL_HAZARD')",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "actual_business",
        "Type": "varchar(150)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "latitude",
        "Type": "decimal(11,8)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "longitude",
        "Type": "decimal(11,8)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "gps_accuracy_meters",
        "Type": "decimal(8,2)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "altitude_meters",
        "Type": "decimal(8,2)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "speed_mps",
        "Type": "decimal(8,2)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "heading_degrees",
        "Type": "decimal(8,2)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "client_timestamp",
        "Type": "datetime",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "server_timestamp",
        "Type": "timestamp",
        "Null": "NO",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": ""
    },
    {
        "Field": "time_drift_seconds",
        "Type": "int(11)",
        "Null": "YES",
        "Key": "",
        "Default": "0",
        "Extra": ""
    },
    {
        "Field": "device_user_agent",
        "Type": "varchar(255)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "device_ip",
        "Type": "varchar(45)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "battery_level",
        "Type": "varchar(20)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "network_type",
        "Type": "varchar(30)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "qr_verified",
        "Type": "tinyint(1)",
        "Null": "YES",
        "Key": "",
        "Default": "0",
        "Extra": ""
    },
    {
        "Field": "qr_scanned_code",
        "Type": "varchar(100)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "distance_from_property_meters",
        "Type": "decimal(10,2)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "geofence_status",
        "Type": "enum('VERIFIED_ON_SITE','OUT_OF_BOUNDS_WARNING','SPOOF_SUSPECTED')",
        "Null": "YES",
        "Key": "",
        "Default": "VERIFIED_ON_SITE",
        "Extra": ""
    },
    {
        "Field": "sub_letting_detected",
        "Type": "tinyint(1)",
        "Null": "NO",
        "Key": "",
        "Default": "0",
        "Extra": ""
    },
    {
        "Field": "unauthorized_extension_sqft",
        "Type": "decimal(8,2)",
        "Null": "NO",
        "Key": "",
        "Default": "0.00",
        "Extra": ""
    },
    {
        "Field": "remarks",
        "Type": "text",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "photo_url",
        "Type": "varchar(255)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "action_recommended",
        "Type": "varchar(150)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "inspection_status",
        "Type": "enum('ASSIGNED','IN_PROGRESS','COMPLETED','ACTION_TAKEN')",
        "Null": "YES",
        "Key": "",
        "Default": "COMPLETED",
        "Extra": ""
    },
    {
        "Field": "created_at",
        "Type": "timestamp",
        "Null": "NO",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": ""
    }
]
=== users ===
[
    {
        "Field": "id",
        "Type": "int(10) unsigned",
        "Null": "NO",
        "Key": "PRI",
        "Default": null,
        "Extra": "auto_increment"
    },
    {
        "Field": "ulb_id",
        "Type": "int(10) unsigned",
        "Null": "NO",
        "Key": "MUL",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "department_id",
        "Type": "int(10) unsigned",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "designation_id",
        "Type": "int(10) unsigned",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "name",
        "Type": "varchar(100)",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "username",
        "Type": "varchar(60)",
        "Null": "NO",
        "Key": "UNI",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "email",
        "Type": "varchar(100)",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "phone",
        "Type": "varchar(30)",
        "Null": "YES",
        "Key": "",
        "Default": "022-22025225",
        "Extra": ""
    },
    {
        "Field": "password_hash",
        "Type": "varchar(255)",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "role",
        "Type": "varchar(50)",
        "Null": "NO",
        "Key": "",
        "Default": "COMMISSIONER",
        "Extra": ""
    },
    {
        "Field": "status",
        "Type": "enum('ACTIVE','INACTIVE','SUSPENDED')",
        "Null": "NO",
        "Key": "",
        "Default": "ACTIVE",
        "Extra": ""
    },
    {
        "Field": "created_at",
        "Type": "timestamp",
        "Null": "NO",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": ""
    },
    {
        "Field": "updated_at",
        "Type": "timestamp",
        "Null": "NO",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": "on update current_timestamp()"
    }
]