NAZ (Zimbabwe)

National Archives Act [Chapter 25:06] — 25-year rule, closure, permits.

ahgNAZPlugin
All Schemas
0
naz_audit_log
0
naz_closure_period
9
naz_config
0
naz_protected_record
0
naz_records_schedule
0
naz_research_permit
0
naz_research_visit
0
naz_researcher
0
naz_transfer
0
naz_transfer_item
Entity Relationship Diagram
Open Full Size
NAZ (Zimbabwe) ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
naz_research_permit_ibfk_1 naz_research_permit researcher_id naz_researcher id
naz_research_visit_ibfk_1 naz_research_visit permit_id naz_research_permit id
naz_research_visit_ibfk_2 naz_research_visit researcher_id naz_researcher id
naz_transfer_ibfk_1 naz_transfer schedule_id naz_records_schedule id
naz_transfer_item_ibfk_1 naz_transfer_item transfer_id naz_transfer id
naz_audit_log
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK action_type varchar(50) NOT NULL -
FK entity_type varchar(50) NOT NULL -
entity_id bigint unsigned NOT NULL -
FK user_id int NULL -
ip_address varchar(45) NULL -
old_value json NULL -
new_value json NULL -
notes text NULL -
FK created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
naz_closure_period
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK closure_type varchar(50) NOT NULL standard standard, extended, indefinite, ministerial
closure_reason varchar(255) NULL -
start_date date NOT NULL -
FK end_date date NULL -
years int NULL 25
authority_reference varchar(100) NULL - Ministerial order or authority reference
review_date date NULL -
FK status varchar(42) NULL active active, expired, extended, released
release_notes text NULL -
released_by int NULL -
released_at datetime NULL -
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_config
6 columns 9 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ config_key varchar(100) NOT NULL -
config_value text NULL -
description text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_protected_record
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK protection_type varchar(52) NOT NULL - cabinet, security, personal, legal, commercial
protection_reason text NOT NULL -
authority_reference varchar(255) NULL - Minister/authority reference
protection_start date NOT NULL -
protection_end date NULL - NULL = indefinite
review_date date NULL -
FK status varchar(31) NULL active active, expired, lifted
lifted_by int NULL -
lifted_date date NULL -
lifted_reason text NULL -
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_records_schedule
21 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ schedule_number varchar(50) NOT NULL -
FK agency_name varchar(255) NOT NULL -
agency_code varchar(50) NULL -
record_series varchar(255) NOT NULL -
description text NULL -
retention_period_active int NOT NULL - Years in active storage
retention_period_semi int NULL 0 Years in semi-active storage
FK disposal_action varchar(43) NOT NULL - destroy, transfer, review, permanent
legal_authority text NULL - Legal basis for retention
classification varchar(46) NULL useful vital, important, useful, non-essential
access_restriction varchar(45) NULL open open, restricted, confidential, secret
approved_by varchar(255) NULL -
approval_date date NULL -
effective_date date NULL -
review_date date NULL -
FK status varchar(52) NULL draft draft, pending, approved, superseded, archived
notes text NULL -
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_research_permit
22 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ permit_number varchar(50) NOT NULL -
FK researcher_id bigint unsigned NOT NULL -
FK permit_type varchar(36) NOT NULL general general, restricted, special
research_topic varchar(500) NOT NULL -
research_purpose text NULL -
start_date date NOT NULL -
FK end_date date NOT NULL -
fee_amount decimal(10,2) NULL 0.00
fee_currency varchar(3) NULL USD
fee_paid tinyint(1) NULL 0
fee_receipt varchar(100) NULL -
payment_date date NULL -
approved_by int NULL -
approved_date date NULL -
FK status varchar(58) NULL pending pending, approved, rejected, active, expired, revoked
rejection_reason text NULL -
collections_access json NULL - Array of collection/repository IDs permitted
restrictions text NULL - Any special restrictions on access
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_research_visit
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK permit_id bigint unsigned NOT NULL -
FK researcher_id bigint unsigned NOT NULL -
FK visit_date date NOT NULL -
check_in_time time NULL -
check_out_time time NULL -
materials_requested text NULL -
materials_provided text NULL -
reading_room varchar(100) NULL -
supervisor_id int NULL -
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
naz_researcher
23 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
user_id int NULL - Link to AtoM user if applicable
FK researcher_type varchar(37) NOT NULL local local, foreign, institutional
title varchar(20) NULL -
first_name varchar(100) NOT NULL -
last_name varchar(100) NOT NULL -
FK email varchar(255) NOT NULL -
phone varchar(50) NULL -
nationality varchar(100) NULL -
passport_number varchar(50) NULL -
national_id varchar(50) NULL -
institution varchar(255) NULL -
position varchar(100) NULL -
address text NULL -
city varchar(100) NULL -
country varchar(100) NULL -
research_interests text NULL -
registration_date date NOT NULL -
FK status varchar(47) NULL active active, inactive, suspended, blacklisted
notes text NULL -
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_transfer
27 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ transfer_number varchar(50) NOT NULL -
FK transferring_agency varchar(255) NOT NULL -
agency_contact varchar(255) NULL -
agency_email varchar(255) NULL -
agency_phone varchar(50) NULL -
FK schedule_id bigint unsigned NULL - Link to records schedule
transfer_type varchar(45) NULL scheduled scheduled, voluntary, rescue, donation
description text NULL -
date_range_start date NULL -
date_range_end date NULL -
quantity_linear_metres decimal(10,2) NULL -
quantity_boxes int NULL -
quantity_items int NULL -
contains_restricted tinyint(1) NULL 0
restriction_details text NULL -
accession_number varchar(100) NULL - NAZ accession number if assigned
FK proposed_date date NULL -
actual_date date NULL -
received_by int NULL -
FK status varchar(79) NULL proposed proposed, scheduled, in_transit, received, accessioned, rejected, cancelled
rejection_reason text NULL -
location_assigned varchar(255) NULL -
notes text NULL -
created_by int NOT NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
naz_transfer_item
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK transfer_id bigint unsigned NOT NULL -
series_title varchar(500) NOT NULL -
description text NULL -
date_range varchar(100) NULL -
quantity int NULL 1
format varchar(100) NULL -
condition_notes text NULL -
access_restriction varchar(38) NULL open open, restricted, confidential
restriction_end_date date NULL -
information_object_id int NULL - Link to AtoM record if created
created_at timestamp 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.