structure.sql

CREATE TABLE active_storage_attachments (
    id bigint NOT NULL,
    name character varying NOT NULL,
    record_type character varying NOT NULL,
    record_id bigint NOT NULL,
    blob_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE active_storage_attachments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE active_storage_attachments_id_seq OWNED BY active_storage_attachments.id;

CREATE TABLE active_storage_blobs (
    id bigint NOT NULL,
    key character varying NOT NULL,
    filename character varying NOT NULL,
    content_type character varying,
    metadata text,
    service_name character varying NOT NULL,
    byte_size bigint NOT NULL,
    checksum character varying,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE active_storage_blobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE active_storage_blobs_id_seq OWNED BY active_storage_blobs.id;

CREATE TABLE active_storage_variant_records (
    id bigint NOT NULL,
    blob_id bigint NOT NULL,
    variation_digest character varying NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE active_storage_variant_records_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE active_storage_variant_records_id_seq OWNED BY active_storage_variant_records.id;

CREATE TABLE application_settings (
    id bigint NOT NULL,
    setting integer NOT NULL,
    value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE application_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE application_settings_id_seq OWNED BY application_settings.id;

CREATE TABLE ar_internal_metadata (
    key character varying NOT NULL,
    value character varying,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL
);

CREATE TABLE audit_events (
    id bigint NOT NULL,
    author_id bigint NOT NULL,
    entity_id bigint NOT NULL,
    entity_type text NOT NULL,
    action_type integer NOT NULL,
    details jsonb NOT NULL,
    ip_address inet,
    target_id bigint NOT NULL,
    target_type text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE audit_events_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE audit_events_id_seq OWNED BY audit_events.id;

CREATE TABLE backup_codes (
    id bigint NOT NULL,
    token text NOT NULL,
    user_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_458fe46218 CHECK ((char_length(token) <= 10))
);

CREATE SEQUENCE backup_codes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE backup_codes_id_seq OWNED BY backup_codes.id;

CREATE TABLE data_type_data_type_links (
    id bigint NOT NULL,
    data_type_id bigint NOT NULL,
    referenced_data_type_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE data_type_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE data_type_data_type_links_id_seq OWNED BY data_type_data_type_links.id;

CREATE TABLE data_type_rules (
    id bigint NOT NULL,
    data_type_id bigint NOT NULL,
    variant integer NOT NULL,
    config jsonb NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE data_type_rules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE data_type_rules_id_seq OWNED BY data_type_rules.id;

CREATE TABLE data_types (
    id bigint NOT NULL,
    identifier text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    runtime_id bigint NOT NULL,
    removed_at timestamp with time zone,
    generic_keys text[] DEFAULT '{}'::text[] NOT NULL,
    version text NOT NULL,
    type text NOT NULL,
    definition_source text,
    runtime_module_id bigint NOT NULL,
    CONSTRAINT check_01ca31b7b9 CHECK ((char_length(type) <= 65536)),
    CONSTRAINT check_3a7198812e CHECK ((char_length(identifier) <= 50)),
    CONSTRAINT check_a133157a46 CHECK ((char_length(definition_source) <= 50))
);

CREATE SEQUENCE data_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE data_types_id_seq OWNED BY data_types.id;

CREATE TABLE execution_node_results (
    id bigint NOT NULL,
    execution_result_id bigint NOT NULL,
    node_function_id bigint,
    "position" integer NOT NULL,
    started_at bigint NOT NULL,
    finished_at bigint NOT NULL,
    success jsonb,
    error jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    function_definition_id bigint,
    CONSTRAINT check_26548a5903 CHECK ((num_nonnulls(success, error) <= 1))
);

CREATE SEQUENCE execution_node_results_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE execution_node_results_id_seq OWNED BY execution_node_results.id;

CREATE TABLE execution_parameter_results (
    id bigint NOT NULL,
    execution_node_result_id bigint NOT NULL,
    "position" integer NOT NULL,
    value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE execution_parameter_results_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE execution_parameter_results_id_seq OWNED BY execution_parameter_results.id;

CREATE TABLE execution_results (
    id bigint NOT NULL,
    flow_id bigint NOT NULL,
    execution_identifier text NOT NULL,
    input jsonb,
    started_at bigint NOT NULL,
    finished_at bigint NOT NULL,
    success jsonb,
    error jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_1e7a71dfb7 CHECK ((char_length(execution_identifier) <= 200)),
    CONSTRAINT check_5bf29caaec CHECK ((num_nonnulls(success, error) <= 1))
);

CREATE SEQUENCE execution_results_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE execution_results_id_seq OWNED BY execution_results.id;

CREATE TABLE flow_data_type_links (
    id bigint NOT NULL,
    flow_id bigint NOT NULL,
    referenced_data_type_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE flow_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flow_data_type_links_id_seq OWNED BY flow_data_type_links.id;

CREATE TABLE flow_settings (
    id bigint NOT NULL,
    flow_id bigint NOT NULL,
    flow_setting_id text NOT NULL,
    object jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    "cast" text,
    CONSTRAINT check_65f98666ae CHECK ((char_length("cast") <= 500))
);

CREATE SEQUENCE flow_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flow_settings_id_seq OWNED BY flow_settings.id;

CREATE TABLE flow_type_data_type_links (
    id bigint NOT NULL,
    flow_type_id bigint NOT NULL,
    referenced_data_type_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE flow_type_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flow_type_data_type_links_id_seq OWNED BY flow_type_data_type_links.id;

CREATE TABLE flow_type_settings (
    id bigint NOT NULL,
    flow_type_id bigint NOT NULL,
    identifier text NOT NULL,
    default_value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    "unique" integer DEFAULT 0 NOT NULL,
    removed_at timestamp with time zone,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL
);

CREATE SEQUENCE flow_type_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flow_type_settings_id_seq OWNED BY flow_type_settings.id;

CREATE TABLE flow_types (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    identifier text NOT NULL,
    editable boolean DEFAULT true NOT NULL,
    removed_at timestamp with time zone,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    version text NOT NULL,
    signature text DEFAULT ''::text NOT NULL,
    definition_source text,
    display_icon text,
    runtime_module_id bigint NOT NULL,
    runtime_flow_type_id bigint NOT NULL,
    CONSTRAINT check_3311b57eb7 CHECK ((char_length(definition_source) <= 50)),
    CONSTRAINT check_3f33e69ae0 CHECK ((char_length(display_icon) <= 100)),
    CONSTRAINT check_dfcfd661f1 CHECK ((char_length(signature) <= 500))
);

CREATE SEQUENCE flow_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flow_types_id_seq OWNED BY flow_types.id;

CREATE TABLE flows (
    id bigint NOT NULL,
    project_id bigint NOT NULL,
    flow_type_id bigint NOT NULL,
    starting_node_id bigint,
    name text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    validation_status integer DEFAULT 0 NOT NULL,
    disabled_reason integer,
    signature text DEFAULT ''::text NOT NULL,
    validation_diagnostics jsonb DEFAULT '[]'::jsonb NOT NULL,
    CONSTRAINT check_8c731c24ec CHECK ((char_length(signature) <= 500))
);

CREATE SEQUENCE flows_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE flows_id_seq OWNED BY flows.id;

CREATE TABLE function_definitions (
    id bigint NOT NULL,
    runtime_function_definition_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    runtime_module_id bigint NOT NULL,
    identifier text NOT NULL,
    removed_at timestamp with time zone,
    runtime_id bigint NOT NULL,
    design text,
    CONSTRAINT check_0641c95c39 CHECK ((char_length(identifier) <= 50)),
    CONSTRAINT check_8b4572b26a CHECK ((char_length(design) <= 200))
);

CREATE SEQUENCE function_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE function_definitions_id_seq OWNED BY function_definitions.id;

CREATE TABLE good_job_batches (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    description text,
    serialized_properties jsonb,
    on_finish text,
    on_success text,
    on_discard text,
    callback_queue_name text,
    callback_priority integer,
    enqueued_at timestamp with time zone,
    discarded_at timestamp with time zone,
    finished_at timestamp with time zone,
    jobs_finished_at timestamp with time zone
);

CREATE TABLE good_job_executions (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    active_job_id uuid NOT NULL,
    job_class text,
    queue_name text,
    serialized_params jsonb,
    scheduled_at timestamp with time zone,
    finished_at timestamp with time zone,
    error text,
    error_event smallint,
    error_backtrace text[],
    process_id uuid,
    duration interval
);

CREATE TABLE good_job_processes (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    state jsonb,
    lock_type smallint
);

CREATE TABLE good_job_settings (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    key text,
    value jsonb
);

CREATE TABLE good_jobs (
    id uuid DEFAULT gen_random_uuid() NOT NULL,
    queue_name text,
    priority integer,
    serialized_params jsonb,
    scheduled_at timestamp with time zone,
    performed_at timestamp with time zone,
    finished_at timestamp with time zone,
    error text,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    active_job_id uuid,
    concurrency_key text,
    cron_key text,
    retried_good_job_id uuid,
    cron_at timestamp with time zone,
    batch_id uuid,
    batch_callback_id uuid,
    is_discrete boolean,
    executions_count integer,
    job_class text,
    error_event smallint,
    labels text[],
    locked_by_id uuid,
    locked_at timestamp with time zone,
    lock_type integer
);

CREATE TABLE licenses (
    id bigint CONSTRAINT organization_licenses_id_not_null NOT NULL,
    data text CONSTRAINT organization_licenses_data_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_licenses_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_licenses_updated_at_not_null NOT NULL,
    namespace_id bigint
);

CREATE SEQUENCE licenses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE licenses_id_seq OWNED BY licenses.id;

CREATE TABLE module_configuration_definition_data_type_links (
    id bigint NOT NULL,
    module_configuration_definition_id bigint CONSTRAINT module_configuration_defini_module_configuration_defin_not_null NOT NULL,
    referenced_data_type_id bigint CONSTRAINT module_configuration_definitio_referenced_data_type_id_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT module_configuration_definition_data_type_l_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT module_configuration_definition_data_type_l_updated_at_not_null NOT NULL
);

CREATE SEQUENCE module_configuration_definition_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE module_configuration_definition_data_type_links_id_seq OWNED BY module_configuration_definition_data_type_links.id;

CREATE TABLE module_configuration_definitions (
    id bigint NOT NULL,
    runtime_module_id bigint NOT NULL,
    identifier text NOT NULL,
    type text NOT NULL,
    default_value jsonb,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_7fe4a3bc1a CHECK ((char_length(type) <= 8192)),
    CONSTRAINT check_b0290d44f1 CHECK ((char_length(identifier) <= 50))
);

CREATE SEQUENCE module_configuration_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE module_configuration_definitions_id_seq OWNED BY module_configuration_definitions.id;

CREATE TABLE module_configurations (
    id bigint NOT NULL,
    namespace_project_runtime_assignment_id bigint CONSTRAINT module_configurations_namespace_project_runtime_assign_not_null NOT NULL,
    module_configuration_definition_id bigint CONSTRAINT module_configurations_module_configuration_definition__not_null NOT NULL,
    value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE module_configurations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE module_configurations_id_seq OWNED BY module_configurations.id;

CREATE TABLE namespace_member_roles (
    id bigint CONSTRAINT organization_member_roles_id_not_null NOT NULL,
    role_id bigint CONSTRAINT organization_member_roles_role_id_not_null NOT NULL,
    member_id bigint CONSTRAINT organization_member_roles_member_id_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_member_roles_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_member_roles_updated_at_not_null NOT NULL
);

CREATE SEQUENCE namespace_member_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_member_roles_id_seq OWNED BY namespace_member_roles.id;

CREATE TABLE namespace_members (
    id bigint CONSTRAINT organization_members_id_not_null NOT NULL,
    user_id bigint CONSTRAINT organization_members_user_id_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_members_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_members_updated_at_not_null NOT NULL,
    namespace_id bigint NOT NULL
);

CREATE SEQUENCE namespace_members_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_members_id_seq OWNED BY namespace_members.id;

CREATE TABLE namespace_project_runtime_assignments (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    namespace_project_id bigint CONSTRAINT namespace_project_runtime_assignm_namespace_project_id_not_null NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    compatible boolean DEFAULT false NOT NULL
);

CREATE SEQUENCE namespace_project_runtime_assignments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_project_runtime_assignments_id_seq OWNED BY namespace_project_runtime_assignments.id;

CREATE TABLE namespace_projects (
    id bigint CONSTRAINT organization_projects_id_not_null NOT NULL,
    name text CONSTRAINT organization_projects_name_not_null NOT NULL,
    description text DEFAULT ''::text CONSTRAINT organization_projects_description_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_projects_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_projects_updated_at_not_null NOT NULL,
    namespace_id bigint NOT NULL,
    primary_runtime_id bigint,
    slug text NOT NULL,
    CONSTRAINT check_09e881e641 CHECK ((char_length(name) <= 50)),
    CONSTRAINT check_34f7fad2d8 CHECK ((char_length(slug) <= 50)),
    CONSTRAINT check_a77bf7c685 CHECK ((char_length(description) <= 500))
);

CREATE SEQUENCE namespace_projects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_projects_id_seq OWNED BY namespace_projects.id;

CREATE TABLE namespace_role_abilities (
    id bigint CONSTRAINT organization_role_abilities_id_not_null NOT NULL,
    ability integer CONSTRAINT organization_role_abilities_ability_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_role_abilities_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_role_abilities_updated_at_not_null NOT NULL,
    namespace_role_id bigint NOT NULL
);

CREATE SEQUENCE namespace_role_abilities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_role_abilities_id_seq OWNED BY namespace_role_abilities.id;

CREATE TABLE namespace_role_project_assignments (
    id bigint NOT NULL,
    role_id bigint NOT NULL,
    project_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE namespace_role_project_assignments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_role_project_assignments_id_seq OWNED BY namespace_role_project_assignments.id;

CREATE TABLE namespace_roles (
    id bigint CONSTRAINT organization_roles_id_not_null NOT NULL,
    name text CONSTRAINT organization_roles_name_not_null NOT NULL,
    created_at timestamp with time zone CONSTRAINT organization_roles_created_at_not_null NOT NULL,
    updated_at timestamp with time zone CONSTRAINT organization_roles_updated_at_not_null NOT NULL,
    namespace_id bigint NOT NULL
);

CREATE SEQUENCE namespace_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespace_roles_id_seq OWNED BY namespace_roles.id;

CREATE TABLE namespaces (
    id bigint NOT NULL,
    parent_type character varying NOT NULL,
    parent_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE namespaces_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE namespaces_id_seq OWNED BY namespaces.id;

CREATE TABLE node_functions (
    id bigint NOT NULL,
    next_node_id bigint,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    flow_id bigint NOT NULL,
    function_definition_id bigint NOT NULL
);

CREATE SEQUENCE node_functions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE node_functions_id_seq OWNED BY node_functions.id;

CREATE TABLE node_parameters (
    id bigint NOT NULL,
    node_function_id bigint NOT NULL,
    literal_value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    parameter_definition_id bigint NOT NULL,
    "cast" text,
    CONSTRAINT check_6439c80497 CHECK ((char_length("cast") <= 500))
);

CREATE SEQUENCE node_parameters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE node_parameters_id_seq OWNED BY node_parameters.id;

CREATE TABLE organizations (
    id bigint NOT NULL,
    name text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_d130d769e0 CHECK ((char_length(name) <= 50))
);

CREATE SEQUENCE organizations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE organizations_id_seq OWNED BY organizations.id;

CREATE TABLE parameter_definitions (
    id bigint NOT NULL,
    runtime_parameter_definition_id bigint NOT NULL,
    default_value jsonb,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    function_definition_id bigint NOT NULL,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL
);

CREATE SEQUENCE parameter_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE parameter_definitions_id_seq OWNED BY parameter_definitions.id;

CREATE TABLE reference_paths (
    id bigint NOT NULL,
    path text,
    array_index integer,
    reference_value_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE reference_paths_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE reference_paths_id_seq OWNED BY reference_paths.id;

CREATE TABLE reference_values (
    id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    node_function_id bigint,
    parameter_index integer,
    input_index integer,
    input_type_identifier text,
    node_parameter_id bigint NOT NULL,
    CONSTRAINT check_a2e3734389 CHECK ((num_nonnulls(parameter_index, input_index) = ANY (ARRAY[0, 2])))
);

CREATE SEQUENCE reference_values_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE reference_values_id_seq OWNED BY reference_values.id;

CREATE TABLE runtime_flow_type_data_type_links (
    id bigint NOT NULL,
    runtime_flow_type_id bigint NOT NULL,
    referenced_data_type_id bigint CONSTRAINT runtime_flow_type_data_type_li_referenced_data_type_id_not_null NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE runtime_flow_type_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_flow_type_data_type_links_id_seq OWNED BY runtime_flow_type_data_type_links.id;

CREATE TABLE runtime_flow_type_settings (
    id bigint NOT NULL,
    runtime_flow_type_id bigint NOT NULL,
    identifier text NOT NULL,
    "unique" integer DEFAULT 0 NOT NULL,
    default_value jsonb,
    removed_at timestamp with time zone,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL
);

CREATE SEQUENCE runtime_flow_type_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_flow_type_settings_id_seq OWNED BY runtime_flow_type_settings.id;

CREATE TABLE runtime_flow_types (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    runtime_module_id bigint NOT NULL,
    identifier text NOT NULL,
    editable boolean DEFAULT false NOT NULL,
    signature text DEFAULT ''::text NOT NULL,
    removed_at timestamp with time zone,
    definition_source text,
    display_icon text,
    version text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_0d21df63ce CHECK ((char_length(identifier) <= 50)),
    CONSTRAINT check_a082764ff7 CHECK ((char_length(definition_source) <= 50)),
    CONSTRAINT check_c63332f6d6 CHECK ((char_length(signature) <= 500)),
    CONSTRAINT check_e4e6c481a3 CHECK ((char_length(display_icon) <= 100))
);

CREATE SEQUENCE runtime_flow_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_flow_types_id_seq OWNED BY runtime_flow_types.id;

CREATE TABLE runtime_function_definition_data_type_links (
    id bigint NOT NULL,
    runtime_function_definition_id bigint CONSTRAINT runtime_function_definition_runtime_function_definitio_not_null NOT NULL,
    referenced_data_type_id bigint CONSTRAINT runtime_function_definition_da_referenced_data_type_id_not_null NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE runtime_function_definition_data_type_links_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_function_definition_data_type_links_id_seq OWNED BY runtime_function_definition_data_type_links.id;

CREATE TABLE runtime_function_definitions (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    runtime_name text NOT NULL,
    throws_error boolean DEFAULT true NOT NULL,
    removed_at timestamp with time zone,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    version text NOT NULL,
    signature text NOT NULL,
    definition_source text,
    display_icon text,
    runtime_module_id bigint NOT NULL,
    design text,
    CONSTRAINT check_4cf530fb6a CHECK ((char_length(definition_source) <= 50)),
    CONSTRAINT check_86da361565 CHECK ((char_length(signature) <= 500)),
    CONSTRAINT check_b25f98a584 CHECK ((char_length(design) <= 200)),
    CONSTRAINT check_ef62cf61e5 CHECK ((char_length(display_icon) <= 100)),
    CONSTRAINT check_fe8fff4f27 CHECK ((char_length(runtime_name) <= 50))
);

CREATE SEQUENCE runtime_function_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_function_definitions_id_seq OWNED BY runtime_function_definitions.id;

CREATE TABLE runtime_module_definitions (
    id bigint NOT NULL,
    runtime_module_id bigint NOT NULL,
    host text NOT NULL,
    port bigint NOT NULL,
    endpoint text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    protocol text NOT NULL,
    CONSTRAINT check_5328b69b6f CHECK ((char_length(host) <= 253)),
    CONSTRAINT check_5a8231f609 CHECK ((char_length(endpoint) <= 2048)),
    CONSTRAINT check_cdbfabb698 CHECK ((char_length(protocol) <= 255))
);

CREATE SEQUENCE runtime_module_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_module_definitions_id_seq OWNED BY runtime_module_definitions.id;

CREATE TABLE runtime_modules (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    identifier text NOT NULL,
    documentation text DEFAULT ''::text NOT NULL,
    author text DEFAULT ''::text NOT NULL,
    icon text,
    version text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    definition_source text,
    CONSTRAINT check_1a843f8ec6 CHECK ((char_length(identifier) <= 50)),
    CONSTRAINT check_3f8395fc6a CHECK ((char_length(icon) <= 100)),
    CONSTRAINT check_436ae79860 CHECK ((char_length(definition_source) <= 50)),
    CONSTRAINT check_59e12f7f02 CHECK ((char_length(author) <= 200)),
    CONSTRAINT check_d169c23c07 CHECK ((char_length(documentation) <= 200))
);

CREATE SEQUENCE runtime_modules_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_modules_id_seq OWNED BY runtime_modules.id;

CREATE TABLE runtime_parameter_definitions (
    id bigint NOT NULL,
    runtime_function_definition_id bigint CONSTRAINT runtime_parameter_definitio_runtime_function_definitio_not_null NOT NULL,
    runtime_name text NOT NULL,
    removed_at timestamp with time zone,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    default_value jsonb,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL,
    CONSTRAINT check_c1156ce358 CHECK ((char_length(runtime_name) <= 50))
);

CREATE SEQUENCE runtime_parameter_definitions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_parameter_definitions_id_seq OWNED BY runtime_parameter_definitions.id;

CREATE TABLE runtime_status_configurations (
    id bigint NOT NULL,
    runtime_status_id bigint NOT NULL,
    endpoint text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE runtime_status_configurations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_status_configurations_id_seq OWNED BY runtime_status_configurations.id;

CREATE TABLE runtime_statuses (
    id bigint NOT NULL,
    runtime_id bigint NOT NULL,
    status integer DEFAULT 0 NOT NULL,
    status_type integer DEFAULT 0 NOT NULL,
    last_heartbeat timestamp with time zone,
    identifier text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE runtime_statuses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtime_statuses_id_seq OWNED BY runtime_statuses.id;

CREATE TABLE runtimes (
    id bigint NOT NULL,
    name text NOT NULL,
    description text DEFAULT ''::text NOT NULL,
    token text NOT NULL,
    namespace_id bigint,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    last_heartbeat timestamp with time zone,
    CONSTRAINT check_090cd49d30 CHECK ((char_length(name) <= 50)),
    CONSTRAINT check_f3c2ba8db3 CHECK ((char_length(description) <= 500))
);

CREATE SEQUENCE runtimes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE runtimes_id_seq OWNED BY runtimes.id;

CREATE TABLE schema_migrations (
    version character varying NOT NULL
);

CREATE TABLE sub_flow_settings (
    id bigint NOT NULL,
    sub_flow_id bigint NOT NULL,
    identifier text NOT NULL,
    default_value jsonb,
    optional boolean DEFAULT false NOT NULL,
    hidden boolean DEFAULT false NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE sub_flow_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE sub_flow_settings_id_seq OWNED BY sub_flow_settings.id;

CREATE TABLE sub_flows (
    id bigint NOT NULL,
    node_parameter_id bigint NOT NULL,
    starting_node_id bigint,
    function_definition_id bigint,
    signature text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    CONSTRAINT check_53a99b1dd3 CHECK ((num_nonnulls(starting_node_id, function_definition_id) = 1)),
    CONSTRAINT check_943d01babb CHECK ((char_length(signature) <= 500))
);

CREATE SEQUENCE sub_flows_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE sub_flows_id_seq OWNED BY sub_flows.id;

CREATE TABLE translations (
    id bigint NOT NULL,
    code text NOT NULL,
    content text NOT NULL,
    owner_type character varying NOT NULL,
    owner_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    purpose text
);

CREATE SEQUENCE translations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE translations_id_seq OWNED BY translations.id;

CREATE TABLE user_identities (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    provider_id text NOT NULL,
    identifier text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE user_identities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE user_identities_id_seq OWNED BY user_identities.id;

CREATE TABLE user_sessions (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    token text NOT NULL,
    active boolean DEFAULT true NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);

CREATE SEQUENCE user_sessions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE user_sessions_id_seq OWNED BY user_sessions.id;

CREATE TABLE users (
    id bigint NOT NULL,
    username text,
    email text,
    password_digest text NOT NULL,
    firstname text,
    lastname text,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    admin boolean DEFAULT false NOT NULL,
    totp_secret text,
    email_verified_at timestamp with time zone,
    readme text,
    user_type integer DEFAULT 0 NOT NULL,
    blocked_at timestamp with time zone,
    CONSTRAINT check_11461c37fb CHECK ((char_length(readme) <= 5000)),
    CONSTRAINT check_3bedaaa612 CHECK ((char_length(email) <= 255)),
    CONSTRAINT check_56606ce552 CHECK ((char_length(username) <= 50)),
    CONSTRAINT check_60346c5299 CHECK ((char_length(lastname) <= 50)),
    CONSTRAINT check_d4bc21c175 CHECK ((char_length(firstname) <= 50))
);

CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE users_id_seq OWNED BY users.id;

ALTER TABLE ONLY active_storage_attachments ALTER COLUMN id SET DEFAULT nextval('active_storage_attachments_id_seq'::regclass);

ALTER TABLE ONLY active_storage_blobs ALTER COLUMN id SET DEFAULT nextval('active_storage_blobs_id_seq'::regclass);

ALTER TABLE ONLY active_storage_variant_records ALTER COLUMN id SET DEFAULT nextval('active_storage_variant_records_id_seq'::regclass);

ALTER TABLE ONLY application_settings ALTER COLUMN id SET DEFAULT nextval('application_settings_id_seq'::regclass);

ALTER TABLE ONLY audit_events ALTER COLUMN id SET DEFAULT nextval('audit_events_id_seq'::regclass);

ALTER TABLE ONLY backup_codes ALTER COLUMN id SET DEFAULT nextval('backup_codes_id_seq'::regclass);

ALTER TABLE ONLY data_type_data_type_links ALTER COLUMN id SET DEFAULT nextval('data_type_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY data_type_rules ALTER COLUMN id SET DEFAULT nextval('data_type_rules_id_seq'::regclass);

ALTER TABLE ONLY data_types ALTER COLUMN id SET DEFAULT nextval('data_types_id_seq'::regclass);

ALTER TABLE ONLY execution_node_results ALTER COLUMN id SET DEFAULT nextval('execution_node_results_id_seq'::regclass);

ALTER TABLE ONLY execution_parameter_results ALTER COLUMN id SET DEFAULT nextval('execution_parameter_results_id_seq'::regclass);

ALTER TABLE ONLY execution_results ALTER COLUMN id SET DEFAULT nextval('execution_results_id_seq'::regclass);

ALTER TABLE ONLY flow_data_type_links ALTER COLUMN id SET DEFAULT nextval('flow_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY flow_settings ALTER COLUMN id SET DEFAULT nextval('flow_settings_id_seq'::regclass);

ALTER TABLE ONLY flow_type_data_type_links ALTER COLUMN id SET DEFAULT nextval('flow_type_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY flow_type_settings ALTER COLUMN id SET DEFAULT nextval('flow_type_settings_id_seq'::regclass);

ALTER TABLE ONLY flow_types ALTER COLUMN id SET DEFAULT nextval('flow_types_id_seq'::regclass);

ALTER TABLE ONLY flows ALTER COLUMN id SET DEFAULT nextval('flows_id_seq'::regclass);

ALTER TABLE ONLY function_definitions ALTER COLUMN id SET DEFAULT nextval('function_definitions_id_seq'::regclass);

ALTER TABLE ONLY licenses ALTER COLUMN id SET DEFAULT nextval('licenses_id_seq'::regclass);

ALTER TABLE ONLY module_configuration_definition_data_type_links ALTER COLUMN id SET DEFAULT nextval('module_configuration_definition_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY module_configuration_definitions ALTER COLUMN id SET DEFAULT nextval('module_configuration_definitions_id_seq'::regclass);

ALTER TABLE ONLY module_configurations ALTER COLUMN id SET DEFAULT nextval('module_configurations_id_seq'::regclass);

ALTER TABLE ONLY namespace_member_roles ALTER COLUMN id SET DEFAULT nextval('namespace_member_roles_id_seq'::regclass);

ALTER TABLE ONLY namespace_members ALTER COLUMN id SET DEFAULT nextval('namespace_members_id_seq'::regclass);

ALTER TABLE ONLY namespace_project_runtime_assignments ALTER COLUMN id SET DEFAULT nextval('namespace_project_runtime_assignments_id_seq'::regclass);

ALTER TABLE ONLY namespace_projects ALTER COLUMN id SET DEFAULT nextval('namespace_projects_id_seq'::regclass);

ALTER TABLE ONLY namespace_role_abilities ALTER COLUMN id SET DEFAULT nextval('namespace_role_abilities_id_seq'::regclass);

ALTER TABLE ONLY namespace_role_project_assignments ALTER COLUMN id SET DEFAULT nextval('namespace_role_project_assignments_id_seq'::regclass);

ALTER TABLE ONLY namespace_roles ALTER COLUMN id SET DEFAULT nextval('namespace_roles_id_seq'::regclass);

ALTER TABLE ONLY namespaces ALTER COLUMN id SET DEFAULT nextval('namespaces_id_seq'::regclass);

ALTER TABLE ONLY node_functions ALTER COLUMN id SET DEFAULT nextval('node_functions_id_seq'::regclass);

ALTER TABLE ONLY node_parameters ALTER COLUMN id SET DEFAULT nextval('node_parameters_id_seq'::regclass);

ALTER TABLE ONLY organizations ALTER COLUMN id SET DEFAULT nextval('organizations_id_seq'::regclass);

ALTER TABLE ONLY parameter_definitions ALTER COLUMN id SET DEFAULT nextval('parameter_definitions_id_seq'::regclass);

ALTER TABLE ONLY reference_paths ALTER COLUMN id SET DEFAULT nextval('reference_paths_id_seq'::regclass);

ALTER TABLE ONLY reference_values ALTER COLUMN id SET DEFAULT nextval('reference_values_id_seq'::regclass);

ALTER TABLE ONLY runtime_flow_type_data_type_links ALTER COLUMN id SET DEFAULT nextval('runtime_flow_type_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY runtime_flow_type_settings ALTER COLUMN id SET DEFAULT nextval('runtime_flow_type_settings_id_seq'::regclass);

ALTER TABLE ONLY runtime_flow_types ALTER COLUMN id SET DEFAULT nextval('runtime_flow_types_id_seq'::regclass);

ALTER TABLE ONLY runtime_function_definition_data_type_links ALTER COLUMN id SET DEFAULT nextval('runtime_function_definition_data_type_links_id_seq'::regclass);

ALTER TABLE ONLY runtime_function_definitions ALTER COLUMN id SET DEFAULT nextval('runtime_function_definitions_id_seq'::regclass);

ALTER TABLE ONLY runtime_module_definitions ALTER COLUMN id SET DEFAULT nextval('runtime_module_definitions_id_seq'::regclass);

ALTER TABLE ONLY runtime_modules ALTER COLUMN id SET DEFAULT nextval('runtime_modules_id_seq'::regclass);

ALTER TABLE ONLY runtime_parameter_definitions ALTER COLUMN id SET DEFAULT nextval('runtime_parameter_definitions_id_seq'::regclass);

ALTER TABLE ONLY runtime_status_configurations ALTER COLUMN id SET DEFAULT nextval('runtime_status_configurations_id_seq'::regclass);

ALTER TABLE ONLY runtime_statuses ALTER COLUMN id SET DEFAULT nextval('runtime_statuses_id_seq'::regclass);

ALTER TABLE ONLY runtimes ALTER COLUMN id SET DEFAULT nextval('runtimes_id_seq'::regclass);

ALTER TABLE ONLY sub_flow_settings ALTER COLUMN id SET DEFAULT nextval('sub_flow_settings_id_seq'::regclass);

ALTER TABLE ONLY sub_flows ALTER COLUMN id SET DEFAULT nextval('sub_flows_id_seq'::regclass);

ALTER TABLE ONLY translations ALTER COLUMN id SET DEFAULT nextval('translations_id_seq'::regclass);

ALTER TABLE ONLY user_identities ALTER COLUMN id SET DEFAULT nextval('user_identities_id_seq'::regclass);

ALTER TABLE ONLY user_sessions ALTER COLUMN id SET DEFAULT nextval('user_sessions_id_seq'::regclass);

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);

ALTER TABLE ONLY active_storage_attachments
    ADD CONSTRAINT active_storage_attachments_pkey PRIMARY KEY (id);

ALTER TABLE ONLY active_storage_blobs
    ADD CONSTRAINT active_storage_blobs_pkey PRIMARY KEY (id);

ALTER TABLE ONLY active_storage_variant_records
    ADD CONSTRAINT active_storage_variant_records_pkey PRIMARY KEY (id);

ALTER TABLE ONLY application_settings
    ADD CONSTRAINT application_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY ar_internal_metadata
    ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);

ALTER TABLE ONLY audit_events
    ADD CONSTRAINT audit_events_pkey PRIMARY KEY (id);

ALTER TABLE ONLY backup_codes
    ADD CONSTRAINT backup_codes_pkey PRIMARY KEY (id);

ALTER TABLE ONLY data_type_data_type_links
    ADD CONSTRAINT data_type_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY data_type_rules
    ADD CONSTRAINT data_type_rules_pkey PRIMARY KEY (id);

ALTER TABLE ONLY data_types
    ADD CONSTRAINT data_types_pkey PRIMARY KEY (id);

ALTER TABLE ONLY execution_node_results
    ADD CONSTRAINT execution_node_results_pkey PRIMARY KEY (id);

ALTER TABLE ONLY execution_parameter_results
    ADD CONSTRAINT execution_parameter_results_pkey PRIMARY KEY (id);

ALTER TABLE ONLY execution_results
    ADD CONSTRAINT execution_results_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flow_data_type_links
    ADD CONSTRAINT flow_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flow_settings
    ADD CONSTRAINT flow_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flow_type_data_type_links
    ADD CONSTRAINT flow_type_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flow_type_settings
    ADD CONSTRAINT flow_type_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flow_types
    ADD CONSTRAINT flow_types_pkey PRIMARY KEY (id);

ALTER TABLE ONLY flows
    ADD CONSTRAINT flows_pkey PRIMARY KEY (id);

ALTER TABLE ONLY function_definitions
    ADD CONSTRAINT function_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY good_job_batches
    ADD CONSTRAINT good_job_batches_pkey PRIMARY KEY (id);

ALTER TABLE ONLY good_job_executions
    ADD CONSTRAINT good_job_executions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY good_job_processes
    ADD CONSTRAINT good_job_processes_pkey PRIMARY KEY (id);

ALTER TABLE ONLY good_job_settings
    ADD CONSTRAINT good_job_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY good_jobs
    ADD CONSTRAINT good_jobs_pkey PRIMARY KEY (id);

ALTER TABLE ONLY licenses
    ADD CONSTRAINT licenses_pkey PRIMARY KEY (id);

ALTER TABLE ONLY module_configuration_definition_data_type_links
    ADD CONSTRAINT module_configuration_definition_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY module_configuration_definitions
    ADD CONSTRAINT module_configuration_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY module_configurations
    ADD CONSTRAINT module_configurations_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_member_roles
    ADD CONSTRAINT namespace_member_roles_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_members
    ADD CONSTRAINT namespace_members_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_project_runtime_assignments
    ADD CONSTRAINT namespace_project_runtime_assignments_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_projects
    ADD CONSTRAINT namespace_projects_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_role_abilities
    ADD CONSTRAINT namespace_role_abilities_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_role_project_assignments
    ADD CONSTRAINT namespace_role_project_assignments_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespace_roles
    ADD CONSTRAINT namespace_roles_pkey PRIMARY KEY (id);

ALTER TABLE ONLY namespaces
    ADD CONSTRAINT namespaces_pkey PRIMARY KEY (id);

ALTER TABLE ONLY node_functions
    ADD CONSTRAINT node_functions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY node_parameters
    ADD CONSTRAINT node_parameters_pkey PRIMARY KEY (id);

ALTER TABLE ONLY organizations
    ADD CONSTRAINT organizations_pkey PRIMARY KEY (id);

ALTER TABLE ONLY parameter_definitions
    ADD CONSTRAINT parameter_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY reference_paths
    ADD CONSTRAINT reference_paths_pkey PRIMARY KEY (id);

ALTER TABLE ONLY reference_values
    ADD CONSTRAINT reference_values_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_flow_type_data_type_links
    ADD CONSTRAINT runtime_flow_type_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_flow_type_settings
    ADD CONSTRAINT runtime_flow_type_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_flow_types
    ADD CONSTRAINT runtime_flow_types_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_function_definition_data_type_links
    ADD CONSTRAINT runtime_function_definition_data_type_links_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_function_definitions
    ADD CONSTRAINT runtime_function_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_module_definitions
    ADD CONSTRAINT runtime_module_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_modules
    ADD CONSTRAINT runtime_modules_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_parameter_definitions
    ADD CONSTRAINT runtime_parameter_definitions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_status_configurations
    ADD CONSTRAINT runtime_status_configurations_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtime_statuses
    ADD CONSTRAINT runtime_statuses_pkey PRIMARY KEY (id);

ALTER TABLE ONLY runtimes
    ADD CONSTRAINT runtimes_pkey PRIMARY KEY (id);

ALTER TABLE ONLY schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);

ALTER TABLE ONLY sub_flow_settings
    ADD CONSTRAINT sub_flow_settings_pkey PRIMARY KEY (id);

ALTER TABLE ONLY sub_flows
    ADD CONSTRAINT sub_flows_pkey PRIMARY KEY (id);

ALTER TABLE ONLY translations
    ADD CONSTRAINT translations_pkey PRIMARY KEY (id);

ALTER TABLE ONLY user_identities
    ADD CONSTRAINT user_identities_pkey PRIMARY KEY (id);

ALTER TABLE ONLY user_sessions
    ADD CONSTRAINT user_sessions_pkey PRIMARY KEY (id);

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);

CREATE UNIQUE INDEX idx_data_types_on_runtime_module_id_identifier ON data_types USING btree (runtime_module_id, identifier);

CREATE UNIQUE INDEX idx_exec_node_results_on_execution_id_and_position ON execution_node_results USING btree (execution_result_id, "position");

CREATE UNIQUE INDEX idx_exec_param_results_on_node_result_id_and_position ON execution_parameter_results USING btree (execution_node_result_id, "position");

CREATE UNIQUE INDEX idx_execution_results_on_flow_id_and_identifier ON execution_results USING btree (flow_id, lower(execution_identifier));

CREATE INDEX idx_execution_results_on_identifier ON execution_results USING btree (execution_identifier);

CREATE UNIQUE INDEX idx_flow_types_on_runtime_module_id_identifier ON flow_types USING btree (runtime_module_id, identifier);

CREATE UNIQUE INDEX idx_function_definitions_on_runtime_id_identifier ON function_definitions USING btree (runtime_id, identifier);

CREATE UNIQUE INDEX idx_module_config_links_on_config_id_data_type_id ON module_configuration_definition_data_type_links USING btree (module_configuration_definition_id, referenced_data_type_id);

CREATE INDEX idx_module_configs_on_assignment_id ON module_configurations USING btree (namespace_project_runtime_assignment_id);

CREATE UNIQUE INDEX idx_module_configs_on_assignment_id_and_definition_id ON module_configurations USING btree (namespace_project_runtime_assignment_id, module_configuration_definition_id);

CREATE INDEX idx_module_configs_on_definition_id ON module_configurations USING btree (module_configuration_definition_id);

CREATE UNIQUE INDEX idx_module_configs_on_module_id_identifier ON module_configuration_definitions USING btree (runtime_module_id, identifier);

CREATE UNIQUE INDEX idx_on_data_type_id_referenced_data_type_id_bb9b090c90 ON data_type_data_type_links USING btree (data_type_id, referenced_data_type_id);

CREATE UNIQUE INDEX idx_on_flow_id_referenced_data_type_id_14b02b52f8 ON flow_data_type_links USING btree (flow_id, referenced_data_type_id);

CREATE UNIQUE INDEX idx_on_flow_type_id_referenced_data_type_id_70312c9382 ON flow_type_data_type_links USING btree (flow_type_id, referenced_data_type_id);

CREATE UNIQUE INDEX idx_on_namespace_role_id_ability_a092da8841 ON namespace_role_abilities USING btree (namespace_role_id, ability);

CREATE UNIQUE INDEX idx_on_role_id_project_id_5d4b5917dc ON namespace_role_project_assignments USING btree (role_id, project_id);

CREATE UNIQUE INDEX idx_on_runtime_function_definition_id_referenced_da_a6da962633 ON runtime_function_definition_data_type_links USING btree (runtime_function_definition_id, referenced_data_type_id);

CREATE UNIQUE INDEX idx_on_runtime_function_definition_id_runtime_name_abb3bb31bc ON runtime_parameter_definitions USING btree (runtime_function_definition_id, runtime_name);

CREATE UNIQUE INDEX idx_on_runtime_id_namespace_project_id_bc3c86cc70 ON namespace_project_runtime_assignments USING btree (runtime_id, namespace_project_id);

CREATE UNIQUE INDEX idx_on_runtime_id_runtime_name_de2ab1bfc0 ON runtime_function_definitions USING btree (runtime_id, runtime_name);

CREATE UNIQUE INDEX idx_rfd_on_runtime_module_id_runtime_name ON runtime_function_definitions USING btree (runtime_module_id, runtime_name);

CREATE UNIQUE INDEX idx_rft_links_on_rft_id_data_type_id ON runtime_flow_type_data_type_links USING btree (runtime_flow_type_id, referenced_data_type_id);

CREATE UNIQUE INDEX idx_rft_on_runtime_module_id_identifier ON runtime_flow_types USING btree (runtime_module_id, identifier);

CREATE UNIQUE INDEX idx_rft_settings_on_rft_id_identifier ON runtime_flow_type_settings USING btree (runtime_flow_type_id, identifier);

CREATE UNIQUE INDEX idx_runtime_modules_on_runtime_id_identifier ON runtime_modules USING btree (runtime_id, identifier);

CREATE INDEX index_active_storage_attachments_on_blob_id ON active_storage_attachments USING btree (blob_id);

CREATE UNIQUE INDEX index_active_storage_attachments_uniqueness ON active_storage_attachments USING btree (record_type, record_id, name, blob_id);

CREATE UNIQUE INDEX index_active_storage_blobs_on_key ON active_storage_blobs USING btree (key);

CREATE UNIQUE INDEX index_active_storage_variant_records_uniqueness ON active_storage_variant_records USING btree (blob_id, variation_digest);

CREATE UNIQUE INDEX index_application_settings_on_setting ON application_settings USING btree (setting);

CREATE INDEX index_audit_events_on_author_id ON audit_events USING btree (author_id);

CREATE UNIQUE INDEX "index_backup_codes_on_user_id_LOWER_token" ON backup_codes USING btree (user_id, lower(token));

CREATE INDEX index_data_type_rules_on_data_type_id ON data_type_rules USING btree (data_type_id);

CREATE UNIQUE INDEX index_data_types_on_runtime_id_and_identifier ON data_types USING btree (runtime_id, identifier);

CREATE INDEX index_execution_node_results_on_function_definition_id ON execution_node_results USING btree (function_definition_id);

CREATE INDEX index_execution_node_results_on_node_function_id ON execution_node_results USING btree (node_function_id);

CREATE INDEX index_flow_settings_on_flow_id ON flow_settings USING btree (flow_id);

CREATE UNIQUE INDEX index_flow_type_settings_on_flow_type_id_and_identifier ON flow_type_settings USING btree (flow_type_id, identifier);

CREATE INDEX index_flow_types_on_runtime_flow_type_id ON flow_types USING btree (runtime_flow_type_id);

CREATE UNIQUE INDEX index_flow_types_on_runtime_id_and_identifier ON flow_types USING btree (runtime_id, identifier);

CREATE INDEX index_flows_on_flow_type_id ON flows USING btree (flow_type_id);

CREATE UNIQUE INDEX index_flows_on_name_and_project_id ON flows USING btree (name, project_id);

CREATE INDEX index_flows_on_project_id ON flows USING btree (project_id);

CREATE INDEX index_flows_on_starting_node_id ON flows USING btree (starting_node_id);

CREATE INDEX index_function_definitions_on_runtime_function_definition_id ON function_definitions USING btree (runtime_function_definition_id);

CREATE INDEX index_good_job_executions_on_active_job_id_and_created_at ON good_job_executions USING btree (active_job_id, created_at);

CREATE INDEX index_good_job_executions_on_process_id_and_created_at ON good_job_executions USING btree (process_id, created_at);

CREATE INDEX index_good_job_jobs_for_candidate_lookup ON good_jobs USING btree (priority, created_at) WHERE (finished_at IS NULL);

CREATE UNIQUE INDEX index_good_job_settings_on_key ON good_job_settings USING btree (key);

CREATE INDEX index_good_jobs_for_candidate_dequeue_unlocked ON good_jobs USING btree (priority, scheduled_at, id) WHERE ((finished_at IS NULL) AND (locked_by_id IS NULL));

CREATE INDEX index_good_jobs_jobs_on_finished_at_only ON good_jobs USING btree (finished_at) WHERE (finished_at IS NOT NULL);

CREATE INDEX index_good_jobs_jobs_on_priority_created_at_when_unfinished ON good_jobs USING btree (priority DESC NULLS LAST, created_at) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_active_job_id_and_created_at ON good_jobs USING btree (active_job_id, created_at);

CREATE INDEX index_good_jobs_on_batch_callback_id ON good_jobs USING btree (batch_callback_id) WHERE (batch_callback_id IS NOT NULL);

CREATE INDEX index_good_jobs_on_batch_id ON good_jobs USING btree (batch_id) WHERE (batch_id IS NOT NULL);

CREATE INDEX index_good_jobs_on_concurrency_key_and_created_at ON good_jobs USING btree (concurrency_key, created_at);

CREATE INDEX index_good_jobs_on_concurrency_key_when_unfinished ON good_jobs USING btree (concurrency_key) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_created_at ON good_jobs USING btree (created_at);

CREATE INDEX index_good_jobs_on_cron_key_and_created_at_cond ON good_jobs USING btree (cron_key, created_at) WHERE (cron_key IS NOT NULL);

CREATE UNIQUE INDEX index_good_jobs_on_cron_key_and_cron_at_cond ON good_jobs USING btree (cron_key, cron_at) WHERE (cron_key IS NOT NULL);

CREATE INDEX index_good_jobs_on_discarded ON good_jobs USING btree (finished_at DESC) WHERE ((finished_at IS NOT NULL) AND (error IS NOT NULL));

CREATE INDEX index_good_jobs_on_job_class ON good_jobs USING btree (job_class);

CREATE INDEX index_good_jobs_on_labels ON good_jobs USING gin (labels) WHERE (labels IS NOT NULL);

CREATE INDEX index_good_jobs_on_locked_by_id ON good_jobs USING btree (locked_by_id) WHERE (locked_by_id IS NOT NULL);

CREATE INDEX index_good_jobs_on_priority_scheduled_at_unfinished ON good_jobs USING btree (priority, scheduled_at, id) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_priority_scheduled_at_unfinished_unlocked ON good_jobs USING btree (priority, scheduled_at) WHERE ((finished_at IS NULL) AND (locked_by_id IS NULL));

CREATE INDEX index_good_jobs_on_queue_name ON good_jobs USING btree (queue_name);

CREATE INDEX index_good_jobs_on_queue_name_and_scheduled_at ON good_jobs USING btree (queue_name, scheduled_at) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_queue_name_priority_scheduled_at_unfinished ON good_jobs USING btree (queue_name, scheduled_at, id) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_scheduled_at ON good_jobs USING btree (scheduled_at) WHERE (finished_at IS NULL);

CREATE INDEX index_good_jobs_on_scheduled_at_and_queue_name ON good_jobs USING btree (scheduled_at, queue_name);

CREATE INDEX index_good_jobs_on_unfinished_or_errored ON good_jobs USING btree (id) WHERE ((finished_at IS NULL) OR (error IS NOT NULL));

CREATE INDEX index_licenses_on_namespace_id ON licenses USING btree (namespace_id);

CREATE INDEX index_namespace_member_roles_on_member_id ON namespace_member_roles USING btree (member_id);

CREATE INDEX index_namespace_member_roles_on_role_id ON namespace_member_roles USING btree (role_id);

CREATE UNIQUE INDEX index_namespace_members_on_namespace_id_and_user_id ON namespace_members USING btree (namespace_id, user_id);

CREATE INDEX index_namespace_members_on_user_id ON namespace_members USING btree (user_id);

CREATE INDEX index_namespace_projects_on_namespace_id ON namespace_projects USING btree (namespace_id);

CREATE INDEX index_namespace_projects_on_primary_runtime_id ON namespace_projects USING btree (primary_runtime_id);

CREATE UNIQUE INDEX index_namespace_projects_on_slug ON namespace_projects USING btree (slug);

CREATE INDEX index_namespace_role_project_assignments_on_project_id ON namespace_role_project_assignments USING btree (project_id);

CREATE UNIQUE INDEX "index_namespace_roles_on_namespace_id_LOWER_name" ON namespace_roles USING btree (namespace_id, lower(name));

CREATE UNIQUE INDEX index_namespaces_on_parent_id_and_parent_type ON namespaces USING btree (parent_id, parent_type);

CREATE INDEX index_node_functions_on_flow_id ON node_functions USING btree (flow_id);

CREATE INDEX index_node_functions_on_function_definition_id ON node_functions USING btree (function_definition_id);

CREATE INDEX index_node_functions_on_next_node_id ON node_functions USING btree (next_node_id);

CREATE INDEX index_node_parameters_on_node_function_id ON node_parameters USING btree (node_function_id);

CREATE INDEX index_node_parameters_on_parameter_definition_id ON node_parameters USING btree (parameter_definition_id);

CREATE UNIQUE INDEX "index_organizations_on_LOWER_name" ON organizations USING btree (lower(name));

CREATE INDEX index_parameter_definitions_on_function_definition_id ON parameter_definitions USING btree (function_definition_id);

CREATE INDEX index_parameter_definitions_on_runtime_parameter_definition_id ON parameter_definitions USING btree (runtime_parameter_definition_id);

CREATE INDEX index_reference_paths_on_reference_value_id ON reference_paths USING btree (reference_value_id);

CREATE INDEX index_reference_values_on_node_function_id ON reference_values USING btree (node_function_id);

CREATE INDEX index_reference_values_on_node_parameter_id ON reference_values USING btree (node_parameter_id);

CREATE UNIQUE INDEX index_runtime_flow_types_on_runtime_id_and_identifier ON runtime_flow_types USING btree (runtime_id, identifier);

CREATE INDEX index_runtime_module_definitions_on_runtime_module_id ON runtime_module_definitions USING btree (runtime_module_id);

CREATE INDEX index_runtime_status_configurations_on_runtime_status_id ON runtime_status_configurations USING btree (runtime_status_id);

CREATE INDEX index_runtime_statuses_on_runtime_id ON runtime_statuses USING btree (runtime_id);

CREATE INDEX index_runtimes_on_namespace_id ON runtimes USING btree (namespace_id);

CREATE UNIQUE INDEX index_runtimes_on_token ON runtimes USING btree (token);

CREATE INDEX index_sub_flow_settings_on_sub_flow_id ON sub_flow_settings USING btree (sub_flow_id);

CREATE INDEX index_sub_flows_on_function_definition_id ON sub_flows USING btree (function_definition_id);

CREATE UNIQUE INDEX index_sub_flows_on_node_parameter_id ON sub_flows USING btree (node_parameter_id);

CREATE INDEX index_sub_flows_on_starting_node_id ON sub_flows USING btree (starting_node_id);

CREATE INDEX index_translations_on_owner ON translations USING btree (owner_type, owner_id);

CREATE UNIQUE INDEX index_user_identities_on_provider_id_and_identifier ON user_identities USING btree (provider_id, identifier);

CREATE INDEX index_user_identities_on_user_id ON user_identities USING btree (user_id);

CREATE UNIQUE INDEX index_user_identities_on_user_id_and_provider_id ON user_identities USING btree (user_id, provider_id);

CREATE UNIQUE INDEX index_user_sessions_on_token ON user_sessions USING btree (token);

CREATE INDEX index_user_sessions_on_user_id ON user_sessions USING btree (user_id);

CREATE UNIQUE INDEX "index_users_on_LOWER_email" ON users USING btree (lower(email));

CREATE UNIQUE INDEX "index_users_on_LOWER_username" ON users USING btree (lower(username));

ALTER TABLE ONLY node_parameters
    ADD CONSTRAINT fk_rails_0d79310cfa FOREIGN KEY (node_function_id) REFERENCES node_functions(id) ON DELETE CASCADE;

ALTER TABLE ONLY data_types
    ADD CONSTRAINT fk_rails_118c914ed0 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_types
    ADD CONSTRAINT fk_rails_18bfb8e8af FOREIGN KEY (runtime_flow_type_id) REFERENCES runtime_flow_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY parameter_definitions
    ADD CONSTRAINT fk_rails_18c14268dd FOREIGN KEY (function_definition_id) REFERENCES function_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_roles
    ADD CONSTRAINT fk_rails_205092c9cb FOREIGN KEY (namespace_id) REFERENCES namespaces(id) ON DELETE CASCADE;

ALTER TABLE ONLY execution_node_results
    ADD CONSTRAINT fk_rails_206bb380aa FOREIGN KEY (node_function_id) REFERENCES node_functions(id) ON DELETE SET NULL;

ALTER TABLE ONLY execution_parameter_results
    ADD CONSTRAINT fk_rails_219b049006 FOREIGN KEY (execution_node_result_id) REFERENCES execution_node_results(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_parameter_definitions
    ADD CONSTRAINT fk_rails_260318ad67 FOREIGN KEY (runtime_function_definition_id) REFERENCES runtime_function_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY function_definitions
    ADD CONSTRAINT fk_rails_2b9456e278 FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY node_parameters
    ADD CONSTRAINT fk_rails_2ed7c53167 FOREIGN KEY (parameter_definition_id) REFERENCES parameter_definitions(id) ON DELETE RESTRICT;

ALTER TABLE ONLY sub_flows
    ADD CONSTRAINT fk_rails_32ab48790a FOREIGN KEY (node_parameter_id) REFERENCES node_parameters(id) ON DELETE CASCADE;

ALTER TABLE ONLY execution_results
    ADD CONSTRAINT fk_rails_359854c0d0 FOREIGN KEY (flow_id) REFERENCES flows(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_flow_types
    ADD CONSTRAINT fk_rails_3675f29c4e FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_type_data_type_links
    ADD CONSTRAINT fk_rails_38698de52d FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY runtime_flow_type_data_type_links
    ADD CONSTRAINT fk_rails_38758d9b2b FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY licenses
    ADD CONSTRAINT fk_rails_38f693332d FOREIGN KEY (namespace_id) REFERENCES namespaces(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_statuses
    ADD CONSTRAINT fk_rails_3af887feb9 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY parameter_definitions
    ADD CONSTRAINT fk_rails_3b02763f84 FOREIGN KEY (runtime_parameter_definition_id) REFERENCES runtime_parameter_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY module_configuration_definition_data_type_links
    ADD CONSTRAINT fk_rails_42593aae68 FOREIGN KEY (module_configuration_definition_id) REFERENCES module_configuration_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY module_configurations
    ADD CONSTRAINT fk_rails_42e0cac371 FOREIGN KEY (module_configuration_definition_id) REFERENCES module_configuration_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY data_type_data_type_links
    ADD CONSTRAINT fk_rails_443c90661b FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY module_configurations
    ADD CONSTRAINT fk_rails_47f7323aca FOREIGN KEY (namespace_project_runtime_assignment_id) REFERENCES namespace_project_runtime_assignments(id) ON DELETE CASCADE;

ALTER TABLE ONLY function_definitions
    ADD CONSTRAINT fk_rails_48f4bbe3b6 FOREIGN KEY (runtime_function_definition_id) REFERENCES runtime_function_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_type_data_type_links
    ADD CONSTRAINT fk_rails_4a293cd114 FOREIGN KEY (flow_type_id) REFERENCES flow_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_modules
    ADD CONSTRAINT fk_rails_4ad6cfc2c6 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_function_definitions
    ADD CONSTRAINT fk_rails_5161ff47e6 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY node_functions
    ADD CONSTRAINT fk_rails_53cf3476d6 FOREIGN KEY (function_definition_id) REFERENCES function_definitions(id) ON DELETE RESTRICT;

ALTER TABLE ONLY backup_codes
    ADD CONSTRAINT fk_rails_556c1feac3 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

ALTER TABLE ONLY sub_flow_settings
    ADD CONSTRAINT fk_rails_55f76c79cc FOREIGN KEY (sub_flow_id) REFERENCES sub_flows(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_members
    ADD CONSTRAINT fk_rails_567f152a62 FOREIGN KEY (namespace_id) REFERENCES namespaces(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_member_roles
    ADD CONSTRAINT fk_rails_585a684166 FOREIGN KEY (role_id) REFERENCES namespace_roles(id) ON DELETE CASCADE;

ALTER TABLE ONLY module_configuration_definitions
    ADD CONSTRAINT fk_rails_5967026f74 FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_function_definition_data_type_links
    ADD CONSTRAINT fk_rails_5a52fd74a0 FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY namespace_role_project_assignments
    ADD CONSTRAINT fk_rails_623f8a5b72 FOREIGN KEY (role_id) REFERENCES namespace_roles(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_function_definition_data_type_links
    ADD CONSTRAINT fk_rails_64dd235e33 FOREIGN KEY (runtime_function_definition_id) REFERENCES runtime_function_definitions(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_data_type_links
    ADD CONSTRAINT fk_rails_657ea5202b FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY user_identities
    ADD CONSTRAINT fk_rails_684b0e1ce0 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_types
    ADD CONSTRAINT fk_rails_687d671458 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_role_project_assignments
    ADD CONSTRAINT fk_rails_69066bda8f FOREIGN KEY (project_id) REFERENCES namespace_projects(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_types
    ADD CONSTRAINT fk_rails_69115ada7f FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_member_roles
    ADD CONSTRAINT fk_rails_6c0d5a04c4 FOREIGN KEY (member_id) REFERENCES namespace_members(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_role_abilities
    ADD CONSTRAINT fk_rails_6f3304b078 FOREIGN KEY (namespace_role_id) REFERENCES namespace_roles(id) ON DELETE CASCADE;

ALTER TABLE ONLY data_types
    ADD CONSTRAINT fk_rails_70e5bacc8c FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY data_type_rules
    ADD CONSTRAINT fk_rails_7759633ff8 FOREIGN KEY (data_type_id) REFERENCES data_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_projects
    ADD CONSTRAINT fk_rails_79012c5895 FOREIGN KEY (primary_runtime_id) REFERENCES runtimes(id) ON DELETE RESTRICT;

ALTER TABLE ONLY flows
    ADD CONSTRAINT fk_rails_7de9ce6578 FOREIGN KEY (starting_node_id) REFERENCES node_functions(id) ON DELETE SET NULL;

ALTER TABLE ONLY execution_node_results
    ADD CONSTRAINT fk_rails_81c0c8b99a FOREIGN KEY (execution_result_id) REFERENCES execution_results(id) ON DELETE CASCADE;

ALTER TABLE ONLY node_functions
    ADD CONSTRAINT fk_rails_8615bd0635 FOREIGN KEY (flow_id) REFERENCES flows(id) ON DELETE CASCADE;

ALTER TABLE ONLY reference_values
    ADD CONSTRAINT fk_rails_8b9d8f68cc FOREIGN KEY (node_function_id) REFERENCES node_functions(id) DEFERRABLE INITIALLY DEFERRED;

ALTER TABLE ONLY reference_values
    ADD CONSTRAINT fk_rails_8c916f07f1 FOREIGN KEY (node_parameter_id) REFERENCES node_parameters(id) ON DELETE CASCADE;

ALTER TABLE ONLY data_type_data_type_links
    ADD CONSTRAINT fk_rails_90fbf0d8ef FOREIGN KEY (data_type_id) REFERENCES data_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_module_definitions
    ADD CONSTRAINT fk_rails_9249522e69 FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY reference_paths
    ADD CONSTRAINT fk_rails_92e51047ea FOREIGN KEY (reference_value_id) REFERENCES reference_values(id) ON DELETE CASCADE;

ALTER TABLE ONLY active_storage_variant_records
    ADD CONSTRAINT fk_rails_993965df05 FOREIGN KEY (blob_id) REFERENCES active_storage_blobs(id);

ALTER TABLE ONLY user_sessions
    ADD CONSTRAINT fk_rails_9fa262d742 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_members
    ADD CONSTRAINT fk_rails_a0a760b9b4 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

ALTER TABLE ONLY sub_flows
    ADD CONSTRAINT fk_rails_a99aa3478f FOREIGN KEY (function_definition_id) REFERENCES function_definitions(id) ON DELETE RESTRICT;

ALTER TABLE ONLY flows
    ADD CONSTRAINT fk_rails_ab927e0ecb FOREIGN KEY (project_id) REFERENCES namespace_projects(id) ON DELETE CASCADE;

ALTER TABLE ONLY function_definitions
    ADD CONSTRAINT fk_rails_ac308a3f72 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY execution_node_results
    ADD CONSTRAINT fk_rails_b0dba391fc FOREIGN KEY (function_definition_id) REFERENCES function_definitions(id) ON DELETE SET NULL;

ALTER TABLE ONLY runtime_flow_type_data_type_links
    ADD CONSTRAINT fk_rails_b300bcf944 FOREIGN KEY (runtime_flow_type_id) REFERENCES runtime_flow_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_project_runtime_assignments
    ADD CONSTRAINT fk_rails_c019e5b233 FOREIGN KEY (namespace_project_id) REFERENCES namespace_projects(id) ON DELETE CASCADE;

ALTER TABLE ONLY active_storage_attachments
    ADD CONSTRAINT fk_rails_c3b3935057 FOREIGN KEY (blob_id) REFERENCES active_storage_blobs(id);

ALTER TABLE ONLY namespace_project_runtime_assignments
    ADD CONSTRAINT fk_rails_c640af2146 FOREIGN KEY (runtime_id) REFERENCES runtimes(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_function_definitions
    ADD CONSTRAINT fk_rails_d2d9392ab1 FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY runtime_status_configurations
    ADD CONSTRAINT fk_rails_d3eeb850ed FOREIGN KEY (runtime_status_id) REFERENCES runtime_statuses(id) ON DELETE CASCADE;

ALTER TABLE ONLY namespace_projects
    ADD CONSTRAINT fk_rails_d4f50e2f00 FOREIGN KEY (namespace_id) REFERENCES namespaces(id) ON DELETE CASCADE;

ALTER TABLE ONLY flows
    ADD CONSTRAINT fk_rails_d9ad50fe4b FOREIGN KEY (flow_type_id) REFERENCES flow_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_settings
    ADD CONSTRAINT fk_rails_da3b2fb3c5 FOREIGN KEY (flow_id) REFERENCES flows(id) ON DELETE CASCADE;

ALTER TABLE ONLY sub_flows
    ADD CONSTRAINT fk_rails_e27dd4d82a FOREIGN KEY (starting_node_id) REFERENCES node_functions(id) ON DELETE RESTRICT;

ALTER TABLE ONLY runtime_flow_types
    ADD CONSTRAINT fk_rails_e729dc57e7 FOREIGN KEY (runtime_module_id) REFERENCES runtime_modules(id) ON DELETE CASCADE;

ALTER TABLE ONLY module_configuration_definition_data_type_links
    ADD CONSTRAINT fk_rails_e893387710 FOREIGN KEY (referenced_data_type_id) REFERENCES data_types(id) ON DELETE RESTRICT;

ALTER TABLE ONLY runtimes
    ADD CONSTRAINT fk_rails_eeb42116cc FOREIGN KEY (namespace_id) REFERENCES namespaces(id) ON DELETE CASCADE;

ALTER TABLE ONLY flow_data_type_links
    ADD CONSTRAINT fk_rails_f4202724d3 FOREIGN KEY (flow_id) REFERENCES flows(id) ON DELETE CASCADE;

ALTER TABLE ONLY audit_events
    ADD CONSTRAINT fk_rails_f64374fc56 FOREIGN KEY (author_id) REFERENCES users(id) ON DELETE SET NULL;

ALTER TABLE ONLY flow_type_settings
    ADD CONSTRAINT fk_rails_f6af7d8edf FOREIGN KEY (flow_type_id) REFERENCES flow_types(id) ON DELETE CASCADE;

ALTER TABLE ONLY node_functions
    ADD CONSTRAINT fk_rails_fbc91a3407 FOREIGN KEY (next_node_id) REFERENCES node_functions(id) DEFERRABLE INITIALLY DEFERRED;

ALTER TABLE ONLY runtime_flow_type_settings
    ADD CONSTRAINT fk_rails_fbd356a9f4 FOREIGN KEY (runtime_flow_type_id) REFERENCES runtime_flow_types(id) ON DELETE CASCADE;