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 SchemaSpy |
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016 |
| ||||||
|
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 |