I9 (2 points)
https://knobit.org/id/task/dm-physical-postgres/I9
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| rdfs:label | I9 (2 points) en |
| schema:hasPart | dm-physical-postgres I9: account status list fixed in a CHECK, debit/credit check kept |
| schema:identifier | I9 |
| schema:position | 13 |
| schema:text | Value list fixed in the DDL, both directions, 1 each: (a) ck_account_status lists OPN, DOR and CLS, so the Blocked status the business added (BR-301) is rejected until a release; replaced by a ref_account_status table (code, label, validity) and a foreign key to it; (b) ck_payment_dc stays: D and C are fixed by definition (BR-302). Reporting ck_payment_dc as a defect, or replacing it with a reference table and calling that necessary, scores 0 for (b). en |