structure.sql

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: hstore; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;


--
-- Name: EXTENSION hstore; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs';


--
-- Name: special_action; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE public.special_action AS ENUM (
    'dump_info',
    'emergency_lock',
    'emergency_unlock',
    'power_off',
    'read_status',
    'reboot',
    'sync',
    'take_photo'
);


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: active_storage_attachments; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.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 without time zone NOT NULL
);


--
-- Name: active_storage_attachments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: active_storage_attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.active_storage_attachments_id_seq OWNED BY public.active_storage_attachments.id;


--
-- Name: active_storage_blobs; Type: TABLE; Schema: public; Owner: -
--

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


--
-- Name: active_storage_blobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: active_storage_blobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.active_storage_blobs_id_seq OWNED BY public.active_storage_blobs.id;


--
-- Name: active_storage_variant_records; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.active_storage_variant_records (
    id bigint NOT NULL,
    blob_id bigint NOT NULL,
    variation_digest character varying NOT NULL
);


--
-- Name: active_storage_variant_records_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

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


--
-- Name: active_storage_variant_records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.active_storage_variant_records_id_seq OWNED BY public.active_storage_variant_records.id;


--
-- Name: ai_feedbacks; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.ai_feedbacks (
    id bigint NOT NULL,
    device_id bigint,
    prompt character varying(500),
    reaction character varying(25),
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    model character varying(30),
    temperature character varying(5)
);


--
-- Name: ai_feedbacks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.ai_feedbacks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: ai_feedbacks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.ai_feedbacks_id_seq OWNED BY public.ai_feedbacks.id;


--
-- Name: alerts; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.alerts (
    id bigint NOT NULL,
    problem_tag character varying NOT NULL,
    priority integer DEFAULT 100 NOT NULL,
    slug character varying NOT NULL,
    device_id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: alerts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.alerts_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: alerts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.alerts_id_seq OWNED BY public.alerts.id;


--
-- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.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
);


--
-- Name: arg_names; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.arg_names (
    id bigint NOT NULL,
    value character varying NOT NULL
);


--
-- Name: arg_names_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.arg_names_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: arg_names_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.arg_names_id_seq OWNED BY public.arg_names.id;


--
-- Name: arg_sets; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.arg_sets (
    id bigint NOT NULL,
    fragment_id bigint NOT NULL,
    node_id bigint NOT NULL
);


--
-- Name: arg_sets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.arg_sets_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: arg_sets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.arg_sets_id_seq OWNED BY public.arg_sets.id;


--
-- Name: curves; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.curves (
    id bigint NOT NULL,
    device_id bigint NOT NULL,
    name character varying(80) NOT NULL,
    type character varying(10) NOT NULL,
    data character varying(500) NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL
);


--
-- Name: curves_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.curves_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: curves_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.curves_id_seq OWNED BY public.curves.id;


