Standards & Conformance

Entity Relationship Diagram

Foreign Key Relationships

Constraint	Table	Column	References	Referenced Column
`fk_guide_software`	`registry_setup_guide`	software_id	`registry_software`	id
`fk_ss_software`	`registry_software_standard`	software_id	`registry_software`	id
`fk_ss_standard`	`registry_software_standard`	standard_id	`registry_standard`	id
`fk_ext_standard`	`registry_standard_extension`	standard_id	`registry_standard`	id

`registry_attachment`

14 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(64)	NOT NULL	-		discussion, reply, blog_post, institution, vendor, software
	`entity_id`	bigint unsigned	NOT NULL	-
	`file_path`	varchar(500)	NOT NULL	-
	`file_name`	varchar(255)	NOT NULL	-
	`file_size_bytes`	bigint	NULL	-
	`mime_type`	varchar(100)	NULL	-
FK	`file_type`	varchar(53)	NULL	`other`		image, document, log, archive, screenshot, other
	`caption`	varchar(500)	NULL	-
	`is_inline`	tinyint(1)	NULL	`0`
	`download_count`	int	NULL	`0`
	`uploaded_by_email`	varchar(255)	NULL	-
	`uploaded_by_user_id`	int	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_blog_post`

20 columns 12 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`title`	varchar(500)	NOT NULL	-
UQ	`slug`	varchar(500)	NOT NULL	-
	`content`	text	NOT NULL	-
	`excerpt`	varchar(1000)	NULL	-
	`featured_image_path`	varchar(500)	NULL	-
FK	`author_type`	varchar(45)	NOT NULL	-		admin, vendor, institution, user_group
	`author_id`	bigint unsigned	NULL	-
	`author_name`	varchar(255)	NULL	-
FK	`category`	varchar(77)	NULL	`news`		news, announcement, event, tutorial, case_study, release, community, other
	`tags`	json	NULL	-
FK	`status`	varchar(49)	NULL	`draft`		draft, pending_review, published, archived
	`is_featured`	tinyint(1)	NULL	`0`
	`is_pinned`	tinyint(1)	NULL	`0`
	`view_count`	int	NULL	`0`
	`comment_count`	int	NULL	`0`
	`comments_enabled`	tinyint(1)	NULL	`1`
FK	`published_at`	datetime	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_contact`

16 columns 4 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(28)	NOT NULL	-		institution, vendor
	`entity_id`	bigint unsigned	NOT NULL	-
	`first_name`	varchar(100)	NOT NULL	-
	`last_name`	varchar(100)	NOT NULL	-
	`email`	varchar(255)	NULL	-
	`phone`	varchar(100)	NULL	-
	`mobile`	varchar(100)	NULL	-
	`job_title`	varchar(255)	NULL	-
	`department`	varchar(255)	NULL	-
	`roles`	json	NULL	-
	`is_primary`	tinyint(1)	NULL	`0`
	`is_public`	tinyint(1)	NULL	`1`
	`notes`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_discussion`

20 columns 27 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`group_id`	bigint unsigned	NULL	-
FK	`blog_post_id`	bigint unsigned	NULL	-
	`author_email`	varchar(255)	NOT NULL	-
	`author_name`	varchar(255)	NULL	-
	`author_user_id`	int	NULL	-
FK	`title`	varchar(500)	NOT NULL	-
	`content`	text	NOT NULL	-
	`topic_type`	varchar(62)	NULL	`discussion`		discussion, question, announcement, event, showcase, help
	`tags`	json	NULL	-
FK	`is_pinned`	tinyint(1)	NULL	`0`
	`is_locked`	tinyint(1)	NULL	`0`
	`is_resolved`	tinyint(1)	NULL	`0`
FK	`status`	varchar(35)	NULL	`active`		active, closed, hidden, spam
	`reply_count`	int	NULL	`0`
	`view_count`	int	NULL	`0`
FK	`last_reply_at`	datetime	NULL	-
	`last_reply_by`	varchar(255)	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_discussion_reply`

