Location

Detailed View

agency_property_location_group

Each row of agency_property_location_group identifies an agency and its associated port number.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
agency_property_code_num	int	false	Agency property code.
location_group_port_number	int	false	Port number associated with the agency's location group.

branch

Each row of branch identifies a branch code.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
address	varchar	false	Branch address.
email_source	varchar	false	The "From" address in the header of an emailed overdue notice.
email_reply_to	varchar	false	The "Reply To" address in the header of an emailed overdue notice.
address_latitude	varchar	false	Latitude of the branch address.
address_longitude	varchar	false	Longitude of the branch address.
code_num	int	false	Branch code.

branch_change

Each row of branch_change tracks a change made to the branches table.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
branch_code_num	int	false	An integer value from 1-400, corresponding to the row number of the address in the Branch Addresses table; known as the Circulation Address Number.
description	varchar	false	Description of the change made.

branch_myuser

Each row of branch_myuser identifies a branch, with the name presented in the language associated with the user's login account. Each library maintains its own branch codes and names.

Column	Data Type	Not NULL?	Comment
code	int	false	Branch code.
address	varchar	false	Branch address.
email_source	varchar	false	The "From" address in the header of an emailed overdue notice.
email_reply_to	varchar	false	The "Reply To" address in the header of an emailed overdue notice.
address_latitude	varchar	false	Latitude of the branch address.
address_longitude	varchar	false	Longitude of the branch address.
name	varchar	false	Branch name.

branch_name

Each row of branch_name identifies a branch name.

Column	Data Type	Not NULL?	Comment
branch_id	int	false	Foreign key to branch.
name	varchar	false	Branch name.
iii_language_id	int	false	Foreign key to iii_language.

location

Each row of location identifies a location code.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
code	varchar	false	Location code.
branch_code_num	int	false	An integer value from 1-400, corresponding to the row number of the address in the Branch Addresses table; known as the Circulation Address Number.
parent_location_code	varchar	false	Location code of the parent location.
is_public	boolean	false	Specifies whether the code appears in patron interfaces.
is_requestable	boolean	false	Specifies whether the location code represents a requestable pickup location.

location_change

Each row of location_change describes a change to a location code or name.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
location_code	varchar	false	Foreign key to location.
description	varchar	false	Description of the change.

location_myuser

Each row of location_myuser identifies a location, with the name presented in the language associated with the user's login account. Each library maintains its own location codes and names.

Column	Data Type	Not NULL?	Comment
code	varchar	false	Location code.
branch_code_num	int	false	An integer value from 1-400, corresponding to the row number of the address in the Branch Addresses table; known as the Circulation Address Number.
parent_location_code	varchar	false	Location code of the parent location.
is_public	boolean	false	Specifies whether the code appears in patron interfaces.
name	varchar	false	Location name.

location_name

Each row of location_name identifies a location name.

Column	Data Type	Not NULL?	Comment
location_id	int	false	Foreign key to location.
name	varchar	false	Location name.
iii_language_id	int	false	Foreign key to iii_language.

location_property_type

Each row of location_property_type identifies a location type code.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
code	varchar	false	Location type code.
display_order	int	false	Integer to manage the display order of a list.
default_value	varchar	false	The default location type value.
is_single_value	boolean	false	Indicates whether the location type is a single value.
is_enabled	boolean	false	Indicates whether location type values are enabled.

location_property_type_myuser

Each row of location_property_type_myuser identifies a location type, with the name presented in the language associated with the user's login account. Each library maintains its own location type names.

Column	Data Type	Not NULL?	Comment
code	varchar	false	Location type code.
display_order	int	false	Integer to manage the display order of a list.
default_value	varchar	false	The default location type value.
is_single_value	boolean	false	Indicates whether the location type is a single value.
is_enabled	boolean	false	Indicates whether location type values are enabled.
name	varchar	false	Location type name.

location_property_type_name

Each row of location_property_type_name identifies a location type name.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
location_property_type_id	int	false	Foreign key to location_property_type.
iii_language_id	int	false	Foreign key to iii_language.
name	varchar	false	Location type name.

location_property_value

Each row of location_property_value describes a location.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
location_property_type_id	int	false	Foreign key to location_property_type
location_id	int	false	Foreign key to location.
value	varchar	false	Location value.