I3 (2 points)
https://knobit.org/id/task/ddl-review/I3
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/I3 |
| rdfs:label | I3 (2 points) en |
| schema:hasPart | ddl-review I3a: IBAN length from the sample |
| schema:hasPart | ddl-review I3b: value date as a timestamp |
| schema:identifier | I3 |
| schema:position | 6 |
| schema:text | Domains, 1 each: (a) payout_iban is VARCHAR(20), which fits an Estonian IBAN and truncates or rejects a 34-character one - widened, or the Estonia-only scope stated in the model; (b) value_date is a TIMESTAMP although a value date is a date, so equality against a date fails and a time component nobody means creeps in. en |
Used by
| has question | Generated DDL review, Postgres and Snowflake (DDL review skills) |
|---|---|
| schema:isPartOf | ddl-review I3a: IBAN length from the sample |
| schema:isPartOf | ddl-review I3b: value date as a timestamp |