11 columns 23 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`discussion_id`	bigint unsigned	NOT NULL	-
FK	`parent_reply_id`	bigint unsigned	NULL	-
	`author_email`	varchar(255)	NOT NULL	-
	`author_name`	varchar(255)	NULL	-
	`author_user_id`	int	NULL	-
	`content`	text	NOT NULL	-
	`is_accepted_answer`	tinyint(1)	NULL	`0`
	`status`	varchar(28)	NULL	`active`		active, hidden, spam
FK	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_erd`

17 columns 33 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
UQ	`plugin_name`	varchar(255)	NOT NULL	-		e.g. ahgPreservationPlugin
FK	`vendor_id`	bigint unsigned	NULL	-
	`display_name`	varchar(255)	NOT NULL	-		e.g. Digital Preservation
UQ	`slug`	varchar(255)	NOT NULL	-
	`category`	varchar(100)	NOT NULL	`general`		core, sector, compliance, browse, ai, ingest, rights, research, collection, exhibition, integration, reporting
	`description`	text	NULL	-		Short description of this ERD group
	`tables_json`	json	NULL	-		Array of table names to auto-render schema from information_schema
	`diagram`	longtext	NULL	-		ASCII ERD diagram (rendered in <pre> block)
	`diagram_image`	varchar(500)	NULL	-
	`notes`	text	NULL	-		Additional notes or markdown content
	`icon`	varchar(100)	NULL	`fas fa-database`		Font Awesome icon class
	`color`	varchar(50)	NULL	`primary`		Bootstrap color class
	`is_active`	tinyint(1)	NOT NULL	`1`
	`sort_order`	int	NOT NULL	`100`
	`created_at`	datetime	NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_favorite`

5 columns 2 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`user_id`	int	NOT NULL	-
FK	`entity_type`	varchar(43)	NOT NULL	-		institution, vendor, software, group
	`entity_id`	bigint unsigned	NOT NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_instance`

28 columns 168 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`institution_id`	bigint unsigned	NOT NULL	-
	`name`	varchar(255)	NOT NULL	-
	`url`	varchar(500)	NULL	-
	`instance_type`	varchar(53)	NULL	`production`		production, staging, development, demo, offline
	`software`	varchar(100)	NULL	`heratio`
	`software_version`	varchar(50)	NULL	-
	`hosting`	varchar(46)	NULL	-		self_hosted, cloud, vendor_hosted, saas
FK	`hosting_vendor_id`	bigint unsigned	NULL	-
FK	`maintained_by_vendor_id`	bigint unsigned	NULL	-
FK	`sync_token`	varchar(64)	NULL	-
	`sync_enabled`	tinyint(1)	NULL	`0`
	`last_sync_at`	datetime	NULL	-
	`last_heartbeat_at`	datetime	NULL	-
	`sync_data`	json	NULL	-
FK	`status`	varchar(51)	NULL	`online`		online, offline, maintenance, decommissioned
	`is_public`	tinyint(1)	NULL	`1`
	`description`	text	NULL	-
	`record_count`	int	NULL	-
	`digital_object_count`	int	NULL	-
	`storage_gb`	decimal(10,2)	NULL	-
	`os_environment`	varchar(100)	NULL	-
	`languages`	json	NULL	-
	`descriptive_standard`	varchar(100)	NULL	-
	`feature_usage`	json	NULL	-
	`feature_notes`	json	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_instance_feature`

