Indigenous Cultural IP

Indigenous Cultural & Intellectual Property management and TK Labels.

ahgICIPPlugin
All Schemas
0
icip_access_restriction
0
icip_community
8
icip_config
0
icip_consent
0
icip_consultation
0
icip_cultural_notice
10
icip_cultural_notice_type
0
icip_notice_acknowledgement
0
icip_object_summary
0
icip_tk_label
22
icip_tk_label_type
Entity Relationship Diagram
Open Full Size
Indigenous Cultural IP ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
icip_access_restriction_ibfk_1 icip_access_restriction community_id icip_community id
icip_consent_ibfk_1 icip_consent community_id icip_community id
icip_consultation_ibfk_1 icip_consultation community_id icip_community id
icip_consultation_ibfk_2 icip_consultation linked_consent_id icip_consent id
icip_cultural_notice_ibfk_2 icip_cultural_notice community_id icip_community id
icip_cultural_notice_ibfk_1 icip_cultural_notice notice_type_id icip_cultural_notice_type id
icip_notice_acknowledgement_ibfk_1 icip_notice_acknowledgement notice_id icip_cultural_notice id
icip_tk_label_ibfk_2 icip_tk_label community_id icip_community id
icip_tk_label_ibfk_1 icip_tk_label label_type_id icip_tk_label_type id
icip_access_restriction
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK restriction_type varchar(198) NOT NULL - community_permission_required, gender_restricted_male, gender_restricted_female, initiated_only, seasonal, mourning_period, repatriation_pending, under_consultation, elder_approval_required, custom
FK community_id int NULL - Community that requested restriction
FK start_date date NULL -
end_date date NULL - NULL for indefinite restrictions
applies_to_descendants tinyint(1) NULL 1
override_security_clearance tinyint(1) NULL 1 Override standard security clearance
custom_restriction_text text NULL - For custom restriction type
notes text NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_community
18 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
name varchar(255) NOT NULL -
alternate_names json NULL - Array of alternate names/spellings
FK language_group varchar(255) NULL -
region varchar(255) NULL -
FK state_territory varchar(47) NOT NULL - NSW, VIC, QLD, WA, SA, TAS, NT, ACT, External
contact_name varchar(255) NULL -
contact_email varchar(255) NULL -
contact_phone varchar(100) NULL -
contact_address text NULL -
native_title_reference varchar(255) NULL - Reference to Native Title determination
prescribed_body_corporate varchar(255) NULL - PBC name if applicable
pbc_contact_email varchar(255) NULL -
notes text NULL -
FK 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
icip_config
6 columns 8 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ config_key varchar(100) NOT NULL -
config_value text NULL -
description text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_consent
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK community_id int NULL - Link to icip_community
FK consent_status varchar(135) NOT NULL unknown not_required, pending_consultation, consultation_in_progress, conditional_consent, full_consent, restricted_consent, denied, unknown
consent_scope json NULL - Array of scope values: preservation_only, internal_access, public_access, reproduction, commercial_use, educational_use, research_use, full_rights
consent_date date NULL -
FK consent_expiry_date date NULL -
consent_granted_by varchar(255) NULL - Person/authority who granted consent
consent_document_path varchar(500) NULL - Path to consent document
conditions text NULL - Consent conditions and restrictions
restrictions text NULL - Specific usage restrictions
notes text NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_consultation
22 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NULL - Can be NULL for general consultations
FK community_id int NOT NULL -
FK consultation_type varchar(132) NOT NULL - initial_contact, consent_request, access_request, repatriation, digitisation, exhibition, publication, research, general, follow_up
FK consultation_date date NOT NULL -
consultation_method varchar(50) NOT NULL - in_person, phone, video, email, letter, other
location varchar(255) NULL -
attendees text NULL - List of attendees
community_representatives text NULL - Community members present
institution_representatives text NULL - Institution staff present
summary text NOT NULL -
outcomes text NULL -
action_items json NULL - Array of action items with due dates
FK follow_up_date date NULL -
follow_up_notes text NULL -
is_confidential tinyint(1) NULL 0
FK linked_consent_id int NULL - Link to consent record if applicable
documents json NULL - Array of document paths
FK status varchar(58) NOT NULL completed scheduled, completed, cancelled, follow_up_required
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_cultural_notice
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK notice_type_id int NOT NULL -
custom_text text NULL - Override default text if needed
FK community_id int NULL - Community that requested this notice
applies_to_descendants tinyint(1) NULL 1
FK start_date date NULL - For seasonal restrictions
end_date date NULL - For seasonal restrictions
notes text NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_cultural_notice_type
15 columns 10 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ code varchar(50) NOT NULL -
name varchar(255) NOT NULL -
description text NULL -
default_text text NULL - Default notice text
icon varchar(100) NULL - Icon class or image path
severity varchar(31) NULL warning info, warning, critical
requires_acknowledgement tinyint(1) NULL 0
blocks_access tinyint(1) NULL 0
display_public tinyint(1) NULL 1
display_staff tinyint(1) NULL 1
display_order int NULL 100
FK is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_notice_acknowledgement
6 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK notice_id int NOT NULL -
FK user_id int NOT NULL -
acknowledged_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
icip_object_summary
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK information_object_id int NOT NULL -
FK has_icip_content tinyint(1) NULL 0
FK consent_status varchar(50) NULL -
FK has_cultural_notices tinyint(1) NULL 0
cultural_notice_count int NULL 0
FK has_tk_labels tinyint(1) NULL 0
tk_label_count int NULL 0
FK has_restrictions tinyint(1) NULL 0
restriction_count int NULL 0
requires_acknowledgement tinyint(1) NULL 0
FK blocks_access tinyint(1) NULL 0
community_ids json NULL - Array of linked community IDs
last_consultation_date date NULL -
consent_expiry_date date NULL -
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_tk_label
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK label_type_id int NOT NULL -
FK community_id int NULL - Community that applied the label
FK applied_by varchar(31) NOT NULL institution community, institution
local_contexts_project_id varchar(255) NULL - Link to Local Contexts Hub project
notes text NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
icip_tk_label_type
10 columns 22 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ code varchar(50) NOT NULL -
FK category varchar(20) NOT NULL - TK, BC
name varchar(255) NOT NULL -
description text NULL -
icon_path varchar(255) NULL - Path to label icon
local_contexts_url varchar(500) NULL - Link to Local Contexts definition
display_order int NULL 100
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
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.