ai_sam_workflows_base - Database Schema

Auto-generated model documentation.

Models (34 total)

`ai.automator.config`

AI Automator Configuration

Key Fields:
- knowledge_visualizer_enabled (Boolean)

`all.node.suppliers`

N8N Suppliers (Simplified)

Key Fields:
- name (Char)
- has_services (Boolean)
- action_count (Integer)
- trigger_count (Integer)
- total_nodes (Integer)
- node_ids (One2many)
- created_at (Date)
- default (Date)
- updated_at (Date)
- default (Date)

`name`

N8N Nodes (Simplified - Denormalized)

`all.node.types`

`display_name`

`workflow.business.unit`

Business Unit for Workflow Filtering

Key Fields:
- name (Char)
- code (Char)
- description (Text)
- sequence (Integer)
- active (Boolean)
- color (Integer)
- canvas_ids (One2many)
- canvas_count (Integer)

`canvas`

N8N-Compatible Workflow Definition

Key Fields:
- name (Char)
- description (Text)
- active (Boolean)
- branch_type (Char)
- branch_id (Many2one)
- canvas_type (Selection)
- business_unit_id (Many2one)
- workflow_type (Selection)
- json_definition (Text)
- nodes_cache_valid (Boolean)

`canvas.history`

Canvas Edit History

Key Fields:
- canvas_id (Many2one)
- action_type (Selection)
- previous_state (Text)
- action_data (Text)
- performed_by (Selection)
- user_id (Many2one)
- is_undone (Boolean)

`canvas.nodes`

Canvas Nodes (N8N Compatible)

Inherits: nodes.executor.mixin

Key Fields:
- node_id (Char)
- name (Char)
- type (Char)
- sequence (Integer)
- canvas_id (Many2one)
- workflow_node_type_id (Many2one)
- effective_node_type (Char)
- credential_id (Many2one)
- identity_id (Many2one)
- previous_node_id (Many2one)

`sam_ai_website_builder.page_builder`

Website Page Builder Executor

Inherits: nodes.executor.mixin

`my_module.my_executor`

Node Executor Mixin

`nodes.executor.mixin`

`executions`

Workflow Execution Log

Key Fields:
- name (Char)
- canvas_id (Many2one)
- state (Selection)
- start_time (Date)
- end_time (Date)
- duration (Float)
- trigger_type (Selection)
- triggered_by (Many2one)
- trigger_data (Text)
- input_data (Text)

`dynamic_menus`

N8N Dynamic Menu Generator

`workflow.n8n.import.wizard`

N8N Workflow Import Wizard

Key Fields:
- n8n_json (Text)
- workflow_name (Char)
- preview_name (Char)
- preview_node_count (Integer)
- preview_description (Text)
- replace_existing (Boolean)

`Invalid JSON`

No JSON provided

Key Fields:
- n8n_json (Text)
- workflow_name (Char)
- preview_name (Char)
- preview_node_count (Integer)
- preview_description (Text)
- replace_existing (Boolean)

`Parse Error`

Key Fields:
- n8n_json (Text)
- workflow_name (Char)
- preview_name (Char)
- preview_node_count (Integer)
- preview_description (Text)
- replace_existing (Boolean)

`n8n.menu.debug`

N8N Menu Debug Helper

`n8n.node.category`

N8N Node Categories

Key Fields:
- name (Char)
- description (Text)
- sequence (Integer)
- ui_group (Selection)
- node_count (Integer)
- node_l2_ids (Many2many)
- is_active (Boolean)
- create_date (Date)
- write_date (Date)
- create_uid (Many2one)

`node_types`

N8N Node Types Registry (DEPRECATED - use n8n.simple.node)

Key Fields:
- display_name (Char)
- n8n_type (Char)
- category (Selection)
- description (Text)
- icon_class (Char)
- color (Char)
- requires_credentials (Boolean)
- default_credential_id (Many2one)
- connection_inputs (Integer)
- connection_outputs (Integer)

`display_name`

`n8n.simple.extractor`

N8N Node Extractor (Direct from Filesystem)

Key Fields:
- supplier_ids (Many2many)
- node_ids (Many2many)
- overlay_preview_html (Html)
- new_overlay_html (Html)

`workflow.connection`

Workflow Connection

Key Fields:
- canvas_id (Many2one)
- source_node_id (Many2one)
- target_node_id (Many2one)
- source_handle (Char)
- target_handle (Char)
- sequence (Integer)
- display_name (Char)
- field_mapping_ids (One2many)
- mapped_field_count (Integer)
- unmapped_required_count (Integer)

`display_name`

`workflow.field.mapping`

Field Mapping

Key Fields:
- connection_id (Many2one)
- canvas_id (Many2one)
- source_node_id (Many2one)
- target_node_id (Many2one)
- source_field (Char)
- target_field (Char)
- display_name (Char)
- sequence (Integer)
- transform_type (Selection)
- transform_expression (Text)

`display_name`

`workflow.field.schema`

Node Field Schema

Key Fields:
- node_type_id (Many2one)
- field_name (Char)
- display_name (Char)
- description (Text)
- sequence (Integer)
- direction (Selection)
- field_type (Selection)
- is_required (Boolean)
- default_value (Char)
- is_standard (Boolean)

`field_name`

`workflow.node.binary`

Node Binary Output

Key Fields:
- output_id (Many2one)
- execution_id (Many2one)
- node_id (Char)
- filename (Char)
- sequence (Integer)
- mime_type (Char)
- file_size (Integer)
- file_size_display (Char)
- file_category (Selection)
- data (Binary)

`filename`

`workflow.node.output`

Node Execution Output

Key Fields:
- execution_id (Many2one)
- node_instance_id (Many2one)
- node_type_id (Many2one)
- node_id (Char)
- node_name (Char)
- sequence (Integer)
- display_name (Char)
- status (Selection)
- started_at (Date)
- completed_at (Date)

`display_name`

`workflow.standard.field`

SAM Standard Field Definition

Key Fields:
- name (Char)
- display_name (Char)
- description (Text)
- category (Selection)
- field_type (Selection)
- aliases (Char)

`name`

Key Fields:
- name (Char)
- display_name (Char)
- description (Text)
- category (Selection)
- field_type (Selection)
- aliases (Char)