@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@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#> .

<https://knobit.org/id/task/dm-physical-postgres/C1> a edu:Question ;
    rdfs:label "C1 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/C1> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-614> ;
    schema:identifier "C1" ;
    schema:position 1 ;
    schema:text "Referential actions, both directions, 1 each: (a) the two destructive actions are changed: fk_payment_account ON DELETE CASCADE lets the account purge delete payments BR-306 keeps for 10 years, and fk_payment_approved_by ON DELETE SET NULL erases who approved a payment when a user leaves; both become restrict (or no action), with approved_by_user_id made not null and bank users deactivated rather than deleted. One of the two alone earns 0.5; (b) fk_schedule_line_schedule ON DELETE CASCADE is left as it is, because a schedule line cannot exist without its schedule and schedules are replaced whole (BR-307). Changing it to restrict, or reporting it as a defect, scores 0 for (b)."@en .

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

<https://knobit.org/id/register/data-modelling#I-614> rdfs:label "dm-physical-postgres C1: destructive referential actions changed, schedule-line cascade kept"@en .