--
--


SET transaction_timeout = 0;

--
-- Name: calculate_monthly_budget(bigint, date); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.calculate_monthly_budget(p_article_id bigint, p_target_month date DEFAULT CURRENT_DATE) RETURNS numeric
    LANGUAGE plpgsql
    AS $$
            DECLARE
                v_monthly_budget DECIMAL(30,20);
                v_target_year INTEGER;
                v_target_month_num INTEGER;
            BEGIN
                -- Extract year and month from target date
                v_target_year := EXTRACT(YEAR FROM p_target_month);
                v_target_month_num := EXTRACT(MONTH FROM p_target_month);

                -- Sum all forecast_quantity values for the specified calendar month
                SELECT COALESCE(SUM(forecast_quantity), 0)
                INTO v_monthly_budget
                FROM sales_forecasts
                WHERE article_id = p_article_id
                  AND EXTRACT(YEAR FROM forecast_date) = v_target_year
                  AND EXTRACT(MONTH FROM forecast_date) = v_target_month_num;

                RETURN v_monthly_budget;
            END;
            $$;


ALTER FUNCTION public.calculate_monthly_budget(p_article_id bigint, p_target_month date) OWNER TO postgres;

--
-- Name: calculate_production_data(bigint); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.calculate_production_data(p_article_id bigint) RETURNS void
    LANGUAGE plpgsql
    AS $$
            DECLARE
                v_stock_disponible DECIMAL(30,20);
                v_monthly_budget DECIMAL(30,20);
                v_target_coverage_months INTEGER;
                v_batch_size DECIMAL(30,20);
                v_initial_coverage DECIMAL(30,20);
                v_quantity_to_produce DECIMAL(30,20);
                v_batches_to_produce DECIMAL(30,20);
                v_priority SMALLINT;
                v_month_year RECORD;
            BEGIN
                -- Get stock and article data
                SELECT
                    COALESCE(a.stock, 0),
                    a.target_coverage_months,
                    COALESCE(a.batch_size, 1)
                INTO
                    v_stock_disponible,
                    v_target_coverage_months,
                    v_batch_size
                FROM articles a
                WHERE a.id = p_article_id;

                -- Loop through all months that have forecast data for this article
                FOR v_month_year IN
                    SELECT DISTINCT
                        make_date(EXTRACT(YEAR FROM forecast_date)::INTEGER, EXTRACT(MONTH FROM forecast_date)::INTEGER, 1) as calculation_date
                    FROM sales_forecasts
                    WHERE article_id = p_article_id
                    ORDER BY calculation_date
                LOOP
                    -- Calculate monthly_budget from sales forecasts for this specific month
                    v_monthly_budget := calculate_monthly_budget(p_article_id, v_month_year.calculation_date);

                    -- Calculate initial_coverage
                    IF v_monthly_budget > 0 THEN
                        v_initial_coverage := (v_stock_disponible / v_monthly_budget) * 26;
                    ELSE
                        v_initial_coverage := 0;
                    END IF;

                    -- Calculate quantity_to_produce
                    v_quantity_to_produce := (v_target_coverage_months - (v_initial_coverage / 26)) * v_monthly_budget;

                    IF v_quantity_to_produce < 0 THEN
                        v_quantity_to_produce := 0;
                    END IF;

                    -- Calculate batches_to_produce
                    IF v_batch_size > 0 THEN
                        v_batches_to_produce := CEIL(v_quantity_to_produce / v_batch_size);
                    ELSE
                        v_batches_to_produce := 0;
                    END IF;

                    -- Calculate priority based on business rules
                    -- If initial_coverage (days) is NULL, treat as 0 for the comparison
                    -- If initial_coverage < 26 → priority = 1
                    -- Else if initial_coverage < 78 → priority = 2
                    -- Else (≥ 78) → priority = 3
                    IF COALESCE(v_initial_coverage, 0) < 26 THEN
                        v_priority := 1;
                    ELSIF COALESCE(v_initial_coverage, 0) < 78 THEN
                        v_priority := 2;
                    ELSE
                        v_priority := 3;
                    END IF;

                    -- Insert or update for this specific month
                    INSERT INTO production_calculations (
                        article_id, calculation_date, initial_coverage,
                        monthly_budget, quantity_to_produce, batches_to_produce,
                        priority, created_at, updated_at
                    ) VALUES (
                        p_article_id, v_month_year.calculation_date, v_initial_coverage,
                        v_monthly_budget, v_quantity_to_produce, v_batches_to_produce,
                        v_priority, NOW(), NOW()
                    )
                    ON CONFLICT (article_id, calculation_date)
                    DO UPDATE SET
                        initial_coverage = EXCLUDED.initial_coverage,
                        monthly_budget = EXCLUDED.monthly_budget,
                        quantity_to_produce = EXCLUDED.quantity_to_produce,
                        batches_to_produce = EXCLUDED.batches_to_produce,
                        priority = EXCLUDED.priority,
                        updated_at = NOW();
                END LOOP;
            END;
            $$;


ALTER FUNCTION public.calculate_production_data(p_article_id bigint) OWNER TO postgres;

