Data model

"DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "content_hash": VARCHAR(64) 
  "document_type": VARCHAR(255) 
  "mime_type": VARCHAR(255) 
  "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_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) 
}
"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) 
}
"DOCUMENT"."id" -> "DOCUMENT_TRANSCRIPTION_RESULT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_CLASSIFICATION_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_OPERATION_TASK"."document_id": {
  source-arrowhead.shape: cf-one-required
  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_OPERATION_TASK"."id" -> "DOCUMENT_EXTRACTION_RESULT"."task_id": {
  source-arrowhead.shape: cf-one
  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_EXTRACTION_RESULT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT_EXTRACTION_RESULT"."id" -> "DOCUMENT_INTERNAL_CONTROL_REVIEW"."document_extraction_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
}

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