Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
archive_file_checksum_id | serial | 10 | √ | nextval('archive_file_checksum_archive_file_checksum_id_seq'::regclass) |
|
|
||||
submission_id | int4 | 10 | null |
|
|
|||||
archive_file_name | varchar | 256 | null |
|
|
|||||
archive_file_size | int8 | 19 | null |
|
|
The size of the file in bytes |
||||
checksum | varchar | 40 | null |
|
|
The checksum is SHA1 encrypted. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
archive_file_checksum_pkey | Primary key | Asc | archive_file_checksum_id |
archive_file_checksum_uc | Must be unique | Asc/Asc | archive_file_name + archive_file_size |