--
-- Name: calculate_quantity_per_lot(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.calculate_quantity_per_lot() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            DECLARE
                parent_batch_size DECIMAL(30,20);
            BEGIN
                SELECT batch_size INTO parent_batch_size
                FROM articles
                WHERE id = NEW.parent_article_id;

                IF parent_batch_size IS NOT NULL THEN
                    NEW.quantity_per_lot := parent_batch_size * NEW.quantity_per_unit;
                END IF;

                RETURN NEW;
            END;
            $$;


ALTER FUNCTION public.calculate_quantity_per_lot() OWNER TO postgres;

--
-- Name: calculate_sales_forecast_variance(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.calculate_sales_forecast_variance() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
			DECLARE
				week_start DATE;
				week_end DATE;
				actual_qty DECIMAL(30,20);
				forecast_qty DECIMAL(30,20);
				variance_qty DECIMAL(30,20);
				variance_pct DECIMAL(28,20);
			BEGIN
				IF TG_TABLE_NAME = 'stock_movements' THEN
					week_start := DATE_TRUNC('week', COALESCE(NEW.movement_date, OLD.movement_date));
					week_end := week_start + INTERVAL '6 days';

					SELECT COALESCE(SUM(ABS(quantity)), 0) INTO actual_qty
					FROM stock_movements
					WHERE article_id = COALESCE(NEW.article_id, OLD.article_id)
					AND movement_date BETWEEN week_start AND week_end;

					SELECT forecast_quantity INTO forecast_qty
					FROM sales_forecasts
					WHERE article_id = COALESCE(NEW.article_id, OLD.article_id)
					AND forecast_date BETWEEN week_start AND week_end;

					IF forecast_qty IS NOT NULL THEN
						variance_qty := actual_qty - forecast_qty;
						variance_pct := CASE
							WHEN forecast_qty > 0 THEN (variance_qty / forecast_qty) * 100
							ELSE 0
						END;

						UPDATE sales_forecasts
						SET total_actual_quantity = actual_qty,
							variance_quantity = variance_qty,
							variance_percentage = variance_pct,
							updated_at = NOW()
						WHERE article_id = COALESCE(NEW.article_id, OLD.article_id)
						AND forecast_date BETWEEN week_start AND week_end;
					END IF;
				END IF;

				IF TG_TABLE_NAME = 'sales_forecasts' THEN
					week_start := DATE_TRUNC('week', NEW.forecast_date);
					week_end := week_start + INTERVAL '6 days';

					SELECT COALESCE(SUM(ABS(quantity)), 0) INTO actual_qty
					FROM stock_movements
					WHERE article_id = NEW.article_id
					AND movement_date BETWEEN week_start AND week_end;

					variance_qty := actual_qty - NEW.forecast_quantity;
					variance_pct := CASE
						WHEN NEW.forecast_quantity > 0 THEN (variance_qty / NEW.forecast_quantity) * 100
						ELSE 0
					END;

					NEW.total_actual_quantity := actual_qty;
					NEW.variance_quantity := variance_qty;
					NEW.variance_percentage := variance_pct;
				END IF;

				RETURN COALESCE(NEW, OLD);
			END;
			$$;


ALTER FUNCTION public.calculate_sales_forecast_variance() OWNER TO postgres;


ALTER FUNCTION public.log_table_change() OWNER TO postgres;


ALTER FUNCTION public.set_change_source(source_name text) OWNER TO postgres;

--
-- Name: trigger_calculate_production(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.trigger_calculate_production() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            BEGIN
                -- Handle different table triggers
                IF TG_TABLE_NAME = 'stock_details' THEN
                    PERFORM calculate_production_data(NEW.article_id);
                ELSIF TG_TABLE_NAME = 'articles' THEN
                    PERFORM calculate_production_data(NEW.id);
                END IF;

                RETURN NEW;
            END;
            $$;


ALTER FUNCTION public.trigger_calculate_production() OWNER TO postgres;

--
-- Name: trigger_refresh_priority_on_category_change(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.trigger_refresh_priority_on_category_change() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            BEGIN
                -- Only refresh if category actually changed
                IF OLD.category IS DISTINCT FROM NEW.category THEN
                    -- Update priority for current month production_calculations
                    UPDATE production_calculations
                    SET
                        article_category = NEW.category,
                        priority = CASE
                            WHEN COALESCE(initial_coverage, 0) < 26 THEN 1
                            WHEN COALESCE(initial_coverage, 0) < 78 THEN 2
                            WHEN NEW.category = 'OFF' THEN 3
                            ELSE 4
                        END,
                        updated_at = NOW()
                    WHERE article_id = NEW.id
                      AND calculation_date >= date_trunc('month', CURRENT_DATE);
                END IF;
                
                RETURN NEW;
            END;
            $$;


ALTER FUNCTION public.trigger_refresh_priority_on_category_change() OWNER TO postgres;

--
-- Name: trigger_update_monthly_budget(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.trigger_update_monthly_budget() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            BEGIN
                -- Handle INSERT and UPDATE
                IF TG_OP = 'DELETE' THEN
                    -- For DELETE, use OLD record
                    PERFORM calculate_production_data(OLD.article_id);
                    RETURN OLD;
                ELSE
                    -- For INSERT and UPDATE, use NEW record
                    PERFORM calculate_production_data(NEW.article_id);
                    RETURN NEW;
                END IF;
            END;
            $$;


ALTER FUNCTION public.trigger_update_monthly_budget() OWNER TO postgres;

--
-- Name: trigger_update_priority(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.trigger_update_priority() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            BEGIN
                -- Calculate priority based on initial_coverage only
                -- If initial_coverage < 26 → priority = 1
                -- Else if initial_coverage < 78 → priority = 2
                -- Else (≥ 78) → priority = 3
                IF COALESCE(NEW.initial_coverage, 0) < 26 THEN
                    NEW.priority := 1;
                ELSIF COALESCE(NEW.initial_coverage, 0) < 78 THEN
                    NEW.priority := 2;
                ELSE
                    NEW.priority := 3;
                END IF;
                
                RETURN NEW;
            END;
            $$;


ALTER FUNCTION public.trigger_update_priority() OWNER TO postgres;


ALTER FUNCTION public.update_article_stock() OWNER TO postgres;

--
-- Name: update_product_compositions_on_article_change(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.update_product_compositions_on_article_change() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
            BEGIN
                IF OLD.batch_size IS DISTINCT FROM NEW.batch_size THEN
                    UPDATE product_compositions
                    SET quantity_per_lot = NEW.batch_size * quantity_per_unit
                    WHERE parent_article_id = NEW.id;
                END IF;

                RETURN NEW;
            END;
            $$;


ALTER FUNCTION public.update_product_compositions_on_article_change() OWNER TO postgres;



--
-- Name: article_families; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.article_families (
    id bigint NOT NULL,
    family_code character varying(255) NOT NULL,
    family_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    CONSTRAINT check_family_code_valid CHECK (((family_code)::text = ANY (ARRAY[('MP'::character varying)::text, ('PF'::character varying)::text, ('AC'::character varying)::text, ('SF'::character varying)::text])))
);


ALTER TABLE public.article_families OWNER TO postgres;

--
-- Name: COLUMN article_families.family_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.article_families.family_code IS 'c_famille_article';


--
-- Name: COLUMN article_families.family_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.article_families.family_name IS 'libelle_famille_article';


--
-- Name: article_families_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.article_families_id_seq OWNER TO postgres;

--
-- Name: article_families_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.article_families_id_seq OWNED BY public.article_families.id;


--
-- Name: articles; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.articles (
    id bigint NOT NULL,
    article_family_id bigint,
    article_code character varying(255) NOT NULL,
    article_name character varying(255) NOT NULL,
    inn character varying(255),
    category character varying(50),
    material_type character varying(50),
    form character varying(100),
    batch_size numeric(30,20),
    abc_classification character varying(1),
    unit_purchase character varying(20),
    unit_stock character varying(20),
    bulk_code character varying(50),
    is_complex boolean,
    is_sample boolean,
    target_coverage_months integer,
    stock numeric(30,20) DEFAULT '0'::numeric NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.articles OWNER TO postgres;

--
-- Name: COLUMN articles.article_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.article_code IS 'ITMREF_0, HC0099/C12028/V13001...';


--
-- Name: COLUMN articles.article_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.article_name IS 'ITMDES1_0';


--
-- Name: COLUMN articles.inn; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.inn IS 'TSICOD0_0, International Nonproprietary Name, OME';


--
-- Name: COLUMN articles.category; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.category IS 'TSICOD1_0, OFFICINAL or HOSPITALIER (finished_product), OFF/PIL/ETU';


--
-- Name: COLUMN articles.material_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.material_type IS 'TSICOD2_0, type primary_material, AC1/AC2/PRA/EXC...';


--
-- Name: COLUMN articles.form; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.form IS 'TSICOD3_0, Article form (tablet, capsule, gel, etc.), GEL/CAP/TAB/...';


--
-- Name: COLUMN articles.batch_size; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.batch_size IS 'REOMINQTY_0, taille_lot, 100/1000/10000...';


--
-- Name: COLUMN articles.abc_classification; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.abc_classification IS 'ABC inventory classification (A/B/C), used for prioritization';


--
-- Name: COLUMN articles.unit_purchase; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.unit_purchase IS 'PUU_0, Purchase unit of measure (primary_material), UN/MIL/KG...';


--
-- Name: COLUMN articles.unit_stock; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.unit_stock IS 'STU_0, Stock unit of measure (primary_material), UN/G...';


--
-- Name: COLUMN articles.bulk_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.bulk_code IS 'code_vrac (finished_product), IM1231/IM1232/...';


--
-- Name: COLUMN articles.is_complex; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.is_complex IS 'Complex articles: 4-6 months coverage (finished_product)';


--
-- Name: COLUMN articles.is_sample; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.is_sample IS 'echantillon (finished_product)';


--
-- Name: COLUMN articles.target_coverage_months; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.target_coverage_months IS 'coverture_cible_mois';


--
-- Name: COLUMN articles.stock; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.articles.stock IS 'Total stock quantity (sum of initial_quantity from stock_details with status A only)';


--
-- Name: articles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.articles_id_seq OWNER TO postgres;

--
-- Name: articles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.articles_id_seq OWNED BY public.articles.id;

--
-- Name: db_change_notifications; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.db_change_notifications (
    id integer NOT NULL,
    table_name character varying(255) NOT NULL,
    operation character varying(50) NOT NULL,
    record_id bigint NOT NULL,
    changed_data jsonb NOT NULL,
    source character varying(100) DEFAULT 'db_trigger'::character varying,
    processed boolean DEFAULT false,
    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.db_change_notifications OWNER TO postgres;

--
-- Name: db_change_notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.db_change_notifications_id_seq OWNER TO postgres;

--
-- Name: db_change_notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.db_change_notifications_id_seq OWNED BY public.db_change_notifications.id;


--
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO postgres;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- Name: job_batches; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.job_batches (
    id character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    total_jobs integer NOT NULL,
    pending_jobs integer NOT NULL,
    failed_jobs integer NOT NULL,
    failed_job_ids text NOT NULL,
    options text,
    cancelled_at integer,
    created_at integer NOT NULL,
    finished_at integer
);


ALTER TABLE public.job_batches OWNER TO postgres;

--
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.jobs (
    id bigint NOT NULL,
    queue character varying(255) NOT NULL,
    payload text NOT NULL,
    attempts smallint NOT NULL,
    reserved_at integer,
    available_at integer NOT NULL,
    created_at integer NOT NULL
);


ALTER TABLE public.jobs OWNER TO postgres;

--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres;

--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- Name: migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO postgres;

--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres;

--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- Name: notification_user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.notification_user (
    id bigint NOT NULL,
    notification_id bigint NOT NULL,
    user_id bigint NOT NULL,
    read_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.notification_user OWNER TO postgres;

--
-- Name: notification_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.notification_user_id_seq OWNER TO postgres;

--
-- Name: notification_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.notification_user_id_seq OWNED BY public.notification_user.id;


--
-- Name: notifications; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.notifications (
    id bigint NOT NULL,
    type character varying(255) NOT NULL,
    content jsonb NOT NULL,
    source character varying(100) DEFAULT 'application'::character varying NOT NULL,
    user_id bigint,
    read_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.notifications OWNER TO postgres;

--
-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.notifications_id_seq OWNER TO postgres;

--
-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.personal_access_tokens_id_seq OWNER TO postgres;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


--
-- Name: product_compositions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.product_compositions (
    id bigint NOT NULL,
    parent_article_id bigint NOT NULL,
    component_article_id bigint NOT NULL,
    quantity_per_unit numeric(30,20) NOT NULL,
    quantity_per_lot numeric(30,20) NOT NULL,
    operating_unit character varying(20) DEFAULT 'g'::character varying NOT NULL,
    conversion_factor numeric(30,20) DEFAULT '1'::numeric NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.product_compositions OWNER TO postgres;

--
-- Name: COLUMN product_compositions.parent_article_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.parent_article_id IS 'ITMREF_0, References the main article, HC0099/C12028/V13001...';


--
-- Name: COLUMN product_compositions.component_article_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.component_article_id IS 'CPNITMREF_0,References the component article, C15129/IM1231...';


--
-- Name: COLUMN product_compositions.quantity_per_unit; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.quantity_per_unit IS 'BOMQTY_0, Quantity per product unit, 1/14/0.02/...';


--
-- Name: COLUMN product_compositions.quantity_per_lot; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.quantity_per_lot IS 'Total quantity per production lot';


--
-- Name: COLUMN product_compositions.operating_unit; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.operating_unit IS 'BOMUOM_0, UN/G...';


--
-- Name: COLUMN product_compositions.conversion_factor; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.product_compositions.conversion_factor IS 'BOMSTUCOE_0, Conversion coefficient between units, 1/0.1/0.01...';


--
-- Name: product_compositions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.product_compositions_id_seq OWNER TO postgres;

--
-- Name: product_compositions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.product_compositions_id_seq OWNED BY public.product_compositions.id;


--
-- Name: production_calculations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.production_calculations (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    initial_coverage numeric(30,20),
    monthly_budget numeric(30,20),
    calculation_date date NOT NULL,
    quantity_to_produce numeric(30,20),
    batches_to_produce numeric(30,20),
    priority smallint DEFAULT '3'::smallint NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.production_calculations OWNER TO postgres;

--
-- Name: COLUMN production_calculations.initial_coverage; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.initial_coverage IS 'Initial coverage in days: (stock_disponible / monthly_budget) * 26';


--
-- Name: COLUMN production_calculations.monthly_budget; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.monthly_budget IS 'Monthly budget calculated from sum of forecast_quantity grouped by calendar month';


--
-- Name: COLUMN production_calculations.calculation_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.calculation_date IS 'First day of the month for which calculations are performed (YYYY-MM-01)';


--
-- Name: COLUMN production_calculations.quantity_to_produce; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.quantity_to_produce IS 'Quantity to produce: (target_coverage_months - initial_coverage_months) * monthly_budget';


--
-- Name: COLUMN production_calculations.batches_to_produce; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.batches_to_produce IS 'Batches to produce: quantity_to_produce / batch_size';


--
-- Name: COLUMN production_calculations.priority; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_calculations.priority IS 'Priority level: 1 (highest) to 3 (lowest) based on initial_coverage thresholds';


--
-- Name: production_calculations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.production_calculations_id_seq OWNER TO postgres;

--
-- Name: production_calculations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.production_calculations_id_seq OWNED BY public.production_calculations.id;


--
-- Name: production_orders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.production_orders (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    code character varying(100),
    status character varying(255) NOT NULL,
    batch_size_override numeric(30,20),
    batch_sales_quantity numeric(30,20),
    batch_sample_quantity numeric(30,20),
    selected_sf_stock_detail_id bigint,
    notes text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    deleted_at timestamp(0) without time zone,
    CONSTRAINT production_orders_status_check CHECK (((status)::text = ANY (ARRAY[('pending'::character varying)::text, ('in_progress'::character varying)::text, ('completed'::character varying)::text])))
);


ALTER TABLE public.production_orders OWNER TO postgres;

--
-- Name: COLUMN production_orders.article_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_orders.article_id IS 'References a finished product article';


--
-- Name: COLUMN production_orders.status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_orders.status IS 'Order status: pending, in_progress, completed';


--
-- Name: COLUMN production_orders.batch_size_override; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.production_orders.batch_size_override IS 'Batch size override for this order only (overrides article batch_size)';


--
-- Name: production_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.production_orders_id_seq OWNER TO postgres;

--
-- Name: production_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.production_orders_id_seq OWNED BY public.production_orders.id;


--
-- Name: sales_forecasts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sales_forecasts (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    warehouse_id bigint,
    forecast_code character varying(100) NOT NULL,
    forecast_date date NOT NULL,
    forecast_quantity numeric(30,20) NOT NULL,
    total_actual_quantity numeric(30,20) DEFAULT '0'::numeric NOT NULL,
    variance_quantity numeric(30,20) DEFAULT '0'::numeric NOT NULL,
    variance_percentage numeric(28,20) DEFAULT '0'::numeric NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.sales_forecasts OWNER TO postgres;

--
-- Name: COLUMN sales_forecasts.forecast_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.forecast_code IS 'VCRNUM_0, Unique forecast code, SENDAR14057844/SENDAR14057845/...';


--
-- Name: COLUMN sales_forecasts.forecast_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.forecast_date IS 'STRDAT_0, Weekly forecast date, 2025-01-01/2025-01-07...';


--
-- Name: COLUMN sales_forecasts.forecast_quantity; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.forecast_quantity IS 'EXTQTY_0, Forecast quantity for the week, 425/1000/10000...';


--
-- Name: COLUMN sales_forecasts.total_actual_quantity; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.total_actual_quantity IS 'Total actual quantity from stock movements for the week';


--
-- Name: COLUMN sales_forecasts.variance_quantity; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.variance_quantity IS 'Variance between actual and forecast (actual - forecast)';


--
-- Name: COLUMN sales_forecasts.variance_percentage; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sales_forecasts.variance_percentage IS 'Variance percentage ((actual - forecast) / forecast * 100)';


--
-- Name: sales_forecasts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.sales_forecasts_id_seq OWNER TO postgres;

--
-- Name: sales_forecasts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sales_forecasts_id_seq OWNED BY public.sales_forecasts.id;


--
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sessions (
    id character varying(255) NOT NULL,
    user_id bigint,
    ip_address character varying(45),
    user_agent text,
    payload text NOT NULL,
    last_activity integer NOT NULL
);


ALTER TABLE public.sessions OWNER TO postgres;

--
-- Name: stock_details; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.stock_details (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    article_family_id bigint,
    warehouse_id bigint,
    batch_number_fp character varying(100),
    batch_number_rm character varying(100),
    status character varying(20) DEFAULT 'A'::character varying NOT NULL,
    initial_quantity numeric(30,20) DEFAULT '0'::numeric NOT NULL,
    expiry_date date,
    inspection_date date,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.stock_details OWNER TO postgres;

--
-- Name: COLUMN stock_details.batch_number_fp; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.batch_number_fp IS 'LOT_0, Batch number for finished products, DAR250029/DAR220998...';


--
-- Name: COLUMN stock_details.batch_number_rm; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.batch_number_rm IS 'Batch number for raw materials';


--
-- Name: COLUMN stock_details.status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.status IS 'STA_0, Stock status, A/Q, A: accepte, Q: quitable';


--
-- Name: COLUMN stock_details.initial_quantity; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.initial_quantity IS 'QTYSTU_0, Initial quantity (available stock), 2518/1/10...';


--
-- Name: COLUMN stock_details.expiry_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.expiry_date IS 'SHLDAT_0, Expiry date, 2025-01-01/2025-01-02/...';


--
-- Name: COLUMN stock_details.inspection_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_details.inspection_date IS 'Inspection date for quality control';


--
-- Name: stock_details_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.stock_details_id_seq OWNER TO postgres;

--
-- Name: stock_details_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.stock_details_id_seq OWNED BY public.stock_details.id;


--
-- Name: stock_movements; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.stock_movements (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    warehouse_id bigint,
    movement_date date NOT NULL,
    quantity numeric(30,20) NOT NULL,
    forecast_code character varying(100),
    batch_number_fp character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.stock_movements OWNER TO postgres;

--
-- Name: COLUMN stock_movements.movement_date; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_movements.movement_date IS 'IPTDAT_0 - Daily Date of the stock movement';


--
-- Name: COLUMN stock_movements.quantity; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.stock_movements.quantity IS 'QTYSTU_0 - Quantity moved (negative for outgoing), -108/-36';


--
-- Name: stock_movements_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.stock_movements_id_seq OWNER TO postgres;

--
-- Name: stock_movements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.stock_movements_id_seq OWNED BY public.stock_movements.id;

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

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


ALTER SEQUENCE public.users_id_seq OWNER TO postgres;

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

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


--
-- Name: variance_alerts_sent; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.variance_alerts_sent (
    id bigint NOT NULL,
    article_id bigint NOT NULL,
    week_start date NOT NULL,
    created_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.variance_alerts_sent OWNER TO postgres;

--
-- Name: COLUMN variance_alerts_sent.week_start; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.variance_alerts_sent.week_start IS 'Monday date of the week for which the alert was sent (YYYY-MM-DD)';


--
-- Name: COLUMN variance_alerts_sent.created_at; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.variance_alerts_sent.created_at IS 'When the alert was sent';


--
-- Name: variance_alerts_sent_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.variance_alerts_sent_id_seq OWNER TO postgres;

--
-- Name: variance_alerts_sent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.variance_alerts_sent_id_seq OWNED BY public.variance_alerts_sent.id;


--
-- Name: warehouses; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.warehouses (
    id bigint NOT NULL,
    warehouse_code character varying(50) NOT NULL,
    warehouse_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.warehouses OWNER TO postgres;

--
-- Name: warehouses_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

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


ALTER SEQUENCE public.warehouses_id_seq OWNER TO postgres;

--
-- Name: warehouses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.warehouses_id_seq OWNED BY public.warehouses.id;


--
-- Name: article_families id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: articles id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: db_change_notifications id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: notification_user id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: notifications id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: product_compositions id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: production_calculations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: production_orders id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: sales_forecasts id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: stock_details id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: stock_movements id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: variance_alerts_sent id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: warehouses id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Data for Name: article_families; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.article_families (id, family_code, family_name, created_at, updated_at) FROM stdin;
1	MP	Matière Première	2025-09-25 04:09:28	2025-09-25 04:09:28
2	PF	Produit Fini	2025-09-25 04:09:28	2025-09-25 04:09:28
3	AC	Article de Conditionnement	2025-09-25 04:09:28	2025-09-25 04:09:28
4	SF	Semi-Fini	2025-09-25 04:09:28	2025-09-25 04:09:28
\.


--
-- Data for Name: articles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.articles (id, article_family_id, article_code, article_name, inn, category, material_type, form, batch_size, abc_classification, unit_purchase, unit_stock, bulk_code, is_complex, is_sample, target_coverage_months, stock, is_active, created_at, updated_at) FROM stdin;
11	4	C15753	DarOmeprazole	 	VIG	AC2	 	0.00000000000000000000	\N	UN	UN	\N	\N	\N	\N	0.00000000000000000000	t	\N	\N
12	4	C15916	DarOmeprazole	 	ETI	AC2	 	0.00000000000000000000	\N	UN	UN	\N	\N	\N	\N	0.00000000000000000000	t	\N	\N
4	3	C12028	DarOmeprazole	 	PIL	AC1	 	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	240595.00000000000000000000	t	\N	\N
5	3	C13024	DarOmeprazole	 	 	 	 	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	91541.00000000000000000000	t	\N	\N
6	3	C14205	DarOmeprazole	 	ETU	AC2	 	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	10747.00000000000000000000	t	\N	\N
7	3	C15129	DarOmeprazole	 	ETI	AC2	 	1000.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	10697.00000000000000000000	t	\N	\N
8	3	C15768	DarOmeprazole	 	PRO	AC2	 	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	17799.00000000000000000000	t	\N	\N
9	3	C25037	DarOmeprazole	 	CAR	AC2	 	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	3067.00000000000000000000	t	\N	\N
2	1	H19156	DarOmeprazole	 	 	PRA	 	0.00000000000000000000	\N	KG	G	\N	\N	\N	\N	76477.00000000000000000000	t	\N	\N
10	4	IM1231	DarOmeprazole	 	SF	 	GEL	107296.00000000000000000000	\N	UN	UN	\N	\N	\N	\N	2340.00000000000000000000	t	\N	\N
3	1	V13001	DarOmeprazole	 	EXC	EXC	GEL	0.00000000000000000000	\N	MIL	UN	\N	\N	\N	\N	1684232.00000000000000000000	t	\N	\N
1	2	HC0099	DarOmeprazole	OME	OFF		GEL	7642.00000000000000000000	\N	UN	UN	\N	\N	\N	\N	2518.00000000000000000000	t	\N	\N
\.


--
-- Data for Name: db_change_notifications; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.db_change_notifications (id, table_name, operation, record_id, changed_data, source, processed, created_at) FROM stdin;
1	production_calculations	UPDATE	17	{"id": 17, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3231.00000000000000000000, "calculation_date": "2017-04-01", "initial_coverage": 20.26245744351593933766, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
2	production_calculations	UPDATE	105	{"id": 105, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2636.00000000000000000000, "calculation_date": "2023-01-01", "initial_coverage": 24.83611532625189681338, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
3	production_calculations	UPDATE	238	{"id": 238, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2692.00000000000000000000, "calculation_date": "2023-04-01", "initial_coverage": 24.31946508172362555712, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
4	production_calculations	UPDATE	432	{"id": 432, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2700.00000000000000000000, "calculation_date": "2021-07-01", "initial_coverage": 24.24740740740740740734, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
5	production_calculations	UPDATE	795	{"id": 795, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2592.00000000000000000000, "calculation_date": "2023-10-01", "initial_coverage": 25.25771604938271604928, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
6	production_calculations	UPDATE	1632	{"id": 1632, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2850.00000000000000000000, "calculation_date": "2019-01-01", "initial_coverage": 22.97122807017543859640, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
7	production_calculations	UPDATE	412	{"id": 412, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2700.00000000000000000000, "calculation_date": "2021-06-01", "initial_coverage": 24.24740740740740740734, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
8	production_calculations	UPDATE	1662	{"id": 1662, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2532.00000000000000000000, "calculation_date": "2019-02-01", "initial_coverage": 25.85624012638230647720, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
9	production_calculations	UPDATE	2212	{"id": 2212, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2534.00000000000000000000, "calculation_date": "2019-04-01", "initial_coverage": 25.83583267561168113644, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
10	production_calculations	UPDATE	2246	{"id": 2246, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2852.00000000000000000000, "calculation_date": "2019-06-01", "initial_coverage": 22.95511921458625525942, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
11	production_calculations	UPDATE	2389	{"id": 2389, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2532.00000000000000000000, "calculation_date": "2019-10-01", "initial_coverage": 25.85624012638230647720, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
12	production_calculations	UPDATE	4174	{"id": 4174, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2880.00000000000000000000, "calculation_date": "2021-04-01", "initial_coverage": 22.73194444444444444456, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
13	production_calculations	UPDATE	2212	{"id": 2212, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3801.00000000000000000000, "calculation_date": "2019-04-01", "initial_coverage": 17.22388845040778742438, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
14	production_calculations	UPDATE	2212	{"id": 2212, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 5068.00000000000000000000, "calculation_date": "2019-04-01", "initial_coverage": 12.91791633780584056822, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
15	production_calculations	UPDATE	4174	{"id": 4174, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3840.00000000000000000000, "calculation_date": "2021-04-01", "initial_coverage": 17.04895833333333333342, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
16	production_calculations	UPDATE	2893	{"id": 2893, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2852.00000000000000000000, "calculation_date": "2019-07-01", "initial_coverage": 22.95511921458625525942, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
17	production_calculations	UPDATE	2389	{"id": 2389, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3165.00000000000000000000, "calculation_date": "2019-10-01", "initial_coverage": 20.68499210110584518176, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
18	production_calculations	UPDATE	2538	{"id": 2538, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2532.00000000000000000000, "calculation_date": "2019-11-01", "initial_coverage": 25.85624012638230647720, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
19	production_calculations	UPDATE	4174	{"id": 4174, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 4800.00000000000000000000, "calculation_date": "2021-04-01", "initial_coverage": 13.63916666666666666658, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
20	production_calculations	UPDATE	2816	{"id": 2816, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2700.00000000000000000000, "calculation_date": "2021-01-01", "initial_coverage": 24.24740740740740740734, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
21	production_calculations	UPDATE	10658	{"id": 10658, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3000.00000000000000000000, "calculation_date": "2021-10-01", "initial_coverage": 21.82266666666666666658, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
22	production_calculations	INSERT	12235	{"id": 12235, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 4945.00000000000000000000, "calculation_date": "2020-04-01", "initial_coverage": 13.23923154701718907986, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
23	production_calculations	INSERT	12310	{"id": 12310, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2780.00000000000000000000, "calculation_date": "2020-06-01", "initial_coverage": 23.54964028776978417266, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
24	production_calculations	INSERT	12385	{"id": 12385, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2780.00000000000000000000, "calculation_date": "2020-07-01", "initial_coverage": 23.54964028776978417266, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
25	production_calculations	INSERT	13089	{"id": 13089, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2780.00000000000000000000, "calculation_date": "2020-01-01", "initial_coverage": 23.54964028776978417266, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
26	production_calculations	INSERT	13263	{"id": 13263, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3090.00000000000000000000, "calculation_date": "2020-10-01", "initial_coverage": 21.18705501618122977352, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
27	production_calculations	UPDATE	18751	{"id": 18751, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2772.00000000000000000000, "calculation_date": "2018-04-01", "initial_coverage": 23.61760461760461760466, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
28	production_calculations	UPDATE	22604	{"id": 22604, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2576.00000000000000000000, "calculation_date": "2018-07-01", "initial_coverage": 25.41459627329192546574, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
29	production_calculations	INSERT	33667	{"id": 33667, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2942.00000000000000000000, "calculation_date": "2022-07-01", "initial_coverage": 22.25288919102651257648, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
30	production_calculations	INSERT	35192	{"id": 35192, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2844.00000000000000000000, "calculation_date": "2022-01-01", "initial_coverage": 23.01969057665260196902, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
31	production_calculations	INSERT	36605	{"id": 36605, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3081.00000000000000000000, "calculation_date": "2022-04-01", "initial_coverage": 21.24894514767932489452, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
32	production_calculations	UPDATE	32407	{"id": 32407, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2928.00000000000000000000, "calculation_date": "2017-06-01", "initial_coverage": 22.35928961748633879780, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
33	production_calculations	UPDATE	31621	{"id": 31621, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2928.00000000000000000000, "calculation_date": "2017-11-01", "initial_coverage": 22.35928961748633879780, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
34	production_calculations	UPDATE	32013	{"id": 32013, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3012.00000000000000000000, "calculation_date": "2017-10-01", "initial_coverage": 21.73572377158034528546, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
35	production_calculations	UPDATE	29366	{"id": 29366, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2760.00000000000000000000, "calculation_date": "2017-01-01", "initial_coverage": 23.72028985507246376818, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
36	production_calculations	UPDATE	31105	{"id": 31105, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2836.00000000000000000000, "calculation_date": "2017-02-01", "initial_coverage": 23.08462623413258110006, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
37	production_calculations	UPDATE	29611	{"id": 29611, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2968.00000000000000000000, "calculation_date": "2017-03-01", "initial_coverage": 22.05795148247978436656, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
38	production_calculations	UPDATE	31234	{"id": 31234, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 3320.00000000000000000000, "calculation_date": "2017-05-01", "initial_coverage": 19.71927710843373493964, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
39	production_calculations	UPDATE	31491	{"id": 31491, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2892.00000000000000000000, "calculation_date": "2017-09-01", "initial_coverage": 22.63762102351313969574, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
40	production_calculations	INSERT	38612	{"id": 38612, "priority": 1, "article_id": 1, "created_at": "2025-09-25T12:59:00", "updated_at": "2025-09-25T12:59:00", "monthly_budget": 2714.00000000000000000000, "calculation_date": "2022-10-01", "initial_coverage": 24.12232866617538688282, "batches_to_produce": null, "quantity_to_produce": null}	db_trigger	f	2025-09-25 12:59:00.040549
\.


--
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
\.


--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
\.


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.migrations (id, migration, batch) FROM stdin;
\.


--
-- Data for Name: notification_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.notification_user (id, notification_id, user_id, read_at, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.notifications (id, type, content, source, user_id, read_at, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: product_compositions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.product_compositions (id, parent_article_id, component_article_id, quantity_per_unit, quantity_per_lot, operating_unit, conversion_factor, created_at, updated_at) FROM stdin;
1	1	7	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
2	1	10	14.00000000000000000000	106988.00000000000000000000	UN	1.00000000000000000000	\N	\N
3	1	6	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
4	1	11	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
5	1	8	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
6	1	12	0.02777700000000000000	212.27183400000000000000	UN	1.00000000000000000000	\N	\N
7	1	9	0.02777700000000000000	212.27183400000000000000	UN	1.00000000000000000000	\N	\N
8	1	4	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
9	1	5	1.00000000000000000000	7642.00000000000000000000	UN	1.00000000000000000000	\N	\N
10	10	2	0.23300000000000000000	24999.96800000000000000000	G	1.00000000000000000000	\N	\N
11	10	3	1.00000000000000000000	107296.00000000000000000000	UN	1.00000000000000000000	\N	\N
\.


--
-- Data for Name: production_calculations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.production_calculations (id, article_id, initial_coverage, monthly_budget, calculation_date, quantity_to_produce, batches_to_produce, priority, created_at, updated_at) FROM stdin;
27205	1	38.51058823529411764712	1700.00000000000000000000	2015-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
25921	1	46.76285714285714285718	1400.00000000000000000000	2015-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
26037	1	62.23193916349809885928	1052.00000000000000000000	2015-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
26154	1	50.36000000000000000008	1300.00000000000000000000	2015-04-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
28745	1	54.55666666666666666658	1200.00000000000000000000	2015-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
29839	1	65.46800000000000000000	1000.00000000000000000000	2015-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
28986	1	72.74222222222222222228	900.00000000000000000000	2015-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
28507	1	68.76890756302521008392	952.00000000000000000000	2015-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
30338	1	81.83500000000000000000	800.00000000000000000000	2015-09-01	\N	\N	3	2025-09-25 12:59:00	2025-09-25 12:59:32
25693	1	59.51636363636363636366	1100.00000000000000000000	2015-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
25580	1	54.55666666666666666658	1200.00000000000000000000	2015-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
25468	1	54.55666666666666666658	1200.00000000000000000000	2015-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
17206	1	43.64533333333333333342	1500.00000000000000000000	2016-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
17300	1	40.91750000000000000000	1600.00000000000000000000	2016-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
20413	1	40.91750000000000000000	1600.00000000000000000000	2016-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
17771	1	38.51058823529411764712	1700.00000000000000000000	2016-04-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18057	1	38.51058823529411764712	1700.00000000000000000000	2016-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
19987	1	43.64533333333333333342	1500.00000000000000000000	2016-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18154	1	43.64533333333333333342	1500.00000000000000000000	2016-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
16562	1	50.36000000000000000008	1300.00000000000000000000	2016-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
15745	1	50.36000000000000000008	1300.00000000000000000000	2016-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
15480	1	54.55666666666666666658	1200.00000000000000000000	2016-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
15657	1	54.55666666666666666658	1200.00000000000000000000	2016-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
15928	1	65.46800000000000000000	1000.00000000000000000000	2016-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
29366	1	23.72028985507246376818	2760.00000000000000000000	2017-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
31105	1	23.08462623413258110006	2836.00000000000000000000	2017-02-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
29611	1	22.05795148247978436656	2968.00000000000000000000	2017-03-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
17	1	20.26245744351593933766	3231.00000000000000000000	2017-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
31234	1	19.71927710843373493964	3320.00000000000000000000	2017-05-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
32407	1	22.35928961748633879780	2928.00000000000000000000	2017-06-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
33886	1	27.46140939597315436254	2384.00000000000000000000	2017-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
31362	1	26.27126805778491171740	2492.00000000000000000000	2017-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
31491	1	22.63762102351313969574	2892.00000000000000000000	2017-09-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
32013	1	21.73572377158034528546	3012.00000000000000000000	2017-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
31621	1	22.35928961748633879780	2928.00000000000000000000	2017-11-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
31752	1	29.12277580071174377218	2248.00000000000000000000	2017-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18355	1	29.59674502712477396028	2212.00000000000000000000	2018-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18552	1	26.87520525451559934318	2436.00000000000000000000	2018-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18952	1	28.76449912126537785584	2276.00000000000000000000	2018-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
18751	1	23.61760461760461760466	2772.00000000000000000000	2018-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
18852	1	27.78777589134125636668	2356.00000000000000000000	2018-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
19159	1	26.39838709677419354832	2480.00000000000000000000	2018-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
22604	1	25.41459627329192546574	2576.00000000000000000000	2018-07-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
19263	1	35.97142857142857142848	1820.00000000000000000000	2018-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
21079	1	35.42640692640692640686	1848.00000000000000000000	2018-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
19472	1	31.96679687500000000000	2048.00000000000000000000	2018-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
22938	1	27.60033726812816188878	2372.00000000000000000000	2018-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
19578	1	36.29046563192904656322	1804.00000000000000000000	2018-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
1632	1	22.97122807017543859640	2850.00000000000000000000	2019-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
1662	1	25.85624012638230647720	2532.00000000000000000000	2019-02-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2179	1	34.45684210526315789486	1900.00000000000000000000	2019-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2212	1	12.91791633780584056822	5068.00000000000000000000	2019-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2649	1	29.55665914221218961620	2215.00000000000000000000	2019-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2246	1	22.95511921458625525942	2852.00000000000000000000	2019-06-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2893	1	22.95511921458625525942	2852.00000000000000000000	2019-07-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2281	1	41.30473186119873817042	1585.00000000000000000000	2019-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2352	1	34.45684210526315789486	1900.00000000000000000000	2019-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2389	1	20.68499210110584518176	3165.00000000000000000000	2019-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2538	1	25.85624012638230647720	2532.00000000000000000000	2019-11-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
2615	1	29.54332129963898916960	2216.00000000000000000000	2019-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
13089	1	23.54964028776978417266	2780.00000000000000000000	2020-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
12162	1	26.48381877022653721690	2472.00000000000000000000	2020-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
13173	1	35.34989200863930885530	1852.00000000000000000000	2020-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12235	1	13.23923154701718907986	4945.00000000000000000000	2020-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
12021	1	30.25323475046210720876	2164.00000000000000000000	2020-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12310	1	23.54964028776978417266	2780.00000000000000000000	2020-06-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
12385	1	23.54964028776978417266	2780.00000000000000000000	2020-07-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
12092	1	42.40155440414507772028	1544.00000000000000000000	2020-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12462	1	35.34989200863930885530	1852.00000000000000000000	2020-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
13263	1	21.18705501618122977352	3090.00000000000000000000	2020-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
13348	1	26.48381877022653721690	2472.00000000000000000000	2020-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
9725	1	30.23926096997690531166	2165.00000000000000000000	2020-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2816	1	24.24740740740740740734	2700.00000000000000000000	2021-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
1030	1	27.27833333333333333342	2400.00000000000000000000	2021-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
733	1	36.37111111111111111114	1800.00000000000000000000	2021-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
4174	1	13.63916666666666666658	4800.00000000000000000000	2021-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
393	1	31.17523809523809523812	2100.00000000000000000000	2021-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
412	1	24.24740740740740740734	2700.00000000000000000000	2021-06-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
432	1	24.24740740740740740734	2700.00000000000000000000	2021-07-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
1245	1	43.64533333333333333342	1500.00000000000000000000	2021-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
10859	1	36.37111111111111111114	1800.00000000000000000000	2021-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
10658	1	21.82266666666666666658	3000.00000000000000000000	2021-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
10997	1	27.27833333333333333342	2400.00000000000000000000	2021-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
221	1	31.01279014684983420184	2111.00000000000000000000	2021-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
35192	1	23.01969057665260196902	2844.00000000000000000000	2022-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
33259	1	31.10118764845605700720	2105.00000000000000000000	2022-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
35053	1	36.67675070028011204474	1785.00000000000000000000	2022-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
36605	1	21.24894514767932489452	3081.00000000000000000000	2022-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
33394	1	31.93560975609756097554	2050.00000000000000000000	2022-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
33530	1	35.67738419618528610364	1835.00000000000000000000	2022-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
33667	1	22.25288919102651257648	2942.00000000000000000000	2022-07-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
33805	1	39.94386821232458816360	1639.00000000000000000000	2022-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
36752	1	28.73924495171202809492	2278.00000000000000000000	2022-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
38612	1	24.12232866617538688282	2714.00000000000000000000	2022-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
377	1	29.66379700951517897592	2207.00000000000000000000	2022-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
150	1	38.96904761904761904752	1680.00000000000000000000	2022-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
105	1	24.83611532625189681338	2636.00000000000000000000	2023-01-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
75	1	30.08639705882352941178	2176.00000000000000000000	2023-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
90	1	29.62352941176470588240	2210.00000000000000000000	2023-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
238	1	24.31946508172362555712	2692.00000000000000000000	2023-04-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
214	1	33.88612836438923395458	1932.00000000000000000000	2023-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
1199	1	33.48746803069053708452	1955.00000000000000000000	2023-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
292	1	26.69983686786296900500	2452.00000000000000000000	2023-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
769	1	41.43544303797468354434	1580.00000000000000000000	2023-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
321	1	30.30925925925925925924	2160.00000000000000000000	2023-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
795	1	25.25771604938271604928	2592.00000000000000000000	2023-10-01	\N	\N	1	2025-09-25 12:59:00	2025-09-25 12:59:32
337	1	32.81604010025062656636	1995.00000000000000000000	2023-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
2013	1	49.59696969696969696976	1320.00000000000000000000	2023-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
484	1	37.45308924485125858120	1748.00000000000000000000	2024-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
506	1	38.85341246290801186942	1685.00000000000000000000	2024-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
8	1	40.61290322580645161280	1612.00000000000000000000	2024-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
23	1	38.78436018957345971554	1688.00000000000000000000	2024-04-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12570	1	40.79003115264797507788	1605.00000000000000000000	2024-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
14061	1	43.18469656992084432722	1516.00000000000000000000	2024-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
14406	1	43.87935656836461125994	1492.00000000000000000000	2024-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12648	1	53.66229508196721311472	1220.00000000000000000000	2024-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12727	1	40.61290322580645161280	1612.00000000000000000000	2024-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12807	1	39.67757575757575757586	1650.00000000000000000000	2024-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
12888	1	43.29894179894179894192	1512.00000000000000000000	2024-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
1	1	56.38931955211024978456	1161.00000000000000000000	2024-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3	1	29.89406392694063926948	2190.00000000000000000000	2025-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
61	1	61.99621212121212121220	1056.00000000000000000000	2025-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
7158	1	32.40990099009900990090	2020.00000000000000000000	2025-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
8089	1	30.99810606060606060610	2112.00000000000000000000	2025-04-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6142	1	32.57114427860696517400	2010.00000000000000000000	2025-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
8154	1	34.52953586497890295366	1896.00000000000000000000	2025-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6255	1	35.10348525469168900816	1865.00000000000000000000	2025-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
9500	1	42.95800524934383202088	1524.00000000000000000000	2025-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6313	1	32.47420634920634920644	2016.00000000000000000000	2025-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6372	1	31.70363196125907990312	2065.00000000000000000000	2025-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6432	1	34.60253699788583509526	1892.00000000000000000000	2025-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
6553	1	44.84109589041095890422	1460.00000000000000000000	2025-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
5099	1	29.89406392694063926948	2190.00000000000000000000	2026-01-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3846	1	61.99621212121212121220	1056.00000000000000000000	2026-02-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3138	1	32.40990099009900990090	2020.00000000000000000000	2026-03-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3182	1	30.95413711583924349892	2115.00000000000000000000	2026-04-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3227	1	32.60358565737051792832	2008.00000000000000000000	2026-05-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3318	1	34.52953586497890295366	1896.00000000000000000000	2026-06-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
5213	1	35.10348525469168900816	1865.00000000000000000000	2026-07-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
4001	1	42.95800524934383202088	1524.00000000000000000000	2026-08-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3365	1	32.47420634920634920644	2016.00000000000000000000	2026-09-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
4364	1	31.70363196125907990312	2065.00000000000000000000	2026-10-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3460	1	34.60253699788583509526	1892.00000000000000000000	2026-11-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
3509	1	44.93342484557309540144	1457.00000000000000000000	2026-12-01	\N	\N	2	2025-09-25 12:59:00	2025-09-25 12:59:32
\.


--
-- Data for Name: production_orders; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.production_orders (id, article_id, code, status, batch_size_override, batch_sales_quantity, batch_sample_quantity, selected_sf_stock_detail_id, notes, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: sales_forecasts; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sales_forecasts (id, article_id, warehouse_id, forecast_code, forecast_date, forecast_quantity, total_actual_quantity, variance_quantity, variance_percentage, created_at, updated_at) FROM stdin;
1	1	1	SENDAR24124116	2024-12-09	291.00000000000000000000	0.00000000000000000000	-291.00000000000000000000	-100.00000000000000000000	\N	\N
2	1	1	SENDAR24124119	2025-01-01	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
5	1	1	SENDAR24013257	2024-03-25	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
6	1	1	SENDAR24124115	2024-12-02	291.00000000000000000000	0.00000000000000000000	-291.00000000000000000000	-100.00000000000000000000	\N	\N
7	1	1	SENDAR24124117	2024-12-16	291.00000000000000000000	0.00000000000000000000	-291.00000000000000000000	-100.00000000000000000000	\N	\N
163	1	1	SENDAR20094809	2021-12-06	420.00000000000000000000	0.00000000000000000000	-420.00000000000000000000	-100.00000000000000000000	\N	\N
164	1	1	SENDAR24124212	2026-10-12	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
165	1	1	SENDAR24124214	2026-10-26	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
166	1	1	SENDAR24124216	2026-11-09	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
167	1	1	SENDAR24124219	2026-12-01	292.00000000000000000000	0.00000000000000000000	-292.00000000000000000000	-100.00000000000000000000	\N	\N
244	1	1	SENDAR24124168	2025-12-08	365.00000000000000000000	0.00000000000000000000	-365.00000000000000000000	-100.00000000000000000000	\N	\N
245	1	1	SENDAR24124172	2026-01-05	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
388	1	1	SENDAR17082412	2018-09-10	462.00000000000000000000	0.00000000000000000000	-462.00000000000000000000	-100.00000000000000000000	\N	\N
389	1	1	SENDAR15061288	2016-02-22	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
390	1	1	SENDAR15061290	2016-03-07	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
391	1	1	SENDAR15061291	2016-03-14	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
392	1	1	SENDAR15061292	2016-03-21	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
393	1	1	SENDAR15061299	2016-05-16	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
394	1	1	SENDAR15061302	2016-06-06	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
395	1	1	SENDAR15061303	2016-06-13	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
396	1	1	SENDAR15061304	2016-06-20	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
397	1	1	SENDAR17082382	2018-01-22	553.00000000000000000000	0.00000000000000000000	-553.00000000000000000000	-100.00000000000000000000	\N	\N
398	1	1	SENDAR17082387	2018-03-01	569.00000000000000000000	0.00000000000000000000	-569.00000000000000000000	-100.00000000000000000000	\N	\N
399	1	1	SENDAR17082390	2018-03-19	569.00000000000000000000	0.00000000000000000000	-569.00000000000000000000	-100.00000000000000000000	\N	\N
400	1	1	SENDAR17082396	2018-05-07	589.00000000000000000000	0.00000000000000000000	-589.00000000000000000000	-100.00000000000000000000	\N	\N
401	1	1	SENDAR17082401	2018-06-18	620.00000000000000000000	0.00000000000000000000	-620.00000000000000000000	-100.00000000000000000000	\N	\N
402	1	1	SENDAR17082403	2018-07-02	644.00000000000000000000	0.00000000000000000000	-644.00000000000000000000	-100.00000000000000000000	\N	\N
403	1	1	SENDAR17082404	2018-07-09	644.00000000000000000000	0.00000000000000000000	-644.00000000000000000000	-100.00000000000000000000	\N	\N
404	1	1	SENDAR17082415	2018-10-01	512.00000000000000000000	0.00000000000000000000	-512.00000000000000000000	-100.00000000000000000000	\N	\N
405	1	1	SENDAR17082421	2018-11-12	593.00000000000000000000	0.00000000000000000000	-593.00000000000000000000	-100.00000000000000000000	\N	\N
406	1	1	SENDAR17082424	2018-12-10	451.00000000000000000000	0.00000000000000000000	-451.00000000000000000000	-100.00000000000000000000	\N	\N
407	1	1	SENDAR17082426	2018-12-24	451.00000000000000000000	0.00000000000000000000	-451.00000000000000000000	-100.00000000000000000000	\N	\N
408	1	1	SENDAR17082388	2018-03-05	569.00000000000000000000	0.00000000000000000000	-569.00000000000000000000	-100.00000000000000000000	\N	\N
409	1	1	SENDAR17082397	2018-05-14	589.00000000000000000000	0.00000000000000000000	-589.00000000000000000000	-100.00000000000000000000	\N	\N
410	1	1	SENDAR17082398	2018-05-21	589.00000000000000000000	0.00000000000000000000	-589.00000000000000000000	-100.00000000000000000000	\N	\N
411	1	1	SENDAR17082399	2018-06-04	620.00000000000000000000	0.00000000000000000000	-620.00000000000000000000	-100.00000000000000000000	\N	\N
412	1	1	SENDAR17082406	2018-07-23	644.00000000000000000000	0.00000000000000000000	-644.00000000000000000000	-100.00000000000000000000	\N	\N
413	1	1	SENDAR17082407	2018-08-01	455.00000000000000000000	0.00000000000000000000	-455.00000000000000000000	-100.00000000000000000000	\N	\N
13	1	1	SENDAR24124120	2025-01-06	438.00000000000000000000	396.00000000000000000000	-42.00000000000000000000	-9.58904109589041095900	\N	2025-09-25 12:59:32
3	1	1	SENDAR24124121	2025-01-13	438.00000000000000000000	288.00000000000000000000	-150.00000000000000000000	-34.24657534246575342500	\N	2025-09-25 12:59:32
4	1	1	SENDAR24124122	2025-01-20	438.00000000000000000000	180.00000000000000000000	-258.00000000000000000000	-58.90410958904109589000	\N	2025-09-25 12:59:32
14	1	1	SENDAR24124123	2025-01-27	438.00000000000000000000	540.00000000000000000000	102.00000000000000000000	23.28767123287671232900	\N	2025-09-25 12:59:32
16	1	1	SENDAR24124124	2025-02-03	264.00000000000000000000	216.00000000000000000000	-48.00000000000000000000	-18.18181818181818181800	\N	2025-09-25 12:59:32
414	1	1	SENDAR17082418	2018-10-22	512.00000000000000000000	0.00000000000000000000	-512.00000000000000000000	-100.00000000000000000000	\N	\N
415	1	1	SENDAR17082423	2018-12-03	451.00000000000000000000	0.00000000000000000000	-451.00000000000000000000	-100.00000000000000000000	\N	\N
416	1	1	SENDAR17082383	2018-02-01	609.00000000000000000000	0.00000000000000000000	-609.00000000000000000000	-100.00000000000000000000	\N	\N
417	1	1	SENDAR17082393	2018-04-16	693.00000000000000000000	0.00000000000000000000	-693.00000000000000000000	-100.00000000000000000000	\N	\N
418	1	1	SENDAR17082402	2018-06-25	620.00000000000000000000	0.00000000000000000000	-620.00000000000000000000	-100.00000000000000000000	\N	\N
419	1	1	SENDAR17082405	2018-07-16	644.00000000000000000000	0.00000000000000000000	-644.00000000000000000000	-100.00000000000000000000	\N	\N
420	1	1	SENDAR17082413	2018-09-17	462.00000000000000000000	0.00000000000000000000	-462.00000000000000000000	-100.00000000000000000000	\N	\N
421	1	1	SENDAR17082414	2018-09-24	462.00000000000000000000	0.00000000000000000000	-462.00000000000000000000	-100.00000000000000000000	\N	\N
422	1	1	SENDAR17082419	2018-11-01	593.00000000000000000000	0.00000000000000000000	-593.00000000000000000000	-100.00000000000000000000	\N	\N
423	1	1	SENDAR17082410	2018-08-20	455.00000000000000000000	0.00000000000000000000	-455.00000000000000000000	-100.00000000000000000000	\N	\N
424	1	1	SENDAR17082411	2018-09-03	462.00000000000000000000	0.00000000000000000000	-462.00000000000000000000	-100.00000000000000000000	\N	\N
425	1	1	SENDAR17082416	2018-10-08	512.00000000000000000000	0.00000000000000000000	-512.00000000000000000000	-100.00000000000000000000	\N	\N
426	1	1	SENDAR17082420	2018-11-05	593.00000000000000000000	0.00000000000000000000	-593.00000000000000000000	-100.00000000000000000000	\N	\N
427	1	1	SENDAR17082422	2018-11-19	593.00000000000000000000	0.00000000000000000000	-593.00000000000000000000	-100.00000000000000000000	\N	\N
428	1	1	SENDAR14057891	2015-12-21	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
429	1	1	SENDAR14057885	2015-11-09	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
430	1	1	SENDAR14057882	2015-10-12	275.00000000000000000000	0.00000000000000000000	-275.00000000000000000000	-100.00000000000000000000	\N	\N
431	1	1	SENDAR14057886	2015-11-16	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
432	1	1	SENDAR14057849	2015-02-09	350.00000000000000000000	0.00000000000000000000	-350.00000000000000000000	-100.00000000000000000000	\N	\N
433	1	1	SENDAR14057855	2015-03-23	263.00000000000000000000	0.00000000000000000000	-263.00000000000000000000	-100.00000000000000000000	\N	\N
434	1	1	SENDAR14057856	2015-04-01	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
435	1	1	SENDAR14057858	2015-04-13	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
436	1	1	SENDAR14057881	2015-10-05	275.00000000000000000000	0.00000000000000000000	-275.00000000000000000000	-100.00000000000000000000	\N	\N
437	1	1	SENDAR14057883	2015-10-19	275.00000000000000000000	0.00000000000000000000	-275.00000000000000000000	-100.00000000000000000000	\N	\N
438	1	1	SENDAR14057884	2015-11-02	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
439	1	1	SENDAR14057889	2015-12-07	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
440	1	1	SENDAR14057887	2015-11-23	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
441	1	1	SENDAR14057888	2015-12-01	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
442	1	1	SENDAR14057890	2015-12-14	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
443	1	1	SENDAR14057844	2015-01-01	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
444	1	1	SENDAR14057845	2015-01-05	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
445	1	1	SENDAR14057847	2015-01-19	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
446	1	1	SENDAR14057851	2015-02-23	350.00000000000000000000	0.00000000000000000000	-350.00000000000000000000	-100.00000000000000000000	\N	\N
8	1	1	SENDAR17021107	2017-04-03	810.00000000000000000000	0.00000000000000000000	-810.00000000000000000000	-100.00000000000000000000	\N	\N
9	1	1	SENDAR24013258	2024-04-01	422.00000000000000000000	0.00000000000000000000	-422.00000000000000000000	-100.00000000000000000000	\N	\N
10	1	1	SENDAR24013259	2024-04-08	422.00000000000000000000	0.00000000000000000000	-422.00000000000000000000	-100.00000000000000000000	\N	\N
11	1	1	SENDAR24013260	2024-04-15	422.00000000000000000000	0.00000000000000000000	-422.00000000000000000000	-100.00000000000000000000	\N	\N
12	1	1	SENDAR24124118	2024-12-23	288.00000000000000000000	0.00000000000000000000	-288.00000000000000000000	-100.00000000000000000000	\N	\N
15	1	1	SENDAR17021110	2017-04-24	801.00000000000000000000	0.00000000000000000000	-801.00000000000000000000	-100.00000000000000000000	\N	\N
17	1	1	SENDAR17021108	2017-04-10	810.00000000000000000000	0.00000000000000000000	-810.00000000000000000000	-100.00000000000000000000	\N	\N
18	1	1	SENDAR17021109	2017-04-17	810.00000000000000000000	0.00000000000000000000	-810.00000000000000000000	-100.00000000000000000000	\N	\N
19	1	1	SENDAR22080464	2023-02-01	544.00000000000000000000	0.00000000000000000000	-544.00000000000000000000	-100.00000000000000000000	\N	\N
20	1	1	SENDAR22080466	2023-02-13	544.00000000000000000000	0.00000000000000000000	-544.00000000000000000000	-100.00000000000000000000	\N	\N
21	1	1	SENDAR22080470	2023-03-13	442.00000000000000000000	0.00000000000000000000	-442.00000000000000000000	-100.00000000000000000000	\N	\N
22	1	1	SENDAR22080471	2023-03-20	442.00000000000000000000	0.00000000000000000000	-442.00000000000000000000	-100.00000000000000000000	\N	\N
23	1	1	SENDAR22080463	2023-01-23	659.00000000000000000000	0.00000000000000000000	-659.00000000000000000000	-100.00000000000000000000	\N	\N
24	1	1	SENDAR22080460	2023-01-02	659.00000000000000000000	0.00000000000000000000	-659.00000000000000000000	-100.00000000000000000000	\N	\N
447	1	1	SENDAR14057853	2015-03-09	263.00000000000000000000	0.00000000000000000000	-263.00000000000000000000	-100.00000000000000000000	\N	\N
448	1	1	SENDAR14057854	2015-03-16	263.00000000000000000000	0.00000000000000000000	-263.00000000000000000000	-100.00000000000000000000	\N	\N
449	1	1	SENDAR14057852	2015-03-02	263.00000000000000000000	0.00000000000000000000	-263.00000000000000000000	-100.00000000000000000000	\N	\N
450	1	1	SENDAR14057848	2015-02-02	350.00000000000000000000	0.00000000000000000000	-350.00000000000000000000	-100.00000000000000000000	\N	\N
451	1	1	SENDAR14057846	2015-01-12	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
452	1	1	SENDAR14057850	2015-02-16	350.00000000000000000000	0.00000000000000000000	-350.00000000000000000000	-100.00000000000000000000	\N	\N
453	1	1	SENDAR14057857	2015-04-06	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
454	1	1	SENDAR14057873	2015-08-10	238.00000000000000000000	0.00000000000000000000	-238.00000000000000000000	-100.00000000000000000000	\N	\N
455	1	1	SENDAR14057875	2015-08-24	238.00000000000000000000	0.00000000000000000000	-238.00000000000000000000	-100.00000000000000000000	\N	\N
456	1	1	SENDAR14057860	2015-05-04	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
457	1	1	SENDAR14057861	2015-05-11	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
458	1	1	SENDAR14057868	2015-07-01	225.00000000000000000000	0.00000000000000000000	-225.00000000000000000000	-100.00000000000000000000	\N	\N
459	1	1	SENDAR14057871	2015-07-20	225.00000000000000000000	0.00000000000000000000	-225.00000000000000000000	-100.00000000000000000000	\N	\N
460	1	1	SENDAR14057872	2015-08-03	238.00000000000000000000	0.00000000000000000000	-238.00000000000000000000	-100.00000000000000000000	\N	\N
461	1	1	SENDAR17014180	2017-01-23	690.00000000000000000000	0.00000000000000000000	-690.00000000000000000000	-100.00000000000000000000	\N	\N
462	1	1	SENDAR17014177	2017-01-02	690.00000000000000000000	0.00000000000000000000	-690.00000000000000000000	-100.00000000000000000000	\N	\N
463	1	1	SENDAR17014187	2017-03-13	742.00000000000000000000	0.00000000000000000000	-742.00000000000000000000	-100.00000000000000000000	\N	\N
25	1	1	SENDAR22080468	2023-03-01	442.00000000000000000000	0.00000000000000000000	-442.00000000000000000000	-100.00000000000000000000	\N	\N
26	1	1	SENDAR22080472	2023-03-27	442.00000000000000000000	0.00000000000000000000	-442.00000000000000000000	-100.00000000000000000000	\N	\N
27	1	1	SENDAR24013261	2024-04-22	422.00000000000000000000	0.00000000000000000000	-422.00000000000000000000	-100.00000000000000000000	\N	\N
28	1	1	SENDAR22080459	2022-12-05	1680.00000000000000000000	0.00000000000000000000	-1680.00000000000000000000	-100.00000000000000000000	\N	\N
29	1	1	SENDAR22080462	2023-01-16	659.00000000000000000000	0.00000000000000000000	-659.00000000000000000000	-100.00000000000000000000	\N	\N
30	1	1	SENDAR22080461	2023-01-09	659.00000000000000000000	0.00000000000000000000	-659.00000000000000000000	-100.00000000000000000000	\N	\N
31	1	1	SENDAR22080467	2023-02-20	544.00000000000000000000	0.00000000000000000000	-544.00000000000000000000	-100.00000000000000000000	\N	\N
32	1	1	SENDAR22080465	2023-02-06	544.00000000000000000000	0.00000000000000000000	-544.00000000000000000000	-100.00000000000000000000	\N	\N
33	1	1	SENDAR22080469	2023-03-06	442.00000000000000000000	0.00000000000000000000	-442.00000000000000000000	-100.00000000000000000000	\N	\N
34	1	1	SENDAR22080479	2023-05-15	483.00000000000000000000	0.00000000000000000000	-483.00000000000000000000	-100.00000000000000000000	\N	\N
35	1	1	SENDAR20094811	2021-12-20	420.00000000000000000000	0.00000000000000000000	-420.00000000000000000000	-100.00000000000000000000	\N	\N
36	1	1	SENDAR22080475	2023-04-17	673.00000000000000000000	0.00000000000000000000	-673.00000000000000000000	-100.00000000000000000000	\N	\N
37	1	1	SENDAR22080477	2023-05-01	483.00000000000000000000	0.00000000000000000000	-483.00000000000000000000	-100.00000000000000000000	\N	\N
38	1	1	SENDAR22080480	2023-05-22	483.00000000000000000000	0.00000000000000000000	-483.00000000000000000000	-100.00000000000000000000	\N	\N
39	1	1	SENDAR22080473	2023-04-03	673.00000000000000000000	0.00000000000000000000	-673.00000000000000000000	-100.00000000000000000000	\N	\N
40	1	1	SENDAR22080487	2023-07-10	613.00000000000000000000	0.00000000000000000000	-613.00000000000000000000	-100.00000000000000000000	\N	\N
41	1	1	SENDAR22080489	2023-07-24	613.00000000000000000000	0.00000000000000000000	-613.00000000000000000000	-100.00000000000000000000	\N	\N
42	1	1	SENDAR22080496	2023-09-11	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
43	1	1	SENDAR22080503	2023-11-01	399.00000000000000000000	0.00000000000000000000	-399.00000000000000000000	-100.00000000000000000000	\N	\N
44	1	1	SENDAR22080476	2023-04-24	673.00000000000000000000	0.00000000000000000000	-673.00000000000000000000	-100.00000000000000000000	\N	\N
45	1	1	SENDAR22080478	2023-05-08	483.00000000000000000000	0.00000000000000000000	-483.00000000000000000000	-100.00000000000000000000	\N	\N
46	1	1	SENDAR21078107	2022-11-07	2207.00000000000000000000	0.00000000000000000000	-2207.00000000000000000000	-100.00000000000000000000	\N	\N
47	1	1	SENDAR20084260	2021-05-24	525.00000000000000000000	0.00000000000000000000	-525.00000000000000000000	-100.00000000000000000000	\N	\N
48	1	1	SENDAR20084263	2021-06-14	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
49	1	1	SENDAR20084266	2021-07-05	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
50	1	1	SENDAR24013254	2024-03-04	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
51	1	1	SENDAR24013248	2024-01-22	437.00000000000000000000	0.00000000000000000000	-437.00000000000000000000	-100.00000000000000000000	\N	\N
52	1	1	SENDAR24013249	2024-02-01	337.00000000000000000000	0.00000000000000000000	-337.00000000000000000000	-100.00000000000000000000	\N	\N
53	1	1	SENDAR24013250	2024-02-05	337.00000000000000000000	0.00000000000000000000	-337.00000000000000000000	-100.00000000000000000000	\N	\N
54	1	1	SENDAR24013256	2024-03-18	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
55	1	1	SENDAR20084264	2021-06-21	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
56	1	1	SENDAR20084265	2021-07-01	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
57	1	1	SENDAR24013252	2024-02-19	337.00000000000000000000	0.00000000000000000000	-337.00000000000000000000	-100.00000000000000000000	\N	\N
58	1	1	SENDAR24013253	2024-02-26	337.00000000000000000000	0.00000000000000000000	-337.00000000000000000000	-100.00000000000000000000	\N	\N
59	1	1	SENDAR24013255	2024-03-11	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
60	1	1	SENDAR20084261	2021-06-01	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
61	1	1	SENDAR20084267	2021-07-12	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
62	1	1	SENDAR20084268	2021-07-19	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
63	1	1	SENDAR20084251	2021-03-22	450.00000000000000000000	0.00000000000000000000	-450.00000000000000000000	-100.00000000000000000000	\N	\N
64	1	1	SENDAR22080491	2023-08-07	316.00000000000000000000	0.00000000000000000000	-316.00000000000000000000	-100.00000000000000000000	\N	\N
65	1	1	SENDAR22080499	2023-10-02	648.00000000000000000000	0.00000000000000000000	-648.00000000000000000000	-100.00000000000000000000	\N	\N
66	1	1	SENDAR22080505	2023-11-13	399.00000000000000000000	0.00000000000000000000	-399.00000000000000000000	-100.00000000000000000000	\N	\N
67	1	1	SENDAR22080506	2023-11-20	399.00000000000000000000	0.00000000000000000000	-399.00000000000000000000	-100.00000000000000000000	\N	\N
68	1	1	SENDAR22080494	2023-08-28	316.00000000000000000000	0.00000000000000000000	-316.00000000000000000000	-100.00000000000000000000	\N	\N
69	1	1	SENDAR22080495	2023-09-04	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
70	1	1	SENDAR22080501	2023-10-16	648.00000000000000000000	0.00000000000000000000	-648.00000000000000000000	-100.00000000000000000000	\N	\N
71	1	1	SENDAR22080502	2023-10-23	648.00000000000000000000	0.00000000000000000000	-648.00000000000000000000	-100.00000000000000000000	\N	\N
72	1	1	SENDAR22080504	2023-11-06	399.00000000000000000000	0.00000000000000000000	-399.00000000000000000000	-100.00000000000000000000	\N	\N
73	1	1	SENDAR24013251	2024-02-12	337.00000000000000000000	0.00000000000000000000	-337.00000000000000000000	-100.00000000000000000000	\N	\N
74	1	1	SENDAR20084249	2021-03-08	450.00000000000000000000	0.00000000000000000000	-450.00000000000000000000	-100.00000000000000000000	\N	\N
75	1	1	SENDAR20084247	2021-02-22	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
76	1	1	SENDAR20084248	2021-03-01	450.00000000000000000000	0.00000000000000000000	-450.00000000000000000000	-100.00000000000000000000	\N	\N
77	1	1	SENDAR20084258	2021-05-10	525.00000000000000000000	0.00000000000000000000	-525.00000000000000000000	-100.00000000000000000000	\N	\N
78	1	1	SENDAR22080488	2023-07-17	613.00000000000000000000	0.00000000000000000000	-613.00000000000000000000	-100.00000000000000000000	\N	\N
79	1	1	SENDAR22080490	2023-08-01	316.00000000000000000000	0.00000000000000000000	-316.00000000000000000000	-100.00000000000000000000	\N	\N
80	1	1	SENDAR22080492	2023-08-14	316.00000000000000000000	0.00000000000000000000	-316.00000000000000000000	-100.00000000000000000000	\N	\N
81	1	1	SENDAR22080485	2023-06-26	391.00000000000000000000	0.00000000000000000000	-391.00000000000000000000	-100.00000000000000000000	\N	\N
82	1	1	SENDAR22080474	2023-04-10	673.00000000000000000000	0.00000000000000000000	-673.00000000000000000000	-100.00000000000000000000	\N	\N
83	1	1	SENDAR20084270	2021-08-02	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
84	1	1	SENDAR20084271	2021-08-09	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
85	1	1	SENDAR22080497	2023-09-18	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
86	1	1	SENDAR22080481	2023-06-01	391.00000000000000000000	0.00000000000000000000	-391.00000000000000000000	-100.00000000000000000000	\N	\N
87	1	1	SENDAR20084259	2021-05-17	525.00000000000000000000	0.00000000000000000000	-525.00000000000000000000	-100.00000000000000000000	\N	\N
88	1	1	SENDAR20084269	2021-07-26	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
89	1	1	SENDAR20084250	2021-03-15	450.00000000000000000000	0.00000000000000000000	-450.00000000000000000000	-100.00000000000000000000	\N	\N
90	1	1	SENDAR22080493	2023-08-21	316.00000000000000000000	0.00000000000000000000	-316.00000000000000000000	-100.00000000000000000000	\N	\N
91	1	1	SENDAR22080498	2023-09-25	540.00000000000000000000	0.00000000000000000000	-540.00000000000000000000	-100.00000000000000000000	\N	\N
92	1	1	SENDAR22080500	2023-10-09	648.00000000000000000000	0.00000000000000000000	-648.00000000000000000000	-100.00000000000000000000	\N	\N
93	1	1	SENDAR22080507	2023-11-27	399.00000000000000000000	0.00000000000000000000	-399.00000000000000000000	-100.00000000000000000000	\N	\N
94	1	1	SENDAR22080486	2023-07-03	613.00000000000000000000	0.00000000000000000000	-613.00000000000000000000	-100.00000000000000000000	\N	\N
95	1	1	SENDAR22080483	2023-06-12	391.00000000000000000000	0.00000000000000000000	-391.00000000000000000000	-100.00000000000000000000	\N	\N
96	1	1	SENDAR22080484	2023-06-19	391.00000000000000000000	0.00000000000000000000	-391.00000000000000000000	-100.00000000000000000000	\N	\N
97	1	1	SENDAR19022023	2019-01-01	570.00000000000000000000	0.00000000000000000000	-570.00000000000000000000	-100.00000000000000000000	\N	\N
98	1	1	SENDAR19022028	2019-02-04	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
99	1	1	SENDAR19022029	2019-02-11	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
100	1	1	SENDAR24013246	2024-01-08	437.00000000000000000000	0.00000000000000000000	-437.00000000000000000000	-100.00000000000000000000	\N	\N
101	1	1	SENDAR19022024	2019-01-07	570.00000000000000000000	0.00000000000000000000	-570.00000000000000000000	-100.00000000000000000000	\N	\N
102	1	1	SENDAR19022025	2019-01-14	570.00000000000000000000	0.00000000000000000000	-570.00000000000000000000	-100.00000000000000000000	\N	\N
103	1	1	SENDAR19022026	2019-01-21	570.00000000000000000000	0.00000000000000000000	-570.00000000000000000000	-100.00000000000000000000	\N	\N
104	1	1	SENDAR19022027	2019-01-28	570.00000000000000000000	0.00000000000000000000	-570.00000000000000000000	-100.00000000000000000000	\N	\N
105	1	1	SENDAR20084262	2021-06-07	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
106	1	1	SENDAR19022030	2019-02-18	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
107	1	1	SENDAR22080482	2023-06-05	391.00000000000000000000	0.00000000000000000000	-391.00000000000000000000	-100.00000000000000000000	\N	\N
108	1	1	SENDAR19022031	2019-02-25	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
109	1	1	SENDAR24013241	2023-12-04	331.00000000000000000000	0.00000000000000000000	-331.00000000000000000000	-100.00000000000000000000	\N	\N
110	1	1	SENDAR24013242	2023-12-11	331.00000000000000000000	0.00000000000000000000	-331.00000000000000000000	-100.00000000000000000000	\N	\N
111	1	1	SENDAR24013244	2023-12-25	327.00000000000000000000	0.00000000000000000000	-327.00000000000000000000	-100.00000000000000000000	\N	\N
112	1	1	SENDAR24013245	2024-01-01	437.00000000000000000000	0.00000000000000000000	-437.00000000000000000000	-100.00000000000000000000	\N	\N
113	1	1	SENDAR24013247	2024-01-15	437.00000000000000000000	0.00000000000000000000	-437.00000000000000000000	-100.00000000000000000000	\N	\N
114	1	1	SENDAR24013243	2023-12-18	331.00000000000000000000	0.00000000000000000000	-331.00000000000000000000	-100.00000000000000000000	\N	\N
115	1	1	SENDAR19022032	2019-03-04	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
116	1	1	SENDAR19022038	2019-04-15	1267.00000000000000000000	0.00000000000000000000	-1267.00000000000000000000	-100.00000000000000000000	\N	\N
117	1	1	SENDAR19022047	2019-06-17	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
118	1	1	SENDAR19022054	2019-08-05	317.00000000000000000000	0.00000000000000000000	-317.00000000000000000000	-100.00000000000000000000	\N	\N
119	1	1	SENDAR19022057	2019-08-26	317.00000000000000000000	0.00000000000000000000	-317.00000000000000000000	-100.00000000000000000000	\N	\N
120	1	1	SENDAR19022059	2019-09-09	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
121	1	1	SENDAR19022065	2019-10-21	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
122	1	1	SENDAR19022046	2019-06-10	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
123	1	1	SENDAR19022055	2019-08-12	317.00000000000000000000	0.00000000000000000000	-317.00000000000000000000	-100.00000000000000000000	\N	\N
124	1	1	SENDAR19022062	2019-10-01	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
125	1	1	SENDAR19022067	2019-11-04	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
126	1	1	SENDAR19022068	2019-11-11	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
127	1	1	SENDAR19022074	2019-12-23	554.00000000000000000000	0.00000000000000000000	-554.00000000000000000000	-100.00000000000000000000	\N	\N
128	1	1	SENDAR19022040	2019-05-01	443.00000000000000000000	0.00000000000000000000	-443.00000000000000000000	-100.00000000000000000000	\N	\N
129	1	1	SENDAR19022033	2019-03-11	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
130	1	1	SENDAR19022034	2019-03-18	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
131	1	1	SENDAR19022035	2019-03-25	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
132	1	1	SENDAR20084242	2021-01-18	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
133	1	1	SENDAR19022045	2019-06-03	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
134	1	1	SENDAR19022051	2019-07-15	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
135	1	1	SENDAR19022056	2019-08-19	317.00000000000000000000	0.00000000000000000000	-317.00000000000000000000	-100.00000000000000000000	\N	\N
136	1	1	SENDAR19022063	2019-10-07	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
137	1	1	SENDAR19022039	2019-04-22	1267.00000000000000000000	0.00000000000000000000	-1267.00000000000000000000	-100.00000000000000000000	\N	\N
138	1	1	SENDAR19022042	2019-05-13	443.00000000000000000000	0.00000000000000000000	-443.00000000000000000000	-100.00000000000000000000	\N	\N
139	1	1	SENDAR24124183	2026-03-23	505.00000000000000000000	0.00000000000000000000	-505.00000000000000000000	-100.00000000000000000000	\N	\N
140	1	1	SENDAR24124188	2026-04-27	423.00000000000000000000	0.00000000000000000000	-423.00000000000000000000	-100.00000000000000000000	\N	\N
141	1	1	SENDAR24124189	2026-05-04	502.00000000000000000000	0.00000000000000000000	-502.00000000000000000000	-100.00000000000000000000	\N	\N
142	1	1	SENDAR24124191	2026-05-18	502.00000000000000000000	0.00000000000000000000	-502.00000000000000000000	-100.00000000000000000000	\N	\N
143	1	1	SENDAR24124193	2026-06-01	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
144	1	1	SENDAR24124206	2026-09-01	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
145	1	1	SENDAR24124208	2026-09-14	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
146	1	1	SENDAR24124215	2026-11-02	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
147	1	1	SENDAR24124222	2026-12-21	292.00000000000000000000	0.00000000000000000000	-292.00000000000000000000	-100.00000000000000000000	\N	\N
148	1	1	SENDAR19022044	2019-05-27	443.00000000000000000000	0.00000000000000000000	-443.00000000000000000000	-100.00000000000000000000	\N	\N
149	1	1	SENDAR19022052	2019-07-22	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
150	1	1	SENDAR19022058	2019-09-02	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
151	1	1	SENDAR19022061	2019-09-23	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
152	1	1	SENDAR19022069	2019-11-18	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
153	1	1	SENDAR19022073	2019-12-16	554.00000000000000000000	0.00000000000000000000	-554.00000000000000000000	-100.00000000000000000000	\N	\N
154	1	1	SENDAR24124177	2026-02-09	264.00000000000000000000	0.00000000000000000000	-264.00000000000000000000	-100.00000000000000000000	\N	\N
155	1	1	SENDAR24124182	2026-03-16	505.00000000000000000000	0.00000000000000000000	-505.00000000000000000000	-100.00000000000000000000	\N	\N
156	1	1	SENDAR24124195	2026-06-15	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
157	1	1	SENDAR24124204	2026-08-17	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
158	1	1	SENDAR24124205	2026-08-24	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
159	1	1	SENDAR19022048	2019-06-24	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
160	1	1	SENDAR19022064	2019-10-14	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
161	1	1	SENDAR20084252	2021-04-01	960.00000000000000000000	0.00000000000000000000	-960.00000000000000000000	-100.00000000000000000000	\N	\N
162	1	1	SENDAR24124179	2026-02-23	264.00000000000000000000	0.00000000000000000000	-264.00000000000000000000	-100.00000000000000000000	\N	\N
168	1	1	SENDAR24124223	2026-12-28	289.00000000000000000000	0.00000000000000000000	-289.00000000000000000000	-100.00000000000000000000	\N	\N
169	1	1	SENDAR24124180	2026-03-02	505.00000000000000000000	0.00000000000000000000	-505.00000000000000000000	-100.00000000000000000000	\N	\N
170	1	1	SENDAR24124185	2026-04-06	423.00000000000000000000	0.00000000000000000000	-423.00000000000000000000	-100.00000000000000000000	\N	\N
171	1	1	SENDAR24124192	2026-05-25	502.00000000000000000000	0.00000000000000000000	-502.00000000000000000000	-100.00000000000000000000	\N	\N
172	1	1	SENDAR24124203	2026-08-10	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
173	1	1	SENDAR20084257	2021-05-03	525.00000000000000000000	0.00000000000000000000	-525.00000000000000000000	-100.00000000000000000000	\N	\N
174	1	1	SENDAR20084255	2021-04-19	960.00000000000000000000	0.00000000000000000000	-960.00000000000000000000	-100.00000000000000000000	\N	\N
175	1	1	SENDAR24124213	2026-10-19	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
177	1	1	SENDAR20084254	2021-04-12	960.00000000000000000000	0.00000000000000000000	-960.00000000000000000000	-100.00000000000000000000	\N	\N
178	1	1	SENDAR24124174	2026-01-19	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
179	1	1	SENDAR24124190	2026-05-11	502.00000000000000000000	0.00000000000000000000	-502.00000000000000000000	-100.00000000000000000000	\N	\N
180	1	1	SENDAR24124198	2026-07-06	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
181	1	1	SENDAR24124199	2026-07-13	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
182	1	1	SENDAR24124200	2026-07-20	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
183	1	1	SENDAR24124209	2026-09-21	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
184	1	1	SENDAR19022037	2019-04-08	1267.00000000000000000000	0.00000000000000000000	-1267.00000000000000000000	-100.00000000000000000000	\N	\N
185	1	1	SENDAR19022041	2019-05-06	443.00000000000000000000	0.00000000000000000000	-443.00000000000000000000	-100.00000000000000000000	\N	\N
186	1	1	SENDAR19022043	2019-05-20	443.00000000000000000000	0.00000000000000000000	-443.00000000000000000000	-100.00000000000000000000	\N	\N
187	1	1	SENDAR19022036	2019-04-01	1267.00000000000000000000	0.00000000000000000000	-1267.00000000000000000000	-100.00000000000000000000	\N	\N
188	1	1	SENDAR20084256	2021-04-26	960.00000000000000000000	0.00000000000000000000	-960.00000000000000000000	-100.00000000000000000000	\N	\N
189	1	1	SENDAR24124210	2026-10-01	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
190	1	1	SENDAR24124211	2026-10-05	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
191	1	1	SENDAR24124218	2026-11-23	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
192	1	1	SENDAR19022049	2019-07-01	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
193	1	1	SENDAR19022050	2019-07-08	713.00000000000000000000	0.00000000000000000000	-713.00000000000000000000	-100.00000000000000000000	\N	\N
194	1	1	SENDAR19022053	2019-08-01	317.00000000000000000000	0.00000000000000000000	-317.00000000000000000000	-100.00000000000000000000	\N	\N
195	1	1	SENDAR19022060	2019-09-16	475.00000000000000000000	0.00000000000000000000	-475.00000000000000000000	-100.00000000000000000000	\N	\N
197	1	1	SENDAR24124139	2025-05-19	402.00000000000000000000	0.00000000000000000000	-402.00000000000000000000	-100.00000000000000000000	\N	\N
198	1	1	SENDAR24124140	2025-05-26	402.00000000000000000000	0.00000000000000000000	-402.00000000000000000000	-100.00000000000000000000	\N	\N
199	1	1	SENDAR24124145	2025-07-01	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
200	1	1	SENDAR24124157	2025-09-22	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
201	1	1	SENDAR24124159	2025-10-06	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
202	1	1	SENDAR24124163	2025-11-03	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
203	1	1	SENDAR24124164	2025-11-10	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
204	1	1	SENDAR24124170	2025-12-22	365.00000000000000000000	0.00000000000000000000	-365.00000000000000000000	-100.00000000000000000000	\N	\N
205	1	1	SENDAR24124175	2026-01-26	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
206	1	1	SENDAR24124176	2026-02-02	264.00000000000000000000	0.00000000000000000000	-264.00000000000000000000	-100.00000000000000000000	\N	\N
207	1	1	SENDAR24124178	2026-02-16	264.00000000000000000000	0.00000000000000000000	-264.00000000000000000000	-100.00000000000000000000	\N	\N
208	1	1	SENDAR24124181	2026-03-09	505.00000000000000000000	0.00000000000000000000	-505.00000000000000000000	-100.00000000000000000000	\N	\N
209	1	1	SENDAR24124184	2026-04-01	423.00000000000000000000	0.00000000000000000000	-423.00000000000000000000	-100.00000000000000000000	\N	\N
210	1	1	SENDAR24124187	2026-04-20	423.00000000000000000000	0.00000000000000000000	-423.00000000000000000000	-100.00000000000000000000	\N	\N
211	1	1	SENDAR24124194	2026-06-08	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
212	1	1	SENDAR24124197	2026-07-01	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
213	1	1	SENDAR24124202	2026-08-03	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
216	1	1	SENDAR24124136	2025-05-01	402.00000000000000000000	0.00000000000000000000	-402.00000000000000000000	-100.00000000000000000000	\N	\N
217	1	1	SENDAR24124138	2025-05-12	402.00000000000000000000	0.00000000000000000000	-402.00000000000000000000	-100.00000000000000000000	\N	\N
218	1	1	SENDAR24124146	2025-07-07	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
219	1	1	SENDAR24124147	2025-07-14	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
220	1	1	SENDAR24124165	2025-11-17	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
221	1	1	SENDAR20094810	2021-12-13	420.00000000000000000000	0.00000000000000000000	-420.00000000000000000000	-100.00000000000000000000	\N	\N
222	1	1	SENDAR20084245	2021-02-08	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
223	1	1	SENDAR20084241	2021-01-11	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
224	1	1	SENDAR24124217	2026-11-16	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
225	1	1	SENDAR19022066	2019-10-28	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
226	1	1	SENDAR19022070	2019-11-25	633.00000000000000000000	0.00000000000000000000	-633.00000000000000000000	-100.00000000000000000000	\N	\N
227	1	1	SENDAR19022071	2019-12-02	554.00000000000000000000	0.00000000000000000000	-554.00000000000000000000	-100.00000000000000000000	\N	\N
228	1	1	SENDAR19022072	2019-12-09	554.00000000000000000000	0.00000000000000000000	-554.00000000000000000000	-100.00000000000000000000	\N	\N
229	1	1	SENDAR24124132	2025-04-01	528.00000000000000000000	0.00000000000000000000	-528.00000000000000000000	-100.00000000000000000000	\N	\N
230	1	1	SENDAR24124142	2025-06-09	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
231	1	1	SENDAR24124149	2025-07-28	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
232	1	1	SENDAR24124167	2025-12-01	365.00000000000000000000	0.00000000000000000000	-365.00000000000000000000	-100.00000000000000000000	\N	\N
233	1	1	SENDAR24124169	2025-12-15	365.00000000000000000000	0.00000000000000000000	-365.00000000000000000000	-100.00000000000000000000	\N	\N
234	1	1	SENDAR24124171	2026-01-01	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
236	1	1	SENDAR24124134	2025-04-14	528.00000000000000000000	0.00000000000000000000	-528.00000000000000000000	-100.00000000000000000000	\N	\N
237	1	1	SENDAR24124141	2025-06-02	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
238	1	1	SENDAR24124143	2025-06-16	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
239	1	1	SENDAR24124144	2025-06-23	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
240	1	1	SENDAR24124154	2025-09-01	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
241	1	1	SENDAR24124156	2025-09-15	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
242	1	1	SENDAR24124158	2025-10-01	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
243	1	1	SENDAR24124161	2025-10-20	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
246	1	1	SENDAR20084253	2021-04-05	960.00000000000000000000	0.00000000000000000000	-960.00000000000000000000	-100.00000000000000000000	\N	\N
247	1	1	SENDAR24124220	2026-12-07	292.00000000000000000000	0.00000000000000000000	-292.00000000000000000000	-100.00000000000000000000	\N	\N
248	1	1	SENDAR24124221	2026-12-14	292.00000000000000000000	0.00000000000000000000	-292.00000000000000000000	-100.00000000000000000000	\N	\N
249	1	1	SENDAR24124133	2025-04-07	528.00000000000000000000	0.00000000000000000000	-528.00000000000000000000	-100.00000000000000000000	\N	\N
250	1	1	SENDAR24124135	2025-04-21	528.00000000000000000000	0.00000000000000000000	-528.00000000000000000000	-100.00000000000000000000	\N	\N
251	1	1	SENDAR24124153	2025-08-25	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
252	1	1	SENDAR24124155	2025-09-08	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
253	1	1	SENDAR24124160	2025-10-13	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
254	1	1	SENDAR24124166	2025-11-24	473.00000000000000000000	0.00000000000000000000	-473.00000000000000000000	-100.00000000000000000000	\N	\N
255	1	1	SENDAR20084239	2020-12-07	2165.00000000000000000000	0.00000000000000000000	-2165.00000000000000000000	-100.00000000000000000000	\N	\N
256	1	1	SENDAR24124186	2026-04-13	423.00000000000000000000	0.00000000000000000000	-423.00000000000000000000	-100.00000000000000000000	\N	\N
257	1	1	SENDAR24124196	2026-06-22	474.00000000000000000000	0.00000000000000000000	-474.00000000000000000000	-100.00000000000000000000	\N	\N
258	1	1	SENDAR24124201	2026-07-27	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
259	1	1	SENDAR24124207	2026-09-07	504.00000000000000000000	0.00000000000000000000	-504.00000000000000000000	-100.00000000000000000000	\N	\N
262	1	1	SENDAR24124137	2025-05-05	402.00000000000000000000	0.00000000000000000000	-402.00000000000000000000	-100.00000000000000000000	\N	\N
263	1	1	SENDAR24124148	2025-07-21	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
264	1	1	SENDAR24124150	2025-08-04	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
265	1	1	SENDAR24124151	2025-08-11	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
266	1	1	SENDAR24124152	2025-08-18	381.00000000000000000000	0.00000000000000000000	-381.00000000000000000000	-100.00000000000000000000	\N	\N
267	1	1	SENDAR24124162	2025-10-27	413.00000000000000000000	0.00000000000000000000	-413.00000000000000000000	-100.00000000000000000000	\N	\N
268	1	1	SENDAR20084244	2021-02-01	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
269	1	1	SENDAR20084280	2021-10-11	750.00000000000000000000	0.00000000000000000000	-750.00000000000000000000	-100.00000000000000000000	\N	\N
270	1	1	SENDAR20084243	2021-01-25	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
271	1	1	SENDAR20084273	2021-08-23	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
272	1	1	SENDAR20084274	2021-09-01	360.00000000000000000000	0.00000000000000000000	-360.00000000000000000000	-100.00000000000000000000	\N	\N
273	1	1	SENDAR20084276	2021-09-13	360.00000000000000000000	0.00000000000000000000	-360.00000000000000000000	-100.00000000000000000000	\N	\N
274	1	1	SENDAR20084286	2021-11-22	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
275	1	1	SENDAR20094808	2021-12-01	420.00000000000000000000	0.00000000000000000000	-420.00000000000000000000	-100.00000000000000000000	\N	\N
276	1	1	SENDAR20084272	2021-08-16	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
277	1	1	SENDAR20084277	2021-09-20	360.00000000000000000000	0.00000000000000000000	-360.00000000000000000000	-100.00000000000000000000	\N	\N
278	1	1	SENDAR20084283	2021-11-01	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
279	1	1	SENDAR20084284	2021-11-08	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
280	1	1	SENDAR20084240	2021-01-04	675.00000000000000000000	0.00000000000000000000	-675.00000000000000000000	-100.00000000000000000000	\N	\N
281	1	1	SENDAR20084275	2021-09-06	360.00000000000000000000	0.00000000000000000000	-360.00000000000000000000	-100.00000000000000000000	\N	\N
282	1	1	SENDAR20084278	2021-09-27	360.00000000000000000000	0.00000000000000000000	-360.00000000000000000000	-100.00000000000000000000	\N	\N
283	1	1	SENDAR20084279	2021-10-04	750.00000000000000000000	0.00000000000000000000	-750.00000000000000000000	-100.00000000000000000000	\N	\N
284	1	1	SENDAR20084282	2021-10-25	750.00000000000000000000	0.00000000000000000000	-750.00000000000000000000	-100.00000000000000000000	\N	\N
285	1	1	SENDAR20084285	2021-11-15	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
286	1	1	SENDAR24124173	2026-01-12	438.00000000000000000000	0.00000000000000000000	-438.00000000000000000000	-100.00000000000000000000	\N	\N
287	1	1	SENDAR20084281	2021-10-18	750.00000000000000000000	0.00000000000000000000	-750.00000000000000000000	-100.00000000000000000000	\N	\N
288	1	1	SENDAR20084246	2021-02-15	600.00000000000000000000	0.00000000000000000000	-600.00000000000000000000	-100.00000000000000000000	\N	\N
289	1	1	SENDAR19102705	2020-05-11	2164.00000000000000000000	0.00000000000000000000	-2164.00000000000000000000	-100.00000000000000000000	\N	\N
290	1	1	SENDAR19102708	2020-08-10	1544.00000000000000000000	0.00000000000000000000	-1544.00000000000000000000	-100.00000000000000000000	\N	\N
291	1	1	SENDAR19102702	2020-02-10	2472.00000000000000000000	0.00000000000000000000	-2472.00000000000000000000	-100.00000000000000000000	\N	\N
292	1	1	SENDAR19102704	2020-04-06	4945.00000000000000000000	0.00000000000000000000	-4945.00000000000000000000	-100.00000000000000000000	\N	\N
293	1	1	SENDAR19102706	2020-06-08	2780.00000000000000000000	0.00000000000000000000	-2780.00000000000000000000	-100.00000000000000000000	\N	\N
294	1	1	SENDAR19102707	2020-07-06	2780.00000000000000000000	0.00000000000000000000	-2780.00000000000000000000	-100.00000000000000000000	\N	\N
295	1	1	SENDAR19102709	2020-09-07	1852.00000000000000000000	0.00000000000000000000	-1852.00000000000000000000	-100.00000000000000000000	\N	\N
296	1	1	SENDAR24013264	2024-05-13	321.00000000000000000000	0.00000000000000000000	-321.00000000000000000000	-100.00000000000000000000	\N	\N
297	1	1	SENDAR24013276	2024-08-05	244.00000000000000000000	0.00000000000000000000	-244.00000000000000000000	-100.00000000000000000000	\N	\N
298	1	1	SENDAR24013283	2024-09-23	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
299	1	1	SENDAR24013285	2024-10-07	330.00000000000000000000	0.00000000000000000000	-330.00000000000000000000	-100.00000000000000000000	\N	\N
300	1	1	SENDAR24013290	2024-11-11	378.00000000000000000000	0.00000000000000000000	-378.00000000000000000000	-100.00000000000000000000	\N	\N
301	1	1	SENDAR24013291	2024-11-18	378.00000000000000000000	0.00000000000000000000	-378.00000000000000000000	-100.00000000000000000000	\N	\N
302	1	1	SENDAR24013292	2024-11-25	378.00000000000000000000	0.00000000000000000000	-378.00000000000000000000	-100.00000000000000000000	\N	\N
303	1	1	SENDAR19102701	2020-01-06	2780.00000000000000000000	0.00000000000000000000	-2780.00000000000000000000	-100.00000000000000000000	\N	\N
304	1	1	SENDAR19102703	2020-03-09	1852.00000000000000000000	0.00000000000000000000	-1852.00000000000000000000	-100.00000000000000000000	\N	\N
305	1	1	SENDAR19102710	2020-10-05	3090.00000000000000000000	0.00000000000000000000	-3090.00000000000000000000	-100.00000000000000000000	\N	\N
306	1	1	SENDAR19102711	2020-11-09	2472.00000000000000000000	0.00000000000000000000	-2472.00000000000000000000	-100.00000000000000000000	\N	\N
307	1	1	SENDAR24013277	2024-08-12	244.00000000000000000000	0.00000000000000000000	-244.00000000000000000000	-100.00000000000000000000	\N	\N
308	1	1	SENDAR24013281	2024-09-09	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
309	1	1	SENDAR24013287	2024-10-21	330.00000000000000000000	0.00000000000000000000	-330.00000000000000000000	-100.00000000000000000000	\N	\N
310	1	1	SENDAR24013289	2024-11-04	378.00000000000000000000	0.00000000000000000000	-378.00000000000000000000	-100.00000000000000000000	\N	\N
311	1	1	SENDAR24013279	2024-08-26	244.00000000000000000000	0.00000000000000000000	-244.00000000000000000000	-100.00000000000000000000	\N	\N
312	1	1	SENDAR24013282	2024-09-16	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
313	1	1	SENDAR24013284	2024-10-01	330.00000000000000000000	0.00000000000000000000	-330.00000000000000000000	-100.00000000000000000000	\N	\N
314	1	1	SENDAR24013269	2024-06-17	379.00000000000000000000	0.00000000000000000000	-379.00000000000000000000	-100.00000000000000000000	\N	\N
315	1	1	SENDAR24013286	2024-10-14	330.00000000000000000000	0.00000000000000000000	-330.00000000000000000000	-100.00000000000000000000	\N	\N
316	1	1	SENDAR24013288	2024-10-28	330.00000000000000000000	0.00000000000000000000	-330.00000000000000000000	-100.00000000000000000000	\N	\N
317	1	1	SENDAR24013266	2024-05-27	321.00000000000000000000	0.00000000000000000000	-321.00000000000000000000	-100.00000000000000000000	\N	\N
318	1	1	SENDAR24013271	2024-07-01	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
319	1	1	SENDAR24013273	2024-07-15	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
320	1	1	SENDAR24013278	2024-08-19	244.00000000000000000000	0.00000000000000000000	-244.00000000000000000000	-100.00000000000000000000	\N	\N
321	1	1	SENDAR24013280	2024-09-02	403.00000000000000000000	0.00000000000000000000	-403.00000000000000000000	-100.00000000000000000000	\N	\N
322	1	1	SENDAR24013267	2024-06-03	379.00000000000000000000	0.00000000000000000000	-379.00000000000000000000	-100.00000000000000000000	\N	\N
323	1	1	SENDAR24013262	2024-05-01	321.00000000000000000000	0.00000000000000000000	-321.00000000000000000000	-100.00000000000000000000	\N	\N
324	1	1	SENDAR24013265	2024-05-20	321.00000000000000000000	0.00000000000000000000	-321.00000000000000000000	-100.00000000000000000000	\N	\N
325	1	1	SENDAR24013268	2024-06-10	379.00000000000000000000	0.00000000000000000000	-379.00000000000000000000	-100.00000000000000000000	\N	\N
326	1	1	SENDAR24013270	2024-06-24	379.00000000000000000000	0.00000000000000000000	-379.00000000000000000000	-100.00000000000000000000	\N	\N
327	1	1	SENDAR24013275	2024-08-01	244.00000000000000000000	0.00000000000000000000	-244.00000000000000000000	-100.00000000000000000000	\N	\N
328	1	1	SENDAR24013272	2024-07-08	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
329	1	1	SENDAR24013263	2024-05-06	321.00000000000000000000	0.00000000000000000000	-321.00000000000000000000	-100.00000000000000000000	\N	\N
330	1	1	SENDAR24013274	2024-07-22	373.00000000000000000000	0.00000000000000000000	-373.00000000000000000000	-100.00000000000000000000	\N	\N
331	1	1	SENDAR15061319	2016-10-17	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
332	1	1	SENDAR20094812	2021-12-27	431.00000000000000000000	0.00000000000000000000	-431.00000000000000000000	-100.00000000000000000000	\N	\N
333	1	1	SENDAR15061321	2016-11-01	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
334	1	1	SENDAR15061314	2016-09-05	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
335	1	1	SENDAR15061322	2016-11-07	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
336	1	1	SENDAR15061327	2016-12-12	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
337	1	1	SENDAR15061317	2016-10-03	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
338	1	1	SENDAR15061318	2016-10-10	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
339	1	1	SENDAR15061325	2016-12-01	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
340	1	1	SENDAR15061326	2016-12-05	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
341	1	1	SENDAR15061328	2016-12-19	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
342	1	1	SENDAR15061320	2016-10-24	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
343	1	1	SENDAR15061311	2016-08-15	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
344	1	1	SENDAR15061315	2016-09-12	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
345	1	1	SENDAR15061323	2016-11-14	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
346	1	1	SENDAR15061324	2016-11-21	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
347	1	1	SENDAR15061316	2016-09-19	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
348	1	1	SENDAR15061312	2016-08-22	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
349	1	1	SENDAR15061313	2016-09-01	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
350	1	1	SENDAR15061283	2016-01-18	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
351	1	1	SENDAR15061285	2016-02-01	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
352	1	1	SENDAR15061286	2016-02-08	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
353	1	1	SENDAR15061310	2016-08-08	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
354	1	1	SENDAR15061281	2016-01-04	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
355	1	1	SENDAR15061284	2016-01-25	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
356	1	1	SENDAR15061295	2016-04-18	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
357	1	1	SENDAR15061296	2016-04-25	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
358	1	1	SENDAR15061309	2016-08-01	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
359	1	1	SENDAR15061298	2016-05-09	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
360	1	1	SENDAR15061306	2016-07-11	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
361	1	1	SENDAR15061308	2016-07-25	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
362	1	1	SENDAR17082379	2018-01-01	553.00000000000000000000	0.00000000000000000000	-553.00000000000000000000	-100.00000000000000000000	\N	\N
363	1	1	SENDAR17082380	2018-01-08	553.00000000000000000000	0.00000000000000000000	-553.00000000000000000000	-100.00000000000000000000	\N	\N
364	1	1	SENDAR17082385	2018-02-12	609.00000000000000000000	0.00000000000000000000	-609.00000000000000000000	-100.00000000000000000000	\N	\N
365	1	1	SENDAR17082386	2018-02-19	609.00000000000000000000	0.00000000000000000000	-609.00000000000000000000	-100.00000000000000000000	\N	\N
366	1	1	SENDAR17082394	2018-04-23	693.00000000000000000000	0.00000000000000000000	-693.00000000000000000000	-100.00000000000000000000	\N	\N
367	1	1	SENDAR17082395	2018-05-01	589.00000000000000000000	0.00000000000000000000	-589.00000000000000000000	-100.00000000000000000000	\N	\N
368	1	1	SENDAR17082389	2018-03-12	569.00000000000000000000	0.00000000000000000000	-569.00000000000000000000	-100.00000000000000000000	\N	\N
369	1	1	SENDAR17082391	2018-04-02	693.00000000000000000000	0.00000000000000000000	-693.00000000000000000000	-100.00000000000000000000	\N	\N
370	1	1	SENDAR17082400	2018-06-11	620.00000000000000000000	0.00000000000000000000	-620.00000000000000000000	-100.00000000000000000000	\N	\N
371	1	1	SENDAR17082408	2018-08-06	455.00000000000000000000	0.00000000000000000000	-455.00000000000000000000	-100.00000000000000000000	\N	\N
372	1	1	SENDAR17082409	2018-08-13	455.00000000000000000000	0.00000000000000000000	-455.00000000000000000000	-100.00000000000000000000	\N	\N
373	1	1	SENDAR17082417	2018-10-15	512.00000000000000000000	0.00000000000000000000	-512.00000000000000000000	-100.00000000000000000000	\N	\N
374	1	1	SENDAR17082425	2018-12-17	451.00000000000000000000	0.00000000000000000000	-451.00000000000000000000	-100.00000000000000000000	\N	\N
375	1	1	SENDAR15061287	2016-02-15	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
376	1	1	SENDAR15061294	2016-04-11	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
377	1	1	SENDAR15061297	2016-05-02	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
378	1	1	SENDAR15061301	2016-06-01	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
379	1	1	SENDAR17082381	2018-01-15	553.00000000000000000000	0.00000000000000000000	-553.00000000000000000000	-100.00000000000000000000	\N	\N
380	1	1	SENDAR17082384	2018-02-05	609.00000000000000000000	0.00000000000000000000	-609.00000000000000000000	-100.00000000000000000000	\N	\N
381	1	1	SENDAR15061282	2016-01-11	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
382	1	1	SENDAR15061289	2016-03-01	400.00000000000000000000	0.00000000000000000000	-400.00000000000000000000	-100.00000000000000000000	\N	\N
383	1	1	SENDAR15061293	2016-04-04	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
384	1	1	SENDAR15061300	2016-05-23	425.00000000000000000000	0.00000000000000000000	-425.00000000000000000000	-100.00000000000000000000	\N	\N
385	1	1	SENDAR15061305	2016-07-04	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
386	1	1	SENDAR15061307	2016-07-18	375.00000000000000000000	0.00000000000000000000	-375.00000000000000000000	-100.00000000000000000000	\N	\N
387	1	1	SENDAR17082392	2018-04-09	693.00000000000000000000	0.00000000000000000000	-693.00000000000000000000	-100.00000000000000000000	\N	\N
464	1	1	SENDAR14057859	2015-04-20	325.00000000000000000000	0.00000000000000000000	-325.00000000000000000000	-100.00000000000000000000	\N	\N
465	1	1	SENDAR14057865	2015-06-08	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
466	1	1	SENDAR14057866	2015-06-15	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
467	1	1	SENDAR14057867	2015-06-22	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
468	1	1	SENDAR14057874	2015-08-17	238.00000000000000000000	0.00000000000000000000	-238.00000000000000000000	-100.00000000000000000000	\N	\N
469	1	1	SENDAR14057876	2015-09-01	200.00000000000000000000	0.00000000000000000000	-200.00000000000000000000	-100.00000000000000000000	\N	\N
470	1	1	SENDAR14057877	2015-09-07	200.00000000000000000000	0.00000000000000000000	-200.00000000000000000000	-100.00000000000000000000	\N	\N
471	1	1	SENDAR14057880	2015-10-01	275.00000000000000000000	0.00000000000000000000	-275.00000000000000000000	-100.00000000000000000000	\N	\N
472	1	1	SENDAR14057864	2015-06-01	250.00000000000000000000	0.00000000000000000000	-250.00000000000000000000	-100.00000000000000000000	\N	\N
473	1	1	SENDAR14057870	2015-07-13	225.00000000000000000000	0.00000000000000000000	-225.00000000000000000000	-100.00000000000000000000	\N	\N
474	1	1	SENDAR17014179	2017-01-16	690.00000000000000000000	0.00000000000000000000	-690.00000000000000000000	-100.00000000000000000000	\N	\N
475	1	1	SENDAR17014181	2017-02-01	709.00000000000000000000	0.00000000000000000000	-709.00000000000000000000	-100.00000000000000000000	\N	\N
476	1	1	SENDAR17014193	2017-05-01	830.00000000000000000000	0.00000000000000000000	-830.00000000000000000000	-100.00000000000000000000	\N	\N
477	1	1	SENDAR17014208	2017-08-21	623.00000000000000000000	0.00000000000000000000	-623.00000000000000000000	-100.00000000000000000000	\N	\N
478	1	1	SENDAR17014210	2017-09-11	723.00000000000000000000	0.00000000000000000000	-723.00000000000000000000	-100.00000000000000000000	\N	\N
479	1	1	SENDAR17014217	2017-11-01	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
480	1	1	SENDAR17014223	2017-12-18	562.00000000000000000000	0.00000000000000000000	-562.00000000000000000000	-100.00000000000000000000	\N	\N
481	1	1	SENDAR17014224	2017-12-25	562.00000000000000000000	0.00000000000000000000	-562.00000000000000000000	-100.00000000000000000000	\N	\N
482	1	1	SENDAR17014216	2017-10-23	753.00000000000000000000	0.00000000000000000000	-753.00000000000000000000	-100.00000000000000000000	\N	\N
483	1	1	SENDAR17014183	2017-02-13	709.00000000000000000000	0.00000000000000000000	-709.00000000000000000000	-100.00000000000000000000	\N	\N
484	1	1	SENDAR17014194	2017-05-08	830.00000000000000000000	0.00000000000000000000	-830.00000000000000000000	-100.00000000000000000000	\N	\N
485	1	1	SENDAR17014200	2017-06-19	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
486	1	1	SENDAR14057862	2015-05-18	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
487	1	1	SENDAR14057863	2015-05-25	300.00000000000000000000	0.00000000000000000000	-300.00000000000000000000	-100.00000000000000000000	\N	\N
488	1	1	SENDAR14057869	2015-07-06	225.00000000000000000000	0.00000000000000000000	-225.00000000000000000000	-100.00000000000000000000	\N	\N
489	1	1	SENDAR14057878	2015-09-14	200.00000000000000000000	0.00000000000000000000	-200.00000000000000000000	-100.00000000000000000000	\N	\N
490	1	1	SENDAR14057879	2015-09-21	200.00000000000000000000	0.00000000000000000000	-200.00000000000000000000	-100.00000000000000000000	\N	\N
491	1	1	SENDAR21078098	2022-02-07	2105.00000000000000000000	0.00000000000000000000	-2105.00000000000000000000	-100.00000000000000000000	\N	\N
492	1	1	SENDAR21078101	2022-05-09	2050.00000000000000000000	0.00000000000000000000	-2050.00000000000000000000	-100.00000000000000000000	\N	\N
493	1	1	SENDAR21078102	2022-06-06	1835.00000000000000000000	0.00000000000000000000	-1835.00000000000000000000	-100.00000000000000000000	\N	\N
494	1	1	SENDAR21078103	2022-07-11	2942.00000000000000000000	0.00000000000000000000	-2942.00000000000000000000	-100.00000000000000000000	\N	\N
495	1	1	SENDAR21078104	2022-08-08	1639.00000000000000000000	0.00000000000000000000	-1639.00000000000000000000	-100.00000000000000000000	\N	\N
496	1	1	SENDAR17014202	2017-07-10	596.00000000000000000000	0.00000000000000000000	-596.00000000000000000000	-100.00000000000000000000	\N	\N
497	1	1	SENDAR17014203	2017-07-17	596.00000000000000000000	0.00000000000000000000	-596.00000000000000000000	-100.00000000000000000000	\N	\N
498	1	1	SENDAR17014218	2017-11-06	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
499	1	1	SENDAR17014215	2017-10-16	753.00000000000000000000	0.00000000000000000000	-753.00000000000000000000	-100.00000000000000000000	\N	\N
500	1	1	SENDAR17014186	2017-03-06	742.00000000000000000000	0.00000000000000000000	-742.00000000000000000000	-100.00000000000000000000	\N	\N
501	1	1	SENDAR17014197	2017-06-01	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
502	1	1	SENDAR17014198	2017-06-05	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
503	1	1	SENDAR17014204	2017-07-24	596.00000000000000000000	0.00000000000000000000	-596.00000000000000000000	-100.00000000000000000000	\N	\N
504	1	1	SENDAR21078099	2022-03-07	1785.00000000000000000000	0.00000000000000000000	-1785.00000000000000000000	-100.00000000000000000000	\N	\N
505	1	1	SENDAR21078097	2022-01-10	2844.00000000000000000000	0.00000000000000000000	-2844.00000000000000000000	-100.00000000000000000000	\N	\N
506	1	1	SENDAR17014184	2017-02-20	709.00000000000000000000	0.00000000000000000000	-709.00000000000000000000	-100.00000000000000000000	\N	\N
507	1	1	SENDAR17014185	2017-03-01	742.00000000000000000000	0.00000000000000000000	-742.00000000000000000000	-100.00000000000000000000	\N	\N
508	1	1	SENDAR17014205	2017-08-01	623.00000000000000000000	0.00000000000000000000	-623.00000000000000000000	-100.00000000000000000000	\N	\N
509	1	1	SENDAR17014207	2017-08-14	623.00000000000000000000	0.00000000000000000000	-623.00000000000000000000	-100.00000000000000000000	\N	\N
510	1	1	SENDAR17014220	2017-11-20	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
511	1	1	SENDAR17014221	2017-12-04	562.00000000000000000000	0.00000000000000000000	-562.00000000000000000000	-100.00000000000000000000	\N	\N
512	1	1	SENDAR17014222	2017-12-11	562.00000000000000000000	0.00000000000000000000	-562.00000000000000000000	-100.00000000000000000000	\N	\N
513	1	1	SENDAR17014214	2017-10-09	753.00000000000000000000	0.00000000000000000000	-753.00000000000000000000	-100.00000000000000000000	\N	\N
514	1	1	SENDAR17014212	2017-09-25	723.00000000000000000000	0.00000000000000000000	-723.00000000000000000000	-100.00000000000000000000	\N	\N
515	1	1	SENDAR21078100	2022-04-11	3081.00000000000000000000	0.00000000000000000000	-3081.00000000000000000000	-100.00000000000000000000	\N	\N
516	1	1	SENDAR21078105	2022-09-05	2278.00000000000000000000	0.00000000000000000000	-2278.00000000000000000000	-100.00000000000000000000	\N	\N
517	1	1	SENDAR17014196	2017-05-22	830.00000000000000000000	0.00000000000000000000	-830.00000000000000000000	-100.00000000000000000000	\N	\N
518	1	1	SENDAR17014199	2017-06-12	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
519	1	1	SENDAR17014206	2017-08-07	623.00000000000000000000	0.00000000000000000000	-623.00000000000000000000	-100.00000000000000000000	\N	\N
520	1	1	SENDAR17014211	2017-09-18	723.00000000000000000000	0.00000000000000000000	-723.00000000000000000000	-100.00000000000000000000	\N	\N
521	1	1	SENDAR17014219	2017-11-13	732.00000000000000000000	0.00000000000000000000	-732.00000000000000000000	-100.00000000000000000000	\N	\N
522	1	1	SENDAR17014213	2017-10-02	753.00000000000000000000	0.00000000000000000000	-753.00000000000000000000	-100.00000000000000000000	\N	\N
523	1	1	SENDAR17014178	2017-01-09	690.00000000000000000000	0.00000000000000000000	-690.00000000000000000000	-100.00000000000000000000	\N	\N
524	1	1	SENDAR17014182	2017-02-06	709.00000000000000000000	0.00000000000000000000	-709.00000000000000000000	-100.00000000000000000000	\N	\N
525	1	1	SENDAR17014188	2017-03-20	742.00000000000000000000	0.00000000000000000000	-742.00000000000000000000	-100.00000000000000000000	\N	\N
526	1	1	SENDAR17014195	2017-05-15	830.00000000000000000000	0.00000000000000000000	-830.00000000000000000000	-100.00000000000000000000	\N	\N
527	1	1	SENDAR17014201	2017-07-03	596.00000000000000000000	0.00000000000000000000	-596.00000000000000000000	-100.00000000000000000000	\N	\N
528	1	1	SENDAR17014209	2017-09-04	723.00000000000000000000	0.00000000000000000000	-723.00000000000000000000	-100.00000000000000000000	\N	\N
529	1	1	SENDAR21078106	2022-10-10	2714.00000000000000000000	0.00000000000000000000	-2714.00000000000000000000	-100.00000000000000000000	\N	\N
176	1	1	SENDAR24124125	2025-02-10	264.00000000000000000000	468.00000000000000000000	204.00000000000000000000	77.27272727272727272700	\N	2025-09-25 12:59:32
235	1	1	SENDAR24124126	2025-02-17	264.00000000000000000000	540.00000000000000000000	276.00000000000000000000	104.54545454545454545500	\N	2025-09-25 12:59:32
196	1	1	SENDAR24124127	2025-02-24	264.00000000000000000000	576.00000000000000000000	312.00000000000000000000	118.18181818181818181800	\N	2025-09-25 12:59:32
260	1	1	SENDAR24124128	2025-03-03	505.00000000000000000000	144.00000000000000000000	-361.00000000000000000000	-71.48514851485148514900	\N	2025-09-25 12:59:32
214	1	1	SENDAR24124129	2025-03-10	505.00000000000000000000	180.00000000000000000000	-325.00000000000000000000	-64.35643564356435643600	\N	2025-09-25 12:59:32
261	1	1	SENDAR24124130	2025-03-17	505.00000000000000000000	540.00000000000000000000	35.00000000000000000000	6.93069306930693069300	\N	2025-09-25 12:59:32
215	1	1	SENDAR24124131	2025-03-24	505.00000000000000000000	576.00000000000000000000	71.00000000000000000000	14.05940594059405940600	\N	2025-09-25 12:59:32
\.


--
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
KLAf7DrNMF1gQRuaNjMTIcDiS363tGach8xJbDTt	\N	192.168.1.18	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36	YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZDFFUm1jcGNZY20wVzRVZGhwcmpqZFl6cHRJNTRBWlVXd3N2R2g5TCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNzoiaHR0cDovLzE5Mi4xNjguMS4xMC9wcm9kdWN0aW9uLW9yZGVycyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI1OiJodHRwOi8vMTkyLjE2OC4xLjEwL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==	1758804997
\.


--
-- Data for Name: stock_details; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.stock_details (id, article_id, article_family_id, warehouse_id, batch_number_fp, batch_number_rm, status, initial_quantity, expiry_date, inspection_date, created_at, updated_at) FROM stdin;
8	4	3	1	\N	24040308	A	3018.00000000000000000000	2029-05-20	2029-05-20	\N	\N
9	4	3	1	\N	24080636	A	29577.00000000000000000000	2029-10-07	2029-10-07	\N	\N
10	4	3	1	\N	25040277	A	117000.00000000000000000000	2030-05-06	2030-05-06	\N	\N
11	4	3	1	\N	25040278	A	91000.00000000000000000000	2030-05-09	2030-05-09	\N	\N
12	5	3	1	\N	21070570	Q	77600.00000000000000000000	2022-07-26	2022-07-26	\N	\N
13	5	3	1	\N	24040301	A	318.00000000000000000000	2025-05-17	2025-05-17	\N	\N
14	5	3	1	\N	25040280	A	91223.00000000000000000000	2026-05-06	2026-05-06	\N	\N
15	6	3	1	\N	25010031	A	10747.00000000000000000000	2030-01-21	2030-01-21	\N	\N
16	7	3	1	\N	25010037	A	10697.00000000000000000000	2027-01-28	2027-01-28	\N	\N
17	8	3	1	\N	24070589	A	1274.00000000000000000000	2027-08-13	2027-08-13	\N	\N
18	8	3	1	\N	25040226	A	16525.00000000000000000000	2028-04-11	2028-04-11	\N	\N
19	9	3	1	\N	24030202	A	29.00000000000000000000	2029-03-19	2029-03-19	\N	\N
20	9	3	1	\N	24060504	A	15.00000000000000000000	2029-06-29	2029-06-29	\N	\N
21	9	3	1	\N	24080650	A	160.00000000000000000000	2029-09-13	2029-09-13	\N	\N
22	9	3	1	\N	25010005	A	2863.00000000000000000000	2030-01-14	2030-01-14	\N	\N
23	9	3	1	\N	25060430	Q	5430.00000000000000000000	2030-06-11	2030-06-11	\N	\N
24	2	1	1	\N	25010025	A	76477.00000000000000000000	2027-09-01	2026-02-24	\N	\N
25	10	4	1	\N	21090784	A	1170.00000000000000000000	2999-12-31	2999-12-31	\N	\N
26	10	4	1	\N	21090785	A	1170.00000000000000000000	2999-12-31	2999-12-31	\N	\N
27	3	1	1	\N	24110867	A	634232.00000000000000000000	2029-09-19	2025-12-18	\N	\N
28	3	1	1	\N	25030190	A	1050000.00000000000000000000	2030-02-08	2027-10-03	\N	\N
1	1	2	1	DAR250029	\N	A	2518.00000000000000000000	2026-12-01	\N	\N	\N
2	1	2	1	DAR210384	\N	Q	1.00000000000000000000	2023-08-01	\N	\N	\N
3	1	2	1	DAR210550	\N	Q	1.00000000000000000000	2023-08-01	\N	\N	\N
4	1	2	1	DAR220320	\N	Q	1.00000000000000000000	2024-03-01	\N	\N	\N
5	1	2	1	DAR220321	\N	Q	2.00000000000000000000	2024-03-01	\N	\N	\N
6	1	2	1	DAR220797	\N	Q	10.00000000000000000000	2024-06-01	\N	\N	\N
7	1	2	1	DAR220998	\N	Q	11.00000000000000000000	2024-06-01	\N	\N	\N
\.


--
-- Data for Name: stock_movements; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.stock_movements (id, article_id, warehouse_id, movement_date, quantity, forecast_code, batch_number_fp, created_at, updated_at) FROM stdin;
1	1	1	2025-01-06	108.00000000000000000000	LIVDSF2500014	DAR241076	\N	\N
2	1	1	2025-01-06	36.00000000000000000000	LIVDSF2500011	DAR241076	\N	\N
3	1	1	2025-01-07	36.00000000000000000000	LIVDSF2500020	DAR241076	\N	\N
4	1	1	2025-01-08	36.00000000000000000000	LIVDSF2500026	DAR241076	\N	\N
5	1	1	2025-01-09	36.00000000000000000000	LIVDSF2500035	DAR241076	\N	\N
6	1	1	2025-01-10	36.00000000000000000000	LIVDSF2500044	DAR241076	\N	\N
7	1	1	2025-01-10	36.00000000000000000000	LIVDSF2500051	DAR241076	\N	\N
8	1	1	2025-01-10	36.00000000000000000000	LIVDSF2500052	DAR241076	\N	\N
9	1	1	2025-01-11	36.00000000000000000000	LIVDSF2500055	DAR241076	\N	\N
10	1	1	2025-01-14	36.00000000000000000000	LIVDSF2500063	DAR241076	\N	\N
11	1	1	2025-01-17	180.00000000000000000000	LIVDSF2500079	DAR241076	\N	\N
12	1	1	2025-01-17	36.00000000000000000000	LIVDSF2500082	DAR241076	\N	\N
13	1	1	2025-01-18	36.00000000000000000000	LIVDSF2500085	DAR241076	\N	\N
14	1	1	2025-01-20	36.00000000000000000000	LIVDSF2500090	DAR241076	\N	\N
15	1	1	2025-01-23	36.00000000000000000000	LIVDSF2500117	DAR241076	\N	\N
16	1	1	2025-01-24	36.00000000000000000000	LIVDSF2500124	DAR241076	\N	\N
17	1	1	2025-01-24	36.00000000000000000000	LIVDSF2500119	DAR241076	\N	\N
18	1	1	2025-01-24	36.00000000000000000000	LIVDSF2500118	DAR241076	\N	\N
19	1	1	2025-01-27	36.00000000000000000000	LIVDSF2500131	DAR241076	\N	\N
20	1	1	2025-01-27	72.00000000000000000000	LIVDSF2500127	DAR241076	\N	\N
21	1	1	2025-01-27	72.00000000000000000000	LIVDSF2500135	DAR241076	\N	\N
22	1	1	2025-01-28	36.00000000000000000000	LIVDSF2500138	DAR241076	\N	\N
23	1	1	2025-01-28	36.00000000000000000000	LIVDSF2500147	DAR241076	\N	\N
24	1	1	2025-01-29	72.00000000000000000000	LIVDSF2500157	DAR241076	\N	\N
25	1	1	2025-01-31	72.00000000000000000000	LIVDSF2500175	DAR241076	\N	\N
26	1	1	2025-01-31	36.00000000000000000000	LIVDSF2500174	DAR241076	\N	\N
27	1	1	2025-01-31	36.00000000000000000000	LIVDSF2500173	DAR241076	\N	\N
28	1	1	2025-02-01	72.00000000000000000000	LIVDSF2500179	DAR241076	\N	\N
29	1	1	2025-02-04	36.00000000000000000000	LIVDSF2500190	DAR241076	\N	\N
30	1	1	2025-02-08	180.00000000000000000000	LIVDSF2500211	DAR241076	\N	\N
31	1	1	2025-02-10	36.00000000000000000000	LIVDSF2500217	DAR241076	\N	\N
32	1	1	2025-02-10	36.00000000000000000000	LIVDSF2500213	DAR241076	\N	\N
33	1	1	2025-02-10	36.00000000000000000000	LIVDSF2500219	DAR241076	\N	\N
34	1	1	2025-02-11	36.00000000000000000000	LIVDSF2500220	DAR241076	\N	\N
35	1	1	2025-02-12	72.00000000000000000000	LIVDSF2500228	DAR241076	\N	\N
36	1	1	2025-02-12	72.00000000000000000000	LIVDSF2500229	DAR241076	\N	\N
37	1	1	2025-02-13	2.00000000000000000000	LIVDSF2500235	DAR241076	\N	\N
38	1	1	2025-02-13	34.00000000000000000000	LIVDSF2500235	DAR250029	\N	\N
39	1	1	2025-02-13	72.00000000000000000000	LIVDSF2500239	DAR250029	\N	\N
40	1	1	2025-02-14	72.00000000000000000000	LIVDSF2500244	DAR250029	\N	\N
41	1	1	2025-02-17	36.00000000000000000000	LIVDSF2500247	DAR250029	\N	\N
42	1	1	2025-02-17	36.00000000000000000000	LIVDSF2500249	DAR250029	\N	\N
43	1	1	2025-02-17	72.00000000000000000000	LIVDSF2500250	DAR250029	\N	\N
44	1	1	2025-02-17	36.00000000000000000000	LIVDSF2500251	DAR250029	\N	\N
45	1	1	2025-02-18	36.00000000000000000000	LIVDSF2500262	DAR250029	\N	\N
46	1	1	2025-02-19	36.00000000000000000000	LIVDSF2500268	DAR250029	\N	\N
47	1	1	2025-02-20	36.00000000000000000000	LIVDSF2500276	DAR250029	\N	\N
48	1	1	2025-02-20	36.00000000000000000000	LIVDSF2500277	DAR250029	\N	\N
49	1	1	2025-02-20	36.00000000000000000000	LIVDSF2500274	DAR250029	\N	\N
50	1	1	2025-02-21	144.00000000000000000000	LIVDSF2500285	DAR250029	\N	\N
51	1	1	2025-02-22	36.00000000000000000000	LIVDSF2500290	DAR250029	\N	\N
52	1	1	2025-02-24	36.00000000000000000000	LIVDSF2500294	DAR250029	\N	\N
53	1	1	2025-02-25	36.00000000000000000000	LIVDSF2500296	DAR250029	\N	\N
54	1	1	2025-02-25	72.00000000000000000000	LIVDSF2500299	DAR250029	\N	\N
55	1	1	2025-02-26	36.00000000000000000000	LIVDSF2500308	DAR250029	\N	\N
56	1	1	2025-02-27	36.00000000000000000000	LIVDSF2500309	DAR250029	\N	\N
57	1	1	2025-02-27	108.00000000000000000000	LIVDSF2500314	DAR250029	\N	\N
58	1	1	2025-02-27	144.00000000000000000000	LIVDSF2500316	DAR250029	\N	\N
59	1	1	2025-02-28	36.00000000000000000000	LIVDSF2500322	DAR250029	\N	\N
60	1	1	2025-03-01	72.00000000000000000000	LIVDSF2500324	DAR250029	\N	\N
61	1	1	2025-03-03	36.00000000000000000000	LIVDSF2500332	DAR250029	\N	\N
62	1	1	2025-03-06	36.00000000000000000000	LIVDSF2500368	DAR250029	\N	\N
63	1	1	2025-03-07	72.00000000000000000000	LIVDSF2500369	DAR250029	\N	\N
64	1	1	2025-03-10	36.00000000000000000000	LIVDSF2500381	DAR250029	\N	\N
65	1	1	2025-03-11	36.00000000000000000000	LIVDSF2500388	DAR250029	\N	\N
66	1	1	2025-03-12	36.00000000000000000000	LIVDSF2500401	DAR250029	\N	\N
67	1	1	2025-03-13	36.00000000000000000000	LIVDSF2500408	DAR250029	\N	\N
68	1	1	2025-03-15	36.00000000000000000000	LIVDSF2500430	DAR250029	\N	\N
69	1	1	2025-03-17	36.00000000000000000000	LIVDSF2500437	DAR250029	\N	\N
70	1	1	2025-03-17	36.00000000000000000000	LIVDSF2500436	DAR250029	\N	\N
71	1	1	2025-03-18	144.00000000000000000000	LIVDSF2500446	DAR250029	\N	\N
72	1	1	2025-03-19	36.00000000000000000000	LIVDSF2500454	DAR250029	\N	\N
73	1	1	2025-03-21	36.00000000000000000000	LIVDSF2500461	DAR250029	\N	\N
74	1	1	2025-03-22	36.00000000000000000000	LIVDSF2500466	DAR250029	\N	\N
75	1	1	2025-03-22	72.00000000000000000000	LIVDSF2500467	DAR250029	\N	\N
76	1	1	2025-03-22	144.00000000000000000000	LIVDSF2500468	DAR250029	\N	\N
77	1	1	2025-03-24	36.00000000000000000000	LIVDSF2500473	DAR250029	\N	\N
78	1	1	2025-03-25	72.00000000000000000000	LIVDSF2500480	DAR250029	\N	\N
79	1	1	2025-03-26	36.00000000000000000000	LIVDSF2500493	DAR250029	\N	\N
80	1	1	2025-03-26	36.00000000000000000000	LIVDSF2500497	DAR250029	\N	\N
81	1	1	2025-03-27	36.00000000000000000000	LIVDSF2500506	DAR250029	\N	\N
82	1	1	2025-03-27	72.00000000000000000000	LIVDSF2500519	DAR250029	\N	\N
83	1	1	2025-03-28	36.00000000000000000000	LIVDSF2500525	DAR250029	\N	\N
84	1	1	2025-03-28	180.00000000000000000000	LIVDSF2500528	DAR250029	\N	\N
85	1	1	2025-03-29	72.00000000000000000000	LIVDSF2500532	DAR250029	\N	\N
\.


--
-- Data for Name: variance_alerts_sent; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.variance_alerts_sent (id, article_id, week_start, created_at) FROM stdin;
\.


--
-- Data for Name: warehouses; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.warehouses (id, warehouse_code, warehouse_name, created_at, updated_at) FROM stdin;
1	DSF	DSF	\N	\N
\.



--
-- Name: article_families article_families_family_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.article_families
    ADD CONSTRAINT article_families_family_code_unique UNIQUE (family_code);


--
-- Name: article_families article_families_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.article_families
    ADD CONSTRAINT article_families_pkey PRIMARY KEY (id);


--
-- Name: articles articles_article_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.articles
    ADD CONSTRAINT articles_article_code_unique UNIQUE (article_code);


--
-- Name: articles articles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.articles
    ADD CONSTRAINT articles_pkey PRIMARY KEY (id);


--
-- Name: db_change_notifications db_change_notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.db_change_notifications
    ADD CONSTRAINT db_change_notifications_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: notification_user notification_user_notification_id_user_id_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_user
    ADD CONSTRAINT notification_user_notification_id_user_id_unique UNIQUE (notification_id, user_id);


--
-- Name: notification_user notification_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_user
    ADD CONSTRAINT notification_user_pkey PRIMARY KEY (id);


--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


--
-- Name: product_compositions product_compositions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.product_compositions
    ADD CONSTRAINT product_compositions_pkey PRIMARY KEY (id);


--
-- Name: production_calculations production_calculations_article_id_calculation_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_calculations
    ADD CONSTRAINT production_calculations_article_id_calculation_date_unique UNIQUE (article_id, calculation_date);


--
-- Name: production_calculations production_calculations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_calculations
    ADD CONSTRAINT production_calculations_pkey PRIMARY KEY (id);


--
-- Name: production_orders production_orders_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_orders
    ADD CONSTRAINT production_orders_code_unique UNIQUE (code);


--
-- Name: production_orders production_orders_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_orders
    ADD CONSTRAINT production_orders_pkey PRIMARY KEY (id);


--
-- Name: sales_forecasts sales_forecasts_article_id_forecast_date_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sales_forecasts
    ADD CONSTRAINT sales_forecasts_article_id_forecast_date_unique UNIQUE (article_id, forecast_date);


--
-- Name: sales_forecasts sales_forecasts_forecast_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sales_forecasts
    ADD CONSTRAINT sales_forecasts_forecast_code_unique UNIQUE (forecast_code);


--
-- Name: sales_forecasts sales_forecasts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sales_forecasts
    ADD CONSTRAINT sales_forecasts_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: stock_details stock_details_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_details
    ADD CONSTRAINT stock_details_pkey PRIMARY KEY (id);


--
-- Name: stock_movements stock_movements_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_pkey PRIMARY KEY (id);


--
-- Name: variance_alerts_sent variance_alerts_sent_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.variance_alerts_sent
    ADD CONSTRAINT variance_alerts_sent_pkey PRIMARY KEY (id);


--
-- Name: variance_alerts_sent variance_alerts_sent_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.variance_alerts_sent
    ADD CONSTRAINT variance_alerts_sent_unique UNIQUE (article_id, week_start);


--
-- Name: warehouses warehouses_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.warehouses
    ADD CONSTRAINT warehouses_pkey PRIMARY KEY (id);


--
-- Name: warehouses warehouses_warehouse_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.warehouses
    ADD CONSTRAINT warehouses_warehouse_code_unique UNIQUE (warehouse_code);


--
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- Name: notification_user_user_id_read_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notification_user_user_id_read_at_index ON public.notification_user USING btree (user_id, read_at);


--
-- Name: notifications_source_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notifications_source_index ON public.notifications USING btree (source);


--
-- Name: notifications_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notifications_type_index ON public.notifications USING btree (type);


--
-- Name: notifications_user_id_read_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notifications_user_id_read_at_index ON public.notifications USING btree (user_id, read_at);


--
-- Name: production_calculations_calculation_date_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX production_calculations_calculation_date_index ON public.production_calculations USING btree (calculation_date);


--
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- Name: variance_alerts_sent_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX variance_alerts_sent_created_at_index ON public.variance_alerts_sent USING btree (created_at);


--
-- Name: variance_alerts_sent_week_start_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX variance_alerts_sent_week_start_index ON public.variance_alerts_sent USING btree (week_start);


--
-- Name: articles articles_batch_size_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER articles_batch_size_trigger AFTER UPDATE ON public.articles FOR EACH ROW EXECUTE FUNCTION public.update_product_compositions_on_article_change();


--
-- Name: articles articles_calculation_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER articles_calculation_trigger AFTER INSERT OR UPDATE OF stock, target_coverage_months, batch_size ON public.articles FOR EACH ROW EXECUTE FUNCTION public.trigger_calculate_production();


--
-- Name: product_compositions product_compositions_quantity_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER product_compositions_quantity_trigger BEFORE INSERT OR UPDATE ON public.product_compositions FOR EACH ROW EXECUTE FUNCTION public.calculate_quantity_per_lot();


--
-- Name: production_calculations production_calculations_change_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER production_calculations_change_trigger AFTER INSERT OR DELETE OR UPDATE OF initial_coverage ON public.production_calculations FOR EACH ROW EXECUTE FUNCTION public.log_table_change();


--
-- Name: production_calculations production_calculations_priority_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER production_calculations_priority_trigger BEFORE INSERT OR UPDATE ON public.production_calculations FOR EACH ROW EXECUTE FUNCTION public.trigger_update_priority();


--
-- Name: sales_forecasts sales_forecasts_budget_trigger; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER sales_forecasts_budget_trigger AFTER INSERT OR DELETE OR UPDATE ON public.sales_forecasts FOR EACH ROW EXECUTE FUNCTION public.trigger_update_monthly_budget();


--
-- Name: sales_forecasts trigger_sales_forecasts_variance; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_sales_forecasts_variance BEFORE INSERT OR UPDATE ON public.sales_forecasts FOR EACH ROW EXECUTE FUNCTION public.calculate_sales_forecast_variance();


--
-- Name: stock_movements trigger_stock_movements_variance; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_stock_movements_variance AFTER INSERT OR DELETE OR UPDATE ON public.stock_movements FOR EACH ROW EXECUTE FUNCTION public.calculate_sales_forecast_variance();


--
-- Name: stock_details trigger_update_article_stock_after_delete; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_update_article_stock_after_delete AFTER DELETE ON public.stock_details FOR EACH ROW EXECUTE FUNCTION public.update_article_stock();


--
-- Name: stock_details trigger_update_article_stock_after_insert; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_update_article_stock_after_insert AFTER INSERT ON public.stock_details FOR EACH ROW EXECUTE FUNCTION public.update_article_stock();


--
-- Name: stock_details trigger_update_article_stock_after_update; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER trigger_update_article_stock_after_update AFTER UPDATE ON public.stock_details FOR EACH ROW EXECUTE FUNCTION public.update_article_stock();


--
-- Name: articles articles_article_family_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.articles
    ADD CONSTRAINT articles_article_family_id_foreign FOREIGN KEY (article_family_id) REFERENCES public.article_families(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: notification_user notification_user_notification_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_user
    ADD CONSTRAINT notification_user_notification_id_foreign FOREIGN KEY (notification_id) REFERENCES public.notifications(id) ON DELETE CASCADE;


--
-- Name: notification_user notification_user_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_user
    ADD CONSTRAINT notification_user_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: notifications notifications_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: product_compositions product_compositions_component_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.product_compositions
    ADD CONSTRAINT product_compositions_component_article_id_foreign FOREIGN KEY (component_article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
-- Name: product_compositions product_compositions_parent_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.product_compositions
    ADD CONSTRAINT product_compositions_parent_article_id_foreign FOREIGN KEY (parent_article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
-- Name: production_calculations production_calculations_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_calculations
    ADD CONSTRAINT production_calculations_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: production_orders production_orders_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_orders
    ADD CONSTRAINT production_orders_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: production_orders production_orders_selected_sf_stock_detail_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.production_orders
    ADD CONSTRAINT production_orders_selected_sf_stock_detail_id_foreign FOREIGN KEY (selected_sf_stock_detail_id) REFERENCES public.stock_details(id);


--
-- Name: sales_forecasts sales_forecasts_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sales_forecasts
    ADD CONSTRAINT sales_forecasts_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
-- Name: sales_forecasts sales_forecasts_warehouse_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sales_forecasts
    ADD CONSTRAINT sales_forecasts_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: stock_details stock_details_article_family_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_details
    ADD CONSTRAINT stock_details_article_family_id_foreign FOREIGN KEY (article_family_id) REFERENCES public.article_families(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: stock_details stock_details_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_details
    ADD CONSTRAINT stock_details_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
-- Name: stock_details stock_details_warehouse_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_details
    ADD CONSTRAINT stock_details_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: stock_movements stock_movements_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
-- Name: stock_movements stock_movements_warehouse_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.stock_movements
    ADD CONSTRAINT stock_movements_warehouse_id_foreign FOREIGN KEY (warehouse_id) REFERENCES public.warehouses(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: variance_alerts_sent variance_alerts_sent_article_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.variance_alerts_sent
    ADD CONSTRAINT variance_alerts_sent_article_id_foreign FOREIGN KEY (article_id) REFERENCES public.articles(id) ON DELETE CASCADE;


--
--

