@prefix activity: <https://knobit.org/id/activity/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

activity:LO-8 a edu:Activity ;
    rdfs:label "Generate and review DDL"@en,
        "DDL-i genereerimine ja ülevaatus"@et ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    rdfs:comment "Stage 5 (DDL) of the data-modelling skill: produces 05-ddl/<dialect>/*.sql and passes the stage's validation gate."@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/activity/data-modelling/08-ddl> ;
    edu:requiresKnobit knobit:K-310,
        knobit:K-313,
        knobit:K-356,
        knobit:K-618,
        knobit:K-641,
        knobit:K-801,
        knobit:K-802,
        knobit:K-803,
        knobit:K-804,
        knobit:K-806,
        knobit:K-808,
        knobit:K-809,
        knobit:K-810,
        knobit:K-811,
        knobit:K-812,
        knobit:K-813,
        knobit:K-814,
        knobit:K-816,
        knobit:K-817,
        knobit:K-819,
        knobit:K-820,
        knobit:K-821,
        knobit:K-822,
        knobit:K-823,
        knobit:K-824,
        knobit:K-825,
        knobit:K-826,
        knobit:K-827,
        knobit:K-828,
        knobit:K-851,
        knobit:K-852,
        knobit:K-853,
        knobit:K-854,
        knobit:K-855,
        knobit:K-856,
        knobit:K-857,
        knobit:K-858,
        knobit:K-859 ;
    schema:position 5 .

edu:Activity rdfs:label "Activity"@en,
        "Tegevusnäitaja"@et .

knobit:K-310 rdfs:label "Recognises a constraint claimed by a rule and missing from the schema"@en .

knobit:K-313 rdfs:label "Recognises a declared constraint the target platform does not enforce"@en .

knobit:K-356 rdfs:label "Explains rule enforcement mechanisms and platform enforcement"@en .

knobit:K-618 rdfs:label "Recognises binary floating point used for an exact quantity"@en .

knobit:K-641 rdfs:label "Routes a defect to the deliverable responsible for it"@en .

knobit:K-801 rdfs:label "Recognises generated SQL edited by hand"@en .

knobit:K-802 rdfs:label "Recognises DDL older than its model"@en .

knobit:K-803 rdfs:label "Recognises an object in the SQL missing from the model"@en .

knobit:K-804 rdfs:label "Recognises generator warnings carried without a decision"@en .

knobit:K-806 rdfs:label "Recognises a configured dialect left unregenerated"@en .

knobit:K-808 rdfs:label "Recognises a CHECK constraint parsed and ignored"@en .

knobit:K-809 rdfs:label "Recognises an expression running on one engine only"@en .

knobit:K-810 rdfs:label "Recognises a truncated identifier taken as the real name"@en .

knobit:K-811 rdfs:label "Recognises a reserved word used as an identifier"@en .

knobit:K-812 rdfs:label "Recognises a type meaning something else on another engine"@en .

knobit:K-813 rdfs:label "Recognises an index the target engine cannot create or run"@en .

knobit:K-814 rdfs:label "Recognises a foreign-key cycle taken as resolved"@en .

knobit:K-816 rdfs:label "Recognises one decimal scale for every currency"@en .

knobit:K-817 rdfs:label "Recognises a length taken from sample data"@en .

knobit:K-819 rdfs:label "Recognises a collation changing what a key means"@en .

knobit:K-820 rdfs:label "Recognises a default inventing a business fact"@en .

knobit:K-821 rdfs:label "Recognises a restricted column without access design"@en .

knobit:K-822 rdfs:label "Recognises greenfield DDL aimed at a populated database"@en .

knobit:K-823 rdfs:label "Recognises a drop script used as a rollback"@en .

knobit:K-824 rdfs:label "Recognises an environment baked into the script"@en .

knobit:K-825 rdfs:label "Recognises SQL reviewed without being run"@en .

knobit:K-826 rdfs:label "Recognises undetected drift between database and model"@en .

knobit:K-827 rdfs:label "Recognises a time zone dropped from a timestamp"@en,
        "Recognises an event timestamp stored without a time zone"@en .

knobit:K-828 rdfs:label "Recognises a business date stored with a time of day"@en .

knobit:K-851 rdfs:label "Explains generated artefacts and their single source of truth"@en .

knobit:K-852 rdfs:label "Explains SQL dialect differences"@en .

knobit:K-853 rdfs:label "Explains currency minor units"@en .

knobit:K-854 rdfs:label "Explains time zones in timestamps and business dates"@en .

knobit:K-855 rdfs:label "Explains collation and case or accent sensitivity"@en .

knobit:K-856 rdfs:label "Explains access design for classified data"@en .

knobit:K-857 rdfs:label "Explains schema migration and rollback"@en .

knobit:K-858 rdfs:label "Explains environment-independent deployment"@en .

knobit:K-859 rdfs:label "Explains testing DDL by execution and detecting drift"@en .