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_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 | description | varchar | 100 | √ | null | A descriptive name to help recognizs the file such as the original file name. | |
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 | 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_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 | 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 | 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 |