A3KER
Tables (48)
activity_corrections
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- correction_type_code — VARCHAR(100)
- superseded_activity_record_id — CHAR(36) — Foreign key → activity_records.id
- reason_code — VARCHAR(100)
- acted_by_type — VARCHAR(100)
- acted_by_id — CHAR(36)
- acted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
activity_records
- id — CHAR(36)
- field_season_id — CHAR(36) — Foreign key → field_seasons.id
- seasonal_event_id — CHAR(36) — Foreign key → seasonal_events.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- activity_type_code — VARCHAR(100)
- activity_date — DATE
- submission_status_code — VARCHAR(100)
- correction_status_code — VARCHAR(100)
- source_channel_message_id — CHAR(36) — Foreign key
- submitted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
admin_credentials
- id — CHAR(36)
- admin_user_id — CHAR(36) — Foreign key → admin_users.id
- password_hash — VARCHAR(500)
- password_algorithm_code — VARCHAR(100)
- password_set_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
admin_invites
- id — CHAR(36)
- admin_user_id — CHAR(36) — Foreign key → admin_users.id
- invite_email — VARCHAR(255)
- token_hash — VARCHAR(500)
- invited_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- expires_at — DATETIME
- redeemed_at — DATETIME
- revoked_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
admin_users
- id — CHAR(36)
- email — VARCHAR(255)
- display_name — VARCHAR(255)
- is_master_admin — BOOLEAN
- admin_user_status_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
agricultural_input_aliases
- id — CHAR(36)
- target_type_code — VARCHAR(100)
- canonical_code — VARCHAR(255)
- alias_text — VARCHAR(255)
- normalized_alias — VARCHAR(255)
- locale_code — VARCHAR(20)
- confidence_hint — DECIMAL(8,4)
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
ai_feature_policies
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- feature_code — VARCHAR(100)
- policy_version — VARCHAR(100)
- enabled — BOOLEAN
- auto_use_enabled — BOOLEAN
- auto_send_enabled — BOOLEAN
- fallback_mode_code — VARCHAR(100)
- fallback_reason_code — VARCHAR(100)
- per_item_cost_ceiling — DECIMAL(14,6)
- monthly_budget_ceiling — DECIMAL(14,6)
- release_gate_status_code — VARCHAR(100)
- latest_release_gate_evaluation_id — CHAR(36) — Foreign key → ai_release_gate_evaluations.id
- effective_from — DATETIME
- effective_to — DATETIME
- approved_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- approved_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
ai_model_runs
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- feature_code — VARCHAR(100)
- job_run_id — CHAR(36) — Foreign key
- provider_code — VARCHAR(100)
- model_name — VARCHAR(255)
- model_version — VARCHAR(100)
- prompt_version_id — CHAR(36) — Foreign key → ai_prompt_versions.id
- prompt_name — VARCHAR(255)
- prompt_version — VARCHAR(100)
- prompt_template_hash — VARCHAR(255)
- ops_config_revision_id — CHAR(36) — Foreign key → ops_config_revisions.id
- input_ref_json — JSON
- output_ref_json — JSON
- raw_output_ref_json — JSON
- result_label — VARCHAR(255)
- confidence_score — DECIMAL(8,4)
- confidence_band_code — VARCHAR(100)
- fallback_used — BOOLEAN
- run_status_code — VARCHAR(100)
- error_code — VARCHAR(100)
- error_message — TEXT
- token_input_count — INT
- token_output_count — INT
- estimated_cost — DECIMAL(14,6)
- latency_ms — INT
- started_at — DATETIME
- finished_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
ai_prompt_versions
- id — CHAR(36)
- feature_code — VARCHAR(100)
- prompt_name — VARCHAR(255)
- prompt_version — VARCHAR(100)
- locale_code — VARCHAR(20)
- template_hash — VARCHAR(255)
- template_artifact_uri — VARCHAR(500)
- ops_config_revision_id — CHAR(36) — Foreign key → ops_config_revisions.id
- status_code — VARCHAR(100)
- approved_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- approved_at — DATETIME
- retired_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
ai_release_gate_evaluations
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- feature_code — VARCHAR(100)
- policy_id — CHAR(36) — Foreign key → ai_feature_policies.id
- eval_dataset_ref — VARCHAR(500)
- sample_size — INT
- prompt_version_id — CHAR(36) — Foreign key → ai_prompt_versions.id
- prompt_name — VARCHAR(255)
- prompt_version — VARCHAR(100)
- model_name — VARCHAR(255)
- model_version — VARCHAR(100)
- precision — DECIMAL(8,4)
- false_accept_rate — DECIMAL(8,4)
- ambiguous_share — DECIMAL(8,4)
- reviewer_acceptable_rate — DECIMAL(8,4)
- unsafe_count — INT
- hallucination_count — INT
- unsupported_claim_count — INT
- locale_drift_count — INT
- estimated_unit_cost — DECIMAL(14,6)
- estimated_monthly_cost — DECIMAL(14,6)
- gate_result_code — VARCHAR(100)
- blocker_summary — TEXT
- report_artifact_uri — VARCHAR(500)
- evaluated_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
equipment_operation_records
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- equipment_type_code — VARCHAR(100)
- fuel_type_code — VARCHAR(100)
- usage_hours — DECIMAL(14,4)
- created_at — DATETIME
- updated_at — DATETIME
evidence_artifacts
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- artifact_type_code — VARCHAR(100)
- artifact_status_code — VARCHAR(100)
- storage_uri — VARCHAR(500)
- checksum — VARCHAR(255)
- mime_type — VARCHAR(255)
- byte_size — BIGINT
- source_event_id — CHAR(36) — Foreign key → evidence_request_events.id
- job_run_id — CHAR(36)
- created_at — DATETIME
- updated_at — DATETIME
evidence_request_events
- id — CHAR(36)
- field_season_id — CHAR(36) — Foreign key → field_seasons.id
- seasonal_event_id — CHAR(36) — Foreign key → seasonal_events.id
- field_id — CHAR(36) — Foreign key → fields.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- request_sequence — INT
- request_status_code — VARCHAR(100)
- request_sent_at — DATETIME
- window_start_at — DATETIME
- window_end_at — DATETIME
- schedule_version — INT
- ops_config_revision_id — CHAR(36) — Foreign key → ops_config_revisions.id
- created_at — DATETIME
- updated_at — DATETIME
evidence_sensitive_metadata
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- exact_capture_point — GEOMETRY
- raw_exif_json — JSON
- device_metadata_json — JSON
- retention_expires_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
evidence_sessions
- id — CHAR(36)
- evidence_request_event_id — CHAR(36) — Foreign key → evidence_request_events.id
- channel_code — VARCHAR(100)
- session_state_code — VARCHAR(100)
- opened_at — DATETIME
- location_request_sent_at — DATETIME
- location_retry_sent_at — DATETIME
- location_received_at — DATETIME
- accepted_location_at — DATETIME
- location_point — GEOMETRY
- location_accuracy_m — DECIMAL(14,4)
- expires_at — DATETIME
- provider_conversation_ref — VARCHAR(255)
- closed_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
evidence_submissions
- id — CHAR(36)
- evidence_request_event_id — CHAR(36) — Foreign key → evidence_request_events.id
- evidence_session_id — CHAR(36) — Foreign key → evidence_sessions.id
- field_id — CHAR(36) — Foreign key → fields.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- field_polygon_version_id — CHAR(36) — Foreign key → field_polygon_versions.id
- submission_no — INT
- channel_code — VARCHAR(100)
- provider_message_id — VARCHAR(255)
- upload_path_code — VARCHAR(100)
- capture_timestamp — DATETIME
- upload_timestamp — DATETIME
- server_received_at — DATETIME
- project_timezone — VARCHAR(100)
- submission_state_code — VARCHAR(100)
- current_auto_validation_result_code — VARCHAR(100)
- current_review_outcome_code — VARCHAR(100)
- current_delivery_state_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
evidence_validation_state_logs
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- actor_type_code — VARCHAR(100)
- actor_id — CHAR(36)
- previous_validation_state_code — VARCHAR(100)
- next_validation_state_code — VARCHAR(100)
- reason_code — VARCHAR(100)
- validation_signal_snapshot_json — JSON
- occurred_at — DATETIME
- recorded_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
fertilizer_records
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- fertilizer_kind_code — VARCHAR(100)
- product_name — VARCHAR(255)
- amount — DECIMAL(14,4)
- amount_unit — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
field_binding_candidates
- id — CHAR(36)
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- candidate_field_id — CHAR(36) — Foreign key → fields.id
- lookup_polygon_version_id — CHAR(36) — Foreign key → field_polygon_versions.id
- search_point_json — JSON
- distance_meters — DECIMAL(14,4)
- rank_no — INT
- source_command_id — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
field_binding_denials
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- participant_id — CHAR(36) — Foreign key → participants.id
- requested_field_id — CHAR(36) — Foreign key → fields.id
- requested_field_unique_id — VARCHAR(255)
- requested_candidate_id — CHAR(36) — Foreign key → field_binding_candidates.id
- source_command_id — VARCHAR(255)
- source_method_code — VARCHAR(100)
- actor_type — VARCHAR(100)
- actor_id — CHAR(36)
- reason_code — VARCHAR(100)
- participant_message_key — VARCHAR(255)
- current_active_binding_count — INT
- max_allowed_binding_count — INT
- created_at — DATETIME
- updated_at — DATETIME
field_binding_exceptions
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- participant_id — CHAR(36) — Foreign key → participants.id
- field_id — CHAR(36) — Foreign key → fields.id
- submitted_unique_id — VARCHAR(255)
- search_point_json — JSON
- lookup_polygon_version_id — CHAR(36) — Foreign key → field_polygon_versions.id
- candidate_field_ids_json — JSON
- candidate_polygon_version_ids_json — JSON
- conflicting_binding_id — CHAR(36) — Foreign key → field_bindings.id
- source_command_id — VARCHAR(255)
- source_method_code — VARCHAR(100)
- exception_status_code — VARCHAR(100)
- reason_code — VARCHAR(100)
- participant_message_key — VARCHAR(255)
- candidate_snapshot_json — JSON
- resolved_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
field_bindings
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- field_id — CHAR(36) — Foreign key → fields.id
- project_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- participant_id — CHAR(36) — Foreign key → participants.id
- binding_method_code — VARCHAR(100)
- binding_status_code — VARCHAR(100)
- binding_version — INT
- location_point_json — JSON
- location_received_at — DATETIME
- source_command_id — VARCHAR(255)
- bound_at — DATETIME
- unbound_at — DATETIME
- superseded_by_binding_id — CHAR(36) — Foreign key → field_bindings.id
- reason_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
field_polygon_links
- id — CHAR(36)
- field_id — CHAR(36) — Foreign key → fields.id
- field_polygon_version_id — CHAR(36) — Foreign key → field_polygon_versions.id
- link_status_code — VARCHAR(100)
- effective_from — DATETIME
- effective_to — DATETIME
- linked_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- reason_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
field_polygon_versions
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- source_system — VARCHAR(100)
- source_external_id — VARCHAR(255)
- version_no — INT
- geometry — GEOMETRY
- bbox_geometry — GEOMETRY
- area_ha — DECIMAL(14,4)
- review_status_code — VARCHAR(100)
- reviewed_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- reviewed_at — DATETIME
- imported_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
field_seasons
- id — CHAR(36)
- project_season_id — CHAR(36) — Foreign key → project_seasons.id
- field_id — CHAR(36) — Foreign key → fields.id
- crop_cycle_no — INT
- season_status_code — VARCHAR(100)
- sowing_date — DATE
- rice_variety_code — VARCHAR(100)
- sowing_method_code — VARCHAR(100)
- first_drainage_start_date — DATE
- first_drainage_end_date — DATE
- second_drainage_start_date — DATE
- second_drainage_end_date — DATE
- harvest_date — DATE
- schedule_version — INT
- created_at — DATETIME
- updated_at — DATETIME
fields
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- unique_id — VARCHAR(255)
- display_name — VARCHAR(255)
- registered_area_ha — DECIMAL(14,4)
- field_geometry — GEOMETRY
- current_polygon_version_id — CHAR(36) — Foreign key → field_polygon_versions.id
- field_status_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
input_resolution_attempts
- id — CHAR(36)
- input_resolution_session_id — CHAR(36) — Foreign key → input_resolution_sessions.id
- input_method_code — VARCHAR(100)
- raw_text — TEXT
- ocr_artifact_id — CHAR(36)
- ocr_text — TEXT
- vision_label — VARCHAR(255)
- ocr_confidence — DECIMAL(8,4)
- locale_code — VARCHAR(20)
- provider_code — VARCHAR(100)
- token_count — INT
- estimated_cost — DECIMAL(14,6)
- latency_ms — INT
- ai_model_run_id — CHAR(36) — Foreign key → ai_model_runs.id
- created_at — DATETIME
- updated_at — DATETIME
input_resolution_candidates
- id — CHAR(36)
- input_resolution_attempt_id — CHAR(36) — Foreign key → input_resolution_attempts.id
- canonical_code — VARCHAR(255)
- canonical_label — VARCHAR(255)
- candidate_rank — INT
- similarity_score — DECIMAL(8,4)
- confidence_score — DECIMAL(8,4)
- match_source_code — VARCHAR(100)
- shown_to_user — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
input_resolution_decisions
- id — CHAR(36)
- input_resolution_session_id — CHAR(36) — Foreign key → input_resolution_sessions.id
- selected_candidate_id — CHAR(36) — Foreign key → input_resolution_candidates.id
- decision_source_code — VARCHAR(100)
- canonical_code — VARCHAR(255)
- manual_value_text — TEXT
- decided_by_type — VARCHAR(100)
- decided_by_id — CHAR(36)
- decided_at — DATETIME
- created_activity_record_id — CHAR(36) — Foreign key → activity_records.id
- created_at — DATETIME
- updated_at — DATETIME
input_resolution_sessions
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- field_season_id — CHAR(36) — Foreign key → field_seasons.id
- seasonal_event_id — CHAR(36) — Foreign key → seasonal_events.id
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- target_type_code — VARCHAR(100)
- target_field_name — VARCHAR(255)
- resolution_status_code — VARCHAR(100)
- started_by_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- source_channel_message_id — CHAR(36) — Foreign key
- opened_at — DATETIME
- resolved_at — DATETIME
- escalated_follow_up_queue_id — CHAR(36)
- escalated_input_resolution_attempt_id — CHAR(36)
- created_at — DATETIME
- updated_at — DATETIME
onboarding_session_events
- id — CHAR(36)
- onboarding_session_id — CHAR(36) — Foreign key → onboarding_sessions.id
- event_type_code — VARCHAR(100)
- from_step_code — VARCHAR(100)
- to_step_code — VARCHAR(100)
- from_status_code — VARCHAR(100)
- to_status_code — VARCHAR(100)
- payload_json — JSON
- channel_message_id — CHAR(36)
- acted_by_type — VARCHAR(100)
- acted_by_id — CHAR(36)
- occurred_at — DATETIME
- recorded_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
onboarding_sessions
- id — CHAR(36)
- channel_code — VARCHAR(100)
- identity_provider_code — VARCHAR(100)
- provider_user_id — VARCHAR(255)
- participant_identity_id — CHAR(36) — Foreign key → participant_identities.id
- participant_id — CHAR(36) — Foreign key → participants.id
- project_invitation_id — CHAR(36) — Foreign key → project_invitations.id
- project_id — CHAR(36) — Foreign key → projects.id
- session_status_code — VARCHAR(100)
- current_step_code — VARCHAR(100)
- preferred_locale_code — VARCHAR(20)
- draft_payload_json — JSON
- last_interaction_at — DATETIME
- expires_at — DATETIME
- submitted_at — DATETIME
- completed_at — DATETIME
- result_participant_id — CHAR(36) — Foreign key → participants.id
- result_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- created_at — DATETIME
- updated_at — DATETIME
ops_config_revisions
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- config_family_code — VARCHAR(100)
- revision — VARCHAR(100)
- checksum — VARCHAR(255)
- status_code — VARCHAR(100)
- owner_name — VARCHAR(255)
- artifact_refs_json — JSON
- recorded_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
organic_amendment_records
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- amendment_kind_code — VARCHAR(100)
- quantity — DECIMAL(14,4)
- quantity_unit — VARCHAR(100)
- quantity_source_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
participant_identities
- id — CHAR(36)
- participant_id — CHAR(36) — Foreign key → participants.id
- identity_provider_code — VARCHAR(100)
- provider_user_id — VARCHAR(255)
- provider_handle — VARCHAR(255)
- linked_contact_id — CHAR(36) — Foreign key → participant_private_contacts.id
- link_provenance — JSON
- is_primary — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
participant_identity_link_reviews
- id — CHAR(36)
- related_onboarding_session_id — CHAR(36) — Foreign key → onboarding_sessions.id
- identity_provider_code — VARCHAR(100)
- provider_user_id — VARCHAR(255)
- linked_contact_normalized — VARCHAR(255)
- review_status_code — VARCHAR(100)
- conflict_reason_code — VARCHAR(100)
- candidate_participant_ids_json — JSON
- resolved_participant_id — CHAR(36) — Foreign key → participants.id
- resolved_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- resolved_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
participant_private_contacts
- id — CHAR(36)
- participant_id — CHAR(36) — Foreign key → participants.id
- contact_type_code — VARCHAR(100)
- normalized_value — VARCHAR(255)
- raw_value — VARCHAR(255)
- is_primary — BOOLEAN
- verified_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
participants
- id — CHAR(36)
- full_name — VARCHAR(255)
- preferred_language — VARCHAR(20)
- participant_status_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
pesticide_records
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- pesticide_kind_code — VARCHAR(100)
- product_name — VARCHAR(255)
- amount — DECIMAL(14,4)
- amount_unit — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
project_enrollments
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- participant_id — CHAR(36) — Foreign key → participants.id
- invitation_id — CHAR(36) — Foreign key → project_invitations.id
- participant_role_code — VARCHAR(100)
- enrollment_status_code — VARCHAR(100)
- enrollment_source_code — VARCHAR(100)
- accepted_at — DATETIME
- activated_at — DATETIME
- activated_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- revoked_at — DATETIME
- revoked_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- rejection_reason_code — VARCHAR(100)
- created_at — DATETIME
- updated_at — DATETIME
project_invitations
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- channel_code — VARCHAR(100)
- invite_code — VARCHAR(100)
- invite_token_hash — VARCHAR(500)
- invite_status_code — VARCHAR(100)
- target_contact_type_code — VARCHAR(100)
- target_contact_normalized — VARCHAR(255)
- target_contact_raw — VARCHAR(255)
- target_participant_role_code — VARCHAR(100)
- invited_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- issued_at — DATETIME
- expires_at — DATETIME
- used_at — DATETIME
- revoked_at — DATETIME
- accepted_participant_id — CHAR(36) — Foreign key → participants.id
- accepted_enrollment_id — CHAR(36) — Foreign key → project_enrollments.id
- used_channel_message_id — CHAR(36)
- created_at — DATETIME
- updated_at — DATETIME
project_seasons
- id — CHAR(36)
- project_id — CHAR(36) — Foreign key → projects.id
- season_code — VARCHAR(100)
- season_year — INT
- season_label — VARCHAR(255)
- season_status_code — VARCHAR(100)
- official_start_date — DATE
- official_end_date — DATE
- agronomic_window_start_date — DATE
- agronomic_window_end_date — DATE
- created_at — DATETIME
- updated_at — DATETIME
projects
- id — CHAR(36)
- code — VARCHAR(100)
- name — VARCHAR(255)
- registry_standard_code — VARCHAR(100)
- registry_project_id — VARCHAR(100)
- registry_project_url — VARCHAR(500)
- country_code — VARCHAR(20)
- region_name — VARCHAR(255)
- project_boundary_geometry — GEOMETRY
- monitoring_program_start_date — DATE
- monitoring_program_end_date — DATE
- project_timezone — VARCHAR(100)
- current_governance_policy_version_id — CHAR(36)
- project_status_code — VARCHAR(100)
- max_active_field_bindings_per_participant — INT
- created_at — DATETIME
- updated_at — DATETIME
review_decisions
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- reviewed_by_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- review_outcome_code — VARCHAR(100)
- reason_code — VARCHAR(100)
- admin_note — TEXT
- decided_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
review_reassignments
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- from_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- to_admin_user_id — CHAR(36) — Foreign key → admin_users.id
- reason_code — VARCHAR(100)
- acted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
seasonal_events
- id — CHAR(36)
- field_season_id — CHAR(36) — Foreign key → field_seasons.id
- event_type_code — VARCHAR(100)
- event_status_code — VARCHAR(100)
- due_at — DATETIME
- window_start_at — DATETIME
- window_end_at — DATETIME
- local_due_date — DATE
- generated_by — VARCHAR(100)
- schedule_version — INT
- created_at — DATETIME
- updated_at — DATETIME
validation_signal_bundles
- id — CHAR(36)
- evidence_submission_id — CHAR(36) — Foreign key → evidence_submissions.id
- ai_model_run_id — CHAR(36) — Foreign key → ai_model_runs.id
- gps_accuracy_m — DECIMAL(14,4)
- polygon_distance_m — DECIMAL(14,4)
- gps_rule_result_code — VARCHAR(100)
- schedule_consistency_result_code — VARCHAR(100)
- exif_present — BOOLEAN
- exif_gps_present — BOOLEAN
- exif_capture_time_present — BOOLEAN
- current_gps_present — BOOLEAN
- vision_result_code — VARCHAR(100)
- vision_confidence_band_code — VARCHAR(100)
- fieldsense_result_code — VARCHAR(100)
- dry_soil_visibility_code — VARCHAR(100)
- duplicate_check_code — VARCHAR(100)
- screenshot_check_code — VARCHAR(100)
- fallback_used — BOOLEAN
- auto_validation_result_code — VARCHAR(100)
- explanation — TEXT
- created_at — DATETIME
- updated_at — DATETIME
yield_records
- id — CHAR(36)
- activity_record_id — CHAR(36) — Foreign key → activity_records.id
- yield_amount — DECIMAL(14,4)
- yield_unit — VARCHAR(100)
- harvest_date — DATE
- created_at — DATETIME
- updated_at — DATETIME