Categorization

Detailed View

ead_hierarchy

Each row of ead_hierarchy describes an Encoded Archival Description entry.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
bib_record_id	bigint	false	The bibliographic record associated with the EAD position string.
entry	varchar	false	The Encoded Archival Description string that identifies a position in the hierarchy.

physical_format

Each row of physical_format identifies a physical format. Each library maintains its own list of physical formats.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
is_default	boolean	false	Identifies the default physical format.
display_order	int	false	Integer to manage the display order of a list.

physical_format_myuser

Each row of physical_format_myuser identifies a physical format, with the name presented in the language associated with the user's login account. Each library maintains its own list of physical formats.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
is_default	boolean	false	Identifies the default physical format.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	Physical format name specified by the library.

physical_format_name

Each row of physical_format_name identifies a physical format name.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	Physical format name.
iii_language_id	int	false	Foreign key to iii_language.
physical_format_id	int	false	Foreign key to physical_format.

scat_category

Each row of scat_category identifies a statistical category (SCAT) code.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
code_num	int	false	SCAT code.
scat_section_id	bigint	false	Foreign key to scat_section.

scat_category_myuser

Each row of scat_category_myuser identifies a statistical category (SCAT), with the name presented in the language associated with the user's login account. Each library maintains its own statistical categories.

Column	Data Type	Not NULL?	Comment
code	int	false	SCAT code.
scat_section_id	bigint	false	Foreign key to scat_section.
name	varchar	false	SCAT name.

scat_category_name

Each row of scat_category_name identifies a statistical category (SCAT) name.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
scat_category_id	bigint	false	Foreign key to scat_category.
name	varchar	false	SCAT name.
iii_language_code	varchar	false	Foreign key to iii_language.

scat_range

Each row of scat_range defines a statistical category range.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
line_num	int	false	Line number within the scat file corresponding to the range.
start_letter_str	varchar	false	Up to three characters specifying the Class Letter in the starting call number (marks the lower boundary for this grouping). Can be blank, e.g., for Dewey call numbers.
end_letter_str	varchar	false	Up to three characters specifying the Class Letter in the ending call number (marks the upper boundary for this grouping). Can be blank, e.g., for Dewey call numbers.
start_num_str	varchar	false	Up to seven digits plus one decimal point specifying the Class Number in the starting call number (marks the lower boundary for this grouping).
end_num_str	varchar	false	Up to seven digits plus one decimal point specifying the Class Number in the ending call number (marks the upper boundary for this grouping).
scat_category_id	bigint	false	Foreign key to scat_category.
free_text_type	char	false	Either 'm' (for "match") or 'r' (for "range"). The scat table allows "free text" categories sorted by matching the "beginning" and "end" text exactly or using the "beginning" and "end" text as a range.

scat_section

Each row of scat_section identifies a statistical categories (SCAT) table section code.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
code_num	int	false	SCAT section code.
index_tag	varchar	false	SCAT table index tag.

scat_section_myuser

Each row of scat_section_myuser identifies a statistical categories (SCAT) table section, with the name presented in the language associated with the user's login account. Each library maintains its own statistical categories.

Column	Data Type	Not NULL?	Comment
code	int	false	SCAT section code.
index_tag	varchar	false	SCAT table index tag.
name	varchar	false	SCAT section name.

scat_section_name

Each row of scat_section_name identifies a statistical categories (SCAT) table section name.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
scat_section_id	bigint	false	Foreign key to scat_section.
name	varchar	false	SCAT section name.
iii_language_code	varchar	false	Foreign key to iii_language.

target_audience

Each row of target_audience identifies a target audience category. Each library maintains its own list of target audience categories.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
is_default	boolean	false	Identifies the default target audience category.
display_order	int	false	Integer to manage the display order of a list.

target_audience_myuser

Each row of target_audience_myuser identifies a target audience category, with the name presented in the language associated with the user's login account. Each library maintains its own list of target audience categories.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
is_default	boolean	false	Identifies the default physical format.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	Target audience category name specified by the library.

target_audience_name

Each row of target_audience_name identifies a target audience category name. Each library maintains its own list of target audience category names.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	Target audience category name.
iii_language_id	int	false	Foreign key to iii_language.
target_audience_id	int	false	Foreign key to target_audience.