bitstream

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bitstream_id int4 10 √ null
bitstream_format_id int4 10 √ null
bitstreamformatregistry.bitstream_format_id bitstream_bitstream_format_id_fkey R
size_bytes int8 19 √ null
checksum varchar 64 √ null
checksum_algorithm varchar 32 √ null
internal_id varchar 256 √ null
deleted bool 1 √ null
store_number int4 10 √ null
sequence_id int4 10 √ null
uuid uuid 2147483647 gen_random_uuid()
bundle.primary_bitstream_id bundle_primary_bitstream_id_fkey R
bundle2bitstream.bitstream_id bundle2bitstream_bitstream_id_fkey R
checksum_history.bitstream_id checksum_history_bitstream_id_fkey R
community.logo_bitstream_id community_logo_bitstream_id_fkey R
most_recent_checksum.bitstream_id most_recent_checksum_bitstream_id_fkey R
requestitem.bitstream_id requestitem_bitstream_id_fkey R
dspaceobject.uuid bitstream_uuid_fkey R

Indexes

Constraint Name Type Sort Column(s)
bitstream_pkey Primary key Asc uuid
bit_bitstream_fk_idx Performance Asc bitstream_format_id
bitstream_id_idx Performance Asc bitstream_id
bitstream_id_unique Must be unique Asc uuid
bitstream_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation