I4 (2 points)
https://knobit.org/id/task/ddl-review/I4
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/ddl-review/I4 |
| rdfs:label | I4 (2 points) en |
| schema:hasPart | ddl-review I4a: DEFAULT 0 on a settled amount |
| schema:hasPart | ddl-review I4b: restricted column without access design |
| schema:identifier | I4 |
| schema:position | 7 |
| schema:text | 1 each: (a) settled_amount DEFAULT 0 turns an unsettled payment into a settled zero, which then sums into a total that reconciles - removed, with the unsettled case left null; (b) applicant_personal_id_code is classified restricted in the model and created as a plain column, so the answer names the access design it still needs and does not expect the generator to produce it. en |
Used by
| has question | Generated DDL review, Postgres and Snowflake (DDL review skills) |
|---|---|
| schema:isPartOf | ddl-review I4a: DEFAULT 0 on a settled amount |
| schema:isPartOf | ddl-review I4b: restricted column without access design |