C3 (2 points)
https://knobit.org/id/task/ddl-review/C3
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/C3 |
| rdfs:label | C3 (2 points) en |
| schema:hasPart | ddl-review C3a: binary floating point for money |
| schema:hasPart | ddl-review C3b: one scale for every currency |
| schema:identifier | C3 |
| schema:position | 3 |
| schema:text | Money, 1 each: (a) requested_amount is DOUBLE PRECISION on both targets, which cannot hold money exactly, so totals stop reconciling and move with row order - changed to a decimal with a scale; (b) settled_amount is DECIMAL(14,2) on a table whose currency column ranges over ISO 4217, whose minor units are not all 2 - the scale is widened, or the single-currency scope is stated, and either way the point is that 2 was not a decision. en |
Used by
| has question | Generated DDL review, Postgres and Snowflake (DDL review skills) |
|---|---|
| schema:isPartOf | ddl-review C3a: binary floating point for money |
| schema:isPartOf | ddl-review C3b: one scale for every currency |