Constraints

43 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

package_export_config_package_group_id_fk

package_export_config.package_id

package_group.id

Cascade on delete

FK_build_depends_depend

build_depends.depend_id

build.build_id

Cascade on delete

FK_build_depends_id

build_depends.build_id

build.build_id

Cascade on delete

build_package_group_id_fk

build.package_id

package_group.id

Cascade on delete

comparison_internal_document_data_fk

comparison_internal_document.hash

comparison_internal_document_data.hash

Restrict delete

comparison_internal_document_version_comparison_fk

comparison_internal_document.package_id

comparison_internal_document.version

comparison_internal_document.revision

comparison_internal_document.previous_package_id

comparison_internal_document.previous_version

comparison_internal_document.previous_revision

version_comparison.package_id

version_comparison.version

version_comparison.revision

version_comparison.previous_package_id

version_comparison.previous_version

version_comparison.previous_revision

Cascade on delete

version_internal_document_published_version_fk

version_internal_document.package_id

version_internal_document.version

version_internal_document.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

version_internal_document_data_fk

version_internal_document.hash

version_internal_document_data.hash

Restrict delete

published_data_package_group_id_fk

published_data.package_id

package_group.id

Cascade on delete

FK_published_sources_version_revision

published_sources.package_id

published_sources.version

published_sources.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_published_version_validation

published_version_validation.package_id

published_version_validation.version

published_version_validation.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_published_version

published_version_reference.package_id

published_version_reference.version

published_version_reference.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_user_data

external_identity.internal_id

user_data.user_id

Cascade on delete

personal_access_tokens_user_fk

personal_access_tokens.user_id

user_data.user_id

Restrict delete

FK_build_result_build_id

build_result.build_id

build.build_id

Cascade on delete

FK_operation

grouped_operation.package_id

grouped_operation.version

grouped_operation.revision

grouped_operation.operation_id

operation.package_id

operation.version

operation.revision

operation.operation_id

Cascade on delete

FK_operation_group

grouped_operation.group_id

operation_group.group_id

Cascade on delete

FK_version_comparison

operation_comparison.comparison_id

version_comparison.comparison_id

Cascade on delete

error_build_notification_build_id_fk

error_build_notification.build_id

build.build_id

Cascade on delete

FK_package_group

published_version.package_id

package_group.id

Cascade on delete

ddl_comparison_version_comparison_comparison_id_fk

ddl_comparison.comparison_id

version_comparison.comparison_id

Cascade on delete

fk_published_version_notification

published_version_notification.package_id

published_version_notification.version

published_version_notification.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_package_group_workspace

package_service.workspace_id

package_group.id

Cascade on delete

FK_package_group

package_service.package_id

package_group.id

Cascade on delete

operation_open_count_package_group_id_fk

operation_open_count.package_id

package_group.id

Cascade on delete

FK_transformed_content_data_operation_group

transformed_content_data.group_id

operation_group.group_id

Cascade on delete

FK_favorite_packages_package_group

favorite_packages.package_id

package_group.id

Cascade on delete

FK_favorite_packages_user_data

favorite_packages.user_id

user_data.user_id

Cascade on delete

FK_published_version

operation_group.package_id

operation_group.version

operation_group.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_published_version_revision

published_version_revision_content.package_id

published_version_revision_content.version

published_version_revision_content.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

published_version_revision_content_published_data_fk

published_version_revision_content.checksum

published_version_revision_content.package_id

published_data.checksum

published_data.package_id

Restrict delete

FK_package_group

package_member_role.package_id

package_group.id

Cascade on delete

published_version_open_count_package_group_id_fk

published_version_open_count.package_id

package_group.id

Cascade on delete

ai_chat_user_fk

ai_chat.user_id

user_data.user_id

Cascade on delete

ai_chat_message_chat_fk

ai_chat_message.chat_id

Cascade on delete

shared_url_info_package_group_id_fk

shared_url_info.package_id

package_group.id

Cascade on delete

FK_published_version

operation.package_id

operation.version

operation.revision

published_version.package_id

published_version.version

published_version.revision

Cascade on delete

FK_operation_data

operation.data_hash

operation_data.data_hash

Cascade on delete

activity_tracking_package_group_id_fk

activity_tracking.package_id

package_group.id

Cascade on delete

published_document_open_count_package_group_id_fk

published_document_open_count.package_id

package_group.id

Cascade on delete

FK_build_src

build_src.build_id

build.build_id

Cascade on delete

version_comparison_notification_comparison_id_fk

version_comparison_notification.comparison_id

version_comparison.comparison_id

Cascade on delete

FK_parent_package_group

package_group.parent_id

package_group.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
mcp_entities	mcp_entities_kind_check	(((kind)::text = ANY ((ARRAY['init'::character varying, 'tool'::character varying, 'prompt'::character varying, 'resource'::character varying])::text[])))
ddl_tables	ddl_tables_kind_check	(((kind)::text = ANY ((ARRAY['table'::character varying, 'view'::character varying])::text[])))