container.user_bucket_item

↑ container schema

Cascading Deletes: Deleting rows from this table will cascade to: container.user_bucket, actor.usr.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: user_bucket_item_bucket_fkey, user_bucket_item_target_user_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.user_bucket_item_id_seq'::regclass)

bucket FK

integer

No

→ container.user_bucket(id)

target_user FK

integer

No

→ actor.usr(id)

pos

integer

Yes

create_time

timestamp with time zone

No

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

bucket

container.user_bucket(id)

CASCADE

CASCADE

DEFERRED

user_bucket_item_bucket_fkey

target_user

actor.usr(id)

CASCADE

CASCADE

DEFERRED

user_bucket_item_target_user_fkey

Indexes

Index Method Definition

user_bucket_item_pkey PK

btree

CREATE UNIQUE INDEX user_bucket_item_pkey ON container.user_bucket_item USING btree (id)

user_bucket_item_target_user_idx

btree

CREATE INDEX user_bucket_item_target_user_idx ON container.user_bucket_item USING btree (target_user)

Referenced By

The following tables have foreign keys pointing to container.user_bucket_item (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

container.user_bucket_item_note

item

id

user_bucket_item_note_item_fkey
Previous
Next