meta:
  schema: gate-d-dry-run.v1
  prepared_at: "2026-07-26"
  status: executed-pass
  execution_authorized: true
  approval_comment: https://github.com/hector-sanchez-eu/conductor/issues/3#issuecomment-5085009294
  execution_evidence: gate-d-notion-canary-result.json
  source_registry: source-registry.yml
  review_groups: review-groups.yml

source_boundary:
  gate_c_status: complete
  github_repositories: 103
  github_container_repositories: 1
  ordinary_github_candidate_units: 102
  incubator_project_candidate_units: 29
  candidate_project_units_before_review: 131
  archived_github_candidates: 52
  deployed_hosts: enrichment-only-not-enumerated
  notion_existing_assets: none-created-before-gate-d

proposed_database_creates:
  - Conductor Initiatives
  - Conductor Workstreams
  - Conductor Products
  - Conductor Assets
  - Conductor Decisions/Events
  - Conductor Asset Repositories
  - Conductor Asset Environments
  - Conductor Asset Evidence
  - Conductor Asset Relationships

proposed_initial_rows:
  assets:
    count: 131
    review_status: candidate
    rule: names and descriptions remain extraction candidates until human promotion
  asset_repositories:
    count: 131
    rule: one approved GitHub repository or incubator subpath URL per candidate unit
  asset_evidence:
    minimum_count: 131
    evidence_class: provenance
    noted_by: role.portfolio-manager
  asset_environments:
    count: 0
    rule: do not fabricate deployments; add only after verified URL evidence
  asset_relationships:
    count: 0
    rule: review-groups are candidate review queues, not authoritative edges
  decisions_events:
    count: 0
    rule: create import/promotion events only in an approved execution batch with a related Initiative

golden_path:
  recommended_anchor: github:hector-sanchez-eu/germany-real-estate-intelligence
  comparison_group: review.real-estate-golden-path
  status: imported-as-candidate-canary

idempotency:
  batch_key: m1-estate-baseline-2026-07-26
  asset_key: candidate_key
  repository_key: [asset_id, url]
  evidence_key: [asset_id, evidence_class, kind, ref_url]
  rule: rerun must update the same rows or make no change; never create a second row for the same key

privacy:
  default_for_approved_private_sources: internal
  public_repositories: public
  client_private: excluded
  secret_adjacent: excluded
  quarantined_files_imported: false
  candidate_body_text_authoritative: false

rollback_rehearsal:
  status: local-pass-notion-canary-pass
  evidence: gate-d-rollback-rehearsal.yml
  method:
    - create the nine databases empty
    - validate all properties before importing rows
    - import one canary candidate batch
    - verify readback, privacy, relations, and idempotent rerun
    - archive the canary rows and empty databases if verification fails
    - expand to the full candidate batch only after the canary passes
  evidence_required:
    - exact created database IDs
    - canary batch row IDs
    - second-run no-duplicate result
    - archive/delete recovery result
    - partial-failure report

execution_result:
  databases_created: 9
  database_schemas_valid: 9
  candidate_units_processed: 131
  assets: 131
  asset_repositories: 131
  asset_evidence: 131
  duplicate_deterministic_ids: 0
  asset_environments: 0
  asset_relationships: 0
  canary_idempotent_rerun: pass
  config_locators_bound_in_bitwarden: 9
  remaining_review_work:
    - promote candidate facts only after human review
    - resolve review.real-estate-golden-path member dispositions
    - resolve review.fiser-nextjs canonical record and relationship
