binfiles

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
ID	integer	plain			Bin file ID
size	integer	plain			Size in bytes
hash	bytea	extended			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...