Extended Rights

RightsStatements.org, embargo management, TK Labels, and batch rights operations.

ahgExtendedRightsPlugin
All Schemas
0
embargo
0
embargo_audit
0
embargo_exception
0
embargo_i18n
0
extended_rights
0
extended_rights_batch_log
0
extended_rights_i18n
0
extended_rights_tk_label
9
object_rights_holder
12
object_rights_statement
8
rights_cc_license
8
rights_cc_license_i18n
0
rights_derivative_log
0
rights_derivative_rule
0
rights_embargo
0
rights_embargo_i18n
0
rights_embargo_log
0
rights_grant
0
rights_grant_i18n
0
rights_holder
0
rights_i18n
0
rights_object_tk_label
0
rights_orphan_search_step
0
rights_orphan_work
0
rights_orphan_work_i18n
0
rights_record
0
rights_record_i18n
12
rights_statement
12
rights_statement_i18n
0
rights_territory
19
rights_tk_label
19
rights_tk_label_i18n
Entity Relationship Diagram
Open Full Size
Extended Rights ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
fk_rights_cc_license_i18n rights_cc_license_i18n id rights_cc_license id
fk_rights_embargo_i18n rights_embargo_i18n id rights_embargo id
fk_embargo_log rights_embargo_log embargo_id rights_embargo id
fk_rights_grant_record rights_grant rights_record_id rights_record id
fk_rights_grant_i18n rights_grant_i18n id rights_grant id
rights_holder_FK_1 rights_holder id actor id
rights_i18n_FK_1 rights_i18n id rights id
fk_object_tk_label rights_object_tk_label tk_label_id rights_tk_label id
fk_orphan_search_step rights_orphan_search_step orphan_work_id rights_orphan_work id
fk_rights_orphan_work_i18n rights_orphan_work_i18n id rights_orphan_work id
fk_rights_cc_license rights_record cc_license_id rights_cc_license id
fk_rights_record_i18n rights_record_i18n id rights_record id
fk_rights_territory_record rights_territory rights_record_id rights_record id
fk_rights_tk_label_i18n rights_tk_label_i18n id rights_tk_label id
embargo
17 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
embargo_type varchar(50) NOT NULL - full, metadata_only, digital_object, custom
start_date date NOT NULL -
end_date date NULL -
reason text NULL -
is_perpetual tinyint(1) NULL 0
status varchar(39) NULL pending active, expired, lifted, pending
created_by int NULL -
lifted_by int NULL -
lifted_at timestamp NULL -
lift_reason text NULL -
notify_on_expiry tinyint(1) NULL 1
notify_days_before int NULL 30
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
FK is_active tinyint(1) NULL 1
embargo_audit
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK embargo_id bigint unsigned NOT NULL -
action varchar(76) NOT NULL - created, modified, lifted, extended, exception_added, exception_removed
user_id int NULL -
old_values json NULL -
new_values json NULL -
ip_address varchar(45) NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
embargo_exception
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK embargo_id bigint unsigned NOT NULL -
exception_type varchar(40) NOT NULL - user, group, ip_range, repository
exception_id int NULL -
ip_range_start varchar(45) NULL -
ip_range_end varchar(45) NULL -
valid_from date NULL -
valid_until date NULL -
notes text NULL -
granted_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
embargo_i18n
6 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK embargo_id bigint unsigned NOT NULL -
culture varchar(10) NOT NULL en
reason varchar(255) NULL -
notes text NULL -
public_message text NULL -
extended_rights
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
FK rights_statement_id bigint unsigned NULL -
FK creative_commons_license_id bigint unsigned NULL -
rights_date date NULL -
expiry_date date NULL -
rights_holder varchar(255) NULL -
rights_holder_uri varchar(255) NULL -
is_primary tinyint(1) NOT 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
extended_rights_batch_log
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK action varchar(50) NOT NULL -
object_count int NOT NULL 0
object_ids json NULL -
data json NULL -
results json NULL -
FK performed_by int NULL -
FK performed_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
extended_rights_i18n
6 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK extended_rights_id bigint unsigned NOT NULL -
culture varchar(10) NOT NULL en
rights_note text NULL -
usage_conditions text NULL -
copyright_notice text NULL -
extended_rights_tk_label
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK extended_rights_id bigint unsigned NOT NULL -
FK tk_label_id bigint unsigned NOT NULL -
community_id int NULL -
community_note text NULL -
assigned_date date NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
object_rights_holder
6 columns 9 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
FK donor_id int NOT NULL -
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL - on update CURRENT_TIMESTAMP
object_rights_statement
6 columns 12 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
FK rights_statement_id bigint unsigned NOT NULL -
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL - on update CURRENT_TIMESTAMP
rights_cc_license
13 columns 8 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ code varchar(20) NOT NULL -
version varchar(10) NOT NULL 4.0
uri varchar(255) NOT NULL -
allows_commercial tinyint(1) NULL 1
allows_derivatives tinyint(1) NULL 1
requires_share_alike tinyint(1) NULL 0
requires_attribution tinyint(1) NULL 1
icon varchar(100) NULL -
badge_url varchar(255) NULL -
sort_order int NULL 0
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_cc_license_i18n
5 columns 8 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
name varchar(255) NULL -
description text NULL -
human_readable text NULL -
rights_derivative_log
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK rule_id int NULL -
derivative_type varchar(50) NULL -
original_path varchar(500) NULL -
derivative_path varchar(500) NULL -
requested_by int NULL -
request_purpose varchar(100) NULL -
request_ip varchar(45) NULL -
generated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_derivative_rule
21 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NULL - NULL = applies to collection or global
FK collection_id int NULL - NULL = applies to object or global
is_global tinyint(1) NULL 0
FK rule_type varchar(69) NOT NULL - watermark, redaction, resize, format_conversion, metadata_strip
priority int NULL 0
applies_to_roles json NULL - Array of role IDs, NULL = all
applies_to_clearance_levels json NULL - Array of clearance level codes
applies_to_purposes json NULL - Array of purpose codes
watermark_text varchar(255) NULL -
watermark_image_path varchar(500) NULL -
watermark_position varchar(65) NULL bottom_right center, top_left, top_right, bottom_left, bottom_right, tile
watermark_opacity int NULL 50 0-100
redaction_areas json NULL - Array of {x, y, width, height, page}
redaction_color varchar(7) NULL #000000
max_width int NULL -
max_height int NULL -
is_active tinyint(1) NULL 1
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
rights_embargo
21 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL - FK to information_object.id
embargo_type varchar(49) NOT NULL full full, metadata_only, digital_only, partial
reason varchar(95) NOT NULL - donor_restriction, copyright, privacy, legal, commercial, research, cultural, security, other
start_date date NOT NULL -
FK end_date date NULL - NULL = indefinite
auto_release tinyint(1) NULL 1 Auto-lift on end_date
FK review_date date NULL -
review_interval_months int NULL 12
last_reviewed_at datetime NULL -
last_reviewed_by int NULL -
FK status varchar(48) NULL active active, pending, lifted, expired, extended
lifted_at datetime NULL -
lifted_by int NULL -
lift_reason text NULL -
notify_before_days int NULL 30
notification_sent tinyint(1) NULL 0
notify_emails text NULL - JSON array of emails
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
rights_embargo_i18n
4 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
reason_note text NULL -
internal_note text NULL -
rights_embargo_log
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK embargo_id int NOT NULL -
action varchar(74) NOT NULL - created, extended, lifted, reviewed, notification_sent, auto_released
old_status varchar(20) NULL -
new_status varchar(20) NULL -
old_end_date date NULL -
new_end_date date NULL -
notes text NULL -
performed_by int NULL -
performed_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_grant
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK rights_record_id int NOT NULL -
FK act varchar(105) NOT NULL - render, disseminate, replicate, migrate, modify, delete, print, use, publish, excerpt, annotate, move, sell
FK restriction varchar(36) NOT NULL allow allow, disallow, conditional
start_date date NULL -
end_date date NULL -
condition_type varchar(50) NULL -
condition_value text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_grant_i18n
3 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
restriction_note text NULL -
rights_holder
1 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
rights_i18n
11 columns 0 rows
Column Type Nullable Default Extra Comment
rights_note text NULL -
copyright_note text NULL -
identifier_value text NULL -
identifier_type text NULL -
identifier_role text NULL -
license_terms text NULL -
license_note text NULL -
statute_jurisdiction text NULL -
statute_note text NULL -
PK id int NOT NULL -
PK culture varchar(16) NOT NULL -
rights_object_tk_label
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL - FK to information_object.id
FK tk_label_id int NOT NULL -
community_name varchar(255) NULL -
community_contact text NULL -
custom_text text NULL -
verified tinyint(1) NULL 0
verified_by varchar(255) NULL -
verified_date date NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_orphan_search_step
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK orphan_work_id int NOT NULL -
source_type varchar(93) NOT NULL - database, registry, publisher, author_society, archive, library, internet, newspaper, other
source_name varchar(255) NOT NULL -
source_url varchar(500) NULL -
search_date date NOT NULL -
search_terms text NULL -
results_found tinyint(1) NULL 0
results_description text NULL -
evidence_file_path varchar(500) NULL -
screenshot_path varchar(500) NULL -
performed_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_orphan_work
19 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL - FK to information_object.id
FK status varchar(61) NULL in_progress in_progress, completed, rights_holder_found, abandoned
work_type varchar(115) NOT NULL - literary, dramatic, musical, artistic, film, sound_recording, broadcast, typographical, database, photograph, other
search_started_date date NULL -
search_completed_date date NULL -
search_jurisdiction varchar(10) NULL ZA
rights_holder_found tinyint(1) NULL 0
rights_holder_name varchar(255) NULL -
rights_holder_contact text NULL -
contact_attempted tinyint(1) NULL 0
contact_date date NULL -
contact_response text NULL -
intended_use text NULL -
proposed_fee decimal(10,2) NULL -
fee_held_in_escrow tinyint(1) NULL 0
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
rights_orphan_work_i18n
4 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
notes text NULL -
search_summary text NULL -
rights_record
32 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL - FK to information_object.id
FK basis varchar(54) NOT NULL copyright copyright, license, statute, donor, policy, other
FK rights_statement_id int NULL -
FK cc_license_id int NULL -
FK copyright_status varchar(43) NULL unknown copyrighted, public_domain, unknown
copyright_holder varchar(255) NULL -
copyright_holder_actor_id int NULL - FK to actor.id
copyright_jurisdiction varchar(10) NULL ZA ISO 3166-1 alpha-2
copyright_determination_date date NULL -
copyright_note text NULL -
license_identifier varchar(255) NULL -
license_terms text NULL -
license_note text NULL -
statute_citation varchar(255) NULL -
statute_jurisdiction varchar(10) NULL -
statute_determination_date date NULL -
statute_note text NULL -
donor_name varchar(255) NULL -
donor_actor_id int NULL - FK to actor.id
donor_agreement_date date NULL -
donor_note text NULL -
policy_identifier varchar(100) NULL -
policy_note text NULL -
start_date date NULL -
end_date date NULL -
documentation_identifier varchar(255) NULL -
documentation_role varchar(100) NULL -
created_by int NULL - FK to user.id
updated_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
rights_record_i18n
4 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
rights_note text NULL -
restriction_note text NULL -
rights_statement
10 columns 12 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ uri varchar(255) NOT NULL -
UQ code varchar(50) NOT NULL -
category varchar(41) NOT NULL - in-copyright, no-copyright, other
icon_filename varchar(100) NULL -
is_active tinyint(1) NOT NULL 1
sort_order int NOT NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icon_url varchar(255) NULL -
rights_statement_i18n
6 columns 12 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK rights_statement_id bigint unsigned NOT NULL -
culture varchar(10) NOT NULL en
name varchar(255) NOT NULL -
definition text NULL -
scope_note text NULL -
rights_territory
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK rights_record_id int NOT NULL -
territory_type varchar(25) NOT NULL include include, exclude
FK country_code varchar(10) NOT NULL - ISO 3166-1 alpha-2 or region code
is_gdpr_territory tinyint(1) NULL 0
gdpr_legal_basis varchar(50) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_tk_label
9 columns 19 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ code varchar(20) NOT NULL -
FK category varchar(27) NOT NULL tk tk, bc, attribution
uri varchar(255) NULL -
color varchar(7) NULL - Hex color code
icon_path varchar(255) NULL -
sort_order int NULL 0
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_tk_label_i18n
5 columns 19 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
name varchar(255) NULL -
description text NULL -
usage_protocol text NULL -
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.