location__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
check_in__t.item_location_id check_in__t_item_location_id_fkeyR
loan__t.item_effective_location_id_at_check_out loan__t_item_effective_location_id_at_check_out_fkeyR
holdings_record__t.effective_location_id holdings_record__t_effective_location_id_fkeyR
holdings_record__t.permanent_location_id holdings_record__t_permanent_location_id_fkeyR
holdings_record__t.temporary_location_id holdings_record__t_temporary_location_id_fkeyR
item__t.effective_location_id item__t_effective_location_id_fkeyR
item__t.permanent_location_id item__t_permanent_location_id_fkeyR
item__t.temporary_location_id item__t_temporary_location_id_fkeyR
pieces__t.location_id pieces__t_location_id_fkeyR
accession_queue.permanent_location_id accession_queue_permanent_location_id_fkeyR
discovery_display_name varchar 84 √ null
code varchar 17 √ null
library_id uuid 2147483647 √ null
loclibrary__t.id location__t_library_id_fkeyR
primary_service_point uuid 2147483647 √ null
service_point__t.id location__t_primary_service_point_fkeyR
description varchar 79 √ null
institution_id uuid 2147483647 √ null
locinstitution__t.id location__t_institution_id_fkeyR
name varchar 79 √ null
campus_id uuid 2147483647 √ null
loccampus__t.id location__t_campus_id_fkeyR
is_active bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
location__t_pkey Primary key Asc id
location__t___origin_idx Performance Asc __origin
location__t___source_idx Performance Asc __source
location__t___start_idx Performance Asc __start
location__t_campus_id_idx Performance Asc campus_id
location__t_code_idx Performance Asc code
location__t_description_idx Performance Asc description
location__t_discovery_display_name_idx Performance Asc discovery_display_name
location__t_id_idx Performance Asc id
location__t_institution_id_idx Performance Asc institution_id
location__t_is_active_idx Performance Asc is_active
location__t_library_id_idx Performance Asc library_id
location__t_name_idx Performance Asc name
location__t_primary_service_point_idx Performance Asc primary_service_point

Relationships

Close relationships within degrees of separation