SQL reference: 48_enviroment

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/48_enviroment.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 48_enviroment. SHA-256 (LF): 5d4bf75bacf6ebb21b83f60aa6a5f33d245787fdcb67125b8f860f2be3ebddf8.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

================================================================= Arybit Earth v2.0 — Planetary Intelligence Fabric Powered by AARAB v4.0 Intelligence Model Suite Complete Production-Ready MySQL Schema Version: 2.1.0 (Integrated) • January 2026 MODULE: 48_enviroment Arybit Technologies • Nairobi, Kenya Integrated into Arybit Auth Master Schema (Modular Bridge)

Declared objects

• earth_alerts
• earth_carbon_credits_history
• earth_carbon_credits
• earth_local_sensors
• earth_persona_metrics
• earth_personas
• earth_predictions
• earth_sensor_readings
• earth_system_logs
• earth_task_queue
• earth_tasks
• earth_users
• idx_assigned_persona_id
• idx_created_at
• idx_domain_status
• idx_last_active_at
• idx_last_reading_at
• idx_level_timestamp
• idx_persona_issued_at
• idx_persona_task
• idx_persona_type_status
• idx_persona_type_timestamp
• idx_resolved
• idx_sensor_timestamp
• idx_sensor_type_status
• idx_severity_created
• idx_status_type_priority
• idx_task_id
• idx_task_persona
• idx_timestamp_quality
• sp_create_alert
• sp_get_carbon_totals
• trg_earth_alerts_resolve
• trg_earth_carbon_credits_insert
• trg_earth_carbon_credits_update
• trg_earth_personas_update_active
• trg_earth_sensor_readings_update
• trg_earth_task_queue_attempt
• vw_carbon_totals
• vw_earth_impact_summary
• vw_recent_logs
• vw_sensor_status
• create_earth_alerts_indexes
• create_earth_carbon_credits_indexes
• create_earth_local_sensors_indexes
• create_earth_persona_metrics_indexes
• create_earth_personas_indexes
• create_earth_predictions_indexes
• create_earth_sensor_readings_indexes
• create_earth_system_logs_indexes
• create_earth_task_queue_indexes
• create_earth_tasks_indexes

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog