Properties

agency_property

Each row of agency_property identifies an agency code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code_num

int

false

Agency property code.

display_order

int

false

Integer to manage the display order of a list.

agency_property_myuser

Each row of agency_property_myuser identifies an agency, with the name presented in the language associated with the user's login account. Each library determines its own agency names for libraries or other library-defined entities.

Column

Data Type

Not NULL?

Comment

code

int

false

Agency code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Agency name.

agency_property_name

Each row of agency_property_name identifies an agency name.

Column

Data Type

Not NULL?

Comment

agency_property_id

int

false

Foreign key to agency_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Agency name.

country_property

Each row of country_property identifies a country code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Country code.

display_order

int

false

Integer to manage the display order of a list.

country_property_myuser

Each row of country_property_myuser identifies a country (based on the MARC 21 Code List of Countries, or ISO 3166/MA standard for UNIMARC systems), with the country name presented in the language associated with the user's login account.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Country code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Country name.

country_property_name

Each row of country_property_name identifies a country name.

Column

Data Type

Not NULL?

Comment

country_property_id

int

false

Foreign key to country_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Country name.

itype_property

Each row of itype_property identifies an item type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code_num

int

false

Item type code.

display_order

int

false

Integer to manage the display order of a list.

itype_property_category_id

int

false

Foreign key to itype_property_category.

physical_format_id

int

false

Foreign key to physical_format.

target_audience_id

int

false

Foreign key to target_audience.

collection_id

int

false

Foreign key to collection.

language_property

Each row of language_property identifies a standard MARC or library-specified custom language code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Language code. (Standard MARC or library-specified custom code.)

display_order

int

false

Integer to manage the display order of a list.

is_public

boolean

false

Specifies whether the code appears in patron interfaces.

language_property_myuser

Each row of language_property_myuser identifies a language, with the name presented in the language associated with the user's login account. The table includes standard MARC language codes by default. Each library can specify additional custom codes and names.

Column

Data Type

Not NULL?

Comment

code

varchar

false

Language code. (Standard MARC or library-specified custom code.)

display_order

int

false

Integer to manage the display order of a list.

is_public

boolean

false

Specifies whether the code appears in patron interfaces.

name

varchar

false

Language name.

language_property_name

Each row of language_property_name identifies a language name.

Column

Data Type

Not NULL?

Comment

language_property_id

int

false

Foreign key to language_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Language name.

material_property

Each row of material_property identifies a material type code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

Material type code.

display_order

int

false

Integer to manage the display order of a list.

is_public

boolean

false

Specifies whether the entry appears in public interfaces.

material_property_category_id

int

false

Foreign key to material_property_category.

physical_format_id

int

false

Foreign key to physical_format.

receiving_location_property

Each row of receiving_location_property identifies a receiving location code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

char

false

Receiving location code.

display_order

int

false

Integer to manage the display order of a list.

receiving_location_property_myuser

Each row of receiving_location_property_myuser identifies a receiving location (ship to address), presented in the language associated with the user's login account. Each library maintains its own receiving location names.

Column

Data Type

Not NULL?

Comment

code

char

false

Receiving location code.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

Receiving location name.

receiving_location_property_name

Each row of receiving_location_property_name identifies a receiving location name.

Column

Data Type

Not NULL?

Comment

receiving_location_property_id

int

false

Foreign key to receiving_location_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

Receiving location name.

user_defined_category

Each row of user_defined_category identifies a category of user-defined codes.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

code

varchar

false

The user-defined code category, such as acode1, acode2, pcode1, and so forth.

user_defined_property

Each row of user_defined_property identifies a user-defined property code.

Column

Data Type

Not NULL?

Comment

id

int

false

System-generated sequential ID.

user_defined_category_id

int

false

Foreign key to user_defined_category.

code

varchar

false

User-defined property code.

display_order

int

false

Integer to manage the display order of a list.

user_defined_property_myuser

Each row of user_defined_property_myuser identifies a user-defined property, with the name/description presented in the language associated with the user's login account. Each library defines its own user-defined property names.

Column

Data Type

Not NULL?

Comment

code

varchar

false

User-defined property code.

user_defined_category_id

int

false

Foreign key to user_defined_category.

display_order

int

false

Integer to manage the display order of a list.

name

varchar

false

User-defined property name/description.

user_defined_property_name

Each row of user_defined_property_name identifies a user-defined property name/description.

Column

Data Type

Not NULL?

Comment

user_defined_property_id

int

false

Foreign key to user_defined_property.

iii_language_id

int

false

Foreign key to iii_language.

name

varchar

false

User-defined property name/description.