6 columns 0 rows

	Column	Type	Nullable	Default	Extra
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`instance_id`	bigint unsigned	NOT NULL	-
	`feature_name`	varchar(100)	NOT NULL	-
	`is_in_use`	tinyint(1)	NULL	`1`
	`comments`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_institution`

43 columns 177 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`name`	varchar(255)	NOT NULL	-
UQ	`slug`	varchar(255)	NOT NULL	-
FK	`institution_type`	varchar(102)	NOT NULL	-		archive, library, museum, gallery, dam, heritage_site, research_centre, government, university, other
	`glam_sectors`	json	NULL	-
	`description`	text	NULL	-
	`short_description`	varchar(500)	NULL	-
	`logo_path`	varchar(500)	NULL	-
	`banner_path`	varchar(500)	NULL	-
	`website`	varchar(255)	NULL	-
	`email`	varchar(255)	NULL	-
	`phone`	varchar(100)	NULL	-
	`fax`	varchar(100)	NULL	-
	`street_address`	text	NULL	-
	`city`	varchar(100)	NULL	-
	`province_state`	varchar(100)	NULL	-
	`postal_code`	varchar(20)	NULL	-
FK	`country`	varchar(100)	NULL	-
	`latitude`	decimal(10,7)	NULL	-
	`longitude`	decimal(10,7)	NULL	-
	`size`	varchar(37)	NULL	-		small, medium, large, national
	`governance`	varchar(65)	NULL	-		public, private, ngo, academic, government, tribal, community
	`parent_body`	varchar(255)	NULL	-
	`established_year`	int	NULL	-
	`accreditation`	varchar(255)	NULL	-
	`collection_summary`	text	NULL	-
	`collection_strengths`	json	NULL	-
	`total_holdings`	varchar(100)	NULL	-
	`digitization_percentage`	int	NULL	-
	`descriptive_standards`	json	NULL	-
	`management_system`	varchar(100)	NULL	-
	`uses_atom`	tinyint(1)	NULL	`0`
	`open_to_public`	tinyint(1)	NULL	`1`
	`institution_url`	varchar(500)	NULL	-
	`is_verified`	tinyint(1)	NULL	`0`
	`is_featured`	tinyint(1)	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`verification_notes`	text	NULL	-
	`verified_at`	datetime	NULL	-
	`verified_by`	int	NULL	-
	`created_by`	int	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_institution_software`

8 columns 2 rows

	Column	Type	Nullable	Default	Extra
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`institution_id`	bigint unsigned	NOT NULL	-
FK	`software_id`	bigint unsigned	NOT NULL	-
	`instance_id`	bigint unsigned	NULL	-
	`version_in_use`	varchar(50)	NULL	-
	`deployment_date`	date	NULL	-
	`notes`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_newsletter`

15 columns 1 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
	`subject`	varchar(500)	NOT NULL	-
	`content`	text	NOT NULL	-
	`excerpt`	varchar(1000)	NULL	-
	`author_name`	varchar(255)	NULL	-
	`author_user_id`	int	NULL	-
FK	`status`	varchar(40)	NULL	`draft`		draft, scheduled, sent, cancelled
	`recipient_count`	int	NULL	`0`
	`sent_count`	int	NULL	`0`
	`open_count`	int	NULL	`0`
	`click_count`	int	NULL	`0`
	`scheduled_at`	datetime	NULL	-
FK	`sent_at`	datetime	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_newsletter_send_log`

7 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`newsletter_id`	bigint unsigned	NOT NULL	-
FK	`subscriber_id`	bigint unsigned	NOT NULL	-
	`status`	varchar(51)	NULL	`queued`		queued, sent, failed, bounced, opened, clicked
	`sent_at`	datetime	NULL	-
	`opened_at`	datetime	NULL	-
	`error_message`	text	NULL	-

`registry_newsletter_subscriber`

13 columns 53 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
UQ	`email`	varchar(255)	NOT NULL	-
	`name`	varchar(255)	NULL	-
	`user_id`	int	NULL	-
	`institution_id`	bigint unsigned	NULL	-
	`vendor_id`	bigint unsigned	NULL	-
