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

<https://knobit.org/id/task/dm-physical-postgres/I9> a edu:Question ;
    rdfs:label "I9 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-626> ;
    schema:identifier "I9" ;
    schema:position 13 ;
    schema:text "Value list fixed in the DDL, both directions, 1 each: (a) ck_account_status lists OPN, DOR and CLS, so the Blocked status the business added (BR-301) is rejected until a release; replaced by a ref_account_status table (code, label, validity) and a foreign key to it; (b) ck_payment_dc stays: D and C are fixed by definition (BR-302). Reporting ck_payment_dc as a defect, or replacing it with a reference table and calling that necessary, scores 0 for (b)."@en .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-626> rdfs:label "dm-physical-postgres I9: account status list fixed in a CHECK, debit/credit check kept"@en .

