I6 (1 points)

https://knobit.org/id/task/dm-physical-postgres/I6

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I6
rdfs:label	I6 (1 points) en
schema:hasPart	dm-physical-postgres I6: loan document held on a file share by path
schema:identifier	I6
schema:position	10
schema:text	Content held outside the database by reference: loan_document.file_path is a UNC path to the signed agreement on a file share. Deleting the row leaves the file, moving the share breaks every path, and BR-312 needs the document for 10 years. Replaced by the content in the database (BYTEA) or by an object-store key whose lifecycle is tied to the row through one document service, with a DQ rule that every key resolves and a statement of which store is the system of record. Keeping the UNC path with a comment scores 0. en

Used by

has question	Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills)
schema:isPartOf	dm-physical-postgres I6: loan document held on a file share by path