FK	`status`	varchar(37)	NULL	`active`		active, unsubscribed, bounced
	`subscribed_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`unsubscribed_at`	datetime	NULL	-
FK	`unsubscribe_token`	varchar(64)	NOT NULL	-
	`confirm_token`	varchar(64)	NULL	-
	`is_confirmed`	tinyint(1)	NULL	`0`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_note`

10 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(50)	NOT NULL	-		standard, vendor, erd, software, institution, group
	`entity_id`	bigint unsigned	NOT NULL	-
FK	`user_id`	bigint unsigned	NULL	-		FK to registry_user.id
	`user_name`	varchar(255)	NOT NULL	-
	`content`	text	NOT NULL	-
	`is_pinned`	tinyint(1)	NOT NULL	`0`
	`is_active`	tinyint(1)	NOT NULL	`1`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_oauth_account`

14 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`user_id`	int	NULL	-
FK	`provider`	varchar(51)	NOT NULL	-		google, facebook, github, linkedin, microsoft
	`provider_user_id`	varchar(255)	NOT NULL	-
FK	`email`	varchar(255)	NULL	-
	`name`	varchar(255)	NULL	-
	`avatar_url`	varchar(500)	NULL	-
	`access_token_encrypted`	text	NULL	-
	`refresh_token_encrypted`	text	NULL	-
	`token_expires_at`	datetime	NULL	-
	`profile_data`	json	NULL	-
	`last_login_at`	datetime	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_review`

12 columns 1 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(25)	NOT NULL	-		vendor, software
	`entity_id`	bigint unsigned	NOT NULL	-
	`reviewer_institution_id`	bigint unsigned	NULL	-
	`reviewer_name`	varchar(255)	NULL	-
	`reviewer_email`	varchar(255)	NULL	-
FK	`rating`	int	NOT NULL	-
	`title`	varchar(255)	NULL	-
	`comment`	text	NULL	-
	`is_visible`	tinyint(1)	NULL	`1`
	`is_verified`	tinyint(1)	NULL	`0`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_settings`

7 columns 45 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	int unsigned	NOT NULL	-	auto_increment
UQ	`setting_key`	varchar(100)	NOT NULL	-
	`setting_value`	text	NULL	-
	`setting_type`	varchar(34)	NULL	`text`		text, number, boolean, json
	`description`	varchar(255)	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_setup_guide`

15 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`software_id`	bigint unsigned	NOT NULL	-
FK	`title`	varchar(255)	NOT NULL	-
	`slug`	varchar(255)	NOT NULL	-
FK	`category`	varchar(50)	NOT NULL	`deployment`		security, deployment, configuration, optimization, troubleshooting, integration
	`content`	text	NOT NULL	-		Markdown content
	`short_description`	varchar(500)	NULL	-
	`author_name`	varchar(255)	NULL	-
	`author_user_id`	int	NULL	-
	`is_featured`	tinyint(1)	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`view_count`	int	NULL	`0`
	`sort_order`	int	NULL	`100`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_software`

46 columns 6 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`name`	varchar(255)	NOT NULL	-
UQ	`slug`	varchar(255)	NOT NULL	-
FK	`vendor_id`	bigint unsigned	NULL	-
FK	`category`	varchar(110)	NOT NULL	-		ams, ims, dam, dams, cms, preservation, digitization, discovery, utility, plugin, integration, theme, glam, other
	`description`	text	NULL	-
	`short_description`	varchar(500)	NULL	-
	`logo_path`	varchar(500)	NULL	-
	`screenshot_path`	varchar(500)	NULL	-
	`website`	varchar(500)	NULL	-
	`documentation_url`	varchar(500)	NULL	-
	`install_url`	varchar(500)	NULL	-
	`git_provider`	varchar(50)	NULL	`none`		github, gitlab, bitbucket, self_hosted, none
	`git_url`	varchar(500)	NULL	-
	`git_default_branch`	varchar(100)	NULL	-
	`git_latest_tag`	varchar(100)	NULL	-
	`git_latest_commit`	varchar(40)	NULL	-
	`git_is_public`	tinyint(1)	NULL	`1`
	`git_api_token_encrypted`	varchar(500)	NULL	-
	`is_internal`	tinyint(1)	NULL	`0`
	`upload_path`	varchar(500)	NULL	-
	`upload_filename`	varchar(255)	NULL	-
	`upload_size_bytes`	bigint	NULL	-
	`upload_checksum`	varchar(64)	NULL	-
	`license`	varchar(100)	NULL	-
	`license_url`	varchar(500)	NULL	-
	`latest_version`	varchar(50)	NULL	-
	`supported_platforms`	json	NULL	-
	`glam_sectors`	json	NULL	-
	`standards_supported`	json	NULL	-
	`languages`	json	NULL	-
	`min_php_version`	varchar(20)	NULL	-
	`min_mysql_version`	varchar(20)	NULL	-
	`requirements`	text	NULL	-
	`pricing_model`	varchar(65)	NULL	`open_source`		free, open_source, freemium, subscription, one_time, contact
	`pricing_details`	text	NULL	-
	`is_verified`	tinyint(1)	NULL	`0`
	`is_featured`	tinyint(1)	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`institution_count`	int	NULL	`0`
	`average_rating`	decimal(3,2)	NULL	`0.00`
	`rating_count`	int	NULL	`0`
	`download_count`	int	NULL	`0`
	`created_by`	int	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_software_component`

