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