binfiles

Module: dev

Binary file storage with hash-based deduplication.

Name	Type	Nullable	Default Value	Notes
ID	integer			Bin file ID
size	integer			Size in bytes
hash	bytea			MD5 hash of the content in hexadecimal notation prefixed with '\x'

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
i_binfiles_hash					hash	hash
pk_binfiles					btree	ID, +size

Name	Type
dc_binfiles_hash	check
dc_binfiles_size	check
pk_binfiles	primary_key

Name	Type	Events	Function	Definition
tu_binfiles	before	update	ft_integrity

Loading...