@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/C2> a edu:Question ;
    rdfs:label "C2 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-615> ;
    schema:identifier "C2" ;
    schema:position 2 ;
    schema:text "Soft delete the constraints do not understand, 1 each: (a) uk_person_customer_pic (and uk_org_registry_code) count soft-deleted rows, so a person whose record was deleted cannot be registered again (BR-303); replaced by uniqueness over active rows only, a partial unique index WHERE NOT is_deleted, which PostgreSQL has, or by moving deleted rows to a history table. Dropping uniqueness altogether scores 0; (b) something stops active rows referencing a deleted customer (BR-303): a rule enforced by the delete procedure or a trigger, a DQ rule on account_holder, or views exposing only active customers that the application uses, stated as such."@en .

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

<https://knobit.org/id/register/data-modelling#I-615> rdfs:label "dm-physical-postgres C2: soft-deleted customers and the constraints"@en .