Table sola.document.document
Extension to the LADM used by SOLA to store electronic copies of documentation provided in support of land related dealings.
Tags: FLOSS SOLA Extension, Change History

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40 Identifier for the document.
nr varchar 15 Unique number to identify the document. Determined by the Digital Archive EJB when saving the document record.
extension varchar 5 The file extension of the electronic file. E.g. pdf, tiff, doc, etc
mime_type varchar 255  √  null Mime type of the file.
body bytea 2147483647 The content of the electronic file.
description varchar 100  √  null A descriptive name to help recognizs the file such as the original file name.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the document_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc document_pkey
rowidentifier Performance Asc document_index_on_rowidentifier
nr Must be unique Asc document_nr_unique