Table sola.opentenure.attachment_chunk
Holds temporary pieces of attachment uploaded on the server. In case of large files, document can be split into smaller pieces (chunks) allowing reliable upload. After all pieces uploaded, client will instruct server to create a document and remove temporary files stored in this table.

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40 uuid_generate_v1() Unique ID of the chunk
attachment_id varchar 40 Attachment ID, which will be used to create final document object. Used to group all chunks together.
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.
start_position int8 19 Staring position of the byte in the source/destination document
size int8 19 Size of the chunk in bytes.
body bytea 2147483647 The content of the chunk.
md5 varchar 50  √  null Checksum of the chunk, calculated using MD5.
creation_time timestamp 29,6 now() Date and time when chuck was created.
user_name varchar 50 User's id (name), who has loaded the chunk

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc id_pkey_document_chunk
attachment_id + start_position Must be unique Asc/Asc start_unique_document_chunk