C1 (2 points)
https://knobit.org/id/task/dm-physical-postgres/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/C1 |
| rdfs:label | C1 (2 points) en |
| schema:hasPart | dm-physical-postgres C1: destructive referential actions changed, schedule-line cascade kept |
| 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 |