17 columns 84 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`software_id`	bigint unsigned	NOT NULL	-
	`name`	varchar(255)	NOT NULL	-
	`slug`	varchar(255)	NOT NULL	-
FK	`component_type`	varchar(65)	NULL	`plugin`		plugin, module, extension, theme, integration, library, other
FK	`category`	varchar(100)	NULL	-
	`description`	text	NULL	-
	`short_description`	varchar(500)	NULL	-
	`version`	varchar(50)	NULL	-
	`is_required`	tinyint(1)	NULL	`0`
	`is_active`	tinyint(1)	NULL	`1`
	`git_url`	varchar(500)	NULL	-
	`documentation_url`	varchar(500)	NULL	-
	`icon_class`	varchar(100)	NULL	-
	`sort_order`	int	NULL	`100`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_software_release`

17 columns 10 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`software_id`	bigint unsigned	NOT NULL	-
FK	`version`	varchar(50)	NOT NULL	-
	`release_type`	varchar(41)	NULL	`patch`		major, minor, patch, beta, rc, alpha
	`release_notes`	text	NULL	-
	`git_tag`	varchar(100)	NULL	-
	`git_commit`	varchar(40)	NULL	-
	`git_compare_url`	varchar(500)	NULL	-
	`file_path`	varchar(500)	NULL	-
	`file_name`	varchar(255)	NULL	-
	`file_size_bytes`	bigint	NULL	-
	`file_checksum`	varchar(64)	NULL	-
	`download_count`	int	NULL	`0`
	`is_stable`	tinyint(1)	NULL	`1`
FK	`is_latest`	tinyint(1)	NULL	`0`
	`released_at`	datetime	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_software_standard`

7 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`software_id`	bigint unsigned	NOT NULL	-
FK	`standard_id`	bigint unsigned	NOT NULL	-
	`conformance_level`	varchar(20)	NOT NULL	`partial`		full, partial, extended, planned
	`notes`	text	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_standard`

17 columns 27 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`name`	varchar(255)	NOT NULL	-
	`acronym`	varchar(50)	NULL	-
UQ	`slug`	varchar(255)	NOT NULL	-
FK	`category`	varchar(50)	NOT NULL	`descriptive`		descriptive, preservation, rights, accounting, compliance, metadata, interchange, sector
	`description`	text	NULL	-
	`short_description`	varchar(500)	NULL	-
	`website_url`	varchar(500)	NULL	-
	`issuing_body`	varchar(255)	NULL	-
	`current_version`	varchar(50)	NULL	-
	`publication_year`	int	NULL	-
	`sector_applicability`	json	NULL	-		["archive","library","museum","gallery","dam"]
	`is_featured`	tinyint(1)	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`sort_order`	int	NULL	`100`
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_standard_extension`

