Datenbank & Schema

Outcome: Complete the task with Datenbank & Schema (Database & Schema). User context: Eine Bestelltabelle verlinkt auf Kunden und begrenzt Währung, Betrag und Status. Technical concept or control: Datenbank & Schema (Database & Schema). Why it fits: Verwenden Sie ein Schema, um Fakten wahr zu halten und zu erklären, was die Daten bedeuten. Do not use it when: Legen Sie niemals jede Art von Daten in ein JSON-Feld ohne Prüfungen. Engineering requirements: Define inputs, outputs, contracts, and rules that must always hold. Set authorization and input checks. Define failures, timeouts, retries, one-time effects, data moves, and compatibility limits. Operations: Add useful signals and logs that hide sensitive data. Set capacity limits and write an operator guide. Test recovery and rollback. Acceptance criteria: Contract and failure-path tests pass. Data and authorization rules still hold during retries and partial failures. Check performance limits, monitoring, recovery, and rollback. Evidence and limits (evidence boundary): Kein einziger offizieller Standard kontrolliert den gesamten Begriff. Seine Bedeutung kann sich zwischen Teams, Plattformen oder Frameworks ändern. Unknowns to confirm: Where the code runs, data stores, traffic shape, consistency needs, and the security boundary. Also confirm the compatibility period, service goals, and rollback limits.