Data model

"BACKTEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_profile_ref": UUID 
  "dataset_document_ids_to_backtest": ARRAY 
  "description": TEXT 
  "name": VARCHAR(255) 
}
"BACKTESTED_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "backtest_id": UUID 
  "category": VARCHAR(255) 
  "category_actual": VARCHAR(255) 
  "category_expected": VARCHAR(255) 
  "category_is_equal": BOOLEAN 
  "classification_result_actual": JSONB 
  "classification_result_expected": JSONB 
  "commit": VARCHAR(40) 
  "dataset_document_id": UUID 
  "env": VARCHAR(20) 
  "extraction_reasons_for_review": ARRAY 
  "extraction_rejection_content_actual": JSONB 
  "extraction_rejection_content_expected": JSONB 
  "extraction_result_actual": JSONB 
  "extraction_result_expected": JSONB 
  "is_validated": BOOLEAN 
  "mismatch_report": JSONB 
  "reference_extraction_version": INTEGER 
  "rejection_content_is_equal": BOOLEAN 
  "run_at": DATETIME 
  "run_name": VARCHAR(255) 
  "subcategory": VARCHAR(255) 
  "subcategory_actual": VARCHAR(255) 
  "subcategory_expected": VARCHAR(255) 
  "subcategory_is_equal": BOOLEAN 
  "type": VARCHAR(255) 
}
"DATASET_DOCUMENT_LINK" {
  shape: sql_table
  "dataset_document_id": UUID 
  "dataset_id": UUID 
}
"DATASET" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_profile_ref": UUID 
  "description": TEXT 
  "is_usable_for_rag": BOOLEAN 
  "name": VARCHAR(255) 
  "slug": VARCHAR(255) 
}
"DOCUMENT_EMBEDDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_id": VARCHAR(36) 
  "document_metadata": JSONB 
  "embedding_all_minilm_l6_v2": VECTOR(384) 
  "embedding_all_minilm_l6_v2_indexed": VECTOR(384) 
  "embedding_text_embedding_3_large": VECTOR(3072) 
  "embedding_text_embedding_ada_002": VECTOR(1536) 
  "text": TEXT 
  "type": VARCHAR(255) 
}
"DATASET_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "classification_result": JSONB 
  "document_ref": UUID 
  "document_type": VARCHAR(255) 
  "extraction_result": JSONB 
  "markdown_text": TEXT 
  "markdown_text_embedding_all_minilm_l6_v2": VECTOR(384) 
  "rejection_reasons": ARRAY 
  "review_context": JSONB 
  "uri": VARCHAR(2083) 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "content_hash": VARCHAR(64) 
  "document_type": VARCHAR(255) 
  "mime_type": VARCHAR(255) 
  "thumbnail_uris": JSONB 
  "upload_metadata": JSONB 
  "uploader_ref": VARCHAR(255) 
  "uri": VARCHAR(2083) 
}
"DOCUMENT_TRANSCRIPTION_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_ref": VARCHAR(255) 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "document_id": UUID 
  "operator_comment": TEXT 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "transcription_context": JSONB 
  "uri": VARCHAR(2083) 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"DOCUMENT_CLASSIFICATION_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "classification_context": JSONB 
  "classification_result": JSONB 
  "creator_ref": VARCHAR(255) 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "document_id": UUID 
  "operator_comment": TEXT 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "transcription_result_id": UUID 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"DOCUMENT_OPERATION_TASK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "closed_at": DATETIME 
  "document_id": UUID 
  "opened_at": DATETIME 
  "step": VARCHAR(255) 
  "task_provider": VARCHAR(255) 
  "task_ref": VARCHAR(255) 
}
"DOCUMENT_EXTRACTION_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "classification_result_id": UUID 
  "creator_ref": VARCHAR(255) 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "document_id": UUID 
  "extraction_context": JSONB 
  "extraction_result": JSONB 
  "operator_comment": TEXT 
  "rejection_reasons": ARRAY 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "task_id": UUID 
  "transcription_result_id": UUID 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"DOCUMENT_INTERNAL_CONTROL_REVIEW" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_extraction_result_id": UUID 
  "document_id": UUID 
  "operation_task_id": UUID 
  "validation_status": VARCHAR(255) 
}
"BACKTEST"."id" -> "BACKTESTED_DOCUMENT"."backtest_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DATASET_DOCUMENT"."id" -> "BACKTESTED_DOCUMENT"."dataset_document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DATASET"."id" -> "DATASET_DOCUMENT_LINK"."dataset_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DATASET_DOCUMENT"."id" -> "DATASET_DOCUMENT_LINK"."dataset_document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_TRANSCRIPTION_RESULT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT_TRANSCRIPTION_RESULT"."id" -> "DOCUMENT_CLASSIFICATION_RESULT"."transcription_result_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_CLASSIFICATION_RESULT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_OPERATION_TASK"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT_OPERATION_TASK"."id" -> "DOCUMENT_EXTRACTION_RESULT"."task_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT_TRANSCRIPTION_RESULT"."id" -> "DOCUMENT_EXTRACTION_RESULT"."transcription_result_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_EXTRACTION_RESULT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT_CLASSIFICATION_RESULT"."id" -> "DOCUMENT_EXTRACTION_RESULT"."classification_result_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_INTERNAL_CONTROL_REVIEW"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT_OPERATION_TASK"."id" -> "DOCUMENT_INTERNAL_CONTROL_REVIEW"."operation_task_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"DOCUMENT_EXTRACTION_RESULT"."id" -> "DOCUMENT_INTERNAL_CONTROL_REVIEW"."document_extraction_result_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom