SchemaSpy Analysis of sola.document - ColumnsExtension to the LADM used by SOLA to store electronic copies of documentation provided in support of land related dealings. Allows SOLA to support integration with external Document Management Systems (DMS) if required. Generated by
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016
Primary key columns
Columns with indexes

sola.document contains 20 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
document body bytea 2147483647 The content of the electronic file.
document 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).
document change_time timestamp 29,6 now() The date and time the row was last modified.
document change_user varchar 50  √  null The user id of the last person to modify the row.
document description varchar 100  √  null A descriptive name to help recognizs the file such as the original file name.
document extension varchar 5 The file extension of the electronic file. E.g. pdf, tiff, doc, etc
document id varchar 40 Identifier for the document.
document mime_type varchar 255  √  null Mime type of the file.
document nr varchar 15 Unique number to identify the document. Determined by the Digital Archive EJB when saving the document record.
document rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the document_historic table
document rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
document_chunk body bytea 2147483647 The content of the chunk.
document_chunk claim_id varchar 40  √  null Claim ID. Used to clean the table when saving claim. It will guarantee that no orphan chunks left in the table.
document_chunk creation_time timestamp 29,6 now() Date and time when chuck was created.
document_chunk document_id varchar 40 Document ID, which will be used to create final document object. Used to group all chunks together.
document_chunk id varchar 40 uuid_generate_v1() Unique ID of the chunk
document_chunk md5 varchar 50  √  null Checksum of the chunk, calculated using MD5.
document_chunk size int8 19 Size of the chunk in bytes.
document_chunk start_position int8 19 Staring position of the byte in the source/destination document
document_chunk user_name varchar 50 User's id (name), who has loaded the chunk