5stone
Tables (32)
chat_message
- id — UUID
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- message_index — INTEGER — NOT NULL
- sender_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- intent_code — VARCHAR(80)
- workflow_code — VARCHAR(80)
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_session
- id — UUID
- workspace_id — UUID — NOT NULL
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id
- channel — VARCHAR(30) — NOT NULL
- user_identifier — VARCHAR(120)
- status — VARCHAR(20) — NOT NULL
- metadata — JSONB — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ
cluster_evaluation
- id — UUID
- evaluation_run_id — UUID — Foreign key → evaluation_run.id — NOT NULL
- cluster_key — VARCHAR(120) — NOT NULL
- sample_size — INTEGER — NOT NULL
- purity_score — NUMERIC(8,6)
- silhouette_score — NUMERIC(8,6)
- cohesion_score — NUMERIC(8,6)
- separation_score — NUMERIC(8,6)
- notes — TEXT
conversation
- id — UUID
- dataset_id — UUID — Foreign key → dataset.id — NOT NULL
- external_conversation_id — VARCHAR(120)
- channel — VARCHAR(30) — NOT NULL
- customer_identifier — VARCHAR(120)
- language_code — VARCHAR(16)
- started_at — TIMESTAMPTZ
- ended_at — TIMESTAMPTZ
- raw_payload — JSONB — NOT NULL
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
conversation_feature_snapshot
- id — UUID
- conversation_id — UUID — Foreign key → conversation.id — NOT NULL
- turn_id — UUID — Foreign key → conversation_turn.id
- snapshot_type — VARCHAR(30) — NOT NULL
- canonical_text — TEXT
- flow_signature — TEXT
- embedding_model — VARCHAR(120)
- feature_payload — JSONB — NOT NULL
- computed_at — TIMESTAMPTZ — NOT NULL
conversation_turn
- id — UUID
- conversation_id — UUID — Foreign key → conversation.id — NOT NULL
- turn_index — INTEGER — NOT NULL
- speaker_type — VARCHAR(20) — NOT NULL
- speaker_identifier — VARCHAR(120)
- message_text — TEXT — NOT NULL
- canonical_text — TEXT
- token_count — INTEGER
- created_at — TIMESTAMPTZ
- metadata — JSONB — NOT NULL
dataset
- id — UUID
- workspace_id — UUID — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- source_type — VARCHAR(30) — NOT NULL
- ingestion_status — VARCHAR(20) — NOT NULL
- uploaded_by — UUID
- record_count — INTEGER — NOT NULL
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
decision_log
- id — UUID
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- chat_message_id — UUID — Foreign key → chat_message.id
- workflow_execution_id — UUID — Foreign key → workflow_execution.id
- intent_definition_id — UUID — Foreign key → intent_definition.id
- policy_definition_id — UUID
- risk_definition_id — UUID — Foreign key → risk_definition.id
- decision_type — VARCHAR(30) — NOT NULL
- confidence_score — NUMERIC(8,6)
- decision_reason — TEXT
- detail — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
domain_pack
- id — UUID
- workspace_id — UUID — NOT NULL
- code — VARCHAR(80) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- lifecycle_status — VARCHAR(20) — NOT NULL
- created_by — UUID
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
domain_pack_version
- id — UUID
- domain_pack_id — UUID — Foreign key → domain_pack.id — NOT NULL
- version_no — INTEGER — NOT NULL
- version_label — VARCHAR(50)
- status — VARCHAR(20) — NOT NULL
- source_dataset_id — UUID — Foreign key → dataset.id
- created_by — UUID
- published_at — TIMESTAMPTZ
- changelog — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
evaluation_metric
- id — UUID
- evaluation_run_id — UUID — Foreign key → evaluation_run.id — NOT NULL
- metric_name — VARCHAR(80) — NOT NULL
- metric_value — NUMERIC(14,6) — NOT NULL
- metric_unit — VARCHAR(30)
- slice_key — VARCHAR(120)
- created_at — TIMESTAMPTZ — NOT NULL
evaluation_run
- id — UUID
- pipeline_job_id — UUID — Foreign key → pipeline_job.id — NOT NULL
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id
- evaluation_type — VARCHAR(40) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- summary — TEXT
- started_at — TIMESTAMPTZ — NOT NULL
- finished_at — TIMESTAMPTZ
intent_definition
- id — UUID
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id — NOT NULL
- code — VARCHAR(80) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- parent_intent_id — UUID — Foreign key → intent_definition.id
- status — VARCHAR(20) — NOT NULL
- representative_examples — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
intent_slot_binding
- intent_id — UUID — Foreign key → intent_definition.id — NOT NULL
- slot_id — UUID — Foreign key → slot_definition.id — NOT NULL
- binding_type — VARCHAR(20) — NOT NULL
- notes — TEXT
intent_workflow_binding
- intent_id — UUID — Foreign key → intent_definition.id — NOT NULL
- workflow_id — UUID — Foreign key → workflow_definition.id — NOT NULL
- priority — INTEGER — NOT NULL
- entry_condition — TEXT
novel_intent_candidate
- id — UUID
- pipeline_job_id — UUID — Foreign key → pipeline_job.id — NOT NULL
- dataset_id — UUID — Foreign key → dataset.id
- cluster_key — VARCHAR(120) — NOT NULL
- title — VARCHAR(150) — NOT NULL
- description — TEXT
- representative_text — TEXT
- confidence_score — NUMERIC(8,6)
- status — VARCHAR(20) — NOT NULL
- proposed_intent_code — VARCHAR(80)
- created_at — TIMESTAMPTZ — NOT NULL
pipeline_artifact
- id — UUID
- pipeline_job_id — UUID — Foreign key → pipeline_job.id — NOT NULL
- artifact_type — VARCHAR(40) — NOT NULL
- other — ))
- storage_uri — TEXT — NOT NULL
- content_hash — VARCHAR(128)
- version_label — VARCHAR(50)
- metadata — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
pipeline_job
- id — UUID
- workspace_id — UUID — NOT NULL
- dataset_id — UUID — Foreign key → dataset.id
- domain_pack_id — UUID — Foreign key → domain_pack.id
- job_type — VARCHAR(40) — NOT NULL
- publish — ))
- status — VARCHAR(20) — NOT NULL
- airflow_dag_id — VARCHAR(120)
- airflow_run_id — VARCHAR(120)
- requested_by — UUID
- started_at — TIMESTAMPTZ
- finished_at — TIMESTAMPTZ
- config_json — JSONB — NOT NULL
- error_message — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
pipeline_job_event
- id — UUID
- pipeline_job_id — UUID — Foreign key → pipeline_job.id — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- event_level — VARCHAR(20) — NOT NULL
- message — TEXT — NOT NULL
- payload — JSONB — NOT NULL
- event_at — TIMESTAMPTZ — NOT NULL
review_activity_log
- id — UUID
- review_session_id — UUID — NOT NULL
- actor_id — UUID
- action_type — VARCHAR(50) — NOT NULL
- target_table — VARCHAR(80)
- target_id — UUID
- detail — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
review_comment
- id — UUID
- review_task_id — UUID — Foreign key → review_task.id — NOT NULL
- author_id — UUID
- parent_comment_id — UUID — Foreign key → review_comment.id
- body — TEXT — NOT NULL
- is_resolved — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
review_decision
- id — UUID
- review_session_id — UUID — NOT NULL
- decided_by — UUID
- decision_type — VARCHAR(30) — NOT NULL
- rationale — TEXT
- decided_at — TIMESTAMPTZ — NOT NULL
review_summary_metric
- id — UUID
- review_session_id — UUID — NOT NULL
- metric_name — VARCHAR(80) — NOT NULL
- metric_value — NUMERIC(12,4) — NOT NULL
- metric_unit — VARCHAR(30)
- created_at — TIMESTAMPTZ — NOT NULL
review_task
- id — UUID
- review_session_id — UUID — NOT NULL
- task_type — VARCHAR(30) — NOT NULL
- target_table — VARCHAR(80)
- target_id — UUID
- title — VARCHAR(200) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- assignee_id — UUID
- priority — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
risk_definition
- id — UUID
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id — NOT NULL
- code — VARCHAR(80) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- severity — VARCHAR(20) — NOT NULL
- risk_text — TEXT — NOT NULL
- mitigation — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
session_outcome
- id — UUID
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- outcome_type — VARCHAR(20) — NOT NULL
- resolved_intent_code — VARCHAR(80)
- satisfaction_score — NUMERIC(4,2)
- summary — TEXT
- closed_at — TIMESTAMPTZ — NOT NULL
slot_definition
- id — UUID
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id — NOT NULL
- code — VARCHAR(80) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- value_type — VARCHAR(30) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- extraction_rule — TEXT
- description — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
taxonomy_drift_log
- id — UUID
- pipeline_job_id — UUID — Foreign key → pipeline_job.id — NOT NULL
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id
- drift_type — VARCHAR(40) — NOT NULL
- entity_type — VARCHAR(30) — NOT NULL
- entity_code — VARCHAR(120)
- drift_score — NUMERIC(8,6) — NOT NULL
- detail — JSONB — NOT NULL
- detected_at — TIMESTAMPTZ — NOT NULL
webhook_receipt
- id — UUID
- workspace_id — UUID — NOT NULL
- source_system — VARCHAR(50) — NOT NULL
- event_type — VARCHAR(80) — NOT NULL
- external_event_id — VARCHAR(150) — NOT NULL
- payload — JSONB — NOT NULL
- processing_status — VARCHAR(20) — NOT NULL
- processed_job_id — UUID — Foreign key → pipeline_job.id
- received_at — TIMESTAMPTZ — NOT NULL
workflow_definition
- id — UUID
- domain_pack_version_id — UUID — Foreign key → domain_pack_version.id — NOT NULL
- code — VARCHAR(80) — NOT NULL
- name — VARCHAR(150) — NOT NULL
- trigger_type — VARCHAR(30) — NOT NULL
- definition_json — JSONB — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
workflow_execution
- id — UUID
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- workflow_definition_id — UUID — Foreign key → workflow_definition.id
- trigger_message_id — UUID — Foreign key → chat_message.id
- status — VARCHAR(20) — NOT NULL
- current_step_name — VARCHAR(120)
- context_json — JSONB — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ
workflow_execution_step
- id — UUID
- workflow_execution_id — UUID — Foreign key → workflow_execution.id — NOT NULL
- step_index — INTEGER — NOT NULL
- step_name — VARCHAR(120) — NOT NULL
- step_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- input_payload — JSONB — NOT NULL
- output_payload — JSONB — NOT NULL
- error_message — TEXT
- started_at — TIMESTAMPTZ — NOT NULL
- ended_at — TIMESTAMPTZ