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