14 columns 14 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`standard_id`	bigint unsigned	NOT NULL	-
FK	`extension_type`	varchar(30)	NOT NULL	`addition`		addition, deviation, implementation_note, api_binding
	`title`	varchar(255)	NOT NULL	-
	`description`	text	NOT NULL	-
	`rationale`	text	NULL	-		Why this extension exists
FK	`plugin_name`	varchar(100)	NULL	-		Which plugin implements this
	`api_endpoint`	varchar(255)	NULL	-		API route if applicable
	`db_tables`	varchar(500)	NULL	-		Comma-separated table names affected
	`is_active`	tinyint(1)	NULL	`1`
	`sort_order`	int	NULL	`100`
	`created_by`	int	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_sync_log`

8 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`instance_id`	bigint unsigned	NOT NULL	-
FK	`event_type`	varchar(46)	NOT NULL	-		register, heartbeat, sync, update, error
	`payload`	json	NULL	-
	`ip_address`	varchar(45)	NULL	-
	`status`	varchar(23)	NULL	`success`		success, error
	`error_message`	text	NULL	-
FK	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_tag`

4 columns 13 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`entity_type`	varchar(37)	NOT NULL	-		institution, vendor, software
	`entity_id`	bigint unsigned	NOT NULL	-
FK	`tag`	varchar(100)	NOT NULL	-

`registry_user_group`

32 columns 5 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`name`	varchar(255)	NOT NULL	-
UQ	`slug`	varchar(255)	NOT NULL	-
	`description`	text	NULL	-
	`logo_path`	varchar(500)	NULL	-
	`banner_path`	varchar(500)	NULL	-
FK	`group_type`	varchar(53)	NULL	`regional`		regional, topic, software, institutional, other
	`focus_areas`	json	NULL	-
	`website`	varchar(255)	NULL	-
	`email`	varchar(255)	NULL	-
	`city`	varchar(100)	NULL	-
FK	`country`	varchar(100)	NULL	-
	`region`	varchar(100)	NULL	-
	`is_virtual`	tinyint(1)	NULL	`0`
	`meeting_frequency`	varchar(56)	NULL	-		weekly, biweekly, monthly, quarterly, annual, adhoc
	`meeting_format`	varchar(34)	NULL	-		in_person, virtual, hybrid
	`meeting_platform`	varchar(100)	NULL	-
	`next_meeting_at`	datetime	NULL	-
	`next_meeting_details`	text	NULL	-
	`mailing_list_url`	varchar(500)	NULL	-
	`slack_url`	varchar(500)	NULL	-
	`discord_url`	varchar(500)	NULL	-
	`forum_url`	varchar(500)	NULL	-
	`member_count`	int	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`is_featured`	tinyint(1)	NULL	`0`
	`is_verified`	tinyint(1)	NULL	`0`
	`created_by`	int	NULL	-
	`organizer_name`	varchar(255)	NULL	-
	`organizer_email`	varchar(255)	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_user_group_member`

10 columns 81 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`group_id`	bigint unsigned	NOT NULL	-
	`user_id`	int	NULL	-
	`name`	varchar(255)	NULL	-
FK	`email`	varchar(255)	NOT NULL	-
	`institution_id`	bigint unsigned	NULL	-
	`role`	varchar(55)	NULL	`member`		organizer, co_organizer, member, speaker, sponsor
	`is_active`	tinyint(1)	NULL	`1`
	`email_notifications`	tinyint(1)	NULL	`1`
	`joined_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED

`registry_vendor`

