portal_backend.public

TABLES 74

COLUMNS 515

Constraints 43

Anomalies 15

Routines 5

Database Properties

Database Type: PostgreSQL - 16.15 (Debian 16.15-1.pgdg13+2)

Schema public

standard public schema

Tables

Table / View	Children	Parents	Columns	Type
ephemeral_file	0	0	8	Table
package_export_config	0	1	2	Table
sources_update_tracking	0	0	8	Table
stored_schema_migration	0	0	5	Table
migrated_version_changes	0	0	7	Table
build_depends	0	2	2	Table
build	5	1	14	Table
operation_group_history	0	0	6	Table
version_internal_document_data	1	0	2	Table
user_data	4	1	6	Table
operation_group_template	0	0	2	Table
endpoint_calls	0	0	4	Table
operation_group_publication	0	0	3	Table
comparison_internal_document	0	7	9	Table
comparisons_cleanup_run	0	0	8	Table
version_internal_document	0	4	6	Table
published_data	2	1	4	Table
system_role	0	0	2	Table
apihub_api_keys	0	1	10	Table
version_comparison	9	0	15	Table
mcp_entities	0	0	12	Table
mcp_entity_data	0	0	2	Table
unreferenced_data_cleanup_run	0	0	7	Table
fts_mcp_search_text	0	0	8	Table
ddl_table_data	0	0	2	Table
published_sources	0	3	6	Table
published_version_validation	0	3	6	Table
published_version_reference	0	3	10	Table
user_avatar_data	0	0	3	Table
export_result	0	0	6	Table
external_identity	0	1	4	Table
personal_access_tokens	0	2	7	Table
build_result	0	1	2	Table
grouped_operation	0	5	5	Table
operation_comparison	0	1	14	Table
package_transition	0	0	2	Table
error_build_notification	0	1	6	Table
published_version	24	1	12	Table
ddl_comparison	0	5	22	Table
ddl_tables	0	2	12	Table
published_version_notification	0	3	8	Table
business_metric	0	0	6	Table
package_service	0	2	3	Table
operation_open_count	0	1	4	Table
transformed_content_data	0	1	9	Table
role	0	0	5	Table
favorite_packages	0	2	2	Table
build_cleanup_run	0	0	8	Table
fts_operation_search_text	0	0	8	Table
migration_changes	0	0	2	Table
schema_migrations	0	0	2	Table
locks	12	0	5	Table
soft_deleted_data_cleanup_run	0	0	8	Table
published_sources_archives	0	0	2	Table
operation_group	2	3	10	Table
published_version_revision_content	0	6	17	Table
comparison_internal_document_data	1	0	2	Table
versions_cleanup_run	0	0	9	Table
package_member_role	0	1	7	Table
fts_ddl_search_text	0	0	8	Table
published_version_open_count	0	1	3	Table
csv_dashboard_publication	0	0	4	Table
ai_chat	1	1	10	Table
migration_run	0	0	18	Table
ai_chat_message	0	1	7	Table
shared_url_info	0	1	4	Table
operation_data	1	0	2	Table
operation	4	4	18	Table
activity_tracking	0	1	6	Table
published_document_open_count	0	1	4	Table
build_src	0	1	3	Table
version_comparison_notification	0	1	12	Table
activity_tracking_transition	0	0	12	Table
package_group	14	3	16	Table