Reflection-Modell, sql-db-migrations

Reflektiert SQL-Schema, Migrationen und Repository-Queries gegen Integritaets-, Sicherheits- und GUI-Performance-Regeln.

table

• name
• owner_context
• primary_key
• tenant_column
• created_at
• updated_at
• deleted_at_policy

column

• table
• name
• type
• nullable
• default
• check_constraint
• sensitive_data

constraint

• name
• table
• type
• columns
• deferrable
• business_rule

index

• name
• table
• columns
• method
• partial_condition
• supports_query
• write_cost_reviewed

query

• repository_method
• sql_shape
• parameters_bound
• tenant_scope
• default_order
• limit_offset_or_cursor
• explain_reviewed

migration

• version
• description
• transactional
• reversible
• lock_risk
• backfill_strategy
• rollback_plan
• backup_required
• target_schema_preflight
• target_environment
• drift_resolution

target_schema_preflight

• target_environment
• expected_schemas
• expected_tables
• expected_columns
• expected_triggers
• expected_functions
• expected_migration_versions
• actual_objects_checked
• drift_detected
• drift_resolution

seed_or_fixture

• purpose
• deterministic
• contains_personal_data
• cleanup_strategy

mutable_table

• schema
• name
• owner_context
• primary_key
• table_kind
• write_paths
• history_required
• history_exclusion_reason
• existing_audit_sufficiency
• contains_personal_data
• restore_required

history_decision

• audit_question
• auditor_role
• affected_tables
• existing_audit_sources
• existing_audit_sufficiency
• selected_history_scope
• row_count_estimate
• risk_level
• complexity_justification

history_table

• source_table
• name
• entity_key
• revision
• operation
• changed_at
• old_data
• new_data
• changed_fields
• retention_policy
• pii_strategy

history_trigger

• source_table
• history_table
• trigger_name
• trigger_events
• captures_insert
• captures_update
• captures_delete
• ignored_columns
• ignores_timestamp_only_updates
• existing_trigger_interactions
• revision_strategy
• baseline_backfill
• dynamic_schema_coverage

restore_contract

• source_table
• history_table
• restore_allowed
• restore_mapper
• authorization_policy
• conflict_policy
• gui_route
• no_modal_flow

history_gui

• source_table
• list_route
• detail_route
• compare_available
• restore_review_route
• live_search_filter
• keyboard_accessible
• css_component
• js_adapter

Zurück zum Bereich