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 | 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 | extension | varchar | 5 | The file extension of the electronic file. E.g. pdf, tiff, doc, etc | |||
document | rowversion | int4 | 10 | 0 | Sequential value indicating the number of times this row has been modified. | ||
document | nr | varchar | 15 | Unique number to identify the document. Determined by the Digital Archive EJB when saving the document record. | |||
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 | change_time | timestamp | 29,6 | now() | The date and time the row was last modified. | ||
document_chunk | creation_time | timestamp | 29,6 | now() | Date and time when chuck was created. | ||
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 | document_id | varchar | 40 | Document ID, which will be used to create final document object. Used to group all chunks together. | |||
document | id | varchar | 40 | Identifier for the document. | |||
document_chunk | id | varchar | 40 | uuid_generate_v1() | Unique ID of the chunk | ||
document | rowidentifier | varchar | 40 | uuid_generate_v1() | Identifies the all change records for the row in the document_historic table | ||
document | change_user | varchar | 50 | √ | null | The user id of the last person to modify the row. | |
document_chunk | md5 | varchar | 50 | √ | null | Checksum of the chunk, calculated using MD5. | |
document_chunk | user_name | varchar | 50 | User's id (name), who has loaded the chunk | |||
document | description | varchar | 100 | √ | null | A descriptive name to help recognizs the file such as the original file name. | |
document | mime_type | varchar | 255 | √ | null | Mime type of the file. | |
document | body | bytea | 2147483647 | The content of the electronic file. | |||
document_chunk | body | bytea | 2147483647 | The content of the chunk. |