Generate and review DDL

https://knobit.org/id/activity/LO-8

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/activity/data-modelling/08-ddl
rdfs:comment	Stage 5 (DDL) of the data-modelling skill: produces 05-ddl/<dialect>/*.sql and passes the stage's validation gate. en
rdfs:label	DDL-i genereerimine ja ülevaatus et
rdfs:label	Generate and review DDL en
requires knobit	Recognises a constraint claimed by a rule and missing from the schema
requires knobit	Recognises a declared constraint the target platform does not enforce
requires knobit	Explains rule enforcement mechanisms and platform enforcement
requires knobit	Recognises binary floating point used for an exact quantity
requires knobit	Routes a defect to the deliverable responsible for it
requires knobit	Recognises generated SQL edited by hand
requires knobit	Recognises DDL older than its model
requires knobit	Recognises an object in the SQL missing from the model
requires knobit	Recognises generator warnings carried without a decision
requires knobit	Recognises a configured dialect left unregenerated
requires knobit	Recognises a CHECK constraint parsed and ignored
requires knobit	Recognises an expression running on one engine only
requires knobit	Recognises a truncated identifier taken as the real name
requires knobit	Recognises a reserved word used as an identifier
requires knobit	Recognises a type meaning something else on another engine
requires knobit	Recognises an index the target engine cannot create or run
requires knobit	Recognises a foreign-key cycle taken as resolved
requires knobit	Recognises one decimal scale for every currency
requires knobit	Recognises a length taken from sample data
requires knobit	Recognises a collation changing what a key means
requires knobit	Recognises a default inventing a business fact
requires knobit	Recognises a restricted column without access design
requires knobit	Recognises greenfield DDL aimed at a populated database
requires knobit	Recognises a drop script used as a rollback
requires knobit	Recognises an environment baked into the script
requires knobit	Recognises SQL reviewed without being run
requires knobit	Recognises undetected drift between database and model
requires knobit	Recognises a time zone dropped from a timestamp
requires knobit	Recognises a business date stored with a time of day
requires knobit	Explains generated artefacts and their single source of truth
requires knobit	Explains SQL dialect differences
requires knobit	Explains currency minor units
requires knobit	Explains time zones in timestamps and business dates
requires knobit	Explains collation and case or accent sensitivity
requires knobit	Explains access design for classified data
requires knobit	Explains schema migration and rollback
requires knobit	Explains environment-independent deployment
requires knobit	Explains testing DDL by execution and detecting drift
schema:position	5

Used by

consists of	Data modelling