dbml public.graph_metrics       public.graph_metrics        metric_name     character varying(255) (!) counter     bigint (!) last_measured_counter     bigint (!) last_measured_at     timestamp without time zone updated_at     timestamp without time zone notes     text public.schema_migrations       public.schema_migrations        version     integer (!) name     text (!) applied_at     timestamp without time zone (!) kg_api.aggressiveness_profiles       kg_api.aggressiveness_profiles        profile_name     character varying(50) (!) control_x1     double precision (!) control_y1     double precision (!) control_x2     double precision (!) control_y2     double precision (!) description     text is_builtin     boolean created_at     timestamp without time zone updated_at     timestamp without time zone kg_api.ai_extraction_config       kg_api.ai_extraction_config        id     integer (!) provider     character varying(50) (!) model_name     character varying(200) (!) supports_vision     boolean supports_json_mode     boolean max_tokens     integer created_at     timestamp with time zone updated_at     timestamp with time zone updated_by     character varying(100) active     boolean base_url     character varying(255) temperature     double precision top_p     double precision gpu_layers     integer num_threads     integer thinking_mode     character varying(20) max_concurrent_requests     integer max_retries     integer kg_api.ai_vision_config       kg_api.ai_vision_config        id     integer (!) provider     character varying(50) (!) model_name     character varying(200) (!) max_tokens     integer temperature     double precision created_at     timestamp with time zone updated_at     timestamp with time zone updated_by     character varying(100) active     boolean kg_api.annealing_options       kg_api.annealing_options        key     character varying(100) (!) value     text (!) description     text updated_at     timestamp with time zone kg_api.annealing_pressure_history       kg_api.annealing_pressure_history        id     integer (!) epoch     integer (!) total_ontologies     integer (!) total_concepts     integer (!) avg_concepts_per_ontology     double precision (!) pressure_score     double precision (!) pressure_zone     character varying(20) (!) pressure_recommendation     jsonb (!) recorded_at     timestamp with time zone (!) kg_api.annealing_proposals       kg_api.annealing_proposals        id     integer (!) proposal_type     character varying(20) (!) ontology_name     character varying(200) (!) anchor_concept_id     character varying(100) target_ontology     character varying(200) reasoning     text (!) mass_score     numeric(10,4) coherence_score     numeric(10,4) protection_score     numeric(10,4) status     character varying(20) (!) created_at     timestamp with time zone (!) created_at_epoch     integer (!) reviewed_at     timestamp with time zone reviewed_by     character varying(100) reviewer_notes     text expires_at     timestamp with time zone executed_at     timestamp with time zone execution_result     jsonb suggested_name     character varying(200) suggested_description     text proposal_kind     character varying(20) (!) params     jsonb kg_api.artifacts       kg_api.artifacts        id     integer (!) artifact_type     character varying(50) (!) representation     character varying(50) (!) name     character varying(200) owner_id     integer graph_epoch     bigint (!) created_at     timestamp with time zone (!) expires_at     timestamp with time zone parameters     jsonb (!) metadata     jsonb inline_result     jsonb garage_key     character varying(200) query_definition_id     integer ontology     character varying(200) concept_ids     text[] kg_api.query_definitions       kg_api.query_definitions        id     integer (!) name     character varying(200) (!) definition_type     character varying(50) (!) definition     jsonb (!) owner_id     integer created_at     timestamp with time zone (!) updated_at     timestamp with time zone (!) metadata     jsonb kg_api.artifacts:e->kg_api.query_definitions:w kg_auth.users       kg_auth.users        id     integer (!) username     character varying(100) (!) password_hash     character varying(255) (!) primary_role     character varying(50) (!) created_at     timestamp with time zone (!) last_login     timestamp with time zone disabled     boolean kg_api.artifacts:e->kg_auth.users:w kg_api.catalog_edge       kg_api.catalog_edge        parent_kind     character varying(16) (!) parent_id     text (!) child_kind     character varying(16) (!) child_id     text (!) graph_epoch     bigint (!) kg_api.catalog_node       kg_api.catalog_node        kind     character varying(16) (!) node_id     text (!) name     text (!) name_lower     text (!) child_count     integer (!) content_type     character varying(32) properties     jsonb (!) graph_epoch     bigint (!) indexed_at     timestamp with time zone (!) kg_api.concept_access_stats       kg_api.concept_access_stats        concept_id     character varying(100) (!) access_count     integer last_accessed     timestamp with time zone avg_query_time_ms     numeric(10,2) queries_as_start     integer queries_as_result     integer kg_api.concept_version_metadata       kg_api.concept_version_metadata        concept_id     character varying(100) (!) created_in_version     integer last_modified_version     integer kg_api.ontology_versions       kg_api.ontology_versions        version_id     integer (!) version_number     character varying(20) (!) created_at     timestamp with time zone (!) created_by     character varying(100) change_summary     text is_active     boolean vocabulary_snapshot     jsonb (!) types_added     text[] types_aliased     jsonb types_deprecated     text[] backward_compatible     boolean migration_required     boolean kg_api.concept_version_metadata:e->kg_api.ontology_versions:w kg_api.concept_version_metadata:e->kg_api.ontology_versions:w kg_api.edge_usage_stats       kg_api.edge_usage_stats        from_concept_id     character varying(100) (!) to_concept_id     character varying(100) (!) relationship_type     character varying(100) (!) traversal_count     integer last_traversed     timestamp with time zone avg_query_time_ms     numeric(10,2) kg_api.embedding_config_legacy       kg_api.embedding_config_legacy        id     integer (!) provider     character varying(50) (!) model_name     character varying(200) (!) embedding_dimensions     integer (!) precision     character varying(20) (!) max_memory_mb     integer num_threads     integer device     character varying(20) batch_size     integer max_seq_length     integer normalize_embeddings     boolean created_at     timestamp with time zone updated_at     timestamp with time zone updated_by     character varying(100) active     boolean delete_protected     boolean change_protected     boolean kg_api.embedding_generation_jobs       kg_api.embedding_generation_jobs        job_id     uuid (!) job_type     character varying(50) (!) target_types     character varying(100)[] target_count     integer status     character varying(20) (!) processed_count     integer failed_count     integer embedding_model     character varying(100) embedding_provider     character varying(50) created_at     timestamp with time zone started_at     timestamp with time zone completed_at     timestamp with time zone duration_ms     integer result_summary     jsonb error_message     text kg_api.embedding_profile       kg_api.embedding_profile        id     integer (!) name     character varying(200) (!) vector_space     character varying(100) (!) multimodal     boolean text_provider     character varying(50) (!) text_model_name     character varying(200) (!) text_loader     character varying(50) (!) text_revision     character varying(200) text_dimensions     integer (!) text_precision     character varying(20) text_trust_remote_code     boolean image_provider     character varying(50) image_model_name     character varying(200) image_loader     character varying(50) image_revision     character varying(200) image_dimensions     integer image_precision     character varying(20) image_trust_remote_code     boolean device     character varying(20) max_memory_mb     integer num_threads     integer batch_size     integer max_seq_length     integer normalize_embeddings     boolean active     boolean delete_protected     boolean change_protected     boolean created_at     timestamp with time zone updated_at     timestamp with time zone updated_by     character varying(100) text_query_prefix     character varying(200) text_document_prefix     character varying(200) image_vector_space     character varying(100) kg_api.graph_epoch_kinds       kg_api.graph_epoch_kinds        kind     text (!) semantic_wallclock     boolean (!) description     text kg_api.graph_epochs       kg_api.graph_epochs        event_id     bigint (!) occurred_at     timestamp with time zone (!) kind     text (!) actor     text counter_after     bigint metadata     jsonb (!) status     text (!) kg_api.graph_epochs:e->kg_api.graph_epoch_kinds:w kg_api.jobs       kg_api.jobs        job_id     text (!) job_type     text (!) content_hash     text ontology     text status     text (!) progress     text result     text error     text created_at     timestamp without time zone (!) started_at     timestamp without time zone completed_at     timestamp without time zone job_data     jsonb (!) analysis     text approved_at     timestamp without time zone approved_by     text expires_at     timestamp without time zone processing_mode     text job_source     character varying(50) created_by     character varying(100) is_system_job     boolean user_id     integer (!) source_filename     text source_type     text source_path     text source_hostname     text artifact_id     integer priority     integer (!) claimed_by     text claimed_at     timestamp with time zone cancelled     boolean (!) retries     integer (!) max_retries     integer (!) kg_api.jobs:e->kg_api.artifacts:w kg_api.jobs:e->kg_auth.users:w kg_api.ontology_tombstones       kg_api.ontology_tombstones        name     character varying(200) (!) removed_at     timestamp with time zone (!) removed_by     character varying(100) reason     text kg_api.platform_config       kg_api.platform_config        key     character varying(100) (!) value     text (!) description     text updated_at     timestamp with time zone updated_by     character varying(100) kg_api.provider_model_catalog       kg_api.provider_model_catalog        id     integer (!) provider     character varying(50) (!) model_id     character varying(300) (!) display_name     character varying(300) category     character varying(50) (!) context_length     integer max_completion_tokens     integer supports_vision     boolean supports_json_mode     boolean supports_tool_use     boolean supports_streaming     boolean price_prompt_per_m     numeric price_completion_per_m     numeric price_cache_read_per_m     numeric enabled     boolean is_default     boolean sort_order     integer upstream_provider     character varying(100) raw_metadata     jsonb fetched_at     timestamp with time zone created_at     timestamp with time zone updated_at     timestamp with time zone kg_api.pruning_recommendations       kg_api.pruning_recommendations        id     integer (!) relationship_type     character varying(100) (!) target_type     character varying(100) action_type     character varying(50) (!) review_level     character varying(20) (!) reasoning     text (!) similarity     numeric(4,3) value_score     numeric(10,2) metadata     jsonb status     character varying(50) (!) created_at     timestamp with time zone (!) reviewed_at     timestamp with time zone reviewed_by     character varying(100) reviewer_notes     text executed_at     timestamp with time zone expires_at     timestamp with time zone kg_api.query_definitions:e->kg_auth.users:w kg_api.rate_limits       kg_api.rate_limits        client_id     character varying(100) (!) endpoint     character varying(200) (!) window_start     timestamp with time zone (!) request_count     integer (!) kg_api.relationship_vocabulary       kg_api.relationship_vocabulary        relationship_type     character varying(100) (!) description     text category     character varying(50) added_by     character varying(100) added_at     timestamp with time zone (!) usage_count     integer is_active     boolean is_builtin     boolean synonyms     character varying(100)[] deprecation_reason     text embedding     jsonb embedding_model     character varying(100) embedding_generated_at     timestamp with time zone grounding_contribution     double precision last_grounding_calculated     timestamp with time zone avg_confidence     double precision semantic_diversity     double precision embedding_quality_score     double precision embedding_validation_status     character varying(20) category_source     character varying(20) category_confidence     double precision category_scores     jsonb category_ambiguous     boolean direction_semantics     character varying(20) kg_api.scheduled_jobs       kg_api.scheduled_jobs        id     integer (!) name     character varying(100) (!) launcher_class     character varying(255) (!) schedule_cron     character varying(100) (!) enabled     boolean max_retries     integer retry_count     integer last_run     timestamp without time zone last_success     timestamp without time zone last_failure     timestamp without time zone next_run     timestamp without time zone created_at     timestamp without time zone updated_at     timestamp without time zone kg_api.schema_migrations       kg_api.schema_migrations        version     integer (!) description     text (!) applied_at     timestamp without time zone (!) kg_api.sessions       kg_api.sessions        session_id     character varying(100) (!) user_id     integer created_at     timestamp with time zone (!) expires_at     timestamp with time zone (!) last_activity     timestamp with time zone (!) metadata     jsonb kg_api.skipped_relationships       kg_api.skipped_relationships        id     integer (!) relationship_type     character varying(100) (!) from_concept_label     character varying(500) to_concept_label     character varying(500) job_id     character varying(50) ontology     character varying(200) first_seen     timestamp with time zone (!) last_seen     timestamp with time zone (!) occurrence_count     integer sample_context     jsonb kg_api.source_embeddings       kg_api.source_embeddings        embedding_id     integer (!) source_id     text (!) chunk_index     integer (!) chunk_strategy     text (!) start_offset     integer (!) end_offset     integer (!) chunk_text     text (!) chunk_hash     text (!) source_hash     text (!) embedding     bytea (!) embedding_model     text (!) embedding_dimension     integer (!) embedding_provider     text created_at     timestamp with time zone updated_at     timestamp with time zone kg_api.synonym_clusters       kg_api.synonym_clusters        cluster_id     uuid (!) representative_type     character varying(100) member_types     character varying(100)[] avg_similarity     double precision cluster_size     integer total_usage_count     integer detected_at     timestamp with time zone detection_method     character varying(50) is_active     boolean merge_recommended     boolean merge_completed_at     timestamp with time zone kg_api.synonym_clusters:e->kg_api.relationship_vocabulary:w kg_api.system_api_keys       kg_api.system_api_keys        provider     character varying(50) (!) encrypted_key     bytea (!) updated_at     timestamp with time zone validation_status     character varying(20) last_validated_at     timestamp with time zone validation_error     text kg_api.system_initialization_status       kg_api.system_initialization_status        component     character varying(50) (!) initialized     boolean initialized_at     timestamp with time zone initialization_job_id     uuid version     character varying(20) metadata     jsonb last_processed_vocab_change_counter     bigint (!) kg_api.system_initialization_status:e->kg_api.embedding_generation_jobs:w kg_api.vocabulary_audit       kg_api.vocabulary_audit        id     integer (!) relationship_type     character varying(100) action     character varying(50) (!) performed_by     character varying(100) performed_at     timestamp with time zone (!) details     jsonb kg_api.vocabulary_config       kg_api.vocabulary_config        key     character varying(100) (!) value     text (!) description     text updated_at     timestamp with time zone (!) updated_by     character varying(100) kg_api.vocabulary_history       kg_api.vocabulary_history        id     integer (!) relationship_type     character varying(100) (!) action     character varying(50) (!) performed_by     character varying(100) (!) performed_at     timestamp with time zone (!) target_type     character varying(100) reason     text metadata     jsonb aggressiveness     numeric(4,3) zone     character varying(20) vocab_size_before     integer vocab_size_after     integer kg_api.vocabulary_suggestions       kg_api.vocabulary_suggestions        id     integer (!) relationship_type     character varying(100) (!) suggestion_type     character varying(50) (!) confidence     numeric(3,2) (!) suggested_canonical_type     character varying(100) suggested_category     character varying(50) suggested_description     text similar_types     jsonb reasoning     text created_at     timestamp with time zone (!) reviewed     boolean curator_decision     character varying(50) curator_notes     text kg_api.worker_lanes       kg_api.worker_lanes        name     text (!) job_types     text[] (!) max_slots     integer (!) poll_interval_ms     integer (!) stale_timeout_minutes     integer (!) enabled     boolean (!) updated_at     timestamp with time zone (!) kg_api.worker_status       kg_api.worker_status        worker_id     character varying(100) (!) last_heartbeat     timestamp with time zone (!) current_job_id     character varying(50) status     character varying(50) (!) metadata     jsonb kg_auth.groups       kg_auth.groups        id     integer (!) group_name     character varying(100) (!) display_name     character varying(200) description     text is_system     boolean created_at     timestamp with time zone (!) created_by     integer kg_auth.groups:e->kg_auth.users:w kg_auth.oauth_access_tokens       kg_auth.oauth_access_tokens        token_hash     character varying(255) (!) client_id     character varying(255) (!) user_id     integer scopes     text[] expires_at     timestamp with time zone (!) revoked     boolean created_at     timestamp with time zone kg_auth.oauth_clients       kg_auth.oauth_clients        client_id     character varying(255) (!) client_secret_hash     character varying(255) client_name     character varying(255) (!) client_type     character varying(50) (!) grant_types     text[] (!) redirect_uris     text[] scopes     text[] is_active     boolean created_by     integer created_at     timestamp with time zone metadata     jsonb kg_auth.oauth_access_tokens:e->kg_auth.oauth_clients:w kg_auth.oauth_access_tokens:e->kg_auth.users:w kg_auth.oauth_authorization_codes       kg_auth.oauth_authorization_codes        code     character varying(255) (!) client_id     character varying(255) (!) user_id     integer (!) redirect_uri     text (!) scopes     text[] code_challenge     character varying(255) code_challenge_method     character varying(10) expires_at     timestamp with time zone (!) used     boolean created_at     timestamp with time zone kg_auth.oauth_authorization_codes:e->kg_auth.oauth_clients:w kg_auth.oauth_authorization_codes:e->kg_auth.users:w kg_auth.oauth_clients:e->kg_auth.users:w kg_auth.oauth_device_codes       kg_auth.oauth_device_codes        device_code     character varying(255) (!) user_code     character varying(50) (!) client_id     character varying(255) (!) user_id     integer scopes     text[] status     character varying(50) expires_at     timestamp with time zone (!) created_at     timestamp with time zone kg_auth.oauth_device_codes:e->kg_auth.oauth_clients:w kg_auth.oauth_device_codes:e->kg_auth.users:w kg_auth.oauth_external_provider_tokens       kg_auth.oauth_external_provider_tokens        token_hash     character varying(255) (!) user_id     integer provider     character varying(50) scopes     text[] expires_at     timestamp with time zone (!) kg_auth.oauth_external_provider_tokens:e->kg_auth.users:w kg_auth.oauth_refresh_tokens       kg_auth.oauth_refresh_tokens        token_hash     character varying(255) (!) client_id     character varying(255) (!) user_id     integer (!) scopes     text[] access_token_hash     character varying(255) expires_at     timestamp with time zone (!) revoked     boolean created_at     timestamp with time zone last_used     timestamp with time zone kg_auth.oauth_refresh_tokens:e->kg_auth.oauth_access_tokens:w kg_auth.oauth_refresh_tokens:e->kg_auth.oauth_clients:w kg_auth.oauth_refresh_tokens:e->kg_auth.users:w kg_auth.resource_grants       kg_auth.resource_grants        id     integer (!) resource_type     character varying(50) (!) resource_id     character varying(200) (!) principal_type     character varying(20) (!) principal_id     integer (!) permission     character varying(20) (!) granted_at     timestamp with time zone (!) granted_by     integer kg_auth.resource_grants:e->kg_auth.users:w kg_auth.resources       kg_auth.resources        resource_type     character varying(100) (!) description     text parent_type     character varying(100) available_actions     character varying(50)[] (!) supports_scoping     boolean metadata     jsonb registered_at     timestamp with time zone (!) registered_by     character varying(100) kg_auth.resources:e->kg_auth.resources:w kg_auth.role_permissions       kg_auth.role_permissions        id     integer (!) role_name     character varying(50) (!) resource_type     character varying(100) (!) action     character varying(50) (!) scope_type     character varying(50) scope_id     character varying(200) scope_filter     jsonb granted     boolean (!) inherited_from     character varying(50) created_at     timestamp with time zone (!) created_by     integer kg_auth.role_permissions:e->kg_auth.resources:w kg_auth.roles       kg_auth.roles        role_name     character varying(50) (!) display_name     character varying(100) (!) description     text is_builtin     boolean is_active     boolean parent_role     character varying(50) created_at     timestamp with time zone (!) created_by     integer metadata     jsonb kg_auth.role_permissions:e->kg_auth.roles:w kg_auth.role_permissions:e->kg_auth.roles:w kg_auth.role_permissions:e->kg_auth.users:w kg_auth.roles:e->kg_auth.roles:w kg_auth.roles:e->kg_auth.users:w kg_auth.user_groups       kg_auth.user_groups        user_id     integer (!) group_id     integer (!) added_at     timestamp with time zone (!) added_by     integer kg_auth.user_groups:e->kg_auth.groups:w kg_auth.user_groups:e->kg_auth.users:w kg_auth.user_groups:e->kg_auth.users:w kg_auth.user_roles       kg_auth.user_roles        id     integer (!) user_id     integer (!) role_name     character varying(50) (!) scope_type     character varying(50) scope_id     character varying(200) assigned_at     timestamp with time zone (!) assigned_by     integer expires_at     timestamp with time zone kg_auth.user_roles:e->kg_auth.roles:w kg_auth.user_roles:e->kg_auth.users:w kg_auth.user_roles:e->kg_auth.users:w kg_auth.users:e->kg_auth.roles:w kg_logs.api_metrics       kg_logs.api_metrics        id     integer (!) timestamp     timestamp with time zone (!) endpoint     character varying(200) (!) method     character varying(10) (!) status_code     integer (!) duration_ms     numeric(10,2) (!) client_id     character varying(100) error_message     text kg_logs.audit_trail       kg_logs.audit_trail        id     integer (!) timestamp     timestamp with time zone (!) user_id     integer action     character varying(100) (!) resource_type     character varying(50) (!) resource_id     character varying(200) details     jsonb ip_address     inet user_agent     text outcome     character varying(50) (!) kg_logs.health_checks       kg_logs.health_checks        id     integer (!) timestamp     timestamp with time zone (!) service     character varying(50) (!) status     character varying(50) (!) metrics     jsonb kg_logs.job_events       kg_logs.job_events        id     integer (!) job_id     character varying(50) (!) timestamp     timestamp with time zone (!) event_type     character varying(50) (!) details     jsonb
publickg_apikg_authkg_logs
Drag to pan · scroll to zoom · click a table to trace its relationships