--
-- Name: delayed_jobs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.delayed_jobs (
    id integer NOT NULL,
    priority integer DEFAULT 0 NOT NULL,
    attempts integer DEFAULT 0 NOT NULL,
    handler text NOT NULL,
    last_error text,
    run_at timestamp without time zone,
    locked_at timestamp without time zone,
    failed_at timestamp without time zone,
    locked_by character varying,
    queue character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


--
-- Name: delayed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.delayed_jobs_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: delayed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.delayed_jobs_id_seq OWNED BY public.delayed_jobs.id;


--
-- Name: devices; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.devices (
    id integer NOT NULL,
    name character varying DEFAULT 'FarmBot'::character varying,
    max_log_count integer DEFAULT 1000,
    max_images_count integer DEFAULT 450,
    timezone character varying(280),
    last_saw_api timestamp without time zone,
    fbos_version character varying(17),
    throttled_until timestamp without time zone,
    throttled_at timestamp without time zone,
    mounted_tool_id bigint,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    serial_number character varying(32),
    mqtt_rate_limit_email_sent_at timestamp without time zone,
    ota_hour integer DEFAULT 3,
    first_saw_api timestamp without time zone,
    ota_hour_utc integer,
    last_watchdog timestamp without time zone,
    last_ota_attempt_at timestamp without time zone,
    fb_order_number character varying,
    setup_completed_at timestamp without time zone,
    lat numeric,
    lng numeric,
    indoor boolean DEFAULT false,
    rpi character varying(3),
    max_log_age_in_days integer DEFAULT 0,
    max_sequence_count integer DEFAULT 0,
    max_sequence_length integer DEFAULT 0,
    account_seeded_at timestamp without time zone
);


--
-- Name: devices_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.devices_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: devices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.devices_id_seq OWNED BY public.devices.id;


--
-- Name: edge_nodes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.edge_nodes (
    id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    sequence_id bigint NOT NULL,
    primary_node_id bigint NOT NULL,
    kind character varying(50),
    value character varying(3000)
);


--
-- Name: edge_nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.edge_nodes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: edge_nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.edge_nodes_id_seq OWNED BY public.edge_nodes.id;


--
-- Name: farm_events; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.farm_events (
    id integer NOT NULL,
    device_id integer,
    start_time timestamp without time zone,
    end_time timestamp without time zone,
    repeat integer,
    time_unit character varying,
    executable_type character varying(280),
    executable_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


--
-- Name: farm_events_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.farm_events_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: farm_events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.farm_events_id_seq OWNED BY public.farm_events.id;


--
-- Name: farmware_envs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.farmware_envs (
    id bigint NOT NULL,
    device_id bigint,
    key character varying(100),
    value character varying(1000),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: farmware_envs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.farmware_envs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: farmware_envs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.farmware_envs_id_seq OWNED BY public.farmware_envs.id;


--
-- Name: farmware_installations; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.farmware_installations (
    id bigint NOT NULL,
    device_id bigint,
    url character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    package character varying(80),
    package_error character varying
);


--
-- Name: farmware_installations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.farmware_installations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: farmware_installations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.farmware_installations_id_seq OWNED BY public.farmware_installations.id;


--
-- Name: fbos_configs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.fbos_configs (
    id bigint NOT NULL,
    device_id bigint,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    disable_factory_reset boolean DEFAULT true,
    firmware_input_log boolean DEFAULT false,
    firmware_output_log boolean DEFAULT false,
    sequence_body_log boolean DEFAULT false,
    sequence_complete_log boolean DEFAULT false,
    sequence_init_log boolean DEFAULT false,
    network_not_found_timer integer,
    firmware_hardware character varying,
    os_auto_update boolean DEFAULT true,
    arduino_debug_messages boolean DEFAULT false,
    firmware_path character varying,
    firmware_debug_log boolean DEFAULT false,
    update_channel character varying(7) DEFAULT 'stable'::character varying,
    boot_sequence_id integer,
    safe_height integer DEFAULT 0,
    soil_height integer DEFAULT '-500'::integer,
    gantry_height integer DEFAULT 0,
    default_axis_order character varying(10) DEFAULT 'xy,z;high'::character varying
);


--
-- Name: fbos_configs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.fbos_configs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: fbos_configs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.fbos_configs_id_seq OWNED BY public.fbos_configs.id;


--
-- Name: firmware_configs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.firmware_configs (
    id bigint NOT NULL,
    device_id bigint,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    encoder_enabled_x integer DEFAULT 1,
    encoder_enabled_y integer DEFAULT 1,
    encoder_enabled_z integer DEFAULT 1,
    encoder_invert_x integer DEFAULT 0,
    encoder_invert_y integer DEFAULT 0,
    encoder_invert_z integer DEFAULT 0,
    encoder_missed_steps_decay_x integer DEFAULT 5,
    encoder_missed_steps_decay_y integer DEFAULT 5,
    encoder_missed_steps_decay_z integer DEFAULT 5,
    encoder_missed_steps_max_x integer DEFAULT 5,
    encoder_missed_steps_max_y integer DEFAULT 5,
    encoder_missed_steps_max_z integer DEFAULT 5,
    encoder_scaling_x integer DEFAULT 5556,
    encoder_scaling_y integer DEFAULT 5556,
    encoder_scaling_z integer DEFAULT 5556,
    encoder_type_x integer DEFAULT 0,
    encoder_type_y integer DEFAULT 0,
    encoder_type_z integer DEFAULT 0,
    encoder_use_for_pos_x integer DEFAULT 0,
    encoder_use_for_pos_y integer DEFAULT 0,
    encoder_use_for_pos_z integer DEFAULT 0,
    movement_axis_nr_steps_x integer DEFAULT 0,
    movement_axis_nr_steps_y integer DEFAULT 0,
    movement_axis_nr_steps_z integer DEFAULT 0,
    movement_enable_endpoints_x integer DEFAULT 0,
    movement_enable_endpoints_y integer DEFAULT 0,
    movement_enable_endpoints_z integer DEFAULT 0,
    movement_home_at_boot_x integer DEFAULT 0,
    movement_home_at_boot_y integer DEFAULT 0,
    movement_home_at_boot_z integer DEFAULT 0,
    movement_home_spd_x integer DEFAULT 400,
    movement_home_spd_y integer DEFAULT 400,
    movement_home_spd_z integer DEFAULT 400,
    movement_home_up_x integer DEFAULT 0,
    movement_home_up_y integer DEFAULT 0,
    movement_home_up_z integer DEFAULT 1,
    movement_invert_endpoints_x integer DEFAULT 0,
    movement_invert_endpoints_y integer DEFAULT 0,
    movement_invert_endpoints_z integer DEFAULT 0,
    movement_invert_motor_x integer DEFAULT 0,
    movement_invert_motor_y integer DEFAULT 0,
    movement_invert_motor_z integer DEFAULT 0,
    movement_keep_active_x integer DEFAULT 0,
    movement_keep_active_y integer DEFAULT 0,
    movement_keep_active_z integer DEFAULT 1,
    movement_max_spd_x integer DEFAULT 400,
    movement_max_spd_y integer DEFAULT 400,
    movement_max_spd_z integer DEFAULT 400,
    movement_min_spd_x integer DEFAULT 50,
    movement_min_spd_y integer DEFAULT 50,
    movement_min_spd_z integer DEFAULT 50,
    movement_secondary_motor_invert_x integer DEFAULT 1,
    movement_secondary_motor_x integer DEFAULT 1,
    movement_step_per_mm_x double precision DEFAULT 5,
    movement_step_per_mm_y double precision DEFAULT 5,
    movement_step_per_mm_z double precision DEFAULT 25,
    movement_steps_acc_dec_x integer DEFAULT 300,
    movement_steps_acc_dec_y integer DEFAULT 300,
    movement_steps_acc_dec_z integer DEFAULT 300,
    movement_stop_at_home_x integer DEFAULT 1,
    movement_stop_at_home_y integer DEFAULT 1,
    movement_stop_at_home_z integer DEFAULT 1,
    movement_stop_at_max_x integer DEFAULT 1,
    movement_stop_at_max_y integer DEFAULT 1,
    movement_stop_at_max_z integer DEFAULT 1,
    movement_timeout_x integer DEFAULT 180,
    movement_timeout_y integer DEFAULT 180,
    movement_timeout_z integer DEFAULT 180,
    param_config_ok integer DEFAULT 0,
    param_e_stop_on_mov_err integer DEFAULT 0,
    param_mov_nr_retry integer DEFAULT 3,
    param_test integer DEFAULT 0,
    param_use_eeprom integer DEFAULT 1,
    param_version integer DEFAULT 1,
    pin_guard_1_active_state integer DEFAULT 1,
    pin_guard_1_pin_nr integer DEFAULT 0,
    pin_guard_1_time_out integer DEFAULT 60,
    pin_guard_2_active_state integer DEFAULT 1,
    pin_guard_2_pin_nr integer DEFAULT 0,
    pin_guard_2_time_out integer DEFAULT 60,
    pin_guard_3_active_state integer DEFAULT 1,
    pin_guard_3_pin_nr integer DEFAULT 0,
    pin_guard_3_time_out integer DEFAULT 60,
    pin_guard_4_active_state integer DEFAULT 1,
    pin_guard_4_pin_nr integer DEFAULT 0,
    pin_guard_4_time_out integer DEFAULT 60,
    pin_guard_5_active_state integer DEFAULT 1,
    pin_guard_5_pin_nr integer DEFAULT 0,
    pin_guard_5_time_out integer DEFAULT 60,
    movement_invert_2_endpoints_x integer DEFAULT 0,
    movement_invert_2_endpoints_y integer DEFAULT 0,
    movement_invert_2_endpoints_z integer DEFAULT 0,
    movement_microsteps_x integer DEFAULT 1,
    movement_microsteps_y integer DEFAULT 1,
    movement_microsteps_z integer DEFAULT 1,
    movement_motor_current_x integer DEFAULT 1823,
    movement_motor_current_y integer DEFAULT 1823,
    movement_motor_current_z integer DEFAULT 1823,
    movement_stall_sensitivity_x integer DEFAULT 63,
    movement_stall_sensitivity_y integer DEFAULT 63,
    movement_stall_sensitivity_z integer DEFAULT 63,
    movement_min_spd_z2 integer DEFAULT 50,
    movement_max_spd_z2 integer DEFAULT 400,
    movement_steps_acc_dec_z2 integer DEFAULT 300,
    movement_calibration_retry_x integer DEFAULT 1,
    movement_calibration_retry_y integer DEFAULT 1,
    movement_calibration_retry_z integer DEFAULT 1,
    movement_calibration_deadzone_x integer DEFAULT 250,
    movement_calibration_deadzone_y integer DEFAULT 250,
    movement_calibration_deadzone_z integer DEFAULT 250,
    movement_axis_stealth_x integer DEFAULT 1,
    movement_axis_stealth_y integer DEFAULT 1,
    movement_axis_stealth_z integer DEFAULT 1,
    movement_calibration_retry_total_x integer DEFAULT 10,
    movement_calibration_retry_total_y integer DEFAULT 10,
    movement_calibration_retry_total_z integer DEFAULT 10,
    pin_report_1_pin_nr integer DEFAULT 0,
    pin_report_2_pin_nr integer DEFAULT 0
);


--
-- Name: firmware_configs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.firmware_configs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: firmware_configs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.firmware_configs_id_seq OWNED BY public.firmware_configs.id;


--
-- Name: folders; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.folders (
    id bigint NOT NULL,
    device_id bigint NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    color character varying(20) NOT NULL,
    name character varying(40) NOT NULL,
    parent_id integer
);


--
-- Name: folders_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.folders_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: folders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.folders_id_seq OWNED BY public.folders.id;


--
-- Name: fragments; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.fragments (
    id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    device_id bigint,
    owner_type character varying NOT NULL,
    owner_id bigint NOT NULL
);


--
-- Name: fragments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.fragments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: fragments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.fragments_id_seq OWNED BY public.fragments.id;


--
-- Name: global_bulletins; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.global_bulletins (
    id bigint NOT NULL,
    href character varying,
    href_label character varying,
    slug character varying,
    title character varying,
    type character varying,
    content text,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: global_bulletins_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.global_bulletins_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: global_bulletins_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.global_bulletins_id_seq OWNED BY public.global_bulletins.id;


--
-- Name: global_configs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.global_configs (
    id bigint NOT NULL,
    key character varying,
    value text,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: global_configs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.global_configs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: global_configs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.global_configs_id_seq OWNED BY public.global_configs.id;


--
-- Name: images; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.images (
    id integer NOT NULL,
    device_id integer,
    meta text,
    attachment_processed_at timestamp without time zone,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    attachment_file_name character varying,
    attachment_content_type character varying,
    attachment_file_size integer,
    attachment_updated_at timestamp without time zone
);


--
-- Name: images_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.images_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: images_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.images_id_seq OWNED BY public.images.id;


--
-- Name: points; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.points (
    id integer NOT NULL,
    radius double precision DEFAULT 25.0 NOT NULL,
    x double precision NOT NULL,
    y double precision NOT NULL,
    z double precision DEFAULT 0.0 NOT NULL,
    device_id integer NOT NULL,
    meta public.hstore,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    name character varying DEFAULT 'untitled'::character varying NOT NULL,
    pointer_type character varying(280) NOT NULL,
    planted_at timestamp without time zone,
    openfarm_slug character varying(280) DEFAULT '50'::character varying NOT NULL,
    plant_stage character varying(10) DEFAULT 'planned'::character varying,
    tool_id integer,
    pullout_direction integer DEFAULT 0,
    discarded_at timestamp without time zone,
    gantry_mounted boolean DEFAULT false,
    depth integer DEFAULT 0,
    water_curve_id integer,
    spread_curve_id integer,
    height_curve_id integer
);


--
-- Name: sequences; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sequences (
    id integer NOT NULL,
    device_id integer,
    name character varying NOT NULL,
    color character varying,
    updated_at timestamp without time zone,
    created_at timestamp without time zone,
    folder_id bigint,
    pinned boolean DEFAULT false,
    description text,
    forked boolean DEFAULT false,
    sequence_version_id bigint,
    copyright character varying(1500)
);


--
-- Name: in_use_points; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW public.in_use_points AS
 SELECT points.x,
    points.y,
    points.z,
    sequences.id AS sequence_id,
    edge_nodes.id AS edge_node_id,
    points.device_id,
    (edge_nodes.value)::integer AS point_id,
    points.pointer_type,
    points.name AS pointer_name,
    sequences.name AS sequence_name
   FROM ((public.edge_nodes
     JOIN public.sequences ON ((edge_nodes.sequence_id = sequences.id)))
     JOIN public.points ON (((edge_nodes.value)::integer = points.id)))
  WHERE ((edge_nodes.kind)::text = 'pointer_id'::text);


--
-- Name: tools; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.tools (
    id integer NOT NULL,
    name character varying(280),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    device_id integer,
    flow_rate_ml_per_s integer DEFAULT 0,
    seeder_tip_z_offset double precision DEFAULT 80.0
);


--
-- Name: in_use_tools; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW public.in_use_tools AS
 SELECT tools.id AS tool_id,
    tools.name AS tool_name,
    sequences.name AS sequence_name,
    sequences.id AS sequence_id,
    sequences.device_id
   FROM ((public.edge_nodes
     JOIN public.sequences ON ((edge_nodes.sequence_id = sequences.id)))
     JOIN public.tools ON (((edge_nodes.value)::integer = tools.id)))
  WHERE ((edge_nodes.kind)::text = 'tool_id'::text);


--
-- Name: kinds; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.kinds (
    id bigint NOT NULL,
    value character varying NOT NULL
);


--
-- Name: kinds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.kinds_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: kinds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.kinds_id_seq OWNED BY public.kinds.id;


--
-- Name: logs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.logs (
    id integer NOT NULL,
    message text,
    meta text,
    channels character varying(280),
    device_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    type character varying(10) DEFAULT 'info'::character varying,
    major_version integer,
    minor_version integer,
    verbosity integer DEFAULT 1,
    x double precision,
    y double precision,
    z double precision,
    sent_at timestamp without time zone,
    patch_version integer
);


--
-- Name: logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.logs_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.logs_id_seq OWNED BY public.logs.id;


--
-- Name: nodes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.nodes (
    id bigint NOT NULL,
    fragment_id bigint NOT NULL,
    kind_id bigint NOT NULL,
    body_id integer,
    next_id integer,
    parent_id integer,
    comment character varying
);


--
-- Name: nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.nodes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.nodes_id_seq OWNED BY public.nodes.id;


--
-- Name: peripherals; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.peripherals (
    id integer NOT NULL,
    device_id integer,
    pin integer,
    label character varying(280),
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    mode integer DEFAULT 0
);


--
-- Name: peripherals_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.peripherals_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: peripherals_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.peripherals_id_seq OWNED BY public.peripherals.id;


--
-- Name: pin_bindings; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.pin_bindings (
    id bigint NOT NULL,
    device_id bigint,
    pin_num integer,
    sequence_id bigint,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    special_action public.special_action
);


--
-- Name: pin_bindings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.pin_bindings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: pin_bindings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.pin_bindings_id_seq OWNED BY public.pin_bindings.id;


--
-- Name: plant_templates; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.plant_templates (
    id bigint NOT NULL,
    saved_garden_id bigint NOT NULL,
    device_id bigint NOT NULL,
    radius double precision DEFAULT 25.0 NOT NULL,
    x double precision NOT NULL,
    y double precision NOT NULL,
    z double precision DEFAULT 0.0 NOT NULL,
    name character varying DEFAULT 'untitled'::character varying NOT NULL,
    openfarm_slug character varying(280) DEFAULT 'null'::character varying NOT NULL,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


--
-- Name: plant_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.plant_templates_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: plant_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.plant_templates_id_seq OWNED BY public.plant_templates.id;


--
-- Name: point_group_items; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.point_group_items (
    id bigint NOT NULL,
    point_group_id bigint NOT NULL,
    point_id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: point_group_items_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.point_group_items_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: point_group_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.point_group_items_id_seq OWNED BY public.point_group_items.id;


--
-- Name: point_groups; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.point_groups (
    id bigint NOT NULL,
    name character varying(80) NOT NULL,
    device_id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    sort_type character varying(20) DEFAULT 'xy_ascending'::character varying,
    criteria text
);


--
-- Name: point_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.point_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: point_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.point_groups_id_seq OWNED BY public.point_groups.id;


--
-- Name: points_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.points_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: points_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.points_id_seq OWNED BY public.points.id;


--
-- Name: primary_nodes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.primary_nodes (
    id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    sequence_id bigint NOT NULL,
    kind character varying(50),
    child_id bigint,
    parent_id bigint,
    parent_arg_name character varying(50),
    next_id bigint,
    body_id bigint,
    comment character varying(240)
);


--
-- Name: primary_nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.primary_nodes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: primary_nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.primary_nodes_id_seq OWNED BY public.primary_nodes.id;


--
-- Name: primitive_pairs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.primitive_pairs (
    id bigint NOT NULL,
    fragment_id bigint NOT NULL,
    arg_name_id bigint NOT NULL,
    arg_set_id bigint NOT NULL,
    primitive_id bigint NOT NULL
);


--
-- Name: primitive_pairs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.primitive_pairs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: primitive_pairs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.primitive_pairs_id_seq OWNED BY public.primitive_pairs.id;


--
-- Name: primitives; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.primitives (
    id bigint NOT NULL,
    fragment_id bigint NOT NULL,
    value character varying NOT NULL
);


--
-- Name: primitives_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.primitives_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: primitives_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.primitives_id_seq OWNED BY public.primitives.id;


--
-- Name: regimen_items; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.regimen_items (
    id integer NOT NULL,
    time_offset bigint,
    regimen_id integer,
    sequence_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


--
-- Name: regimen_items_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.regimen_items_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: regimen_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.regimen_items_id_seq OWNED BY public.regimen_items.id;


--
-- Name: regimens; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.regimens (
    id integer NOT NULL,
    color character varying,
    name character varying(280),
    device_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


--
-- Name: regimens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.regimens_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: regimens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.regimens_id_seq OWNED BY public.regimens.id;


--
-- Name: releases; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.releases (
    id bigint NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    image_url character varying,
    version character varying,
    platform character varying,
    channel character varying,
    dot_img_url character varying
);


--
-- Name: releases_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.releases_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: releases_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.releases_id_seq OWNED BY public.releases.id;


--
-- Name: resource_update_steps; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW public.resource_update_steps AS
 WITH resource_type AS (
         SELECT edge_nodes.primary_node_id,
            edge_nodes.kind,
            edge_nodes.value
           FROM public.edge_nodes
          WHERE (((edge_nodes.kind)::text = 'resource_type'::text) AND ((edge_nodes.value)::text = ANY (ARRAY[('"GenericPointer"'::character varying)::text, ('"ToolSlot"'::character varying)::text, ('"Plant"'::character varying)::text])))
        ), resource_id AS (
         SELECT edge_nodes.primary_node_id,
            edge_nodes.kind,
            edge_nodes.value,
            edge_nodes.sequence_id
           FROM public.edge_nodes
          WHERE ((edge_nodes.kind)::text = 'resource_id'::text)
        ), user_sequence AS (
         SELECT sequences.name,
            sequences.id
           FROM public.sequences
        )
 SELECT j1.sequence_id,
    j1.primary_node_id,
    (j1.value)::bigint AS point_id,
    j3.name AS sequence_name
   FROM ((resource_id j1
     JOIN resource_type j2 ON ((j1.primary_node_id = j2.primary_node_id)))
     JOIN user_sequence j3 ON ((j3.id = j1.sequence_id)));


--
-- Name: saved_gardens; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.saved_gardens (
    id bigint NOT NULL,
    name character varying NOT NULL,
    device_id bigint NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    notes character varying(1500)
);


--
-- Name: saved_gardens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.saved_gardens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: saved_gardens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.saved_gardens_id_seq OWNED BY public.saved_gardens.id;


--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.schema_migrations (
    version character varying NOT NULL
);


--
-- Name: sensor_readings; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sensor_readings (
    id bigint NOT NULL,
    device_id bigint,
    x double precision,
    y double precision,
    z double precision,
    value integer,
    pin integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    mode integer DEFAULT 0,
    read_at timestamp without time zone
);


--
-- Name: sensor_readings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.sensor_readings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: sensor_readings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sensor_readings_id_seq OWNED BY public.sensor_readings.id;


--
-- Name: sensors; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sensors (
    id bigint NOT NULL,
    device_id bigint,
    pin integer,
    label character varying,
    mode integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: sensors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.sensors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: sensors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sensors_id_seq OWNED BY public.sensors.id;


--
-- Name: sequence_publications; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sequence_publications (
    id bigint NOT NULL,
    cached_author_email character varying NOT NULL,
    author_device_id integer NOT NULL,
    author_sequence_id integer NOT NULL,
    published boolean DEFAULT true NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL
);


--
-- Name: sequence_publications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.sequence_publications_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: sequence_publications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sequence_publications_id_seq OWNED BY public.sequence_publications.id;


--
-- Name: sequence_usage_reports; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW public.sequence_usage_reports AS
 SELECT id AS sequence_id,
    ( SELECT count(*) AS count
           FROM public.edge_nodes
          WHERE (((edge_nodes.kind)::text = 'sequence_id'::text) AND ((edge_nodes.value)::integer = sequences.id))) AS edge_node_count,
    ( SELECT count(*) AS count
           FROM public.farm_events
          WHERE ((farm_events.executable_id = sequences.id) AND ((farm_events.executable_type)::text = 'Sequence'::text))) AS farm_event_count,
    ( SELECT count(*) AS count
           FROM public.regimen_items
          WHERE (regimen_items.sequence_id = sequences.id)) AS regimen_items_count
   FROM public.sequences;


--
-- Name: sequence_versions; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.sequence_versions (
    id bigint NOT NULL,
    sequence_publication_id bigint NOT NULL,
    description text,
    name character varying NOT NULL,
    color character varying NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    copyright character varying(1500)
);


--
-- Name: sequence_versions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.sequence_versions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: sequence_versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sequence_versions_id_seq OWNED BY public.sequence_versions.id;


--
-- Name: sequences_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.sequences_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: sequences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.sequences_id_seq OWNED BY public.sequences.id;


--
-- Name: standard_pairs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.standard_pairs (
    id bigint NOT NULL,
    fragment_id bigint NOT NULL,
    arg_name_id bigint NOT NULL,
    arg_set_id bigint NOT NULL,
    node_id bigint NOT NULL
);


--
-- Name: standard_pairs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.standard_pairs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: standard_pairs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.standard_pairs_id_seq OWNED BY public.standard_pairs.id;


--
-- Name: telemetries; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.telemetries (
    id bigint NOT NULL,
    device_id bigint,
    soc_temp integer,
    wifi_level_percent integer,
    uptime integer,
    memory_usage integer,
    disk_usage integer,
    cpu_usage integer,
    throttled character varying(10),
    target character varying(10),
    fbos_version character varying(20),
    firmware_hardware character varying(20),
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL
);


--
-- Name: telemetries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.telemetries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: telemetries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.telemetries_id_seq OWNED BY public.telemetries.id;


--
-- Name: token_issuances; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.token_issuances (
    id bigint NOT NULL,
    device_id bigint NOT NULL,
    exp integer NOT NULL,
    jti character varying(45) NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    aud character varying(8) DEFAULT 'unknown'::character varying
);


--
-- Name: token_issuances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.token_issuances_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: token_issuances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.token_issuances_id_seq OWNED BY public.token_issuances.id;


--
-- Name: tools_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.tools_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: tools_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.tools_id_seq OWNED BY public.tools.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.users (
    id integer NOT NULL,
    device_id integer NOT NULL,
    name character varying,
    email character varying(280) DEFAULT ''::character varying NOT NULL,
    encrypted_password character varying DEFAULT ''::character varying NOT NULL,
    sign_in_count integer DEFAULT 0 NOT NULL,
    current_sign_in_at timestamp without time zone,
    last_sign_in_at timestamp without time zone,
    current_sign_in_ip character varying,
    last_sign_in_ip character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    confirmed_at timestamp without time zone,
    confirmation_token character varying,
    agreed_to_terms_at timestamp without time zone,
    confirmation_sent_at timestamp without time zone,
    unconfirmed_email character varying,
    inactivity_warning_sent_at timestamp without time zone,
    language character varying(100) DEFAULT 'English'::character varying
);


--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.users_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: web_app_configs; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.web_app_configs (
    id bigint NOT NULL,
    device_id bigint,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    confirm_step_deletion boolean DEFAULT false,
    disable_animations boolean DEFAULT false,
    disable_i18n boolean DEFAULT false,
    display_trail boolean DEFAULT true,
    dynamic_map boolean DEFAULT false,
    encoder_figure boolean DEFAULT false,
    hide_webcam_widget boolean DEFAULT false,
    legend_menu_open boolean DEFAULT true,
    raw_encoders boolean DEFAULT false,
    scaled_encoders boolean DEFAULT false,
    show_spread boolean DEFAULT true,
    show_farmbot boolean DEFAULT true,
    show_plants boolean DEFAULT true,
    show_points boolean DEFAULT true,
    x_axis_inverted boolean DEFAULT false,
    y_axis_inverted boolean DEFAULT false,
    z_axis_inverted boolean DEFAULT false,
    bot_origin_quadrant integer DEFAULT 2,
    zoom_level integer DEFAULT '-2'::integer,
    success_log integer DEFAULT 1,
    busy_log integer DEFAULT 1,
    warn_log integer DEFAULT 1,
    error_log integer DEFAULT 1,
    info_log integer DEFAULT 1,
    fun_log integer DEFAULT 1,
    debug_log integer DEFAULT 1,
    stub_config boolean DEFAULT false,
    show_first_party_farmware boolean DEFAULT false,
    enable_browser_speak boolean DEFAULT false,
    show_images boolean DEFAULT true,
    photo_filter_begin character varying,
    photo_filter_end character varying,
    discard_unsaved boolean DEFAULT false,
    xy_swap boolean DEFAULT false,
    home_button_homing boolean DEFAULT true,
    show_motor_plot boolean DEFAULT false,
    show_historic_points boolean DEFAULT false,
    show_sensor_readings boolean DEFAULT false,
    show_dev_menu boolean DEFAULT false,
    internal_use text,
    time_format_24_hour boolean DEFAULT false,
    show_pins boolean DEFAULT false,
    disable_emergency_unlock_confirmation boolean DEFAULT true,
    map_size_x integer DEFAULT 2900,
    map_size_y integer DEFAULT 1230,
    expand_step_options boolean DEFAULT false,
    hide_sensors boolean DEFAULT false,
    confirm_plant_deletion boolean DEFAULT true,
    confirm_sequence_deletion boolean DEFAULT true,
    discard_unsaved_sequences boolean DEFAULT false,
    user_interface_read_only_mode boolean DEFAULT false,
    assertion_log integer DEFAULT 1,
    show_zones boolean DEFAULT false,
    show_weeds boolean DEFAULT true,
    display_map_missed_steps boolean DEFAULT false,
    time_format_seconds boolean DEFAULT false,
    crop_images boolean DEFAULT true,
    show_camera_view_area boolean DEFAULT true,
    view_celery_script boolean DEFAULT false,
    highlight_modified_settings boolean DEFAULT true,
    show_advanced_settings boolean DEFAULT false,
    show_soil_interpolation_map boolean DEFAULT false,
    show_moisture_interpolation_map boolean DEFAULT false,
    clip_image_layer boolean DEFAULT true,
    beep_verbosity integer DEFAULT 0,
    landing_page character varying(100) DEFAULT 'plants'::character varying,
    go_button_axes character varying(3) DEFAULT 'XY'::character varying NOT NULL,
    show_uncropped_camera_view_area boolean DEFAULT false,
    default_plant_depth integer DEFAULT 5,
    show_missed_step_plot boolean DEFAULT false,
    enable_3d_electronics_box_top boolean DEFAULT true,
    three_d_garden boolean DEFAULT false,
    dark_mode boolean DEFAULT true,
    top_down_view boolean DEFAULT false,
    viewpoint_heading integer DEFAULT 30
);


--
-- Name: web_app_configs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.web_app_configs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: web_app_configs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.web_app_configs_id_seq OWNED BY public.web_app_configs.id;


--
-- Name: webcam_feeds; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.webcam_feeds (
    id bigint NOT NULL,
    device_id bigint,
    url character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    name character varying(80) DEFAULT 'Webcam Feed'::character varying
);


--
-- Name: webcam_feeds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.webcam_feeds_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: webcam_feeds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.webcam_feeds_id_seq OWNED BY public.webcam_feeds.id;


--
-- Name: wizard_step_results; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.wizard_step_results (
    id bigint NOT NULL,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    device_id bigint NOT NULL,
    slug character varying NOT NULL,
    answer boolean,
    outcome character varying
);


--
-- Name: wizard_step_results_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.wizard_step_results_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: wizard_step_results_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.wizard_step_results_id_seq OWNED BY public.wizard_step_results.id;


--
-- Name: active_storage_attachments id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: active_storage_blobs id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: active_storage_variant_records id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: ai_feedbacks id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.ai_feedbacks ALTER COLUMN id SET DEFAULT nextval('public.ai_feedbacks_id_seq'::regclass);


--
-- Name: alerts id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alerts ALTER COLUMN id SET DEFAULT nextval('public.alerts_id_seq'::regclass);


--
-- Name: arg_names id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.arg_names ALTER COLUMN id SET DEFAULT nextval('public.arg_names_id_seq'::regclass);


--
-- Name: arg_sets id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.arg_sets ALTER COLUMN id SET DEFAULT nextval('public.arg_sets_id_seq'::regclass);


--
-- Name: curves id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.curves ALTER COLUMN id SET DEFAULT nextval('public.curves_id_seq'::regclass);


--
-- Name: delayed_jobs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.delayed_jobs ALTER COLUMN id SET DEFAULT nextval('public.delayed_jobs_id_seq'::regclass);


--
-- Name: devices id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.devices ALTER COLUMN id SET DEFAULT nextval('public.devices_id_seq'::regclass);


--
-- Name: edge_nodes id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.edge_nodes ALTER COLUMN id SET DEFAULT nextval('public.edge_nodes_id_seq'::regclass);


--
-- Name: farm_events id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farm_events ALTER COLUMN id SET DEFAULT nextval('public.farm_events_id_seq'::regclass);


--
-- Name: farmware_envs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_envs ALTER COLUMN id SET DEFAULT nextval('public.farmware_envs_id_seq'::regclass);


--
-- Name: farmware_installations id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_installations ALTER COLUMN id SET DEFAULT nextval('public.farmware_installations_id_seq'::regclass);


--
-- Name: fbos_configs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fbos_configs ALTER COLUMN id SET DEFAULT nextval('public.fbos_configs_id_seq'::regclass);


--
-- Name: firmware_configs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.firmware_configs ALTER COLUMN id SET DEFAULT nextval('public.firmware_configs_id_seq'::regclass);


--
-- Name: folders id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.folders ALTER COLUMN id SET DEFAULT nextval('public.folders_id_seq'::regclass);


--
-- Name: fragments id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fragments ALTER COLUMN id SET DEFAULT nextval('public.fragments_id_seq'::regclass);


--
-- Name: global_bulletins id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.global_bulletins ALTER COLUMN id SET DEFAULT nextval('public.global_bulletins_id_seq'::regclass);


--
-- Name: global_configs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.global_configs ALTER COLUMN id SET DEFAULT nextval('public.global_configs_id_seq'::regclass);


--
-- Name: images id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.images ALTER COLUMN id SET DEFAULT nextval('public.images_id_seq'::regclass);


--
-- Name: kinds id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.kinds ALTER COLUMN id SET DEFAULT nextval('public.kinds_id_seq'::regclass);


--
-- Name: logs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.logs ALTER COLUMN id SET DEFAULT nextval('public.logs_id_seq'::regclass);


--
-- Name: nodes id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.nodes ALTER COLUMN id SET DEFAULT nextval('public.nodes_id_seq'::regclass);


--
-- Name: peripherals id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.peripherals ALTER COLUMN id SET DEFAULT nextval('public.peripherals_id_seq'::regclass);


--
-- Name: pin_bindings id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pin_bindings ALTER COLUMN id SET DEFAULT nextval('public.pin_bindings_id_seq'::regclass);


--
-- Name: plant_templates id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plant_templates ALTER COLUMN id SET DEFAULT nextval('public.plant_templates_id_seq'::regclass);


--
-- Name: point_group_items id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_group_items ALTER COLUMN id SET DEFAULT nextval('public.point_group_items_id_seq'::regclass);


--
-- Name: point_groups id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_groups ALTER COLUMN id SET DEFAULT nextval('public.point_groups_id_seq'::regclass);


--
-- Name: points id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.points ALTER COLUMN id SET DEFAULT nextval('public.points_id_seq'::regclass);


--
-- Name: primary_nodes id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primary_nodes ALTER COLUMN id SET DEFAULT nextval('public.primary_nodes_id_seq'::regclass);


--
-- Name: primitive_pairs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primitive_pairs ALTER COLUMN id SET DEFAULT nextval('public.primitive_pairs_id_seq'::regclass);


--
-- Name: primitives id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primitives ALTER COLUMN id SET DEFAULT nextval('public.primitives_id_seq'::regclass);


--
-- Name: regimen_items id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.regimen_items ALTER COLUMN id SET DEFAULT nextval('public.regimen_items_id_seq'::regclass);


--
-- Name: regimens id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.regimens ALTER COLUMN id SET DEFAULT nextval('public.regimens_id_seq'::regclass);


--
-- Name: releases id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.releases ALTER COLUMN id SET DEFAULT nextval('public.releases_id_seq'::regclass);


--
-- Name: saved_gardens id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.saved_gardens ALTER COLUMN id SET DEFAULT nextval('public.saved_gardens_id_seq'::regclass);


--
-- Name: sensor_readings id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensor_readings ALTER COLUMN id SET DEFAULT nextval('public.sensor_readings_id_seq'::regclass);


--
-- Name: sensors id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensors ALTER COLUMN id SET DEFAULT nextval('public.sensors_id_seq'::regclass);


--
-- Name: sequence_publications id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequence_publications ALTER COLUMN id SET DEFAULT nextval('public.sequence_publications_id_seq'::regclass);


--
-- Name: sequence_versions id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequence_versions ALTER COLUMN id SET DEFAULT nextval('public.sequence_versions_id_seq'::regclass);


--
-- Name: sequences id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequences ALTER COLUMN id SET DEFAULT nextval('public.sequences_id_seq'::regclass);


--
-- Name: standard_pairs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.standard_pairs ALTER COLUMN id SET DEFAULT nextval('public.standard_pairs_id_seq'::regclass);


--
-- Name: telemetries id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.telemetries ALTER COLUMN id SET DEFAULT nextval('public.telemetries_id_seq'::regclass);


--
-- Name: token_issuances id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.token_issuances ALTER COLUMN id SET DEFAULT nextval('public.token_issuances_id_seq'::regclass);


--
-- Name: tools id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.tools ALTER COLUMN id SET DEFAULT nextval('public.tools_id_seq'::regclass);


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: -
--

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


--
-- Name: web_app_configs id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.web_app_configs ALTER COLUMN id SET DEFAULT nextval('public.web_app_configs_id_seq'::regclass);


--
-- Name: webcam_feeds id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.webcam_feeds ALTER COLUMN id SET DEFAULT nextval('public.webcam_feeds_id_seq'::regclass);


--
-- Name: wizard_step_results id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wizard_step_results ALTER COLUMN id SET DEFAULT nextval('public.wizard_step_results_id_seq'::regclass);


--
-- Name: active_storage_attachments active_storage_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: active_storage_blobs active_storage_blobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: active_storage_variant_records active_storage_variant_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: ai_feedbacks ai_feedbacks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.ai_feedbacks
    ADD CONSTRAINT ai_feedbacks_pkey PRIMARY KEY (id);


--
-- Name: alerts alerts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alerts
    ADD CONSTRAINT alerts_pkey PRIMARY KEY (id);


--
-- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: arg_names arg_names_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.arg_names
    ADD CONSTRAINT arg_names_pkey PRIMARY KEY (id);


--
-- Name: arg_sets arg_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.arg_sets
    ADD CONSTRAINT arg_sets_pkey PRIMARY KEY (id);


--
-- Name: curves curves_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.curves
    ADD CONSTRAINT curves_pkey PRIMARY KEY (id);


--
-- Name: delayed_jobs delayed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.delayed_jobs
    ADD CONSTRAINT delayed_jobs_pkey PRIMARY KEY (id);


--
-- Name: devices devices_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.devices
    ADD CONSTRAINT devices_pkey PRIMARY KEY (id);


--
-- Name: edge_nodes edge_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.edge_nodes
    ADD CONSTRAINT edge_nodes_pkey PRIMARY KEY (id);


--
-- Name: farm_events farm_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farm_events
    ADD CONSTRAINT farm_events_pkey PRIMARY KEY (id);


--
-- Name: farmware_envs farmware_envs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_envs
    ADD CONSTRAINT farmware_envs_pkey PRIMARY KEY (id);


--
-- Name: farmware_installations farmware_installations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_installations
    ADD CONSTRAINT farmware_installations_pkey PRIMARY KEY (id);


--
-- Name: fbos_configs fbos_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fbos_configs
    ADD CONSTRAINT fbos_configs_pkey PRIMARY KEY (id);


--
-- Name: firmware_configs firmware_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.firmware_configs
    ADD CONSTRAINT firmware_configs_pkey PRIMARY KEY (id);


--
-- Name: folders folders_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.folders
    ADD CONSTRAINT folders_pkey PRIMARY KEY (id);


--
-- Name: fragments fragments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fragments
    ADD CONSTRAINT fragments_pkey PRIMARY KEY (id);


--
-- Name: global_bulletins global_bulletins_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.global_bulletins
    ADD CONSTRAINT global_bulletins_pkey PRIMARY KEY (id);


--
-- Name: global_configs global_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.global_configs
    ADD CONSTRAINT global_configs_pkey PRIMARY KEY (id);


--
-- Name: images images_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.images
    ADD CONSTRAINT images_pkey PRIMARY KEY (id);


--
-- Name: kinds kinds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.kinds
    ADD CONSTRAINT kinds_pkey PRIMARY KEY (id);


--
-- Name: logs logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.logs
    ADD CONSTRAINT logs_pkey PRIMARY KEY (id);


--
-- Name: nodes nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.nodes
    ADD CONSTRAINT nodes_pkey PRIMARY KEY (id);


--
-- Name: peripherals peripherals_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.peripherals
    ADD CONSTRAINT peripherals_pkey PRIMARY KEY (id);


--
-- Name: pin_bindings pin_bindings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pin_bindings
    ADD CONSTRAINT pin_bindings_pkey PRIMARY KEY (id);


--
-- Name: plant_templates plant_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plant_templates
    ADD CONSTRAINT plant_templates_pkey PRIMARY KEY (id);


--
-- Name: point_group_items point_group_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_group_items
    ADD CONSTRAINT point_group_items_pkey PRIMARY KEY (id);


--
-- Name: point_groups point_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_groups
    ADD CONSTRAINT point_groups_pkey PRIMARY KEY (id);


--
-- Name: points points_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.points
    ADD CONSTRAINT points_pkey PRIMARY KEY (id);


--
-- Name: primary_nodes primary_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primary_nodes
    ADD CONSTRAINT primary_nodes_pkey PRIMARY KEY (id);


--
-- Name: primitive_pairs primitive_pairs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primitive_pairs
    ADD CONSTRAINT primitive_pairs_pkey PRIMARY KEY (id);


--
-- Name: primitives primitives_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primitives
    ADD CONSTRAINT primitives_pkey PRIMARY KEY (id);


--
-- Name: regimen_items regimen_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.regimen_items
    ADD CONSTRAINT regimen_items_pkey PRIMARY KEY (id);


--
-- Name: regimens regimens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.regimens
    ADD CONSTRAINT regimens_pkey PRIMARY KEY (id);


--
-- Name: releases releases_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.releases
    ADD CONSTRAINT releases_pkey PRIMARY KEY (id);


--
-- Name: saved_gardens saved_gardens_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.saved_gardens
    ADD CONSTRAINT saved_gardens_pkey PRIMARY KEY (id);


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: sensor_readings sensor_readings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensor_readings
    ADD CONSTRAINT sensor_readings_pkey PRIMARY KEY (id);


--
-- Name: sensors sensors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensors
    ADD CONSTRAINT sensors_pkey PRIMARY KEY (id);


--
-- Name: sequence_publications sequence_publications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequence_publications
    ADD CONSTRAINT sequence_publications_pkey PRIMARY KEY (id);


--
-- Name: sequence_versions sequence_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequence_versions
    ADD CONSTRAINT sequence_versions_pkey PRIMARY KEY (id);


--
-- Name: sequences sequences_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sequences
    ADD CONSTRAINT sequences_pkey PRIMARY KEY (id);


--
-- Name: standard_pairs standard_pairs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.standard_pairs
    ADD CONSTRAINT standard_pairs_pkey PRIMARY KEY (id);


--
-- Name: telemetries telemetries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.telemetries
    ADD CONSTRAINT telemetries_pkey PRIMARY KEY (id);


--
-- Name: token_issuances token_issuances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.token_issuances
    ADD CONSTRAINT token_issuances_pkey PRIMARY KEY (id);


--
-- Name: tools tools_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.tools
    ADD CONSTRAINT tools_pkey PRIMARY KEY (id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: web_app_configs web_app_configs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.web_app_configs
    ADD CONSTRAINT web_app_configs_pkey PRIMARY KEY (id);


--
-- Name: webcam_feeds webcam_feeds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.webcam_feeds
    ADD CONSTRAINT webcam_feeds_pkey PRIMARY KEY (id);


--
-- Name: wizard_step_results wizard_step_results_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wizard_step_results
    ADD CONSTRAINT wizard_step_results_pkey PRIMARY KEY (id);


--
-- Name: delayed_jobs_priority; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX delayed_jobs_priority ON public.delayed_jobs USING btree (priority, run_at);


--
-- Name: index_active_storage_attachments_on_blob_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_active_storage_attachments_on_blob_id ON public.active_storage_attachments USING btree (blob_id);


--
-- Name: index_active_storage_attachments_uniqueness; Type: INDEX; Schema: public; Owner: -
--

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


--
-- Name: index_active_storage_blobs_on_key; Type: INDEX; Schema: public; Owner: -
--

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


--
-- Name: index_active_storage_variant_records_uniqueness; Type: INDEX; Schema: public; Owner: -
--

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


--
-- Name: index_ai_feedbacks_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_ai_feedbacks_on_device_id ON public.ai_feedbacks USING btree (device_id);


--
-- Name: index_alerts_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_alerts_on_device_id ON public.alerts USING btree (device_id);


--
-- Name: index_arg_sets_on_fragment_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_arg_sets_on_fragment_id ON public.arg_sets USING btree (fragment_id);


--
-- Name: index_arg_sets_on_node_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_arg_sets_on_node_id ON public.arg_sets USING btree (node_id);


--
-- Name: index_curves_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_curves_on_device_id ON public.curves USING btree (device_id);


--
-- Name: index_devices_on_mounted_tool_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_devices_on_mounted_tool_id ON public.devices USING btree (mounted_tool_id);


--
-- Name: index_devices_on_timezone; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_devices_on_timezone ON public.devices USING btree (timezone);


--
-- Name: index_edge_nodes_on_kind_and_value; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_edge_nodes_on_kind_and_value ON public.edge_nodes USING btree (kind, value);


--
-- Name: index_edge_nodes_on_primary_node_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_edge_nodes_on_primary_node_id ON public.edge_nodes USING btree (primary_node_id);


--
-- Name: index_edge_nodes_on_sequence_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_edge_nodes_on_sequence_id ON public.edge_nodes USING btree (sequence_id);


--
-- Name: index_farm_events_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_farm_events_on_device_id ON public.farm_events USING btree (device_id);


--
-- Name: index_farm_events_on_end_time; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_farm_events_on_end_time ON public.farm_events USING btree (end_time);


--
-- Name: index_farm_events_on_executable_type_and_executable_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_farm_events_on_executable_type_and_executable_id ON public.farm_events USING btree (executable_type, executable_id);


--
-- Name: index_farmware_envs_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_farmware_envs_on_device_id ON public.farmware_envs USING btree (device_id);


--
-- Name: index_farmware_installations_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_farmware_installations_on_device_id ON public.farmware_installations USING btree (device_id);


--
-- Name: index_fbos_configs_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_fbos_configs_on_device_id ON public.fbos_configs USING btree (device_id);


--
-- Name: index_firmware_configs_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_firmware_configs_on_device_id ON public.firmware_configs USING btree (device_id);


--
-- Name: index_folders_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_folders_on_device_id ON public.folders USING btree (device_id);


--
-- Name: index_fragments_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_fragments_on_device_id ON public.fragments USING btree (device_id);


--
-- Name: index_fragments_on_owner; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_fragments_on_owner ON public.fragments USING btree (owner_type, owner_id);


--
-- Name: index_global_configs_on_key; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_global_configs_on_key ON public.global_configs USING btree (key);


--
-- Name: index_images_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_images_on_device_id ON public.images USING btree (device_id);


--
-- Name: index_logs_on_created_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_created_at ON public.logs USING btree (created_at);


--
-- Name: index_logs_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_device_id ON public.logs USING btree (device_id);


--
-- Name: index_logs_on_device_id_and_created_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_device_id_and_created_at ON public.logs USING btree (device_id, created_at);


--
-- Name: index_logs_on_sent_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_sent_at ON public.logs USING btree (sent_at);


--
-- Name: index_logs_on_type; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_type ON public.logs USING btree (type);


--
-- Name: index_logs_on_updated_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_updated_at ON public.logs USING btree (updated_at);


--
-- Name: index_logs_on_verbosity; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_verbosity ON public.logs USING btree (verbosity);


--
-- Name: index_logs_on_verbosity_and_type; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_logs_on_verbosity_and_type ON public.logs USING btree (verbosity, type);


--
-- Name: index_nodes_on_fragment_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_nodes_on_fragment_id ON public.nodes USING btree (fragment_id);


--
-- Name: index_nodes_on_kind_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_nodes_on_kind_id ON public.nodes USING btree (kind_id);


--
-- Name: index_peripherals_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_peripherals_on_device_id ON public.peripherals USING btree (device_id);


--
-- Name: index_peripherals_on_mode; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_peripherals_on_mode ON public.peripherals USING btree (mode);


--
-- Name: index_pin_bindings_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_pin_bindings_on_device_id ON public.pin_bindings USING btree (device_id);


--
-- Name: index_pin_bindings_on_sequence_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_pin_bindings_on_sequence_id ON public.pin_bindings USING btree (sequence_id);


--
-- Name: index_plant_templates_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_plant_templates_on_device_id ON public.plant_templates USING btree (device_id);


--
-- Name: index_plant_templates_on_saved_garden_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_plant_templates_on_saved_garden_id ON public.plant_templates USING btree (saved_garden_id);


--
-- Name: index_point_group_items_on_point_group_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_point_group_items_on_point_group_id ON public.point_group_items USING btree (point_group_id);


--
-- Name: index_point_group_items_on_point_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_point_group_items_on_point_id ON public.point_group_items USING btree (point_id);


--
-- Name: index_point_groups_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_point_groups_on_device_id ON public.point_groups USING btree (device_id);


--
-- Name: index_points_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_points_on_device_id ON public.points USING btree (device_id);


--
-- Name: index_points_on_device_id_and_tool_id; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX index_points_on_device_id_and_tool_id ON public.points USING btree (device_id, tool_id);


--
-- Name: index_points_on_discarded_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_points_on_discarded_at ON public.points USING btree (discarded_at);


--
-- Name: index_points_on_id_and_pointer_type; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_points_on_id_and_pointer_type ON public.points USING btree (id, pointer_type);


--
-- Name: index_points_on_meta; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_points_on_meta ON public.points USING gin (meta);


--
-- Name: index_points_on_tool_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_points_on_tool_id ON public.points USING btree (tool_id);


--
-- Name: index_primary_nodes_on_body_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primary_nodes_on_body_id ON public.primary_nodes USING btree (body_id);


--
-- Name: index_primary_nodes_on_child_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primary_nodes_on_child_id ON public.primary_nodes USING btree (child_id);


--
-- Name: index_primary_nodes_on_next_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primary_nodes_on_next_id ON public.primary_nodes USING btree (next_id);


--
-- Name: index_primary_nodes_on_parent_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primary_nodes_on_parent_id ON public.primary_nodes USING btree (parent_id);


--
-- Name: index_primary_nodes_on_sequence_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primary_nodes_on_sequence_id ON public.primary_nodes USING btree (sequence_id);


--
-- Name: index_primitive_pairs_on_arg_name_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primitive_pairs_on_arg_name_id ON public.primitive_pairs USING btree (arg_name_id);


--
-- Name: index_primitive_pairs_on_arg_set_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primitive_pairs_on_arg_set_id ON public.primitive_pairs USING btree (arg_set_id);


--
-- Name: index_primitive_pairs_on_fragment_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primitive_pairs_on_fragment_id ON public.primitive_pairs USING btree (fragment_id);


--
-- Name: index_primitive_pairs_on_primitive_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primitive_pairs_on_primitive_id ON public.primitive_pairs USING btree (primitive_id);


--
-- Name: index_primitives_on_fragment_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_primitives_on_fragment_id ON public.primitives USING btree (fragment_id);


--
-- Name: index_regimen_items_on_regimen_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_regimen_items_on_regimen_id ON public.regimen_items USING btree (regimen_id);


--
-- Name: index_regimen_items_on_sequence_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_regimen_items_on_sequence_id ON public.regimen_items USING btree (sequence_id);


--
-- Name: index_regimens_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_regimens_on_device_id ON public.regimens USING btree (device_id);


--
-- Name: index_saved_gardens_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_saved_gardens_on_device_id ON public.saved_gardens USING btree (device_id);


--
-- Name: index_sensor_readings_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sensor_readings_on_device_id ON public.sensor_readings USING btree (device_id);


--
-- Name: index_sensors_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sensors_on_device_id ON public.sensors USING btree (device_id);


--
-- Name: index_sequence_versions_on_sequence_publication_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sequence_versions_on_sequence_publication_id ON public.sequence_versions USING btree (sequence_publication_id);


--
-- Name: index_sequences_on_created_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sequences_on_created_at ON public.sequences USING btree (created_at);


--
-- Name: index_sequences_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sequences_on_device_id ON public.sequences USING btree (device_id);


--
-- Name: index_sequences_on_folder_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sequences_on_folder_id ON public.sequences USING btree (folder_id);


--
-- Name: index_sequences_on_sequence_version_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_sequences_on_sequence_version_id ON public.sequences USING btree (sequence_version_id);


--
-- Name: index_standard_pairs_on_arg_name_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_standard_pairs_on_arg_name_id ON public.standard_pairs USING btree (arg_name_id);


--
-- Name: index_standard_pairs_on_arg_set_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_standard_pairs_on_arg_set_id ON public.standard_pairs USING btree (arg_set_id);


--
-- Name: index_standard_pairs_on_fragment_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_standard_pairs_on_fragment_id ON public.standard_pairs USING btree (fragment_id);


--
-- Name: index_standard_pairs_on_node_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_standard_pairs_on_node_id ON public.standard_pairs USING btree (node_id);


--
-- Name: index_telemetries_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_telemetries_on_device_id ON public.telemetries USING btree (device_id);


--
-- Name: index_token_issuances_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_token_issuances_on_device_id ON public.token_issuances USING btree (device_id);


--
-- Name: index_token_issuances_on_exp; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_token_issuances_on_exp ON public.token_issuances USING btree (exp);


--
-- Name: index_token_issuances_on_jti_and_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_token_issuances_on_jti_and_device_id ON public.token_issuances USING btree (jti, device_id);


--
-- Name: index_tools_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_tools_on_device_id ON public.tools USING btree (device_id);


--
-- Name: index_users_on_agreed_to_terms_at; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_users_on_agreed_to_terms_at ON public.users USING btree (agreed_to_terms_at);


--
-- Name: index_users_on_confirmation_token; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_users_on_confirmation_token ON public.users USING btree (confirmation_token);


--
-- Name: index_users_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_users_on_device_id ON public.users USING btree (device_id);


--
-- Name: index_users_on_email; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX index_users_on_email ON public.users USING btree (email);


--
-- Name: index_web_app_configs_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_web_app_configs_on_device_id ON public.web_app_configs USING btree (device_id);


--
-- Name: index_webcam_feeds_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_webcam_feeds_on_device_id ON public.webcam_feeds USING btree (device_id);


--
-- Name: index_wizard_step_results_on_device_id; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX index_wizard_step_results_on_device_id ON public.wizard_step_results USING btree (device_id);


--
-- Name: farm_events farm_events_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farm_events
    ADD CONSTRAINT farm_events_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: sensor_readings fk_rails_04297fb1ff; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensor_readings
    ADD CONSTRAINT fk_rails_04297fb1ff FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: pin_bindings fk_rails_1f1c3b6979; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pin_bindings
    ADD CONSTRAINT fk_rails_1f1c3b6979 FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: folders fk_rails_58e285f76e; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.folders
    ADD CONSTRAINT fk_rails_58e285f76e FOREIGN KEY (parent_id) REFERENCES public.folders(id);


--
-- Name: telemetries fk_rails_6f6c1e8196; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.telemetries
    ADD CONSTRAINT fk_rails_6f6c1e8196 FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: sensors fk_rails_92e56bf2fb; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sensors
    ADD CONSTRAINT fk_rails_92e56bf2fb FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: active_storage_variant_records fk_rails_993965df05; Type: FK CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: wizard_step_results fk_rails_9958bb64ab; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wizard_step_results
    ADD CONSTRAINT fk_rails_9958bb64ab FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: points fk_rails_a62cbb8aca; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.points
    ADD CONSTRAINT fk_rails_a62cbb8aca FOREIGN KEY (tool_id) REFERENCES public.tools(id);


--
-- Name: farmware_envs fk_rails_ab55c3a1d1; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_envs
    ADD CONSTRAINT fk_rails_ab55c3a1d1 FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: primary_nodes fk_rails_bca7fee3b9; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.primary_nodes
    ADD CONSTRAINT fk_rails_bca7fee3b9 FOREIGN KEY (sequence_id) REFERENCES public.sequences(id);


--
-- Name: alerts fk_rails_c0132c78be; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.alerts
    ADD CONSTRAINT fk_rails_c0132c78be FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: active_storage_attachments fk_rails_c3b3935057; Type: FK CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: farmware_installations fk_rails_c72f38683f; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmware_installations
    ADD CONSTRAINT fk_rails_c72f38683f FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: edge_nodes fk_rails_c86213fd78; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.edge_nodes
    ADD CONSTRAINT fk_rails_c86213fd78 FOREIGN KEY (sequence_id) REFERENCES public.sequences(id);


--
-- Name: ai_feedbacks fk_rails_d25a0df7d7; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.ai_feedbacks
    ADD CONSTRAINT fk_rails_d25a0df7d7 FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: points fk_rails_d6f3cdbe9a; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.points
    ADD CONSTRAINT fk_rails_d6f3cdbe9a FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: token_issuances fk_rails_e202a61188; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.token_issuances
    ADD CONSTRAINT fk_rails_e202a61188 FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: devices fk_rails_eef5afaff7; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.devices
    ADD CONSTRAINT fk_rails_eef5afaff7 FOREIGN KEY (mounted_tool_id) REFERENCES public.tools(id);


--
-- Name: pin_bindings fk_rails_f72ee24d98; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pin_bindings
    ADD CONSTRAINT fk_rails_f72ee24d98 FOREIGN KEY (sequence_id) REFERENCES public.sequences(id);


--
-- Name: peripherals fk_rails_fdaad0007f; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.peripherals
    ADD CONSTRAINT fk_rails_fdaad0007f FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: fragments fragments_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fragments
    ADD CONSTRAINT fragments_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: logs logs_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.logs
    ADD CONSTRAINT logs_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: plant_templates plant_templates_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plant_templates
    ADD CONSTRAINT plant_templates_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: point_group_items point_group_items_point_group_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_group_items
    ADD CONSTRAINT point_group_items_point_group_id_fk FOREIGN KEY (point_group_id) REFERENCES public.point_groups(id);


--
-- Name: point_group_items point_group_items_point_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_group_items
    ADD CONSTRAINT point_group_items_point_id_fk FOREIGN KEY (point_id) REFERENCES public.points(id);


--
-- Name: point_groups point_groups_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.point_groups
    ADD CONSTRAINT point_groups_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: saved_gardens saved_gardens_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.saved_gardens
    ADD CONSTRAINT saved_gardens_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: tools tools_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.tools
    ADD CONSTRAINT tools_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- Name: users users_device_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_device_id_fk FOREIGN KEY (device_id) REFERENCES public.devices(id);


--
-- PostgreSQL database dump complete
--

SET search_path TO "$user", public;

INSERT INTO "schema_migrations" (version) VALUES
('20260422013033'),
('20260417190743'),
('20260305192457'),
('20250930204600'),
('20250925195004'),
('20250802174543'),
('20250722234106'),
('20250514203443'),
('20250502201109'),
('20250221191831'),
('20241203211516'),
('20241203194030'),
('20240625195838'),
('20240405171128'),
('20240207234421'),
('20240202171922'),
('20240118204046'),
('20230808192946'),
('20230714173031'),
('20230714010144'),
('20230712201622'),
('20230616184850'),
('20230413204758'),
('20230210010108'),
('20221222192831'),
('20221109233217'),
('20221103172100'),
('20221028172528'),
('20221027211207'),
('20220819170955'),
('20220810212545'),
('20220620225957'),
('20220415191331'),
('20220413194334'),
('20211206165259'),
('20211117212015'),
('20211104173453'),
('20211030193113'),
('20211007164834'),
('20210929220719'),
('20210917165755'),
('20210914194342'),
('20210913175949'),
('20210901215214'),
('20210820134844'),
('20210803205352'),
('20210723175109'),
('20210720183535'),
('20210720155040'),
('20210607193347'),
('20210514010354'),
('20210501195411'),
('20210308191813'),
('20210304221750'),
('20210217010948'),
('20210210144434'),
('20210201145935'),
('20210107224804'),
('20201216101103'),
('20201211161018'),
('20201211161017'),
('20201124235014'),
('20201120162403'),
('20201118183247'),
('20201105145245'),
('20200914165414'),
('20200910175338'),
('20200907153510'),
('20200902141446'),
('20200823211337'),
('20200807182602'),
('20200804150609'),
('20200801150609'),
('20200704150931'),
('20200630190226'),
('20200629181002'),
('20200623161209'),
('20200621012312'),
('20200616172612'),
('20200412152208'),
('20200323235926'),
('20200204230135'),
('20200204192005'),
('20200116140201'),
('20191220010646'),
('20191219212755'),
('20191203163621'),
('20191119204916'),
('20191107170431'),
('20191002125625'),
('20190930202839'),
('20190924190539'),
('20190918185359'),
('20190823164837'),
('20190804194154'),
('20190804194135'),
('20190729134954'),
('20190722160305'),
('20190715214412'),
('20190709194037'),
('20190701155706'),
('20190621202204'),
('20190621160042'),
('20190613215319'),
('20190613190531'),
('20190607192429'),
('20190605185311'),
('20190603233157'),
('20190515205442'),
('20190515185612'),
('20190513221836'),
('20190512015442'),
('20190504170018'),
('20190502163453'),
('20190501143201'),
('20190419174811'),
('20190419174728'),
('20190419052844'),
('20190419001321'),
('20190417165636'),
('20190416035406'),
('20190411222900'),
('20190411171401'),
('20190411152319'),
('20190401212119'),
('20190307205648'),
('20190212215842'),
('20190209133811'),
('20190108211419'),
('20190103213956'),
('20190103211708'),
('20181208035706'),
('20181204005038'),
('20181126175951'),
('20181112010427'),
('20181025182807'),
('20181019023351'),
('20181014221342'),
('20180926161918'),
('20180925203846'),
('20180920194120'),
('20180910143055'),
('20180829211322'),
('20180815143819'),
('20180813185430'),
('20180727152741'),
('20180726165546'),
('20180726145505'),
('20180720021451'),
('20180719143412'),
('20180716163108'),
('20180713182937'),
('20180615153318'),
('20180609144559'),
('20180606131907'),
('20180524161501'),
('20180521195953'),
('20180521140428'),
('20180520201349'),
('20180518131709'),
('20180508141310'),
('20180502050250'),
('20180501121046'),
('20180430161447'),
('20180423202520'),
('20180423171551'),
('20180419164627'),
('20180418205557'),
('20180417123713'),
('20180413145332'),
('20180413125139'),
('20180412224141'),
('20180412191221'),
('20180412144034'),
('20180411175813'),
('20180411122627'),
('20180410192539'),
('20180410180929'),
('20180410160336'),
('20180409150813'),
('20180407131311'),
('20180404165355'),
('20180403211523'),
('20180401141611'),
('20180330143232'),
('20180330130914'),
('20180328212540'),
('20180328200512'),
('20180326160853'),
('20180325222824'),
('20180325220047'),
('20180323190601'),
('20180315205136'),
('20180310220435'),
('20180306195021'),
('20180305170608'),
('20180301222052'),
('20180228144634'),
('20180227172811'),
('20180226164100'),
('20180217173606'),
('20180216205047'),
('20180215224528'),
('20180215205625'),
('20180215171709'),
('20180215064728'),
('20180213175531'),
('20180211161515'),
('20180209134752'),
('20180205173255'),
('20180202165503'),
('20180201153221'),
('20180201031848'),
('20180126141955'),
('20180124194814'),
('20180122203010'),
('20180121191538'),
('20180109165402'),
('20180109070610'),
('20180105175215'),
('20180104215253'),
('20171031184914'),
('20171017200333'),
('20171003144428'),
('20171003143906'),
('20170918173928'),
('20170818163411'),
('20170814084814'),
('20170807143633'),
('20170703010946'),
('20170629160248');