patron_block_conditions__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
fee_fine_balance_changed_event.id Implied ConstraintR
fee_fine_balance_changed_event__t.fee_fine_type_id Implied ConstraintR
fee_fine_balance_changed_event__t.id Implied ConstraintR
fee_fine_balance_changed_event__t.loan_id Implied ConstraintR
fee_fine_balance_changed_event__t.user_id Implied ConstraintR
item_aged_to_lost_event.id Implied ConstraintR
item_aged_to_lost_event__t.id Implied ConstraintR
item_aged_to_lost_event__t.user_id Implied ConstraintR
item_checked_in_event.id Implied ConstraintR
item_checked_in_event__t.id Implied ConstraintR
item_checked_out_event.id Implied ConstraintR
item_checked_out_event__t.id Implied ConstraintR
item_checked_out_event__t.user_id Implied ConstraintR
item_claimed_returned_event.id Implied ConstraintR
item_claimed_returned_event__t.id Implied ConstraintR
item_declared_lost_event.id Implied ConstraintR
item_declared_lost_event__t.id Implied ConstraintR
loan_due_date_changed_event.id Implied ConstraintR
loan_due_date_changed_event__t.id Implied ConstraintR
patron_block_conditions.id Implied ConstraintR
patron_block_limits.id Implied ConstraintR
patron_block_limits__t.condition_id patron_block_limits__t_condition_id_fkeyR
patron_block_limits__t.id Implied ConstraintR
synchronization_jobs.id Implied ConstraintR
synchronization_jobs__t.id Implied ConstraintR
user_summary.id Implied ConstraintR
user_summary__t.id Implied ConstraintR
user_summary__t.user_id Implied ConstraintR
value_type varchar 7 √ null
block_renewals bool 1 √ null
block_requests bool 1 √ null
block_borrowing bool 1 √ null
name varchar 40 √ null
message varchar 64 √ null

Indexes

Constraint Name Type Sort Column(s)
patron_block_conditions__t_pkey Primary key Asc id
patron_block_conditions__t___origin_idx Performance Asc __origin
patron_block_conditions__t___source_idx Performance Asc __source
patron_block_conditions__t___start_idx Performance Asc __start
patron_block_conditions__t_block_borrowing_idx Performance Asc block_borrowing
patron_block_conditions__t_block_renewals_idx Performance Asc block_renewals
patron_block_conditions__t_block_requests_idx Performance Asc block_requests
patron_block_conditions__t_id_idx Performance Asc id
patron_block_conditions__t_message_idx Performance Asc message
patron_block_conditions__t_name_idx Performance Asc name
patron_block_conditions__t_value_type_idx Performance Asc value_type

Relationships

Close relationships within degrees of separation