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_chunk | body | bytea | 2147483647 | The content of the chunk. | |||
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_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 | description | varchar | 100 | √ | null | A descriptive name to help recognizs the file such as the original file name. | |
document_chunk | document_id | varchar | 40 | Document ID, which will be used to create final document object. Used to group all chunks together. | |||
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_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 | 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 | 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 |