Constraints

39 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
published_data_package_group_id_fk
published_data.package_id
package_group.id
Cascade on delete
ts_graphql_operation_data_operation_data_hash_fk
ts_graphql_operation_data.data_hash
operation_data.data_hash
Restrict delete
published_sources_published_sources_archives_checksum_fk
published_sources.archive_checksum
published_sources_archives.checksum
Restrict 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
ts_operation_data_operation_data_hash_fk
ts_operation_data.data_hash
operation_data.data_hash
Restrict delete
FK_user_data
external_identity.internal_id
user_data.user_id
Cascade on delete
builder_notifications_build_id_fkey
builder_notifications.build_id
build.build_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
ts_rest_operation_data_operation_data_hash_fk
ts_rest_operation_data.data_hash
operation_data.data_hash
Restrict delete
FK_version_comparison
operation_comparison.comparison_id
version_comparison.comparison_id
Cascade on delete
FK_package_group
published_version.package_id
package_group.id
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
fts_operation_data_operation_data_hash_fk
fts_operation_data.data_hash
operation_data.data_hash
Restrict 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
FK_parent_package_group
package_group.parent_id
package_group.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint