archive_file_checksum

468 rows


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
submissions.submission_id archive_file_checksum_submission_id_fkeyR
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

Relationships