IIIF Integration

IIIF manifests, canvases, annotations, annotation bodies, and OCR text storage.

ahgIiifPlugin
All Schemas
0
iiif_3d_manifest
0
iiif_annotation
0
iiif_annotation_body
0
iiif_auth_access_log
0
iiif_auth_repository
0
iiif_auth_resource
3
iiif_auth_service
0
iiif_auth_token
2
iiif_collection
0
iiif_collection_i18n
9
iiif_collection_item
36
iiif_manifest_cache
0
iiif_ocr_block
0
iiif_ocr_text
0
iiif_validation_result
19
iiif_viewer_settings
0
object_3d_audit_log
0
object_3d_hotspot
0
object_3d_hotspot_i18n
0
object_3d_model
0
object_3d_model_i18n
0
object_3d_settings
0
object_3d_texture
8
triposr_jobs
Entity Relationship Diagram
Open Full Size
IIIF Integration ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
iiif_3d_manifest_ibfk_1 iiif_3d_manifest model_id object_3d_model id
iiif_annotation_body_ibfk_1 iiif_annotation_body annotation_id iiif_annotation id
iiif_auth_repository_ibfk_1 iiif_auth_repository service_id iiif_auth_service id
iiif_auth_resource_ibfk_1 iiif_auth_resource service_id iiif_auth_service id
iiif_auth_token_ibfk_1 iiif_auth_token service_id iiif_auth_service id
iiif_collection_ibfk_1 iiif_collection parent_id iiif_collection id
iiif_collection_i18n_ibfk_1 iiif_collection_i18n collection_id iiif_collection id
iiif_collection_item_ibfk_1 iiif_collection_item collection_id iiif_collection id
iiif_collection_item_ibfk_2 iiif_collection_item object_id information_object id
iiif_ocr_block_ibfk_1 iiif_ocr_block ocr_id iiif_ocr_text id
object_3d_hotspot_ibfk_1 object_3d_hotspot model_id object_3d_model id
object_3d_hotspot_i18n_ibfk_1 object_3d_hotspot_i18n hotspot_id object_3d_hotspot id
object_3d_model_ibfk_1 object_3d_model object_id information_object id
object_3d_model_i18n_ibfk_1 object_3d_model_i18n model_id object_3d_model id
object_3d_texture_ibfk_1 object_3d_texture model_id object_3d_model id
iiif_3d_manifest
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ model_id int NOT NULL -
manifest_json longtext NULL -
manifest_hash varchar(64) NULL -
generated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
iiif_annotation
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL -
canvas_id int NULL -
FK target_canvas varchar(500) NOT NULL -
target_selector json NULL -
FK motivation varchar(86) NULL commenting commenting, tagging, describing, linking, transcribing, identifying, supplementing
FK created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
iiif_annotation_body
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK annotation_id int NOT NULL -
body_type varchar(50) NULL TextualBody
body_value text NULL -
body_format varchar(50) NULL text/plain
body_language varchar(10) NULL en
body_purpose varchar(50) NULL -
iiif_auth_access_log
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NULL -
FK user_id int NULL -
token_id int unsigned NULL -
FK action varchar(67) NOT NULL - view, download, token_request, token_grant, token_deny, logout
ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
details json NULL -
FK created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
iiif_auth_repository
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK repository_id int NOT NULL - repository.id
FK service_id int unsigned NOT NULL -
degraded_access tinyint(1) NULL 0
degraded_width int NULL 200
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
iiif_auth_resource
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK object_id int NOT NULL - information_object.id
FK service_id int unsigned NOT NULL -
apply_to_children tinyint(1) NULL 1 Apply to descendant objects
degraded_access tinyint(1) NULL 0 Allow degraded (thumbnail) access
degraded_width int NULL 200 Max width for degraded access
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
iiif_auth_service
14 columns 3 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ name varchar(100) NOT NULL -
FK profile varchar(43) NOT NULL login login, clickthrough, kiosk, external
label varchar(255) NOT NULL -
description text NULL -
confirm_label varchar(100) NULL Login
failure_header varchar(255) NULL Authentication Required
failure_description text NULL -
login_url varchar(500) NULL - External login URL for login profile
logout_url varchar(500) NULL -
token_ttl int NULL 3600 Token time-to-live in seconds
FK is_active tinyint(1) NULL 1
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
iiif_auth_token
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ token_hash char(64) NOT NULL - SHA-256 hash of token
FK user_id int NULL - AtoM user ID, NULL for anonymous
FK service_id int unsigned NOT NULL -
FK session_id varchar(128) NULL - Browser session identifier
ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
issued_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
FK expires_at timestamp NOT NULL -
last_used_at timestamp NULL -
FK is_revoked tinyint(1) NULL 0
iiif_collection
15 columns 2 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
name varchar(255) NOT NULL -
UQ slug varchar(255) NOT NULL -
description text NULL -
attribution varchar(500) NULL -
logo_url varchar(500) NULL -
thumbnail_url varchar(500) NULL -
viewing_hint varchar(53) NULL individuals individuals, paged, continuous, multi-part, top
nav_date date NULL -
FK parent_id int NULL -
sort_order int NULL 0
FK is_public tinyint(1) NULL 1
created_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
iiif_collection_i18n
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK collection_id int NOT NULL -
culture varchar(10) NOT NULL en
name varchar(255) NULL -
description text NULL -
iiif_collection_item
10 columns 9 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK collection_id int NOT NULL -
FK object_id int NULL -
manifest_uri varchar(1000) NULL -
item_type varchar(29) NULL manifest manifest, collection
label varchar(500) NULL -
description text NULL -
thumbnail_url varchar(500) NULL -
sort_order int NULL 0
added_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
iiif_manifest_cache
8 columns 36 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
culture varchar(10) NOT NULL en
manifest_json longtext NOT NULL -
UQ cache_key varchar(64) NOT NULL - SHA-256 of object signature
page_count int NULL - Cached multi-TIFF page count
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
expires_at timestamp NULL -
iiif_ocr_block
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK ocr_id int NOT NULL -
FK page_number int NULL 1
FK block_type varchar(36) NULL word word, line, paragraph, region
FK text varchar(1000) NULL -
x int NOT NULL -
y int NOT NULL -
width int NOT NULL -
height int NOT NULL -
confidence decimal(5,2) NULL -
block_order int NULL 0
iiif_ocr_text
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK object_id int NOT NULL -
FK full_text longtext NULL -
format varchar(25) NULL plain plain, alto, hocr
language varchar(10) NULL en
confidence decimal(5,2) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
iiif_validation_result
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL -
FK validation_type varchar(100) NOT NULL -
FK status varchar(50) NOT NULL -
details text NULL -
FK validated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
validated_by int NULL -
iiif_viewer_settings
6 columns 19 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ setting_key varchar(100) NOT NULL -
setting_value text NULL -
description varchar(255) NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
object_3d_audit_log
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK model_id int NULL -
FK object_id int NULL -
user_id int NULL -
user_name varchar(255) NULL -
FK action varchar(79) NOT NULL - upload, update, delete, view, ar_view, download, hotspot_add, hotspot_delete
details json NULL -
ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
FK created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
object_3d_hotspot
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK model_id int NOT NULL -
hotspot_type varchar(44) NULL annotation annotation, info, link, damage, detail
position_x decimal(10,6) NOT NULL -
position_y decimal(10,6) NOT NULL -
position_z decimal(10,6) NOT NULL -
normal_x decimal(10,6) NULL 0.000000
normal_y decimal(10,6) NULL 1.000000
normal_z decimal(10,6) NULL 0.000000
icon varchar(50) NULL info
color varchar(20) NULL #1a73e8
link_url varchar(500) NULL -
link_target varchar(22) NULL _blank _self, _blank
display_order int NULL 0
is_visible tinyint(1) NULL 1
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
object_3d_hotspot_i18n
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK hotspot_id int NOT NULL -
culture varchar(10) NOT NULL en
title varchar(255) NULL -
description text NULL -
object_3d_model
37 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL -
filename varchar(255) NOT NULL -
original_filename varchar(255) NULL -
file_path varchar(500) NOT NULL -
file_size bigint NULL -
mime_type varchar(100) NULL -
FK format varchar(39) NULL glb glb, gltf, obj, fbx, stl, ply, usdz
vertex_count int NULL -
face_count int NULL -
texture_count int NULL -
animation_count int NULL 0
has_materials tinyint(1) NULL 1
auto_rotate tinyint(1) NULL 1
rotation_speed decimal(3,2) NULL 1.00
camera_orbit varchar(100) NULL 0deg 75deg 105%
min_camera_orbit varchar(100) NULL -
max_camera_orbit varchar(100) NULL -
field_of_view varchar(20) NULL 30deg
exposure decimal(3,2) NULL 1.00
shadow_intensity decimal(3,2) NULL 1.00
shadow_softness decimal(3,2) NULL 1.00
environment_image varchar(255) NULL -
skybox_image varchar(255) NULL -
background_color varchar(20) NULL #f5f5f5
ar_enabled tinyint(1) NULL 1
ar_scale varchar(20) NULL auto
ar_placement varchar(20) NULL floor floor, wall
poster_image varchar(500) NULL -
thumbnail varchar(500) NULL -
is_primary tinyint(1) NULL 0
FK is_public tinyint(1) NULL 1
display_order int NULL 0
created_by int NULL -
updated_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
object_3d_model_i18n
6 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK model_id int NOT NULL -
culture varchar(10) NOT NULL en
title varchar(255) NULL -
description text NULL -
alt_text varchar(500) NULL -
object_3d_settings
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ digital_object_id int NOT NULL -
auto_rotate tinyint(1) NULL 1
rotation_speed decimal(3,2) NULL 1.00
camera_orbit varchar(100) NULL 0deg 75deg 105%
field_of_view varchar(20) NULL 30deg
exposure decimal(3,2) NULL 1.00
shadow_intensity decimal(3,2) NULL 1.00
background_color varchar(20) NULL #f5f5f5
ar_enabled tinyint(1) NULL 1
ar_scale varchar(20) NULL auto
ar_placement varchar(20) NULL floor floor, wall
poster_image varchar(500) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
object_3d_texture
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK model_id int NOT NULL -
texture_type varchar(67) NULL diffuse diffuse, normal, roughness, metallic, ao, emissive, environment
filename varchar(255) NOT NULL -
file_path varchar(500) NOT NULL -
width int NULL -
height int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
triposr_jobs
16 columns 8 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK object_id int NULL - Link to information_object.id
FK model_id int NULL - Link to object_3d_model.id after import
input_image varchar(500) NOT NULL - Path to input image
output_model varchar(500) NULL - Path to generated 3D model
output_format varchar(20) NULL glb glb, obj
FK status varchar(45) NULL pending pending, processing, completed, failed
processing_mode varchar(22) NULL local local, remote
processing_time decimal(10,2) NULL - Time in seconds
error_message text NULL -
options json NULL - Generation options used
created_by int NULL - User who initiated
FK created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
started_at datetime NULL -
completed_at datetime NULL -
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
Notes

Log in to add notes.

Legend
PK Primary Key FK Foreign Key / Index UQ Unique Constraint
Table structures are read live from the database. Row counts reflect current data.