Database e Schema

Outcome: Complete the task with Database e Schema (Database & Schema). User context: Una tabella degli ordini si collega ai clienti e limita i valori consentiti per valuta, importo e stato. Technical concept or control: Database e Schema (Database & Schema). Why it fits: Usa uno schema per mantenere i fatti veri e spiegare cosa significano i dati. Do not use it when: Non mettere mai ogni tipo di dato in un unico campo JSON senza controlli. 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): Nessun singolo standard ufficiale controlla l'intero termine. Il suo significato può cambiare tra team, piattaforme o framework. 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.