39 columns 2 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`name`	varchar(255)	NOT NULL	-
UQ	`slug`	varchar(255)	NOT NULL	-
	`vendor_type`	json	NULL	-
	`specializations`	json	NULL	-
	`description`	text	NULL	-
	`short_description`	varchar(500)	NULL	-
	`logo_path`	varchar(500)	NULL	-
	`banner_path`	varchar(500)	NULL	-
	`website`	varchar(255)	NULL	-
	`email`	varchar(255)	NULL	-
	`phone`	varchar(100)	NULL	-
	`street_address`	text	NULL	-
	`city`	varchar(100)	NULL	-
	`province_state`	varchar(100)	NULL	-
	`postal_code`	varchar(20)	NULL	-
FK	`country`	varchar(100)	NULL	-
	`company_registration`	varchar(100)	NULL	-
	`vat_number`	varchar(50)	NULL	-
	`established_year`	int	NULL	-
	`team_size`	varchar(33)	NULL	-		solo, 2-5, 6-20, 21-50, 50+
	`service_regions`	json	NULL	-
	`languages`	json	NULL	-
	`certifications`	json	NULL	-
	`github_url`	varchar(255)	NULL	-
	`gitlab_url`	varchar(255)	NULL	-
	`linkedin_url`	varchar(255)	NULL	-
	`is_verified`	tinyint(1)	NULL	`0`
	`is_featured`	tinyint(1)	NULL	`0`
FK	`is_active`	tinyint(1)	NULL	`1`
	`verification_notes`	text	NULL	-
	`verified_at`	datetime	NULL	-
	`verified_by`	int	NULL	-
	`client_count`	int	NULL	`0`
	`average_rating`	decimal(3,2)	NULL	`0.00`
	`rating_count`	int	NULL	`0`
	`created_by`	int	NULL	-
	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_vendor_call_log`

23 columns 0 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`vendor_id`	bigint unsigned	NOT NULL	-
FK	`institution_id`	bigint unsigned	NULL	-
	`logged_by_user_id`	int	NULL	-
	`logged_by_name`	varchar(255)	NULL	-
	`logged_by_email`	varchar(255)	NULL	-
FK	`interaction_type`	varchar(71)	NOT NULL	`call`		call, email, meeting, support_ticket, site_visit, video_call, other
	`direction`	varchar(26)	NULL	`outbound`		inbound, outbound
	`subject`	varchar(500)	NOT NULL	-
	`description`	text	NULL	-
FK	`status`	varchar(52)	NULL	`open`		open, in_progress, resolved, closed, escalated
FK	`priority`	varchar(32)	NULL	`medium`		low, medium, high, urgent
	`contact_name`	varchar(255)	NULL	-
	`contact_email`	varchar(255)	NULL	-
	`contact_phone`	varchar(100)	NULL	-
	`resolution`	text	NULL	-
	`resolved_at`	datetime	NULL	-
	`resolved_by`	varchar(255)	NULL	-
FK	`follow_up_date`	date	NULL	-
	`follow_up_notes`	text	NULL	-
	`duration_minutes`	int	NULL	-
FK	`created_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED
	`updated_at`	datetime	NOT NULL	`CURRENT_TIMESTAMP`	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

`registry_vendor_institution`

10 columns 1 rows

	Column	Type	Nullable	Default	Extra	Comment
PK	`id`	bigint unsigned	NOT NULL	-	auto_increment
FK	`vendor_id`	bigint unsigned	NOT NULL	-
FK	`institution_id`	bigint unsigned	NOT NULL	-
	`relationship_type`	varchar(84)	NOT NULL	-		developer, hosting, maintenance, consulting, digitization, training, integration
	`service_description`	text	NULL	-
	`start_date`	date	NULL	-
	`end_date`	date	NULL	-
	`is_active`	tinyint(1)	NULL	`1`
	`is_public`	tinyint(1)	NULL	`1`
	`created_at`	datetime	NOT 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.