user_bucket

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('container.user_bucket_id_seq'::regclass)
batch_hold_event.bucket batch_hold_event_bucket_fkey C
user_bucket_item.bucket user_bucket_item_bucket_fkey C
user_bucket_note.bucket user_bucket_note_bucket_fkey C
owner int4 10 null
usr.id user_bucket_owner_fkey C
name text 2147483647 null
btype text 2147483647 'misc'::text
user_bucket_type.code user_bucket_btype_fkey R
description text 2147483647 √ null
pub bool 1 false
owning_lib int4 10 √ null
org_unit.id user_bucket_owning_lib_fkey C
create_time timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
user_bucket_pkey Primary key Asc id
ub_name_once_per_owner Must be unique Asc/Asc/Asc owner + name + btype

Relationships

Close relationships within degrees of separation