--
--


SET transaction_timeout = 0;

--
-- Name: resource_type_enum; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public.resource_type_enum AS ENUM (
    'MEHNAT',
    'TEXNIKA',
    'MATERIAL'
);


ALTER TYPE public.resource_type_enum OWNER TO postgres;



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

CREATE TABLE public.auth_assignment (
    item_name character varying(64) NOT NULL,
    user_id character varying(64) NOT NULL,
    created_at integer
);


ALTER TABLE public.auth_assignment OWNER TO postgres;

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

CREATE TABLE public.auth_item (
    name character varying(64) NOT NULL,
    type smallint NOT NULL,
    description text,
    rule_name character varying(64),
    data bytea,
    created_at integer,
    updated_at integer
);


ALTER TABLE public.auth_item OWNER TO postgres;

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

CREATE TABLE public.auth_item_child (
    parent character varying(64) NOT NULL,
    child character varying(64) NOT NULL
);


ALTER TABLE public.auth_item_child OWNER TO postgres;

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

CREATE TABLE public.auth_rule (
    name character varying(64) NOT NULL,
    data bytea,
    created_at integer,
    updated_at integer
);


ALTER TABLE public.auth_rule OWNER TO postgres;

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

CREATE TABLE public.customers (
    id bigint NOT NULL,
    name text NOT NULL,
    inn character varying(32),
    phone character varying(50),
    address text,
    status character varying(16) DEFAULT 'active'::character varying NOT NULL,
    notes text,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    CONSTRAINT customers_status_check CHECK (((status)::text = ANY ((ARRAY['active'::character varying, 'inactive'::character varying])::text[])))
);


ALTER TABLE public.customers OWNER TO postgres;

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

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


ALTER SEQUENCE public.customers_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.customers_id_seq OWNED BY public.customers.id;


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

CREATE TABLE public.migration (
    version character varying(180) NOT NULL,
    apply_time integer
);


ALTER TABLE public.migration OWNER TO postgres;

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

CREATE TABLE public.object_members (
    id bigint NOT NULL,
    user_id bigint NOT NULL,
    object_id bigint NOT NULL,
    role_key character varying(64) NOT NULL,
    assigned_at timestamp(0) without time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.object_members OWNER TO postgres;

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

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


ALTER SEQUENCE public.object_members_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.object_members_id_seq OWNED BY public.object_members.id;


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

CREATE TABLE public.object_parts (
    id bigint NOT NULL,
    object_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    status character varying(16) DEFAULT 'planned'::character varying NOT NULL,
    start_date date,
    end_date date,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    CONSTRAINT object_parts_status_check CHECK (((status)::text = ANY ((ARRAY['planned'::character varying, 'active'::character varying, 'done'::character varying, 'closed'::character varying])::text[])))
);


ALTER TABLE public.object_parts OWNER TO postgres;

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

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


ALTER SEQUENCE public.object_parts_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.object_parts_id_seq OWNED BY public.object_parts.id;


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

CREATE TABLE public.objects (
    id bigint NOT NULL,
    project_id bigint NOT NULL,
    name character varying(255) NOT NULL,
    start_date date,
    end_date date,
    status character varying(16) DEFAULT 'planned'::character varying NOT NULL,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    CONSTRAINT objects_status_check CHECK (((status)::text = ANY ((ARRAY['planned'::character varying, 'active'::character varying, 'on_hold'::character varying, 'closed'::character varying])::text[])))
);


ALTER TABLE public.objects OWNER TO postgres;

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

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


ALTER SEQUENCE public.objects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.objects_id_seq OWNED BY public.objects.id;


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

CREATE TABLE public.projects (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    customer_id bigint NOT NULL,
    address text,
    start_date date,
    end_date date,
    status character varying(16) DEFAULT 'planned'::character varying NOT NULL,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    user_id integer NOT NULL,
    CONSTRAINT projects_status_check CHECK (((status)::text = ANY ((ARRAY['planned'::character varying, 'active'::character varying, 'on_hold'::character varying, 'closed'::character varying])::text[])))
);


ALTER TABLE public.projects OWNER TO postgres;

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

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


ALTER SEQUENCE public.projects_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;


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

CREATE TABLE public.resource_catalog (
    id bigint NOT NULL,
    code text NOT NULL,
    name text NOT NULL,
    name_sku text,
    resource_type public.resource_type_enum NOT NULL,
    unit_id bigint NOT NULL,
    description text,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.resource_catalog OWNER TO postgres;

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

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


ALTER SEQUENCE public.resource_catalog_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.resource_catalog_id_seq OWNED BY public.resource_catalog.id;


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

CREATE TABLE public.units (
    id bigint NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.units OWNER TO postgres;

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

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


ALTER SEQUENCE public.units_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.units_id_seq OWNED BY public.units.id;

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

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


ALTER SEQUENCE public.user_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.user_id_seq OWNED BY public."user".id;


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

CREATE TABLE public.work_categories (
    id bigint NOT NULL,
    code character varying(32) NOT NULL,
    name_uz character varying(255) NOT NULL,
    name_ru character varying(255),
    name_en character varying(255),
    parent_id bigint,
    shnk_code character varying(32),
    description text,
    sort_order integer DEFAULT 100 NOT NULL,
    is_active boolean DEFAULT true NOT NULL,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.work_categories OWNER TO postgres;

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

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


ALTER SEQUENCE public.work_categories_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.work_categories_id_seq OWNED BY public.work_categories.id;


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

CREATE TABLE public.work_resources (
    id bigint NOT NULL,
    work_id bigint NOT NULL,
    number text,
    resource_id bigint NOT NULL,
    unit_id bigint,
    norm_work_unit numeric(18,6) NOT NULL,
    qty_total numeric(18,6),
    unit_price numeric(18,2),
    total_price numeric(18,2),
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    object_id bigint,
    code text,
    CONSTRAINT chk_wr_nonneg CHECK (((COALESCE(norm_work_unit, (0)::numeric) >= (0)::numeric) AND (COALESCE(qty_total, (0)::numeric) >= (0)::numeric) AND (COALESCE(unit_price, (0)::numeric) >= (0)::numeric) AND (COALESCE(total_price, (0)::numeric) >= (0)::numeric)))
);


ALTER TABLE public.work_resources OWNER TO postgres;

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

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


ALTER SEQUENCE public.work_resources_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.work_resources_id_seq OWNED BY public.work_resources.id;


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

CREATE TABLE public.work_schedules (
    id bigint NOT NULL,
    work_id bigint NOT NULL,
    planned_start date NOT NULL,
    planned_end date NOT NULL,
    planned_days integer GENERATED ALWAYS AS (((planned_end - planned_start) + 1)) STORED,
    fact_start date,
    fact_end date,
    fact_days integer GENERATED ALWAYS AS (
CASE
    WHEN ((fact_start IS NOT NULL) AND (fact_end IS NOT NULL)) THEN ((fact_end - fact_start) + 1)
    ELSE NULL::integer
END) STORED,
    done_percent numeric(5,2) DEFAULT 0,
    done_quantity numeric(18,3),
    status character varying(16) DEFAULT 'planned'::character varying NOT NULL,
    note text,
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    object_id bigint,
    CONSTRAINT work_schedules_status_check CHECK (((status)::text = ANY ((ARRAY['planned'::character varying, 'active'::character varying, 'done'::character varying, 'closed'::character varying])::text[])))
);


ALTER TABLE public.work_schedules OWNER TO postgres;

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

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


ALTER SEQUENCE public.work_schedules_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.work_schedules_id_seq OWNED BY public.work_schedules.id;


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

CREATE TABLE public.works (
    id bigint NOT NULL,
    object_part_id bigint NOT NULL,
    number text NOT NULL,
    code text,
    name text NOT NULL,
    unit_id bigint,
    qty_units numeric(18,4),
    unit_price numeric(18,2),
    total_price numeric(18,2),
    created_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    updated_at timestamp(0) without time zone DEFAULT now() NOT NULL,
    name_uzbek text,
    work_category_id bigint DEFAULT 1 NOT NULL,
    object_id bigint,
    status character varying(20) DEFAULT 'planned'::character varying,
    source_type character varying(20) DEFAULT 'smeta'::character varying,
    CONSTRAINT works_source_type_check CHECK (((source_type)::text = ANY ((ARRAY['smeta'::character varying, 'manual'::character varying, 'vo'::character varying])::text[]))),
    CONSTRAINT works_status_check CHECK (((status)::text = ANY ((ARRAY['planned'::character varying, 'draft'::character varying, 'done'::character varying, 'rejected'::character varying])::text[])))
);


ALTER TABLE public.works OWNER TO postgres;

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

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


ALTER SEQUENCE public.works_id_seq OWNER TO postgres;

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

ALTER SEQUENCE public.works_id_seq OWNED BY public.works.id;


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COPY public.auth_assignment (item_name, user_id, created_at) FROM stdin;
superadmin	2	1762883290
forsuperadmin	2	1762883290
PTO	2	1763798294
PRORAB	2	1763798336
\.


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

COPY public.auth_item (name, type, description, rule_name, data, created_at, updated_at) FROM stdin;
superadmin	1	\N	\N	\N	1762883198	1762883198
/admin/assignment/index	2	\N	\N	\N	1762883218	1762883218
/admin/assignment/view	2	\N	\N	\N	1762883218	1762883218
/admin/assignment/assign	2	\N	\N	\N	1762883218	1762883218
/admin/assignment/revoke	2	\N	\N	\N	1762883218	1762883218
/admin/assignment/*	2	\N	\N	\N	1762883218	1762883218
/admin/default/index	2	\N	\N	\N	1762883218	1762883218
/admin/default/*	2	\N	\N	\N	1762883218	1762883218
/admin/menu/index	2	\N	\N	\N	1762883218	1762883218
/admin/menu/view	2	\N	\N	\N	1762883218	1762883218
/admin/menu/create	2	\N	\N	\N	1762883218	1762883218
/admin/menu/update	2	\N	\N	\N	1762883218	1762883218
/admin/menu/delete	2	\N	\N	\N	1762883218	1762883218
/admin/menu/*	2	\N	\N	\N	1762883218	1762883218
/admin/permission/index	2	\N	\N	\N	1762883218	1762883218
/admin/permission/view	2	\N	\N	\N	1762883218	1762883218
/admin/permission/create	2	\N	\N	\N	1762883218	1762883218
/admin/permission/update	2	\N	\N	\N	1762883218	1762883218
/admin/permission/delete	2	\N	\N	\N	1762883218	1762883218
/admin/permission/assign	2	\N	\N	\N	1762883218	1762883218
/admin/permission/get-users	2	\N	\N	\N	1762883218	1762883218
/admin/permission/remove	2	\N	\N	\N	1762883218	1762883218
/admin/permission/*	2	\N	\N	\N	1762883218	1762883218
/admin/role/index	2	\N	\N	\N	1762883218	1762883218
/admin/role/view	2	\N	\N	\N	1762883218	1762883218
/admin/role/create	2	\N	\N	\N	1762883218	1762883218
/admin/role/update	2	\N	\N	\N	1762883218	1762883218
/admin/role/delete	2	\N	\N	\N	1762883218	1762883218
/admin/role/assign	2	\N	\N	\N	1762883218	1762883218
/admin/role/get-users	2	\N	\N	\N	1762883218	1762883218
/admin/role/remove	2	\N	\N	\N	1762883218	1762883218
/admin/role/*	2	\N	\N	\N	1762883218	1762883218
/admin/route/index	2	\N	\N	\N	1762883218	1762883218
/admin/route/create	2	\N	\N	\N	1762883218	1762883218
/admin/route/assign	2	\N	\N	\N	1762883218	1762883218
/admin/route/remove	2	\N	\N	\N	1762883218	1762883218
/admin/route/refresh	2	\N	\N	\N	1762883218	1762883218
/admin/route/*	2	\N	\N	\N	1762883218	1762883218
/admin/rule/index	2	\N	\N	\N	1762883218	1762883218
/admin/rule/view	2	\N	\N	\N	1762883218	1762883218
/admin/rule/create	2	\N	\N	\N	1762883218	1762883218
/admin/rule/update	2	\N	\N	\N	1762883218	1762883218
/admin/rule/delete	2	\N	\N	\N	1762883218	1762883218
/admin/rule/*	2	\N	\N	\N	1762883218	1762883218
/admin/user/index	2	\N	\N	\N	1762883218	1762883218
/admin/user/view	2	\N	\N	\N	1762883218	1762883218
/admin/user/delete	2	\N	\N	\N	1762883218	1762883218
/admin/user/login	2	\N	\N	\N	1762883218	1762883218
/admin/user/logout	2	\N	\N	\N	1762883218	1762883218
/admin/user/signup	2	\N	\N	\N	1762883218	1762883218
/admin/user/request-password-reset	2	\N	\N	\N	1762883218	1762883218
/admin/user/reset-password	2	\N	\N	\N	1762883218	1762883218
/admin/user/change-password	2	\N	\N	\N	1762883218	1762883218
/admin/user/activate	2	\N	\N	\N	1762883218	1762883218
/admin/user/*	2	\N	\N	\N	1762883218	1762883218
/admin/*	2	\N	\N	\N	1762883218	1762883218
/debug/default/db-explain	2	\N	\N	\N	1762883218	1762883218
/debug/default/index	2	\N	\N	\N	1762883218	1762883218
/debug/default/view	2	\N	\N	\N	1762883218	1762883218
/debug/default/toolbar	2	\N	\N	\N	1762883218	1762883218
/debug/default/download-mail	2	\N	\N	\N	1762883218	1762883218
/debug/default/*	2	\N	\N	\N	1762883218	1762883218
/debug/user/set-identity	2	\N	\N	\N	1762883218	1762883218
/debug/user/reset-identity	2	\N	\N	\N	1762883218	1762883218
/debug/user/*	2	\N	\N	\N	1762883218	1762883218
/debug/*	2	\N	\N	\N	1762883218	1762883218
/gii/default/index	2	\N	\N	\N	1762883218	1762883218
/gii/default/view	2	\N	\N	\N	1762883218	1762883218
/gii/default/preview	2	\N	\N	\N	1762883218	1762883218
/gii/default/diff	2	\N	\N	\N	1762883218	1762883218
/gii/default/action	2	\N	\N	\N	1762883218	1762883218
/gii/default/*	2	\N	\N	\N	1762883218	1762883218
/gii/*	2	\N	\N	\N	1762883218	1762883218
/customer/index	2	\N	\N	\N	1762883218	1762883218
/customer/view	2	\N	\N	\N	1762883218	1762883218
/customer/create	2	\N	\N	\N	1762883218	1762883218
/customer/update	2	\N	\N	\N	1762883218	1762883218
/customer/delete	2	\N	\N	\N	1762883218	1762883218
/customer/*	2	\N	\N	\N	1762883218	1762883218
/object-members/index	2	\N	\N	\N	1762883218	1762883218
/object-members/view	2	\N	\N	\N	1762883218	1762883218
/object-members/create	2	\N	\N	\N	1762883218	1762883218
/object-members/update	2	\N	\N	\N	1762883218	1762883218
/object-members/delete	2	\N	\N	\N	1762883218	1762883218
/object-members/*	2	\N	\N	\N	1762883218	1762883218
/object-parts/index	2	\N	\N	\N	1762883218	1762883218
/object-parts/view	2	\N	\N	\N	1762883218	1762883218
/object-parts/create	2	\N	\N	\N	1762883218	1762883218
/object-parts/update	2	\N	\N	\N	1762883218	1762883218
/object-parts/delete	2	\N	\N	\N	1762883218	1762883218
/object-parts/*	2	\N	\N	\N	1762883218	1762883218
/objects/index	2	\N	\N	\N	1762883218	1762883218
/objects/view	2	\N	\N	\N	1762883218	1762883218
/objects/create	2	\N	\N	\N	1762883218	1762883218
/objects/update	2	\N	\N	\N	1762883218	1762883218
/objects/delete	2	\N	\N	\N	1762883218	1762883218
/objects/*	2	\N	\N	\N	1762883218	1762883218
/projects/index	2	\N	\N	\N	1762883218	1762883218
/projects/view	2	\N	\N	\N	1762883218	1762883218
/projects/create	2	\N	\N	\N	1762883218	1762883218
/projects/update	2	\N	\N	\N	1762883218	1762883218
/projects/delete	2	\N	\N	\N	1762883218	1762883218
/projects/*	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/index	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/view	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/create	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/update	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/delete	2	\N	\N	\N	1762883218	1762883218
/resource-catalog/*	2	\N	\N	\N	1762883218	1762883218
/site/error	2	\N	\N	\N	1762883218	1762883218
/site/captcha	2	\N	\N	\N	1762883218	1762883218
/site/index	2	\N	\N	\N	1762883218	1762883218
/site/login	2	\N	\N	\N	1762883218	1762883218
/site/logout	2	\N	\N	\N	1762883218	1762883218
/site/contact	2	\N	\N	\N	1762883218	1762883218
/site/about	2	\N	\N	\N	1762883218	1762883218
/site/*	2	\N	\N	\N	1762883218	1762883218
/units/index	2	\N	\N	\N	1762883218	1762883218
/units/view	2	\N	\N	\N	1762883218	1762883218
/units/create	2	\N	\N	\N	1762883218	1762883218
/units/update	2	\N	\N	\N	1762883218	1762883218
/units/delete	2	\N	\N	\N	1762883218	1762883218
/units/*	2	\N	\N	\N	1762883218	1762883218
/work-categories/index	2	\N	\N	\N	1762883218	1762883218
/work-categories/view	2	\N	\N	\N	1762883218	1762883218
/work-categories/create	2	\N	\N	\N	1762883218	1762883218
/work-categories/update	2	\N	\N	\N	1762883218	1762883218
/work-categories/delete	2	\N	\N	\N	1762883218	1762883218
/work-categories/*	2	\N	\N	\N	1762883218	1762883218
/work-resources/index	2	\N	\N	\N	1762883218	1762883218
/work-resources/view	2	\N	\N	\N	1762883218	1762883218
/work-resources/create	2	\N	\N	\N	1762883218	1762883218
/work-resources/update	2	\N	\N	\N	1762883218	1762883218
/work-resources/delete	2	\N	\N	\N	1762883218	1762883218
/work-resources/*	2	\N	\N	\N	1762883218	1762883218
/works/index	2	\N	\N	\N	1762883218	1762883218
/works/view	2	\N	\N	\N	1762883218	1762883218
/works/create	2	\N	\N	\N	1762883218	1762883218
/works/update	2	\N	\N	\N	1762883218	1762883218
/works/delete	2	\N	\N	\N	1762883218	1762883218
/works/*	2	\N	\N	\N	1762883218	1762883218
/*	2	\N	\N	\N	1762883218	1762883218
forsuperadmin	2	\N	\N	\N	1762883208	1762883252
PTO	1	\N	\N	\N	1763798233	1763798233
/smeta/index	2	\N	\N	\N	1763798280	1763798280
/smeta/import	2	\N	\N	\N	1763798280	1763798280
/smeta/view	2	\N	\N	\N	1763798280	1763798280
/smeta/*	2	\N	\N	\N	1763798280	1763798280
/user/index	2	\N	\N	\N	1763798280	1763798280
/user/view	2	\N	\N	\N	1763798280	1763798280
/user/create	2	\N	\N	\N	1763798280	1763798280
/user/update	2	\N	\N	\N	1763798280	1763798280
/user/delete	2	\N	\N	\N	1763798280	1763798280
/user/*	2	\N	\N	\N	1763798280	1763798280
PRORAB	1	\N	\N	\N	1763798311	1763798311
\.


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

COPY public.auth_item_child (parent, child) FROM stdin;
forsuperadmin	/*
forsuperadmin	/admin/*
forsuperadmin	/admin/assignment/*
forsuperadmin	/admin/assignment/assign
forsuperadmin	/admin/assignment/index
forsuperadmin	/admin/assignment/revoke
forsuperadmin	/admin/assignment/view
forsuperadmin	/admin/default/*
forsuperadmin	/admin/default/index
forsuperadmin	/admin/menu/*
forsuperadmin	/admin/menu/create
forsuperadmin	/admin/menu/delete
forsuperadmin	/admin/menu/index
forsuperadmin	/admin/menu/update
forsuperadmin	/admin/menu/view
forsuperadmin	/admin/permission/*
forsuperadmin	/admin/permission/assign
forsuperadmin	/admin/permission/create
forsuperadmin	/admin/permission/delete
forsuperadmin	/admin/permission/get-users
forsuperadmin	/admin/permission/index
forsuperadmin	/admin/permission/remove
forsuperadmin	/admin/permission/update
forsuperadmin	/admin/permission/view
forsuperadmin	/admin/role/*
forsuperadmin	/admin/role/assign
forsuperadmin	/admin/role/create
forsuperadmin	/admin/role/delete
forsuperadmin	/admin/role/get-users
forsuperadmin	/admin/role/index
forsuperadmin	/admin/role/remove
forsuperadmin	/admin/role/update
forsuperadmin	/admin/role/view
forsuperadmin	/admin/route/*
forsuperadmin	/admin/route/assign
forsuperadmin	/admin/route/create
forsuperadmin	/admin/route/index
forsuperadmin	/admin/route/refresh
forsuperadmin	/admin/route/remove
forsuperadmin	/admin/rule/*
forsuperadmin	/admin/rule/create
forsuperadmin	/admin/rule/delete
forsuperadmin	/admin/rule/index
forsuperadmin	/admin/rule/update
forsuperadmin	/admin/rule/view
forsuperadmin	/admin/user/*
forsuperadmin	/admin/user/activate
forsuperadmin	/admin/user/change-password
forsuperadmin	/admin/user/delete
forsuperadmin	/admin/user/index
forsuperadmin	/admin/user/login
forsuperadmin	/admin/user/logout
forsuperadmin	/admin/user/request-password-reset
forsuperadmin	/admin/user/reset-password
forsuperadmin	/admin/user/signup
forsuperadmin	/admin/user/view
forsuperadmin	/customer/*
forsuperadmin	/customer/create
forsuperadmin	/customer/delete
forsuperadmin	/customer/index
forsuperadmin	/customer/update
forsuperadmin	/customer/view
forsuperadmin	/debug/*
forsuperadmin	/debug/default/*
forsuperadmin	/debug/default/db-explain
forsuperadmin	/debug/default/download-mail
forsuperadmin	/debug/default/index
forsuperadmin	/debug/default/toolbar
forsuperadmin	/debug/default/view
forsuperadmin	/debug/user/*
forsuperadmin	/debug/user/reset-identity
forsuperadmin	/debug/user/set-identity
forsuperadmin	/gii/*
forsuperadmin	/gii/default/*
forsuperadmin	/gii/default/action
forsuperadmin	/gii/default/diff
forsuperadmin	/gii/default/index
forsuperadmin	/gii/default/preview
forsuperadmin	/gii/default/view
forsuperadmin	/object-members/*
forsuperadmin	/object-members/create
forsuperadmin	/object-members/delete
forsuperadmin	/object-members/index
forsuperadmin	/object-members/update
forsuperadmin	/object-members/view
forsuperadmin	/object-parts/*
forsuperadmin	/object-parts/create
forsuperadmin	/object-parts/delete
forsuperadmin	/object-parts/index
forsuperadmin	/object-parts/update
forsuperadmin	/object-parts/view
forsuperadmin	/objects/*
forsuperadmin	/objects/create
forsuperadmin	/objects/delete
forsuperadmin	/objects/index
forsuperadmin	/objects/update
forsuperadmin	/objects/view
forsuperadmin	/projects/*
forsuperadmin	/projects/create
forsuperadmin	/projects/delete
forsuperadmin	/projects/index
forsuperadmin	/projects/update
forsuperadmin	/projects/view
forsuperadmin	/resource-catalog/*
forsuperadmin	/resource-catalog/create
forsuperadmin	/resource-catalog/delete
forsuperadmin	/resource-catalog/index
forsuperadmin	/resource-catalog/update
forsuperadmin	/resource-catalog/view
forsuperadmin	/site/*
forsuperadmin	/site/about
forsuperadmin	/site/captcha
forsuperadmin	/site/contact
forsuperadmin	/site/error
forsuperadmin	/site/index
forsuperadmin	/site/login
forsuperadmin	/site/logout
forsuperadmin	/units/*
forsuperadmin	/units/create
forsuperadmin	/units/delete
forsuperadmin	/units/index
forsuperadmin	/units/update
forsuperadmin	/units/view
forsuperadmin	/work-categories/*
forsuperadmin	/work-categories/create
forsuperadmin	/work-categories/delete
forsuperadmin	/work-categories/index
forsuperadmin	/work-categories/update
forsuperadmin	/work-categories/view
forsuperadmin	/work-resources/*
forsuperadmin	/work-resources/create
forsuperadmin	/work-resources/delete
forsuperadmin	/work-resources/index
forsuperadmin	/work-resources/update
forsuperadmin	/work-resources/view
forsuperadmin	/works/*
forsuperadmin	/works/create
forsuperadmin	/works/delete
forsuperadmin	/works/index
forsuperadmin	/works/update
forsuperadmin	/works/view
superadmin	forsuperadmin
superadmin	/*
superadmin	/admin/*
superadmin	/admin/assignment/*
superadmin	/admin/assignment/assign
superadmin	/admin/assignment/index
superadmin	/admin/assignment/revoke
superadmin	/admin/assignment/view
superadmin	/admin/default/*
superadmin	/admin/default/index
superadmin	/admin/menu/*
superadmin	/admin/menu/create
superadmin	/admin/menu/delete
superadmin	/admin/menu/index
superadmin	/admin/menu/update
superadmin	/admin/menu/view
superadmin	/admin/permission/*
superadmin	/admin/permission/assign
superadmin	/admin/permission/create
superadmin	/admin/permission/delete
superadmin	/admin/permission/get-users
superadmin	/admin/permission/index
superadmin	/admin/permission/remove
superadmin	/admin/permission/update
superadmin	/admin/permission/view
superadmin	/admin/role/*
superadmin	/admin/role/assign
superadmin	/admin/role/create
superadmin	/admin/role/delete
superadmin	/admin/role/get-users
superadmin	/admin/role/index
superadmin	/admin/role/remove
superadmin	/admin/role/update
superadmin	/admin/role/view
superadmin	/admin/route/*
superadmin	/admin/route/assign
superadmin	/admin/route/create
superadmin	/admin/route/index
superadmin	/admin/route/refresh
superadmin	/admin/route/remove
superadmin	/admin/rule/*
superadmin	/admin/rule/create
superadmin	/admin/rule/delete
superadmin	/admin/rule/index
superadmin	/admin/rule/update
superadmin	/admin/rule/view
superadmin	/admin/user/*
superadmin	/admin/user/activate
superadmin	/admin/user/change-password
superadmin	/admin/user/delete
superadmin	/admin/user/index
superadmin	/admin/user/login
superadmin	/admin/user/logout
superadmin	/admin/user/request-password-reset
superadmin	/admin/user/reset-password
superadmin	/admin/user/signup
superadmin	/admin/user/view
superadmin	/customer/*
superadmin	/customer/create
superadmin	/customer/delete
superadmin	/customer/index
superadmin	/customer/update
superadmin	/customer/view
superadmin	/debug/*
superadmin	/debug/default/*
superadmin	/debug/default/db-explain
superadmin	/debug/default/download-mail
superadmin	/debug/default/index
superadmin	/debug/default/toolbar
superadmin	/debug/default/view
superadmin	/debug/user/*
superadmin	/debug/user/reset-identity
superadmin	/debug/user/set-identity
superadmin	/gii/*
superadmin	/gii/default/*
superadmin	/gii/default/action
superadmin	/gii/default/diff
superadmin	/gii/default/index
superadmin	/gii/default/preview
superadmin	/gii/default/view
superadmin	/object-members/*
superadmin	/object-members/create
superadmin	/object-members/delete
superadmin	/object-members/index
superadmin	/object-members/update
superadmin	/object-members/view
superadmin	/object-parts/*
superadmin	/object-parts/create
superadmin	/object-parts/delete
superadmin	/object-parts/index
superadmin	/object-parts/update
superadmin	/object-parts/view
superadmin	/objects/*
superadmin	/objects/create
superadmin	/objects/delete
superadmin	/objects/index
superadmin	/objects/update
superadmin	/objects/view
superadmin	/projects/*
superadmin	/projects/create
superadmin	/projects/delete
superadmin	/projects/index
superadmin	/projects/update
superadmin	/projects/view
superadmin	/resource-catalog/*
superadmin	/resource-catalog/create
superadmin	/resource-catalog/delete
superadmin	/resource-catalog/index
superadmin	/resource-catalog/update
superadmin	/resource-catalog/view
superadmin	/site/*
superadmin	/site/about
superadmin	/site/captcha
superadmin	/site/contact
superadmin	/site/error
superadmin	/site/index
superadmin	/site/login
superadmin	/site/logout
superadmin	/units/*
superadmin	/units/create
superadmin	/units/delete
superadmin	/units/index
superadmin	/units/update
superadmin	/units/view
superadmin	/work-categories/*
superadmin	/work-categories/create
superadmin	/work-categories/delete
superadmin	/work-categories/index
superadmin	/work-categories/update
superadmin	/work-categories/view
superadmin	/work-resources/*
superadmin	/work-resources/create
superadmin	/work-resources/delete
superadmin	/work-resources/index
superadmin	/work-resources/update
superadmin	/work-resources/view
superadmin	/works/*
superadmin	/works/create
superadmin	/works/delete
superadmin	/works/index
superadmin	/works/update
superadmin	/works/view
PTO	/*
PTO	/admin/*
PTO	/admin/assignment/*
PTO	/admin/assignment/assign
PTO	/admin/assignment/index
PTO	/admin/assignment/revoke
PTO	/admin/assignment/view
PTO	/admin/default/*
PTO	/admin/default/index
PTO	/admin/menu/*
PTO	/admin/menu/create
PTO	/admin/menu/delete
PTO	/admin/menu/index
PTO	/admin/menu/update
PTO	/admin/menu/view
PTO	/admin/permission/*
PTO	/admin/permission/assign
PTO	/admin/permission/create
PTO	/admin/permission/delete
PTO	/admin/permission/get-users
PTO	/admin/permission/index
PTO	/admin/permission/remove
PTO	/admin/permission/update
PTO	/admin/permission/view
PTO	/admin/role/*
PTO	/admin/role/assign
PTO	/admin/role/create
PTO	/admin/role/delete
PTO	/admin/role/get-users
PTO	/admin/role/index
PTO	/admin/role/remove
PTO	/admin/role/update
PTO	/admin/role/view
PTO	/admin/route/*
PTO	/admin/route/assign
PTO	/admin/route/create
PTO	/admin/route/index
PTO	/admin/route/refresh
PTO	/admin/route/remove
PTO	/admin/rule/*
PTO	/admin/rule/create
PTO	/admin/rule/delete
PTO	/admin/rule/index
PTO	/admin/rule/update
PTO	/admin/rule/view
PTO	/admin/user/*
PTO	/admin/user/activate
PTO	/admin/user/change-password
PTO	/admin/user/delete
PTO	/admin/user/index
PTO	/admin/user/login
PTO	/admin/user/logout
PTO	/admin/user/request-password-reset
PTO	/admin/user/reset-password
PTO	/admin/user/signup
PTO	/admin/user/view
PTO	/customer/*
PTO	/customer/create
PTO	/customer/delete
PTO	/customer/index
PTO	/customer/update
PTO	/customer/view
PTO	/debug/*
PTO	/debug/default/*
PTO	/debug/default/db-explain
PTO	/debug/default/download-mail
PTO	/debug/default/index
PTO	/debug/default/toolbar
PTO	/debug/default/view
PTO	/debug/user/*
PTO	/debug/user/reset-identity
PTO	/debug/user/set-identity
PTO	/gii/*
PTO	/gii/default/*
PTO	/gii/default/action
PTO	/gii/default/diff
PTO	/gii/default/index
PTO	/gii/default/preview
PTO	/gii/default/view
PTO	/object-members/*
PTO	/object-members/create
PTO	/object-members/delete
PTO	/object-members/index
PTO	/object-members/update
PTO	/object-members/view
PTO	/object-parts/*
PTO	/object-parts/create
PTO	/object-parts/delete
PTO	/object-parts/index
PTO	/object-parts/update
PTO	/object-parts/view
PTO	/objects/*
PTO	/objects/create
PTO	/objects/delete
PTO	/objects/index
PTO	/objects/update
PTO	/objects/view
PTO	/projects/*
PTO	/projects/create
PTO	/projects/delete
PTO	/projects/index
PTO	/projects/update
PTO	/projects/view
PTO	/resource-catalog/*
PTO	/resource-catalog/create
PTO	/resource-catalog/delete
PTO	/resource-catalog/index
PTO	/resource-catalog/update
PTO	/resource-catalog/view
PTO	/site/*
PTO	/site/about
PTO	/site/captcha
PTO	/site/contact
PTO	/site/error
PTO	/site/index
PTO	/site/login
PTO	/site/logout
PTO	/units/*
PTO	/units/create
PTO	/units/delete
PTO	/units/index
PTO	/units/update
PTO	/units/view
PTO	/work-categories/*
PTO	/work-categories/create
PTO	/work-categories/delete
PTO	/work-categories/index
PTO	/work-categories/update
PTO	/work-categories/view
PTO	/work-resources/*
PTO	/work-resources/create
PTO	/work-resources/delete
PTO	/work-resources/index
PTO	/work-resources/update
PTO	/work-resources/view
PTO	/works/*
PTO	/works/create
PTO	/works/delete
PTO	/works/index
PTO	/works/update
PTO	/works/view
PRORAB	/*
PRORAB	/admin/*
PRORAB	/admin/assignment/*
PRORAB	/admin/assignment/assign
PRORAB	/admin/assignment/index
PRORAB	/admin/assignment/revoke
PRORAB	/admin/assignment/view
PRORAB	/admin/default/*
PRORAB	/admin/default/index
PRORAB	/admin/menu/*
PRORAB	/admin/menu/create
PRORAB	/admin/menu/delete
PRORAB	/admin/menu/index
PRORAB	/admin/menu/update
PRORAB	/admin/menu/view
PRORAB	/admin/permission/*
PRORAB	/admin/permission/assign
PRORAB	/admin/permission/create
PRORAB	/admin/permission/delete
PRORAB	/admin/permission/get-users
PRORAB	/admin/permission/index
PRORAB	/admin/permission/remove
PRORAB	/admin/permission/update
PRORAB	/admin/permission/view
PRORAB	/admin/role/*
PRORAB	/admin/role/assign
PRORAB	/admin/role/create
PRORAB	/admin/role/delete
PRORAB	/admin/role/get-users
PRORAB	/admin/role/index
PRORAB	/admin/role/remove
PRORAB	/admin/role/update
PRORAB	/admin/role/view
PRORAB	/admin/route/*
PRORAB	/admin/route/assign
PRORAB	/admin/route/create
PRORAB	/admin/route/index
PRORAB	/admin/route/refresh
PRORAB	/admin/route/remove
PRORAB	/admin/rule/*
PRORAB	/admin/rule/create
PRORAB	/admin/rule/delete
PRORAB	/admin/rule/index
PRORAB	/admin/rule/update
PRORAB	/admin/rule/view
PRORAB	/admin/user/*
PRORAB	/admin/user/activate
PRORAB	/admin/user/change-password
PRORAB	/admin/user/delete
PRORAB	/admin/user/index
PRORAB	/admin/user/login
PRORAB	/admin/user/logout
PRORAB	/admin/user/request-password-reset
PRORAB	/admin/user/reset-password
PRORAB	/admin/user/signup
PRORAB	/admin/user/view
PRORAB	/customer/*
PRORAB	/customer/create
PRORAB	/customer/delete
PRORAB	/customer/index
PRORAB	/customer/update
PRORAB	/customer/view
PRORAB	/debug/*
PRORAB	/debug/default/*
PRORAB	/debug/default/db-explain
PRORAB	/debug/default/download-mail
PRORAB	/debug/default/index
PRORAB	/debug/default/toolbar
PRORAB	/debug/default/view
PRORAB	/debug/user/*
PRORAB	/debug/user/reset-identity
PRORAB	/debug/user/set-identity
PRORAB	/gii/*
PRORAB	/gii/default/*
PRORAB	/gii/default/action
PRORAB	/gii/default/diff
PRORAB	/gii/default/index
PRORAB	/gii/default/preview
PRORAB	/gii/default/view
PRORAB	/object-members/*
PRORAB	/object-members/create
PRORAB	/object-members/delete
PRORAB	/object-members/index
PRORAB	/object-members/update
PRORAB	/object-members/view
PRORAB	/object-parts/*
PRORAB	/object-parts/create
PRORAB	/object-parts/delete
PRORAB	/object-parts/index
PRORAB	/object-parts/update
PRORAB	/object-parts/view
PRORAB	/objects/*
PRORAB	/objects/create
PRORAB	/objects/delete
PRORAB	/objects/index
PRORAB	/objects/update
PRORAB	/objects/view
PRORAB	/projects/*
PRORAB	/projects/create
PRORAB	/projects/delete
PRORAB	/projects/index
PRORAB	/projects/update
PRORAB	/projects/view
PRORAB	/resource-catalog/*
PRORAB	/resource-catalog/create
PRORAB	/resource-catalog/delete
PRORAB	/resource-catalog/index
PRORAB	/resource-catalog/update
PRORAB	/resource-catalog/view
PRORAB	/site/*
PRORAB	/site/about
PRORAB	/site/captcha
PRORAB	/site/contact
PRORAB	/site/error
PRORAB	/site/index
PRORAB	/site/login
PRORAB	/site/logout
PRORAB	/smeta/*
PRORAB	/smeta/import
PRORAB	/smeta/index
PRORAB	/smeta/view
PRORAB	/units/*
PRORAB	/units/create
PRORAB	/units/delete
PRORAB	/units/index
PRORAB	/units/update
PRORAB	/units/view
PRORAB	/user/*
PRORAB	/user/create
PRORAB	/user/delete
PRORAB	/user/index
PRORAB	/user/update
PRORAB	/user/view
PRORAB	/work-categories/*
PRORAB	/work-categories/create
PRORAB	/work-categories/delete
PRORAB	/work-categories/index
PRORAB	/work-categories/update
PRORAB	/work-categories/view
PRORAB	/work-resources/*
PRORAB	/work-resources/create
PRORAB	/work-resources/delete
PRORAB	/work-resources/index
PRORAB	/work-resources/update
PRORAB	/work-resources/view
PRORAB	/works/*
PRORAB	/works/create
PRORAB	/works/delete
PRORAB	/works/index
PRORAB	/works/update
PRORAB	/works/view
\.


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

COPY public.auth_rule (name, data, created_at, updated_at) FROM stdin;
\.


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

COPY public.customers (id, name, inn, phone, address, status, notes, created_at, updated_at) FROM stdin;
5	sherzod	1233232132	+998977006043	law street	active	test\r\n	2025-11-11 22:58:51	2025-11-11 22:58:51
\.


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

COPY public.migration (version, apply_time) FROM stdin;
m000000_000000_base	1762583658
m251108_074520_create_customers_table	1762589164
m251108_081321_create_projects_table	1762589877
m251108_082111_create_objects_table	1762590194
m251104_164724_create_user_table	1762610996
m251108_064021_insert_admin_user	1762610996
m251108_104347_add_admin_to	1762610996
m140506_102106_rbac_init	1762611964
m170907_052038_rbac_add_index_on_auth_assignment_user_id	1762611964
m180523_151638_rbac_updates_indexes_without_prefix	1762611964
m200409_110543_rbac_update_mssql_trigger	1762611964
m251108_145030_create_object_parts_table	1762613465
m251108_145337_create_work_categories_table	1762613654
m251108_145547_create_units_table	1762613782
m251108_145708_create_object_members_table	1762614194
m251108_152243_create_works_table	1762615457
m251108_152600_create_work_schedules_table	1762615707
m251108_150833_create_resource_catalog_table	1762615902
m251108_153248_create_work_resources_table	1762616202
m251110_142053_add_column_user_projects_table	1762882258
m251111_181845_add_status_column_to_works_table	1762885169
m251111_182116_add_source_type_column_to_works_table	1762885317
\.


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

COPY public.object_members (id, user_id, object_id, role_key, assigned_at) FROM stdin;
\.


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

COPY public.object_parts (id, object_id, name, status, start_date, end_date, created_at, updated_at) FROM stdin;
1	1	1-qavat	planned	2025-11-12	2025-11-12	2025-11-12 11:02:12	2025-11-12 11:02:12
16	1	test	planned	2025-11-22	2025-11-22	2025-11-22 13:57:20	2025-11-22 13:57:20
17	1	test2	planned	2025-11-22	2025-11-22	2025-11-22 18:23:42	2025-11-22 18:23:42
\.


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

COPY public.objects (id, project_id, name, start_date, end_date, status, created_at, updated_at) FROM stdin;
1	1	helton	2025-11-11	2025-11-11	planned	2025-11-11 23:00:02	2025-11-11 23:00:02
2	1	nestone	2025-11-11	2025-11-11	planned	2025-11-11 23:00:28	2025-11-11 23:00:28
\.


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

COPY public.projects (id, name, customer_id, address, start_date, end_date, status, created_at, updated_at, user_id) FROM stdin;
1	Tashkent city	5	zargar ko`chasi	2025-11-11	2025-11-11	planned	2025-11-11 22:59:30	2025-11-11 22:59:30	2
\.


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

COPY public.resource_catalog (id, code, name, name_sku, resource_type, unit_id, description, is_active, created_at, updated_at) FROM stdin;
830	res_6921b8f938403	ЗАТРАТЫ ТРУДА РАБОЧИХ-СТРОИТЕЛЕЙ	\N	MEHNAT	216	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
831	res_6921b8f93ad75	ЛЕБЕДКИ ЭЛЕКТРИЧЕСКИЕ, ТЯГОВЫМ УСИЛИЕМ 19,62 (2) КН (Т)	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
832	res_6921b8f93b7b3	ПОДЪЕМНИКИ МАЧТОВЫЕ СТРОИТЕЛЬНЫЕ 0,5 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
833	res_6921b8f93ba5f	МОЛОТКИ ОТБОЙНЫЕ ЭЛЕКТРИЧЕСКИЕ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
834	res_6921b8f93c55f	ДРЕЛИ ЭЛЕКТРИЧЕСКИЕ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
835	res_6921b8f93c743	БЕНЗОПИЛЫ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
836	res_6921b8f93c90d	АВТОМОБИЛИ БОРТОВЫЕ ГРУЗОПОДЪЕМНОСТЬЮ ДО 5 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
837	res_6921b8f93ce77	КОМПРЕССОРЫ ПЕРЕДВИЖНЫЕ С ДВИГАТЕЛЕМ ВНУТРЕННЕГО СГОРАНИЯ ДАВЛЕНИЕМ ДО 686 КПА (7 АТМ) 5 М3/МИН	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
838	res_6921b8f93d051	МОЛОТКИ ОТБОЙНЫЕ ПНЕВМАТИЧЕСКИЕ ПРИ РАБОТЕ ОТ ПЕРЕДВИЖНЫХ КОМПРЕССОРНЫХ СТАНЦИЙ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
839	res_6921b8f93dbb6	КРАНЫ НА АВТОМОБИЛЬНОМ ХОДУ ПРИ РАБОТЕ НА ДРУГИХ ВИДАХ СТРОИТЕЛЬСТВА (КРОМЕ МАГИСТРАЛЬНЫХ ТРУБОПРОВОДОВ) 10 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
840	res_6921b8f93dd9c	УСТАНОВКИ ДЛЯ СВАРКИ РУЧНОЙ ДУГОВОЙ (ПОСТОЯННОГО ТОКА)	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
841	res_6921b8f93f2ac	АППАРАТЫ ДЛЯ ГАЗОВОЙ СВАРКИ И РЕЗКИ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
842	res_6921b8f93f46e	КИСЛОРОД ТЕХНИЧЕСКИЙ ГАЗООБРАЗНЫЙ	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
843	res_6921b8f93f648	АЦЕТИЛЕН ГАЗООБРАЗНЫЙ ТЕХНИЧЕСКИЙ	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
844	res_6921b8f93fbf8	КРАНЫ НА ГУСЕНИЧНОМ ХОДУ ПРИ РАБОТЕ НА ДРУГИХ ВИДАХ СТРОИТЕЛЬСТВА (КРОМЕ МАГИСТРАЛЬНЫХ ТРУБОПРОВОДОВ) 25 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
845	res_6921b8f93fdc2	ТЯГАЧИ СЕДЕЛЬНЫЕ 15 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
846	res_6921b8f940170	ПОЛУПРИЦЕПЫ-ТЯЖЕЛОВОЗЫ 40 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
847	res_6921b8f94076a	КРАНЫ НА ГУСЕНИЧНОМ ХОДУ ПРИ РАБОТЕ НА ДРУГИХ ВИДАХ СТРОИТЕЛЬСТВА (КРОМЕ МАГИСТРАЛЬНЫХ ТРУБОПРОВОДОВ) ДО 16 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
848	res_6921b8f94093b	МОЛОТКИ ОТБОЙНЫЕ ПНЕВМАТИЧЕСКИЕ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
849	res_6921b8f942dae	ЭКСКАВАТОРЫ ОДНОКОВШОВЫЕ ДИЗЕЛЬНЫЕ НА ГУСЕНИЧНОМ ХОДУ ПРИ РАБОТЕ НА ДРУГИХ ВИДАХ СТРОИТЕЛЬСТВА (КРОМЕ ВОДОХОЗЯЙСТВЕННОГО) 0,65 М3	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
850	res_6921b8f94322e	АВТОМОБИЛИ-САМОСВАЛЫ ГРУЗОПОДЪЕМНОСТЬЮ ДО 10 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
851	res_6921b8f943a7a	ПРЕОБРАЗОВАТЕЛИ СВАРОЧНЫЕ С НОМИНАЛЬНЫМ СВАРОЧНЫМ ТОКОМ 315-500 А	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
852	res_6921b8f943eee	БОЛТЫ СТРОИТЕЛЬНЫЕ С ГАЙКАМИ И ШАЙБАМИ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
853	res_6921b8f9440b0	ГВОЗДИ СТРОИТЕЛЬНЫЕ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
854	res_6921b8f94425b	ГРУНТОВКА ГФ-021 КРАСНО-КОРИЧНЕВАЯ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
855	res_6921b8f94440d	РАСТВОРИТЕЛЬ МАРКИ Р-4	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
856	res_6921b8f9445ba	КАТАНКА ГОРЯЧЕКАТАНАЯ В МОТКАХ ДИАМЕТРОМ 6,3-6,5 ММ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
857	res_6921b8f944764	ШВЕЛЛЕРЫ N 40 СТАЛЬ МАРКИ СТ0	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
858	res_6921b8f9449fe	ЭЛЕКТРОДЫ ДИАМЕТРОМ 4 ММ Э42	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
859	res_6921b8f944ba3	КАНАТЫ ПЕНЬКОВЫЕ ПРОПИТАННЫЕ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
860	res_6921b8f944d4d	ПИЛОМАТЕРИАЛЫ ХВОЙНЫХ ПОРОД БРУСКИ ОБРЕЗНЫЕ ДЛИНОЙ 4-6,5 М, ШИРИНОЙ 75-150 ММ, ТОЛЩИНОЙ 40-75 ММ I СОРТА	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
861	res_6921b8f944f9b	ПРОПАН-БУТАН, СМЕСЬ ТЕХНИЧЕСКАЯ	\N	MATERIAL	223	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
862	res_6921b8f945149	ОТДЕЛЬНЫЕ КОНСТРУКТИВНЫЕ ЭЛЕМЕНТЫ ЗДАНИЙ И СООРУЖЕНИЙ С ПРЕОБЛАДАНИЕМ ГОРЯЧЕКАТАНЫХ ПРОФИЛЕЙ, СРЕДНЯЯ МАССА СБОРОЧНОЙ ЕДИНИЦЫ СВЫШЕ 01 ДО 05 Т	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
863	res_6921b8f945393	КАНАТ ДВОЙНОЙ СВИВКИ, ТИПА ТК, КОНСТРУКЦИИ 6Х19(1+6+12)+1 ОС ОЦИНКОВАННЫЙ, ИЗ ПРОВОЛОК МАРКИ В, МАРКИРОВОЧНАЯ ГРУППА 1770 Н/ММ2, ДИАМЕТРОМ, ММ: 5,5	\N	MATERIAL	224	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
864	res_6921b8f9487a0	ЭЛЕКТРОДЫ ДИАМЕТРОМ 6 ММ Э42	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
865	res_6921b8f948975	КОНСТРУКТИВНЫЕ ЭЛЕМЕНТЫ ВСПОМОГАТЕЛЬНОГО НАЗНАЧЕНИЯ, С ПРЕОБЛАДАНИЕМ ПРОФИЛЬНОГО ПРОКАТА СОБИРАЕМЫЕ ИЗ ДВУХ И БОЛЕЕ ДЕТАЛЕЙ, С ОТВЕРСТИЯМИ И БЕЗ ОТВЕРСТИЙ, СОЕДИНЯЕМЫЕ НА СВАРКЕ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
866	res_6921b8f9495f2	МАШИНЫ ШЛИФОВАЛЬНЫЕ ЭЛЕКТРИЧЕСКИЕ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
867	res_6921b8f9498b2	ПЕЧИ ЭЛЕКТРИЧЕСКИЕ ДЛЯ СУШКИ СВАРОЧНЫХ МАТЕРИАЛОВ С РЕГУЛИРОВАНИЕМ ТЕМПЕРАТУРЫ В ПРЕДЕЛАХ 80-500 ГР С	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
868	res_6921b8f949b61	ЭЛЕКТРОДЫ ДИАМЕТРОМ 4 ММ Э46	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
869	res_6921b8f949d17	ШЛИФКРУГИ	\N	MATERIAL	220	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
870	res_6921b8f94a21b	АВТОПОГРУЗЧИКИ 5 Т	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
871	res_6921b8f94a3cc	ЛЕБЕДКИ ЭЛЕКТРИЧЕСКИЕ, ТЯГОВЫМ УСИЛИЕМ ДО 5,79 (0,59) КН (Т)	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
872	res_6921b8f94a6fc	АГРЕГАТЫ ОКРАСОЧНЫЕ ВЫСОКОГО ДАВЛЕНИЯ ДЛЯ ОКРАСКИ ПОВЕРХНОСТЕЙ КОНСТРУКЦИЙ МОЩНОСТЬЮ 1 КВТ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
873	res_6921b8f94aa4d	КСИЛОЛ НЕФТЯНОЙ МАРКИ А	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
874	res_6921b8f94bb9b	ЭМАЛЬ ПФ-115 СЕРАЯ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
875	res_6921b8f94bea1	УАЙТ-СПИРИТ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
876	res_6921b8f94cfa5	КИРПИЧ ГЛИНЯНЫЙ ОБЫКНОВЕННЫЙ	\N	MATERIAL	226	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
877	res_6921b8f94d174	РАСТВОР ГОТОВЫЙ КЛАДОЧНЫЙ ТЯЖЕЛЫЙ ЦЕМЕНТНО-ИЗВЕСТКОВЫЙ, МАРКА: 50	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
878	res_6921b8f94e61e	РАСТВОР ГОТОВЫЙ ОТДЕЛОЧНЫЙ ТЯЖЕЛЫЙ, ЦЕМЕНТНЫЙ: 1:3	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
879	res_6921b8f94e9e7	ПРОПАН-БУТАН	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
880	res_6921b8f94ed74	ЩИТЫ ИЗ ДОСОК ТОЛЩИНОЙ 25 ММ	\N	MATERIAL	227	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
881	res_6921b8f94f8b0	ВОДА	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
882	res_6921b8f950606	ВИБРАТОРЫ ПОВЕРХНОСТНЫЕ	\N	TEXNIKA	217	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
883	res_6921b8f950e53	РАСТВОР ГОТОВЫЙ КЛАДОЧНЫЙ ТЯЖЕЛЫЙ ЦЕМЕНТНО-ИЗВЕСТКОВЫЙ, МАРКА: 25	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
884	res_6921b8f95111d	ИЗВЕСТЬ СТРОИТЕЛЬНАЯ НЕГАШЕНАЯ КОМОВАЯ, СОРТ 1	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
885	res_6921b8f9513c6	ПРОВОЛОКА СВЕТЛАЯ ДИАМЕТРОМ 1,1 ММ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
886	res_6921b8f95166d	ПИЛОМАТЕРИАЛЫ ХВОЙНЫХ ПОРОД ДОСКИ ОБРЕЗНЫЕ ДЛИНОЙ 4-6,5 М, ШИРИНОЙ 75-150 ММ, ТОЛЩИНОЙ 44 ММ И БОЛЕЕ II СОРТА	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
887	res_6921b8f95182c	БЕТОН ТЯЖЕЛЫЙ, КЛАСС В 7,5 (М100)	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
888	res_6921b8f952bf0	ПИЛОМАТЕРИАЛЫ ХВОЙНЫХ ПОРОД БРУСЬЯ ОБРЕЗНЫЕ ДЛИНОЙ 4-6,5 М, ШИРИНОЙ 75-150 ММ, ТОЛЩИНОЙ 100, 125 ММ I СОРТА	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
889	res_6921b8f95378c	ДЕТАЛИ ДЕРЕВЯННЫЕ ЛЕСОВ	\N	MATERIAL	218	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
890	res_6921b8f953948	ЩИТЫ НАСТИЛА ПО ПРОЕКТНЫМ ДАННЫМ	\N	MATERIAL	227	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
891	res_6921b8f953b01	ДЕТАЛИ ЛЕСОВ СТАЛЬНЫЕ	\N	MATERIAL	222	\N	t	2025-11-22 18:22:01	2025-11-22 18:22:01
\.


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

COPY public.units (id, name) FROM stdin;
215	100М2
216	ЧЕЛ-Ч
217	МАШ-Ч
218	М3
219	100ШТ
220	ШТ
221	100Т
222	Т
223	КГ
224	10М
225	10Т
226	1000ШТ
227	М2
228	100 М2
\.


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

COPY public.work_categories (id, code, name_uz, name_ru, name_en, parent_id, shnk_code, description, sort_order, is_active, created_at, updated_at) FROM stdin;
1	1	beton ishlari	\N	\N	\N	1	\N	100	t	2025-11-12 11:36:59	2025-11-12 11:36:59
\.


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

COPY public.work_resources (id, work_id, number, resource_id, unit_id, norm_work_unit, qty_total, unit_price, total_price, created_at, updated_at, object_id, code) FROM stdin;
5421	640	1.1	830	216	14.380000	311.758400	26481.40	8255799.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5422	640	1.2	831	217	6.220000	134.849600	1200.00	161820.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000977
5423	640	3.1	830	216	14.380000	311.758400	26481.40	8255799.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5424	640	3.2	831	217	6.220000	134.849600	1200.00	161820.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000977
5425	641	2.1	830	216	126.560000	2743.820800	26481.40	72660216.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5426	641	2.2	832	217	1.800000	39.024000	2600.00	101462.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001522
5427	641	2.3	833	217	53.760000	1165.516800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002831
5428	642	4.1	830	216	15.900000	20.193000	26481.40	534739.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5429	642	4.2	831	217	4.600000	5.842000	1200.00	7010.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000977
5430	643	5.1	830	216	18.000000	27.000000	26481.40	714998.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5431	643	5.2	834	217	0.184000	0.276000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000521
5432	643	5.3	835	217	0.264000	0.396000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001556
5433	643	5.4	836	217	0.288000	0.432000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5434	644	6.1	830	216	8.240000	836.360000	26481.40	22147984.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5435	644	6.2	837	217	1.150000	116.725000	120000.00	14007000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5436	644	6.3	838	217	2.300000	233.450000	2100.00	490245.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5437	644	12.1	830	216	8.240000	1400.800000	26481.40	37095145.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5438	644	12.2	837	217	1.150000	195.500000	120000.00	23460000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5439	644	12.3	838	217	2.300000	391.000000	2100.00	821100.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5440	644	39.1	830	216	8.240000	571.032000	26481.40	15121727.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5441	644	39.2	837	217	1.150000	79.695000	120000.00	9563400.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5442	644	39.3	838	217	2.300000	159.390000	2100.00	334719.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5443	645	7.1	830	216	232.800000	41.904000	26481.40	1109677.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5444	645	7.2	839	217	40.128000	7.223040	160000.00	1155686.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5445	645	7.3	840	217	5.568000	1.002240	2100.00	2105.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5446	645	7.4	836	217	1.744000	0.313920	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5447	645	10.1	830	216	232.800000	293.328000	26481.40	7767736.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5448	645	10.2	839	217	40.128000	50.561280	160000.00	8089805.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5449	645	10.3	840	217	5.568000	7.015680	2100.00	14733.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5450	645	10.4	836	217	1.744000	2.197440	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5451	647	9.1	830	216	233.600000	4.672000	26481.40	123721.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5452	647	9.2	839	217	65.800000	1.316000	160000.00	210560.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5453	647	9.3	840	217	7.616000	0.152320	2100.00	320.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5454	647	9.4	836	217	0.840000	0.016800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5455	648	13.1	830	216	34.700000	3678.200000	26481.40	97403885.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5456	648	13.2	837	217	15.890000	1684.340000	120000.00	202120800.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5457	648	13.3	838	217	31.780000	3368.680000	2100.00	7074228.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5458	648	13.4	841	217	2.440000	258.640000	1200.00	310368.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5459	648	13.5	842	218	2.000000	212.000000	3200.00	678400.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5460	648	13.6	843	218	0.260000	27.560000	50000.00	1378000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034350
5461	649	14.1	830	216	577.600000	40.432000	26481.40	1070696.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5462	649	14.2	844	217	106.312000	7.441840	160000.00	1190694.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000786
5463	649	14.3	845	217	13.480000	0.943600	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001905
5464	649	14.4	840	217	39.224000	2.745680	2100.00	5766.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5465	649	14.5	836	217	0.600000	0.042000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5466	649	14.6	846	217	13.480000	0.943600	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002643
5467	650	15.1	830	216	646.570000	77.588400	26481.40	2054649.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5468	650	15.2	837	217	38.060000	4.567200	120000.00	548064.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5469	650	15.3	847	217	100.230000	12.027600	160000.00	1924416.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000783
5470	650	15.4	848	217	38.060000	4.567200	1200.00	5481.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001199
5471	650	19.1	830	216	646.570000	213.368100	26481.40	5650286.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5472	650	19.2	837	217	38.060000	12.559800	120000.00	1507176.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5473	650	19.3	847	217	100.230000	33.075900	160000.00	5292144.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000783
5474	650	19.4	848	217	38.060000	12.559800	1200.00	15072.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001199
5475	651	16.1	830	216	71.400000	8.568000	26481.40	226893.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5476	651	16.2	847	217	42.720000	5.126400	160000.00	820224.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000783
5477	651	20.1	830	216	71.400000	23.562000	26481.40	623955.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5478	651	20.2	847	217	42.720000	14.097600	160000.00	2255616.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000783
5479	652	17.1	830	216	12.160000	1502.976000	26481.40	39800909.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5480	652	17.2	837	217	3.540000	437.544000	120000.00	52505280.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5481	652	17.3	838	217	7.080000	875.088000	2100.00	1837685.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5482	652	17.4	841	217	2.440000	301.584000	1200.00	361901.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5483	652	17.5	842	218	2.000000	247.200000	3200.00	791040.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5484	652	17.6	843	218	0.260000	32.136000	50000.00	1606800.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034350
5485	653	18.1	830	216	34.700000	5076.610000	26481.40	134435740.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5486	653	18.2	837	217	15.890000	2324.707000	120000.00	278964840.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5487	653	18.3	838	217	31.780000	4649.414000	2100.00	9763769.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5488	653	18.4	841	217	2.440000	356.972000	1200.00	428366.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5489	653	18.5	842	218	2.000000	292.600000	3200.00	936320.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5490	653	18.6	843	218	0.260000	38.038000	50000.00	1901900.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034350
5491	654	21.1	830	216	214.320000	306.477600	26481.40	8115956.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5492	655	22.1	849	217	0.024000	3.432000	140000.00	480480.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002264
5493	656	23.1	850	217	0.126400	18.075200	65000.00	1174888.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000163
5494	657	24.1	830	216	72.772000	715.421532	26481.40	18945364.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5495	657	24.2	839	217	0.125000	1.228875	160000.00	196620.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5496	657	24.3	839	217	0.150000	1.474650	160000.00	235944.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5497	657	24.4	844	217	4.500000	44.239500	160000.00	7078320.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000786
5498	657	24.5	851	217	0.125000	1.228875	2100.00	2581.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001513
5499	657	24.6	836	217	0.237500	2.334863	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5500	657	24.7	841	217	1.825000	17.941575	1200.00	21530.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5501	657	24.8	852	222	0.021000	0.206451	18000000.00	3716118.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030322
5502	657	24.9	853	222	0.000010	0.000098	12000000.00	1176.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030407
5503	657	24.10	854	222	0.000310	0.003048	14500000.00	44190.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031419
5504	657	24.11	855	222	0.000600	0.005899	12000000.00	70783.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031524
5505	657	24.12	856	222	0.000030	0.000295	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	032524
5506	657	24.13	857	222	0.001940	0.019072	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	033816
5507	657	24.14	842	218	1.200000	11.797200	3200.00	37751.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5508	657	24.15	858	222	0.000440	0.004326	16000000.00	69210.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035310
5509	657	24.16	859	222	0.000100	0.000983	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035504
5510	657	24.17	860	218	0.001030	0.010126	3960000.00	40099.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	036023
5511	657	24.18	861	223	0.360000	3.539160	3600.00	12741.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	045077
5512	657	24.19	862	222	0.000200	0.001966	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	050756
5513	657	24.20	863	224	0.018700	0.183840	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	096384
5514	657	29.1	830	216	72.772000	282.209816	26481.40	7473311.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5515	657	29.2	839	217	0.125000	0.484750	160000.00	77560.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5516	657	29.3	839	217	0.150000	0.581700	160000.00	93072.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5517	657	29.4	844	217	4.500000	17.451000	160000.00	2792160.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000786
5518	657	29.5	851	217	0.125000	0.484750	2100.00	1018.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001513
5519	657	29.6	836	217	0.237500	0.921025	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5520	657	29.7	841	217	1.825000	7.077350	1200.00	8493.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5521	657	29.8	852	222	0.021000	0.081438	18000000.00	1465884.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030322
5522	657	29.9	853	222	0.000010	0.000039	12000000.00	468.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030407
5523	657	29.10	854	222	0.000310	0.001202	14500000.00	17432.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031419
5524	657	29.11	855	222	0.000600	0.002327	12000000.00	27922.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031524
5525	657	29.12	856	222	0.000030	0.000116	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	032524
5526	657	29.13	857	222	0.001940	0.007523	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	033816
5527	657	29.14	842	218	1.200000	4.653600	3200.00	14892.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5528	657	29.15	858	222	0.000440	0.001706	16000000.00	27301.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035310
5529	657	29.16	859	222	0.000100	0.000388	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035504
5530	657	29.17	860	218	0.001030	0.003994	3960000.00	15818.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	036023
5531	657	29.18	861	223	0.360000	1.396080	3600.00	5026.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	045077
5532	657	29.19	862	222	0.000200	0.000776	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	050756
5533	657	29.20	863	224	0.018700	0.072519	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	096384
5534	657	33.1	830	216	72.772000	70.734384	26481.40	1873146.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5535	657	33.2	839	217	0.125000	0.121500	160000.00	19440.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5536	657	33.3	839	217	0.150000	0.145800	160000.00	23328.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5537	657	33.4	844	217	4.500000	4.374000	160000.00	699840.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000786
5538	657	33.5	851	217	0.125000	0.121500	2100.00	255.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001513
5539	657	33.6	836	217	0.237500	0.230850	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5540	657	33.7	841	217	1.825000	1.773900	1200.00	2129.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5541	657	33.8	852	222	0.021000	0.020412	18000000.00	367416.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030322
5542	657	33.9	853	222	0.000010	0.000010	12000000.00	120.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030407
5543	657	33.10	854	222	0.000310	0.000301	14500000.00	4369.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031419
5544	657	33.11	855	222	0.000600	0.000583	12000000.00	6998.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031524
5545	657	33.12	856	222	0.000030	0.000029	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	032524
5546	657	33.13	857	222	0.001940	0.001886	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	033816
5547	657	33.14	842	218	1.200000	1.166400	3200.00	3732.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5548	657	33.15	858	222	0.000440	0.000428	16000000.00	6843.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035310
5549	657	33.16	859	222	0.000100	0.000097	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035504
5550	657	33.17	860	218	0.001030	0.001001	3960000.00	3965.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	036023
5551	657	33.18	861	223	0.360000	0.349920	3600.00	1260.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	045077
5552	657	33.19	862	222	0.000200	0.000194	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	050756
5553	657	33.20	863	224	0.018700	0.018176	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	096384
5554	661	28.1	830	216	49.105000	21.900830	26481.40	579965.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5555	661	28.2	840	217	26.562500	11.846875	2100.00	24878.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5556	661	28.3	836	217	1.287500	0.574225	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5557	661	28.4	864	222	0.040000	0.017840	16000000.00	285440.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035326
5558	661	28.5	865	222	1.000000	0.446000	12600000.00	5619600.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	050777
5559	665	36.1	830	216	41.158500	60.424794	26481.40	1600133.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5560	665	36.2	866	217	1.000000	1.468100	1200.00	1762.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001147
5561	665	36.3	851	217	41.612500	61.091311	2100.00	128292.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001513
5562	665	36.4	867	217	4.375000	6.422938	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002346
5563	665	36.5	836	217	0.025000	0.036703	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5564	665	36.6	868	222	0.042000	0.061660	16000000.00	986563.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035312
5565	665	36.7	869	220	0.200000	0.293620	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	044897
5566	666	37.1	830	216	6.106500	31.377334	26481.40	830916.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5567	666	37.2	870	217	0.012500	0.064229	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000112
5568	666	37.3	871	217	0.012500	0.064229	1200.00	77.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000975
5569	666	37.4	836	217	0.012500	0.064229	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5570	666	37.5	872	217	1.400000	7.193690	1200.00	8632.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002515
5571	666	37.6	854	222	0.012000	0.061660	14500000.00	894073.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031419
5572	666	37.7	873	222	0.002000	0.010277	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034288
5573	666	61.1	830	216	6.106500	66.221329	26481.40	1753633.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5574	666	61.2	870	217	0.012500	0.135555	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000112
5575	666	61.3	871	217	0.012500	0.135555	1200.00	163.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000975
5576	666	61.4	836	217	0.012500	0.135555	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5577	666	61.5	872	217	1.400000	15.182160	1200.00	18219.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002515
5578	666	61.6	854	222	0.012000	0.130133	14500000.00	1886926.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031419
5579	666	61.7	873	222	0.002000	0.021689	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034288
5580	667	38.1	830	216	8.809000	45.263725	26481.40	1198647.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5581	667	38.2	870	217	0.025000	0.128459	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000112
5582	667	38.3	871	217	0.025000	0.128459	1200.00	154.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000975
5583	667	38.4	836	217	0.025000	0.128459	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5584	667	38.5	872	217	1.625000	8.349819	1200.00	10020.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002515
5585	667	38.6	874	222	0.038000	0.195257	26500000.00	5174318.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031795
5586	667	38.7	875	222	0.002800	0.014387	12000000.00	172649.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034035
5587	667	62.1	830	216	8.809000	95.528320	26481.40	2529724.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5588	667	62.2	870	217	0.025000	0.271110	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000112
5589	667	62.3	871	217	0.025000	0.271110	1200.00	325.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000975
5590	667	62.4	836	217	0.025000	0.271110	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5591	667	62.5	872	217	1.625000	17.622150	1200.00	21147.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002515
5592	667	62.6	874	222	0.038000	0.412087	26500000.00	10920311.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	031795
5593	667	62.7	875	222	0.002800	0.030364	12000000.00	364372.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034035
5594	668	40.1	830	216	22.820000	138.905340	26481.40	3678408.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5595	669	41.1	830	216	14.630000	330.784300	26481.40	8759631.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5596	669	41.2	831	217	0.320000	7.235200	1200.00	8682.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000977
5597	669	41.3	876	226	0.400000	9.044000	800000.00	7235200.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	009900
5598	669	41.4	877	218	0.240000	5.426400	320000.00	1736448.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	012221
5599	670	42.1	830	216	73.289500	2.345264	26481.40	62106.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5600	670	42.2	839	217	0.287500	0.009200	160000.00	1472.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5601	670	42.3	836	217	0.387500	0.012400	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5602	672	44.1	830	216	22.820000	1229.998000	26481.40	32572069.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5603	673	45.1	830	216	195.630000	3545.206860	26481.40	93882041.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5604	673	45.2	834	217	1.650000	29.901300	1200.00	35882.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000521
5605	673	45.3	839	217	5.120000	92.784640	160000.00	14845542.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5606	673	45.4	840	217	37.060000	671.601320	2100.00	1410363.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5607	673	45.5	836	217	1.330000	24.102260	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5608	673	45.6	841	217	1.900000	34.431800	1200.00	41318.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5609	673	45.7	878	218	0.030000	0.543660	320000.00	173971.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	012217
5610	673	45.8	852	222	0.006000	0.108732	18000000.00	1957176.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030322
5611	673	45.9	842	218	1.830000	33.163260	3200.00	106122.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5612	673	45.10	879	218	0.230000	4.168060	3600.00	15005.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034326
5613	673	45.11	864	222	0.035000	0.634270	16000000.00	10148320.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035326
5614	673	45.12	880	227	5.800000	105.107600	50000.00	5255380.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051619
5615	676	49.1	830	216	35.730000	1925.847000	26481.40	50999125.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5616	676	49.2	871	217	0.100000	5.390000	1200.00	6468.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000975
5617	676	49.3	881	218	0.010000	0.539000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	009210
5618	677	50.1	830	216	127.110000	6851.229000	26481.40	181430136.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5619	677	50.2	832	217	1.920000	103.488000	2600.00	269069.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001522
5620	677	50.3	881	218	1.050000	56.595000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	009210
5621	679	52.1	830	216	41.620000	366.256000	26481.40	9698972.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5622	679	52.2	882	217	1.590000	13.992000	1200.00	16790.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000404
5623	679	52.3	837	217	0.730000	6.424000	120000.00	770880.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000660
5624	679	52.4	839	217	0.310000	2.728000	160000.00	436480.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5625	679	52.5	838	217	1.460000	12.848000	2100.00	26981.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001159
5626	679	52.6	832	217	0.330000	2.904000	2600.00	7550.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	001522
5627	679	52.7	840	217	3.460000	30.448000	2100.00	63941.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002016
5628	679	52.8	836	217	0.460000	4.048000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5629	679	52.9	881	218	0.206000	1.812800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	009219
5630	679	52.10	883	218	0.020000	0.176000	270000.00	47520.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	012120
5631	679	52.11	853	222	0.003200	0.028160	12000000.00	337920.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030407
5632	679	52.12	884	222	0.002300	0.020240	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030652
5633	679	52.13	856	222	0.000100	0.000880	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	032524
5634	679	52.14	885	222	0.000200	0.001760	10000000.00	17600.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	032543
5635	679	52.15	858	222	0.002800	0.024640	16000000.00	394240.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	035310
5636	679	52.16	886	218	0.100000	0.880000	3960000.00	3484800.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	036060
5637	679	52.17	887	218	1.030000	9.064000	360000.00	3263040.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	045021
5638	679	52.18	880	227	3.280000	28.864000	50000.00	1443200.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051619
5639	683	57.1	830	216	202.930000	6287.583120	26481.40	166504004.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5640	683	57.2	834	217	5.600000	173.510400	1200.00	208212.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000521
5641	683	57.3	839	217	0.760000	23.547840	160000.00	3767654.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000762
5642	683	57.4	836	217	0.200000	6.196800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002509
5643	683	57.5	841	217	1.830000	56.700720	1200.00	68041.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002577
5644	683	57.6	852	222	0.050000	1.549200	18000000.00	27885600.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	030322
5645	683	57.7	842	218	1.770000	54.841680	3200.00	175493.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034241
5646	683	57.8	879	218	0.230000	7.126320	3600.00	25655.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	034326
5647	683	57.9	888	218	0.170000	5.267280	3960000.00	20858429.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	036027
5648	683	57.10	880	227	14.400000	446.169600	50000.00	22308480.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051619
5649	686	63.1	830	216	80.730000	2163.564000	26481.40	57294204.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5650	686	63.2	836	217	0.225000	6.030000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5651	686	63.3	889	218	0.008000	0.214400	3600000.00	771840.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	044082
5652	686	63.4	890	227	5.500000	147.400000	50000.00	7370000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051622
5653	686	63.5	891	222	0.029000	0.777200	6000000.00	4663200.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	063944
5654	687	64.1	830	216	114.540000	3069.672000	26481.40	81289212.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5655	687	64.2	836	217	0.275000	7.370000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5656	687	64.3	889	218	0.016000	0.428800	3600000.00	1543680.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	044082
5657	687	64.4	890	227	2.800000	75.040000	50000.00	3752000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051622
5658	687	64.5	891	222	0.058000	1.554400	6000000.00	9326400.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	063944
5659	688	65.1	830	216	50.025000	1340.670000	26481.40	35502819.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	000001
5660	688	65.2	836	217	0.087500	2.345000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	002499
5661	688	65.3	889	218	0.009000	0.241200	3600000.00	868320.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	044082
5662	688	65.4	890	227	3.400000	91.120000	50000.00	4556000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	051622
5663	688	65.5	891	222	0.035000	0.938000	6000000.00	5628000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	1	063944
5664	689	1.1	830	216	14.380000	311.758400	26481.40	8255799.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5665	689	1.2	831	217	6.220000	134.849600	1200.00	161820.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000977
5666	689	3.1	830	216	14.380000	311.758400	26481.40	8255799.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5667	689	3.2	831	217	6.220000	134.849600	1200.00	161820.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000977
5668	690	2.1	830	216	126.560000	2743.820800	26481.40	72660216.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5669	690	2.2	832	217	1.800000	39.024000	2600.00	101462.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001522
5670	690	2.3	833	217	53.760000	1165.516800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002831
5671	691	4.1	830	216	15.900000	20.193000	26481.40	534739.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5672	691	4.2	831	217	4.600000	5.842000	1200.00	7010.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000977
5673	692	5.1	830	216	18.000000	27.000000	26481.40	714998.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5674	692	5.2	834	217	0.184000	0.276000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000521
5675	692	5.3	835	217	0.264000	0.396000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001556
5676	692	5.4	836	217	0.288000	0.432000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5677	693	6.1	830	216	8.240000	836.360000	26481.40	22147984.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5678	693	6.2	837	217	1.150000	116.725000	120000.00	14007000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5679	693	6.3	838	217	2.300000	233.450000	2100.00	490245.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5680	693	12.1	830	216	8.240000	1400.800000	26481.40	37095145.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5681	693	12.2	837	217	1.150000	195.500000	120000.00	23460000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5682	693	12.3	838	217	2.300000	391.000000	2100.00	821100.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5683	693	39.1	830	216	8.240000	571.032000	26481.40	15121727.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5684	693	39.2	837	217	1.150000	79.695000	120000.00	9563400.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5685	693	39.3	838	217	2.300000	159.390000	2100.00	334719.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5686	694	7.1	830	216	232.800000	41.904000	26481.40	1109677.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5687	694	7.2	839	217	40.128000	7.223040	160000.00	1155686.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5688	694	7.3	840	217	5.568000	1.002240	2100.00	2105.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5689	694	7.4	836	217	1.744000	0.313920	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5690	694	10.1	830	216	232.800000	293.328000	26481.40	7767736.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5691	694	10.2	839	217	40.128000	50.561280	160000.00	8089805.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5692	694	10.3	840	217	5.568000	7.015680	2100.00	14733.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5693	694	10.4	836	217	1.744000	2.197440	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5694	696	9.1	830	216	233.600000	4.672000	26481.40	123721.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5695	696	9.2	839	217	65.800000	1.316000	160000.00	210560.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5696	696	9.3	840	217	7.616000	0.152320	2100.00	320.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5697	696	9.4	836	217	0.840000	0.016800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5698	697	13.1	830	216	34.700000	3678.200000	26481.40	97403885.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5699	697	13.2	837	217	15.890000	1684.340000	120000.00	202120800.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5700	697	13.3	838	217	31.780000	3368.680000	2100.00	7074228.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5701	697	13.4	841	217	2.440000	258.640000	1200.00	310368.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5702	697	13.5	842	218	2.000000	212.000000	3200.00	678400.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5703	697	13.6	843	218	0.260000	27.560000	50000.00	1378000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034350
5704	698	14.1	830	216	577.600000	40.432000	26481.40	1070696.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5705	698	14.2	844	217	106.312000	7.441840	160000.00	1190694.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000786
5706	698	14.3	845	217	13.480000	0.943600	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001905
5707	698	14.4	840	217	39.224000	2.745680	2100.00	5766.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5708	698	14.5	836	217	0.600000	0.042000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5709	698	14.6	846	217	13.480000	0.943600	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002643
5710	699	15.1	830	216	646.570000	77.588400	26481.40	2054649.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5711	699	15.2	837	217	38.060000	4.567200	120000.00	548064.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5712	699	15.3	847	217	100.230000	12.027600	160000.00	1924416.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000783
5713	699	15.4	848	217	38.060000	4.567200	1200.00	5481.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001199
5714	699	19.1	830	216	646.570000	213.368100	26481.40	5650286.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5715	699	19.2	837	217	38.060000	12.559800	120000.00	1507176.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5716	699	19.3	847	217	100.230000	33.075900	160000.00	5292144.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000783
5717	699	19.4	848	217	38.060000	12.559800	1200.00	15072.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001199
5718	700	16.1	830	216	71.400000	8.568000	26481.40	226893.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5719	700	16.2	847	217	42.720000	5.126400	160000.00	820224.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000783
5720	700	20.1	830	216	71.400000	23.562000	26481.40	623955.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5721	700	20.2	847	217	42.720000	14.097600	160000.00	2255616.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000783
5722	701	17.1	830	216	12.160000	1502.976000	26481.40	39800909.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5723	701	17.2	837	217	3.540000	437.544000	120000.00	52505280.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5724	701	17.3	838	217	7.080000	875.088000	2100.00	1837685.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5725	701	17.4	841	217	2.440000	301.584000	1200.00	361901.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5726	701	17.5	842	218	2.000000	247.200000	3200.00	791040.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5727	701	17.6	843	218	0.260000	32.136000	50000.00	1606800.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034350
5728	702	18.1	830	216	34.700000	5076.610000	26481.40	134435740.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5729	702	18.2	837	217	15.890000	2324.707000	120000.00	278964840.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5730	702	18.3	838	217	31.780000	4649.414000	2100.00	9763769.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5731	702	18.4	841	217	2.440000	356.972000	1200.00	428366.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5732	702	18.5	842	218	2.000000	292.600000	3200.00	936320.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5733	702	18.6	843	218	0.260000	38.038000	50000.00	1901900.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034350
5734	703	21.1	830	216	214.320000	306.477600	26481.40	8115956.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5735	704	22.1	849	217	0.024000	3.432000	140000.00	480480.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002264
5736	705	23.1	850	217	0.126400	18.075200	65000.00	1174888.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000163
5737	706	24.1	830	216	72.772000	715.421532	26481.40	18945364.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5738	706	24.2	839	217	0.125000	1.228875	160000.00	196620.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5739	706	24.3	839	217	0.150000	1.474650	160000.00	235944.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5740	706	24.4	844	217	4.500000	44.239500	160000.00	7078320.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000786
5741	706	24.5	851	217	0.125000	1.228875	2100.00	2581.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001513
5742	706	24.6	836	217	0.237500	2.334863	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5743	706	24.7	841	217	1.825000	17.941575	1200.00	21530.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5744	706	24.8	852	222	0.021000	0.206451	18000000.00	3716118.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030322
5745	706	24.9	853	222	0.000010	0.000098	12000000.00	1176.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030407
5746	706	24.10	854	222	0.000310	0.003048	14500000.00	44190.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031419
5747	706	24.11	855	222	0.000600	0.005899	12000000.00	70783.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031524
5748	706	24.12	856	222	0.000030	0.000295	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	032524
5749	706	24.13	857	222	0.001940	0.019072	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	033816
5750	706	24.14	842	218	1.200000	11.797200	3200.00	37751.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5751	706	24.15	858	222	0.000440	0.004326	16000000.00	69210.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035310
5752	706	24.16	859	222	0.000100	0.000983	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035504
5753	706	24.17	860	218	0.001030	0.010126	3960000.00	40099.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	036023
5754	706	24.18	861	223	0.360000	3.539160	3600.00	12741.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	045077
5755	706	24.19	862	222	0.000200	0.001966	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	050756
5756	706	24.20	863	224	0.018700	0.183840	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	096384
5757	706	29.1	830	216	72.772000	282.209816	26481.40	7473311.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5758	706	29.2	839	217	0.125000	0.484750	160000.00	77560.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5759	706	29.3	839	217	0.150000	0.581700	160000.00	93072.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5760	706	29.4	844	217	4.500000	17.451000	160000.00	2792160.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000786
5761	706	29.5	851	217	0.125000	0.484750	2100.00	1018.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001513
5762	706	29.6	836	217	0.237500	0.921025	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5763	706	29.7	841	217	1.825000	7.077350	1200.00	8493.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5764	706	29.8	852	222	0.021000	0.081438	18000000.00	1465884.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030322
5765	706	29.9	853	222	0.000010	0.000039	12000000.00	468.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030407
5766	706	29.10	854	222	0.000310	0.001202	14500000.00	17432.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031419
5767	706	29.11	855	222	0.000600	0.002327	12000000.00	27922.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031524
5768	706	29.12	856	222	0.000030	0.000116	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	032524
5769	706	29.13	857	222	0.001940	0.007523	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	033816
5770	706	29.14	842	218	1.200000	4.653600	3200.00	14892.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5771	706	29.15	858	222	0.000440	0.001706	16000000.00	27301.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035310
5772	706	29.16	859	222	0.000100	0.000388	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035504
5773	706	29.17	860	218	0.001030	0.003994	3960000.00	15818.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	036023
5774	706	29.18	861	223	0.360000	1.396080	3600.00	5026.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	045077
5775	706	29.19	862	222	0.000200	0.000776	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	050756
5776	706	29.20	863	224	0.018700	0.072519	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	096384
5777	706	33.1	830	216	72.772000	70.734384	26481.40	1873146.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5778	706	33.2	839	217	0.125000	0.121500	160000.00	19440.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5779	706	33.3	839	217	0.150000	0.145800	160000.00	23328.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5780	706	33.4	844	217	4.500000	4.374000	160000.00	699840.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000786
5781	706	33.5	851	217	0.125000	0.121500	2100.00	255.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001513
5782	706	33.6	836	217	0.237500	0.230850	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5783	706	33.7	841	217	1.825000	1.773900	1200.00	2129.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5784	706	33.8	852	222	0.021000	0.020412	18000000.00	367416.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030322
5785	706	33.9	853	222	0.000010	0.000010	12000000.00	120.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030407
5786	706	33.10	854	222	0.000310	0.000301	14500000.00	4369.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031419
5787	706	33.11	855	222	0.000600	0.000583	12000000.00	6998.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031524
5788	706	33.12	856	222	0.000030	0.000029	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	032524
5789	706	33.13	857	222	0.001940	0.001886	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	033816
5790	706	33.14	842	218	1.200000	1.166400	3200.00	3732.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5791	706	33.15	858	222	0.000440	0.000428	16000000.00	6843.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035310
5792	706	33.16	859	222	0.000100	0.000097	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035504
5793	706	33.17	860	218	0.001030	0.001001	3960000.00	3965.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	036023
5794	706	33.18	861	223	0.360000	0.349920	3600.00	1260.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	045077
5795	706	33.19	862	222	0.000200	0.000194	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	050756
5796	706	33.20	863	224	0.018700	0.018176	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	096384
5797	710	28.1	830	216	49.105000	21.900830	26481.40	579965.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5798	710	28.2	840	217	26.562500	11.846875	2100.00	24878.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5799	710	28.3	836	217	1.287500	0.574225	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5800	710	28.4	864	222	0.040000	0.017840	16000000.00	285440.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035326
5801	710	28.5	865	222	1.000000	0.446000	12600000.00	5619600.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	050777
5802	714	36.1	830	216	41.158500	60.424794	26481.40	1600133.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5803	714	36.2	866	217	1.000000	1.468100	1200.00	1762.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001147
5804	714	36.3	851	217	41.612500	61.091311	2100.00	128292.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001513
5805	714	36.4	867	217	4.375000	6.422938	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002346
5806	714	36.5	836	217	0.025000	0.036703	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5807	714	36.6	868	222	0.042000	0.061660	16000000.00	986563.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035312
5808	714	36.7	869	220	0.200000	0.293620	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	044897
5809	715	37.1	830	216	6.106500	31.377334	26481.40	830916.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5810	715	37.2	870	217	0.012500	0.064229	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000112
5811	715	37.3	871	217	0.012500	0.064229	1200.00	77.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000975
5812	715	37.4	836	217	0.012500	0.064229	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5813	715	37.5	872	217	1.400000	7.193690	1200.00	8632.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002515
5814	715	37.6	854	222	0.012000	0.061660	14500000.00	894073.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031419
5815	715	37.7	873	222	0.002000	0.010277	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034288
5816	715	61.1	830	216	6.106500	66.221329	26481.40	1753633.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5817	715	61.2	870	217	0.012500	0.135555	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000112
5818	715	61.3	871	217	0.012500	0.135555	1200.00	163.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000975
5819	715	61.4	836	217	0.012500	0.135555	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5820	715	61.5	872	217	1.400000	15.182160	1200.00	18219.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002515
5821	715	61.6	854	222	0.012000	0.130133	14500000.00	1886926.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031419
5822	715	61.7	873	222	0.002000	0.021689	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034288
5823	716	38.1	830	216	8.809000	45.263725	26481.40	1198647.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5824	716	38.2	870	217	0.025000	0.128459	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000112
5825	716	38.3	871	217	0.025000	0.128459	1200.00	154.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000975
5826	716	38.4	836	217	0.025000	0.128459	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5827	716	38.5	872	217	1.625000	8.349819	1200.00	10020.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002515
5828	716	38.6	874	222	0.038000	0.195257	26500000.00	5174318.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031795
5829	716	38.7	875	222	0.002800	0.014387	12000000.00	172649.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034035
5830	716	62.1	830	216	8.809000	95.528320	26481.40	2529724.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5831	716	62.2	870	217	0.025000	0.271110	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000112
5832	716	62.3	871	217	0.025000	0.271110	1200.00	325.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000975
5833	716	62.4	836	217	0.025000	0.271110	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5834	716	62.5	872	217	1.625000	17.622150	1200.00	21147.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002515
5835	716	62.6	874	222	0.038000	0.412087	26500000.00	10920311.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	031795
5836	716	62.7	875	222	0.002800	0.030364	12000000.00	364372.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034035
5837	717	40.1	830	216	22.820000	138.905340	26481.40	3678408.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5838	718	41.1	830	216	14.630000	330.784300	26481.40	8759631.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5839	718	41.2	831	217	0.320000	7.235200	1200.00	8682.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000977
5840	718	41.3	876	226	0.400000	9.044000	800000.00	7235200.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	009900
5841	718	41.4	877	218	0.240000	5.426400	320000.00	1736448.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	012221
5842	719	42.1	830	216	73.289500	2.345264	26481.40	62106.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5843	719	42.2	839	217	0.287500	0.009200	160000.00	1472.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5844	719	42.3	836	217	0.387500	0.012400	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5845	721	44.1	830	216	22.820000	1229.998000	26481.40	32572069.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5846	722	45.1	830	216	195.630000	3545.206860	26481.40	93882041.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5847	722	45.2	834	217	1.650000	29.901300	1200.00	35882.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000521
5848	722	45.3	839	217	5.120000	92.784640	160000.00	14845542.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5849	722	45.4	840	217	37.060000	671.601320	2100.00	1410363.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5850	722	45.5	836	217	1.330000	24.102260	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5851	722	45.6	841	217	1.900000	34.431800	1200.00	41318.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5852	722	45.7	878	218	0.030000	0.543660	320000.00	173971.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	012217
5853	722	45.8	852	222	0.006000	0.108732	18000000.00	1957176.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030322
5854	722	45.9	842	218	1.830000	33.163260	3200.00	106122.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5855	722	45.10	879	218	0.230000	4.168060	3600.00	15005.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034326
5856	722	45.11	864	222	0.035000	0.634270	16000000.00	10148320.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035326
5857	722	45.12	880	227	5.800000	105.107600	50000.00	5255380.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051619
5858	725	49.1	830	216	35.730000	1925.847000	26481.40	50999125.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5859	725	49.2	871	217	0.100000	5.390000	1200.00	6468.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000975
5860	725	49.3	881	218	0.010000	0.539000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	009210
5861	726	50.1	830	216	127.110000	6851.229000	26481.40	181430136.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5862	726	50.2	832	217	1.920000	103.488000	2600.00	269069.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001522
5863	726	50.3	881	218	1.050000	56.595000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	009210
5864	728	52.1	830	216	41.620000	366.256000	26481.40	9698972.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5865	728	52.2	882	217	1.590000	13.992000	1200.00	16790.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000404
5866	728	52.3	837	217	0.730000	6.424000	120000.00	770880.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000660
5867	728	52.4	839	217	0.310000	2.728000	160000.00	436480.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5868	728	52.5	838	217	1.460000	12.848000	2100.00	26981.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001159
5869	728	52.6	832	217	0.330000	2.904000	2600.00	7550.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	001522
5870	728	52.7	840	217	3.460000	30.448000	2100.00	63941.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002016
5871	728	52.8	836	217	0.460000	4.048000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5872	728	52.9	881	218	0.206000	1.812800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	009219
5873	728	52.10	883	218	0.020000	0.176000	270000.00	47520.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	012120
5874	728	52.11	853	222	0.003200	0.028160	12000000.00	337920.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030407
5875	728	52.12	884	222	0.002300	0.020240	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030652
5876	728	52.13	856	222	0.000100	0.000880	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	032524
5877	728	52.14	885	222	0.000200	0.001760	10000000.00	17600.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	032543
5878	728	52.15	858	222	0.002800	0.024640	16000000.00	394240.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	035310
5879	728	52.16	886	218	0.100000	0.880000	3960000.00	3484800.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	036060
5880	728	52.17	887	218	1.030000	9.064000	360000.00	3263040.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	045021
5881	728	52.18	880	227	3.280000	28.864000	50000.00	1443200.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051619
5882	732	57.1	830	216	202.930000	6287.583120	26481.40	166504004.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5883	732	57.2	834	217	5.600000	173.510400	1200.00	208212.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000521
5884	732	57.3	839	217	0.760000	23.547840	160000.00	3767654.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000762
5885	732	57.4	836	217	0.200000	6.196800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002509
5886	732	57.5	841	217	1.830000	56.700720	1200.00	68041.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002577
5887	732	57.6	852	222	0.050000	1.549200	18000000.00	27885600.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	030322
5888	732	57.7	842	218	1.770000	54.841680	3200.00	175493.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034241
5889	732	57.8	879	218	0.230000	7.126320	3600.00	25655.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	034326
5890	732	57.9	888	218	0.170000	5.267280	3960000.00	20858429.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	036027
5891	732	57.10	880	227	14.400000	446.169600	50000.00	22308480.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051619
5892	735	63.1	830	216	80.730000	2163.564000	26481.40	57294204.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5893	735	63.2	836	217	0.225000	6.030000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5894	735	63.3	889	218	0.008000	0.214400	3600000.00	771840.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	044082
5895	735	63.4	890	227	5.500000	147.400000	50000.00	7370000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051622
5896	735	63.5	891	222	0.029000	0.777200	6000000.00	4663200.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	063944
5897	736	64.1	830	216	114.540000	3069.672000	26481.40	81289212.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5898	736	64.2	836	217	0.275000	7.370000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5899	736	64.3	889	218	0.016000	0.428800	3600000.00	1543680.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	044082
5900	736	64.4	890	227	2.800000	75.040000	50000.00	3752000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051622
5901	736	64.5	891	222	0.058000	1.554400	6000000.00	9326400.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	063944
5902	737	65.1	830	216	50.025000	1340.670000	26481.40	35502819.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	000001
5903	737	65.2	836	217	0.087500	2.345000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	002499
5904	737	65.3	889	218	0.009000	0.241200	3600000.00	868320.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	044082
5905	737	65.4	890	227	3.400000	91.120000	50000.00	4556000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	051622
5906	737	65.5	891	222	0.035000	0.938000	6000000.00	5628000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	1	063944
\.


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

COPY public.work_schedules (id, work_id, planned_start, planned_end, fact_start, fact_end, done_percent, done_quantity, status, note, created_at, updated_at, object_id) FROM stdin;
\.


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

COPY public.works (id, object_part_id, number, code, name, unit_id, qty_units, unit_price, total_price, created_at, updated_at, name_uzbek, work_category_id, object_id, status, source_type) FROM stdin;
640	16	1	E46-4-8-1	РАЗБОРКА ПОКРЫТИЙ КРОВЕЛЬ ИЗ РУЛОННЫХ МАТЕРИАЛОВ	215	21.6800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
641	16	2	E57-2-11 ШHКДОП5	РАЗБОРКА ПОКРЫТИЙ ПОЛОВ: ЦЕМЕНТНЫХ /ПЕНОБЕТОННЫХ/	215	21.6800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
642	16	4	E46-4-8-4	РАЗБОРКА ПОКРЫТИЙ КРОВЕЛЬ ИЗ ВОЛНИСТЫХ И ПОЛУВОЛНИСТЫХ АСБЕСТОЦЕМЕНТНЫХ ЛИСТОВ	215	1.2700	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
643	16	5	E10-1-10-1 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ЭЛЕМЕНТОВ КАРКАСА ИЗ БРУСЬЕВ ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	218	1.5000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
644	16	6	E46-4-1-4	РАЗБОРКА СТЕН КИРПИЧНЫХ	218	101.5000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
645	16	7	E7-5-11-2 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ПАНЕЛЕЙ ПЕРЕКРЫТИЙ С ОПИРАНИЕМ ПО КОНТУРУ ПЛОЩАДЬЮ ДО 15 М2 ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.1800	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
646	16	8	ВЗ-П	ВОЗВРАТ ПАНЕЛЕЙ ПЕРЕКРЫТИЙ	220	18.0000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
647	16	9	E7-1-47-3 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ЛЕСТНИЧНЫХ МАРШЕЙ ПРИ НАИБОЛЬШЕЙ МАССЕ МОНТАЖНЫХ ЭЛЕМЕНТОВ В ЗДАНИИ ДО 5 Т ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.0200	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
648	16	13	E46-4-3-3	РАЗБОРКА ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ ОБЪЕМОМ БОЛЕЕ 1 М3 ПРИ ПОМОЩИ ОТБОЙНЫХ МОЛОТКОВ ИЗ БЕТОНА МАРКИ 200 /ДЕМОНТАЖ РАМПЫ/	218	106.0000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
649	16	14	E7-1-22-5 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА В ОДНОЭТАЖНЫХ ЗДАНИЯХ СТРОПИЛЬНЫХ БАЛОК ПРИ ДЛИНЕ ПЛИТ ПОКРЫТИЙ ДО 6 М, ПРОЛЕТОМ ДО 12 М, МАССОЙ ДО 10 Т И ВЫСОТЕ ЗДАНИЙ ДО 25 М ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.0700	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
650	16	15	E46-4-21-19 ШHКДОП8	РАЗБОРКА КОЛОНН ПРЯМОУГОЛЬНОГО СЕЧЕНИЯ ИЗ СТАКАННЫХ ФУНДАМЕНТОВ СООРУЖЕНИЙ, МАССА КОЛОНН: ДО 4 Т	219	0.1200	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
651	16	16	E46-4-20-5 ШHКДОП8	РАЗБОРКА ФУНДАМЕНТОВ ПОД КОЛОННЫ ПРИ ГЛУБИНЕ КОТЛОВАНА ДО 4 М, МАССА КОНСТРУКЦИЙ: ДО 1,5 Т	219	0.1200	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
652	16	17	E46-4-2-2	РАЗБОРКА МОНОЛИТНЫХ ПЕРЕКРЫТИЙ ЖЕЛЕЗОБЕТОННЫХ	218	123.6000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
653	16	18	E46-4-3-3	РАЗБОРКА ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ ОБЪЕМОМ БОЛЕЕ 1 М3 ПРИ ПОМОЩИ ОТБОЙНЫХ МОЛОТКОВ ИЗ БЕТОНА МАРКИ 200 /РАЗБОРКА МОНОЛ БАЛОК/	218	146.3000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
654	16	21	E69-9-1	ОЧИСТКА ПОМЕЩЕНИЙ ОТ СТРОИТЕЛЬНОГО МУСОРА	221	1.4300	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
655	16	22	С311-52-1	ПОГРУЗКА: МУСОР СТРОИТЕЛЬНЫЙ С ПОГРУЗКОЙ ЭКСКАВАТОРАМИ	222	143.0000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
656	16	23	С310-1015	ПЕРЕВОЗКА ГРУЗОВ АВТОМОБИЛЕМ НА 15 КМ, КЛАСС ГРУЗА 1	222	143.0000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
657	16	24	E9-3-14-1 ШHК40270-05П110	МОНТАЖ СВЯЗЕЙ И РАСПОРОК ИЗ ОДИНОЧНЫХ И ПАРНЫХ УГОЛКОВ, ГНУТОСВАРНЫХ ПРОФИЛЕЙ ДЛЯ ПРОЛЕТОВ ДО 24 М ПРИ ВЫСОТЕ ЗДАНИЯ ДО 25 М	222	9.8310	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
658	16	25	УГ125-9	УГОЛОК 125Х9 ГОСТ 8509-93	222	8.7010	12782609.00	111221478.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
659	16	26	СЛ-10	СТАЛЬ ЛИСТОВАЯ Т10ММ ГОСТ 19903-74	222	1.1300	13652174.00	15426957.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
660	16	27	Б16	БОЛТ М16 ГОСТ 7798-70	220	144.0000	3000.00	432000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
661	16	28	E7-1-44-3 ШHК40270-05П110	УСТАНОВКА МОНТАЖНЫХ ИЗДЕЛИЙ МАССОЙ ДО 20 КГ	222	0.4460	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
662	16	30	УГ90Х7	УГОЛОК 90Х7 ГОСТ 8509-93	222	2.7310	12782609.00	34909304.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
663	16	31	УГ63Х6	УГОЛОК 63Х6 ГОСТ 8509-93	222	0.7690	12782609.00	9829826.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
664	16	32	СЛ-8	СТАЛЬ ЛИСТОВАЯ Т8ММ ГОСТ 19903-74	222	0.3780	13652174.00	5160522.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
665	16	36	E9-5-2-1 ШHК40270-05П110	ЭЛЕКТРОДУГОВАЯ СВАРКА ПРИ МОНТАЖЕ ОДНОЭТАЖНЫХ ПРОИЗВОДСТВЕННЫХ ЗДАНИЙ КАРКАСОВ В ЦЕЛОМ	225	1.4681	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
666	16	37	E13-3-2-4 ШHК40270-05П110	ОГРУНТОВКА МЕТАЛЛИЧЕСКИХ ПОВЕРХНОСТЕЙ ЗА ОДИН РАЗ ГРУНТОВКОЙ ГФ-021	215	5.1384	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
667	16	38	E13-3-4-26 ШHК40270-05П110 К=2	ОКРАСКА МЕТАЛЛИЧЕСКИХ ОГРУНТОВАННЫХ ПОВЕРХНОСТЕЙ ЭМАЛЬЮ ПФ-115 ЗА 2 PАЗА	215	5.1384	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
668	16	40	E46-2-9-2	ДЕМОНТАЖ ДВЕРНЫХ И ОКОННЫХ ОТКОСОВ	215	6.0870	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
669	16	41	E46-2-7-1	КЛАДКА ОТДЕЛЬНЫХ УЧАСТКОВ КИРПИЧНЫХ СТЕН И ЗАДЕЛКА ПРОЕМОВ В КИРПИЧНЫХ СТЕНАХ ПРИ ОБЪЕМЕ КЛАДКИ В ОДНОМ МЕСТЕ ДО 5 М3	218	22.6100	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
670	16	42	E8-2-7-1 ШHКДОП13 ШHК40270-05П110	АРМИРОВАНИЕ КЛАДКИ СТЕН И ДРУГИХ КОНСТРУКЦИЙ	222	0.0320	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
671	16	43	С124-9220	АРМАТУРА ДЛЯ МОНОЛИТНЫХ ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ В ВИДЕ СЕТОК И ПЛОСКИХ КАРКАСОВ, ПЕРИОДИЧЕСКОГО ПРОФИЛЯ КЛАССА АIII, ДИАМЕТРОМ 10 ММ	222	0.0320	10000000.00	320000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
672	16	44	E46-2-9-2	ОТБИВКА ШТУКАТУРКИ С ПОВЕРХНОСТЕЙ СТЕН КИРПИЧНЫХ	215	53.9000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
673	16	45	E46-1-4-2	УСИЛЕНИЕ КОНСТРУКТИВНЫХ ЭЛЕМЕНТОВ СТЕН КИРПИЧНЫХ СТАЛЬНЫМИ ОБОЙМАМИ	222	18.1220	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
674	16	46	ВР1-4	СЕТКА ИЗ Д4ВР1 ГОСТ 6727-90	222	7.5460	12347826.00	93176696.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
675	16	48	СЛ-4	СТАЛЬ ЛИСТОВАЯ Т4ММ ГОСТ 19903-74	222	2.3290	13652174.00	31795913.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
676	16	49	E61-26-2	ПЕРЕТИРКА ШТУКАТУРКИ: ФАСАДОВ ГЛАДКИХ С ЗЕМЛИ И ЛЕСОВ /ПPИМEHИTEЛЬHО ПPОМЫВКА СTEH ВОДОЙ, ОT ПЫЛИ И ГPЯЗИ/	228	53.9000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
677	16	50	E61-1-2 К=3	СПЛОШНОЕ ВЫРАВНИВАНИЕ ШТУКАТУРКИ СТЕН РАСТВОРОМ МЕЛКОЗЕРНИСТОГО БЕТОНА В20 ПРИ ТОЛЩИНЕ НАМЕТА: ДО 10 ММ ЗА 3 PАЗА	215	53.9000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
678	16	51	РМ-20	РАСТВОР ИЗ МЕЛКОЗЕРНИСТОГО БЕТОНА КЛ В20	218	215.6000	460000.00	99176000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
679	16	52	E46-1-1-3	УСИЛЕНИЕ МОНОЛИТНЫМИ ЖЕЛЕЗОБЕТОННЫМИ ОБОЙМАМИ СТЕН КИРПИЧНЫХ	218	8.8000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
680	16	53	ШВ-20	ШВЕЛЛЕР №20П ГОСТ 8240-89	222	1.0320	14086957.00	14537739.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
681	16	54	УГ50-5	УГОЛОК 50Х5 ГОСТ 8509-93 ГОСТ 8240-89	222	0.1780	12782609.00	2275304.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
682	16	56	СЛ-5	СТАЛЬ ЛИСТОВАЯ Т5ММ ГОСТ 19903-74	222	0.2270	13652174.00	3099043.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
683	16	57	E46-1-4-3	УСИЛЕНИЕ КОНСТРУКТИВНЫХ ЭЛЕМЕНТОВ СТЕН КИРПИЧНЫХ СТАЛЬНЫМИ ТЯЖАМИ	222	30.9840	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
684	16	58	УГ100-7	УГОЛОК 100Х7 ГОСТ 8509-93	222	27.5070	12782609.00	351611217.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
685	16	60	Ш-М16	ШПИЛЬКА М16 L=600	220	253.0000	2000.00	506000.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
686	16	63	E8-7-2-1 ШHК40270-05П110	УСТАНОВКА И РАЗБОРКА ВНУТРЕННИХ ТРУБЧАТЫХ ИНВЕНТАРНЫХ ЛЕСОВ ПРИ ВЫСОТЕ ПОМЕЩЕНИЙ ДО 6 М	215	26.8000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
687	16	64	E8-7-2-2 ШHК40270-05П110 К=2	УСТАНОВКА И РАЗБОРКА ВНУТРЕННИХ ТРУБЧАТЫХ ИНВЕНТАРНЫХ ЛЕСОВ НА КАЖДЫЕ ПОСЛЕДУЮЩИЕ 4 М ВЫСОТЫ ПОМЕЩЕНИЙ ДОБАВЛЯТЬ ЗА 2 PАЗА	215	26.8000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
688	16	65	E8-7-1-2 ШHК40270-05П110	УСТАНОВКА И РАЗБОРКА НАРУЖНЫХ ИНВЕНТАРНЫХ ЛЕСОВ ВЫСОТОЙ ДО 16 М ТРУБЧАТЫХ ДЛЯ ПРОЧИХ ОТДЕЛОЧНЫХ РАБОТ	215	26.8000	0.00	0.00	2025-11-22 18:22:01	2025-11-22 18:22:01	\N	1	1	planned	smeta
689	17	1	E46-4-8-1	РАЗБОРКА ПОКРЫТИЙ КРОВЕЛЬ ИЗ РУЛОННЫХ МАТЕРИАЛОВ	215	21.6800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
690	17	2	E57-2-11 ШHКДОП5	РАЗБОРКА ПОКРЫТИЙ ПОЛОВ: ЦЕМЕНТНЫХ /ПЕНОБЕТОННЫХ/	215	21.6800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
691	17	4	E46-4-8-4	РАЗБОРКА ПОКРЫТИЙ КРОВЕЛЬ ИЗ ВОЛНИСТЫХ И ПОЛУВОЛНИСТЫХ АСБЕСТОЦЕМЕНТНЫХ ЛИСТОВ	215	1.2700	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
692	17	5	E10-1-10-1 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ЭЛЕМЕНТОВ КАРКАСА ИЗ БРУСЬЕВ ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	218	1.5000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
693	17	6	E46-4-1-4	РАЗБОРКА СТЕН КИРПИЧНЫХ	218	101.5000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
694	17	7	E7-5-11-2 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ПАНЕЛЕЙ ПЕРЕКРЫТИЙ С ОПИРАНИЕМ ПО КОНТУРУ ПЛОЩАДЬЮ ДО 15 М2 ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.1800	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
695	17	8	ВЗ-П	ВОЗВРАТ ПАНЕЛЕЙ ПЕРЕКРЫТИЙ	220	18.0000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
696	17	9	E7-1-47-3 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА ЛЕСТНИЧНЫХ МАРШЕЙ ПРИ НАИБОЛЬШЕЙ МАССЕ МОНТАЖНЫХ ЭЛЕМЕНТОВ В ЗДАНИИ ДО 5 Т ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.0200	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
697	17	13	E46-4-3-3	РАЗБОРКА ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ ОБЪЕМОМ БОЛЕЕ 1 М3 ПРИ ПОМОЩИ ОТБОЙНЫХ МОЛОТКОВ ИЗ БЕТОНА МАРКИ 200 /ДЕМОНТАЖ РАМПЫ/	218	106.0000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
698	17	14	E7-1-22-5 #ШHК40200-04 ОП-34-а,б#КзT=0,8, Кэм=0,8, Км=0	УСТАНОВКА В ОДНОЭТАЖНЫХ ЗДАНИЯХ СТРОПИЛЬНЫХ БАЛОК ПРИ ДЛИНЕ ПЛИТ ПОКРЫТИЙ ДО 6 М, ПРОЛЕТОМ ДО 12 М, МАССОЙ ДО 10 Т И ВЫСОТЕ ЗДАНИЙ ДО 25 М ДEМОHTАЖ /PАЗБОPКА/, ПPИМEHEH КОЭФФИЦИEHT К HОPМАМ ЗАTPАT TPУДА - 0,8, К HОPМАМ ЭКСПЛУАTАЦИИ МАШИH - 0,8, К HОPМАМ PАСХОДА МАTEPИАЛОВ - 0	219	0.0700	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
699	17	15	E46-4-21-19 ШHКДОП8	РАЗБОРКА КОЛОНН ПРЯМОУГОЛЬНОГО СЕЧЕНИЯ ИЗ СТАКАННЫХ ФУНДАМЕНТОВ СООРУЖЕНИЙ, МАССА КОЛОНН: ДО 4 Т	219	0.1200	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
700	17	16	E46-4-20-5 ШHКДОП8	РАЗБОРКА ФУНДАМЕНТОВ ПОД КОЛОННЫ ПРИ ГЛУБИНЕ КОТЛОВАНА ДО 4 М, МАССА КОНСТРУКЦИЙ: ДО 1,5 Т	219	0.1200	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
701	17	17	E46-4-2-2	РАЗБОРКА МОНОЛИТНЫХ ПЕРЕКРЫТИЙ ЖЕЛЕЗОБЕТОННЫХ	218	123.6000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
702	17	18	E46-4-3-3	РАЗБОРКА ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ ОБЪЕМОМ БОЛЕЕ 1 М3 ПРИ ПОМОЩИ ОТБОЙНЫХ МОЛОТКОВ ИЗ БЕТОНА МАРКИ 200 /РАЗБОРКА МОНОЛ БАЛОК/	218	146.3000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
703	17	21	E69-9-1	ОЧИСТКА ПОМЕЩЕНИЙ ОТ СТРОИТЕЛЬНОГО МУСОРА	221	1.4300	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
704	17	22	С311-52-1	ПОГРУЗКА: МУСОР СТРОИТЕЛЬНЫЙ С ПОГРУЗКОЙ ЭКСКАВАТОРАМИ	222	143.0000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
705	17	23	С310-1015	ПЕРЕВОЗКА ГРУЗОВ АВТОМОБИЛЕМ НА 15 КМ, КЛАСС ГРУЗА 1	222	143.0000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
706	17	24	E9-3-14-1 ШHК40270-05П110	МОНТАЖ СВЯЗЕЙ И РАСПОРОК ИЗ ОДИНОЧНЫХ И ПАРНЫХ УГОЛКОВ, ГНУТОСВАРНЫХ ПРОФИЛЕЙ ДЛЯ ПРОЛЕТОВ ДО 24 М ПРИ ВЫСОТЕ ЗДАНИЯ ДО 25 М	222	9.8310	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
707	17	25	УГ125-9	УГОЛОК 125Х9 ГОСТ 8509-93	222	8.7010	12782609.00	111221478.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
708	17	26	СЛ-10	СТАЛЬ ЛИСТОВАЯ Т10ММ ГОСТ 19903-74	222	1.1300	13652174.00	15426957.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
709	17	27	Б16	БОЛТ М16 ГОСТ 7798-70	220	144.0000	3000.00	432000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
710	17	28	E7-1-44-3 ШHК40270-05П110	УСТАНОВКА МОНТАЖНЫХ ИЗДЕЛИЙ МАССОЙ ДО 20 КГ	222	0.4460	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
711	17	30	УГ90Х7	УГОЛОК 90Х7 ГОСТ 8509-93	222	2.7310	12782609.00	34909304.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
712	17	31	УГ63Х6	УГОЛОК 63Х6 ГОСТ 8509-93	222	0.7690	12782609.00	9829826.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
713	17	32	СЛ-8	СТАЛЬ ЛИСТОВАЯ Т8ММ ГОСТ 19903-74	222	0.3780	13652174.00	5160522.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
714	17	36	E9-5-2-1 ШHК40270-05П110	ЭЛЕКТРОДУГОВАЯ СВАРКА ПРИ МОНТАЖЕ ОДНОЭТАЖНЫХ ПРОИЗВОДСТВЕННЫХ ЗДАНИЙ КАРКАСОВ В ЦЕЛОМ	225	1.4681	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
715	17	37	E13-3-2-4 ШHК40270-05П110	ОГРУНТОВКА МЕТАЛЛИЧЕСКИХ ПОВЕРХНОСТЕЙ ЗА ОДИН РАЗ ГРУНТОВКОЙ ГФ-021	215	5.1384	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
716	17	38	E13-3-4-26 ШHК40270-05П110 К=2	ОКРАСКА МЕТАЛЛИЧЕСКИХ ОГРУНТОВАННЫХ ПОВЕРХНОСТЕЙ ЭМАЛЬЮ ПФ-115 ЗА 2 PАЗА	215	5.1384	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
717	17	40	E46-2-9-2	ДЕМОНТАЖ ДВЕРНЫХ И ОКОННЫХ ОТКОСОВ	215	6.0870	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
718	17	41	E46-2-7-1	КЛАДКА ОТДЕЛЬНЫХ УЧАСТКОВ КИРПИЧНЫХ СТЕН И ЗАДЕЛКА ПРОЕМОВ В КИРПИЧНЫХ СТЕНАХ ПРИ ОБЪЕМЕ КЛАДКИ В ОДНОМ МЕСТЕ ДО 5 М3	218	22.6100	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
719	17	42	E8-2-7-1 ШHКДОП13 ШHК40270-05П110	АРМИРОВАНИЕ КЛАДКИ СТЕН И ДРУГИХ КОНСТРУКЦИЙ	222	0.0320	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
720	17	43	С124-9220	АРМАТУРА ДЛЯ МОНОЛИТНЫХ ЖЕЛЕЗОБЕТОННЫХ КОНСТРУКЦИЙ В ВИДЕ СЕТОК И ПЛОСКИХ КАРКАСОВ, ПЕРИОДИЧЕСКОГО ПРОФИЛЯ КЛАССА АIII, ДИАМЕТРОМ 10 ММ	222	0.0320	10000000.00	320000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
721	17	44	E46-2-9-2	ОТБИВКА ШТУКАТУРКИ С ПОВЕРХНОСТЕЙ СТЕН КИРПИЧНЫХ	215	53.9000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
722	17	45	E46-1-4-2	УСИЛЕНИЕ КОНСТРУКТИВНЫХ ЭЛЕМЕНТОВ СТЕН КИРПИЧНЫХ СТАЛЬНЫМИ ОБОЙМАМИ	222	18.1220	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
723	17	46	ВР1-4	СЕТКА ИЗ Д4ВР1 ГОСТ 6727-90	222	7.5460	12347826.00	93176696.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
724	17	48	СЛ-4	СТАЛЬ ЛИСТОВАЯ Т4ММ ГОСТ 19903-74	222	2.3290	13652174.00	31795913.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
725	17	49	E61-26-2	ПЕРЕТИРКА ШТУКАТУРКИ: ФАСАДОВ ГЛАДКИХ С ЗЕМЛИ И ЛЕСОВ /ПPИМEHИTEЛЬHО ПPОМЫВКА СTEH ВОДОЙ, ОT ПЫЛИ И ГPЯЗИ/	228	53.9000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
726	17	50	E61-1-2 К=3	СПЛОШНОЕ ВЫРАВНИВАНИЕ ШТУКАТУРКИ СТЕН РАСТВОРОМ МЕЛКОЗЕРНИСТОГО БЕТОНА В20 ПРИ ТОЛЩИНЕ НАМЕТА: ДО 10 ММ ЗА 3 PАЗА	215	53.9000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
727	17	51	РМ-20	РАСТВОР ИЗ МЕЛКОЗЕРНИСТОГО БЕТОНА КЛ В20	218	215.6000	460000.00	99176000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
728	17	52	E46-1-1-3	УСИЛЕНИЕ МОНОЛИТНЫМИ ЖЕЛЕЗОБЕТОННЫМИ ОБОЙМАМИ СТЕН КИРПИЧНЫХ	218	8.8000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
729	17	53	ШВ-20	ШВЕЛЛЕР №20П ГОСТ 8240-89	222	1.0320	14086957.00	14537739.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
730	17	54	УГ50-5	УГОЛОК 50Х5 ГОСТ 8509-93 ГОСТ 8240-89	222	0.1780	12782609.00	2275304.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
731	17	56	СЛ-5	СТАЛЬ ЛИСТОВАЯ Т5ММ ГОСТ 19903-74	222	0.2270	13652174.00	3099043.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
732	17	57	E46-1-4-3	УСИЛЕНИЕ КОНСТРУКТИВНЫХ ЭЛЕМЕНТОВ СТЕН КИРПИЧНЫХ СТАЛЬНЫМИ ТЯЖАМИ	222	30.9840	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
733	17	58	УГ100-7	УГОЛОК 100Х7 ГОСТ 8509-93	222	27.5070	12782609.00	351611217.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
734	17	60	Ш-М16	ШПИЛЬКА М16 L=600	220	253.0000	2000.00	506000.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
735	17	63	E8-7-2-1 ШHК40270-05П110	УСТАНОВКА И РАЗБОРКА ВНУТРЕННИХ ТРУБЧАТЫХ ИНВЕНТАРНЫХ ЛЕСОВ ПРИ ВЫСОТЕ ПОМЕЩЕНИЙ ДО 6 М	215	26.8000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
736	17	64	E8-7-2-2 ШHК40270-05П110 К=2	УСТАНОВКА И РАЗБОРКА ВНУТРЕННИХ ТРУБЧАТЫХ ИНВЕНТАРНЫХ ЛЕСОВ НА КАЖДЫЕ ПОСЛЕДУЮЩИЕ 4 М ВЫСОТЫ ПОМЕЩЕНИЙ ДОБАВЛЯТЬ ЗА 2 PАЗА	215	26.8000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
737	17	65	E8-7-1-2 ШHК40270-05П110	УСТАНОВКА И РАЗБОРКА НАРУЖНЫХ ИНВЕНТАРНЫХ ЛЕСОВ ВЫСОТОЙ ДО 16 М ТРУБЧАТЫХ ДЛЯ ПРОЧИХ ОТДЕЛОЧНЫХ РАБОТ	215	26.8000	0.00	0.00	2025-11-22 18:23:43	2025-11-22 18:23:43	\N	1	1	planned	smeta
\.



--
-- Name: auth_assignment auth_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_assignment
    ADD CONSTRAINT auth_assignment_pkey PRIMARY KEY (item_name, user_id);


--
-- Name: auth_item_child auth_item_child_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_item_child
    ADD CONSTRAINT auth_item_child_pkey PRIMARY KEY (parent, child);


--
-- Name: auth_item auth_item_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_item
    ADD CONSTRAINT auth_item_pkey PRIMARY KEY (name);


--
-- Name: auth_rule auth_rule_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_rule
    ADD CONSTRAINT auth_rule_pkey PRIMARY KEY (name);


--
-- Name: customers customers_inn_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_inn_key UNIQUE (inn);


--
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.customers
    ADD CONSTRAINT customers_pkey PRIMARY KEY (id);


--
-- Name: migration migration_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migration
    ADD CONSTRAINT migration_pkey PRIMARY KEY (version);


--
-- Name: object_members object_members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.object_members
    ADD CONSTRAINT object_members_pkey PRIMARY KEY (id);


--
-- Name: object_parts object_parts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.object_parts
    ADD CONSTRAINT object_parts_pkey PRIMARY KEY (id);


--
-- Name: objects objects_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.objects
    ADD CONSTRAINT objects_pkey PRIMARY KEY (id);


--
-- Name: projects projects_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_name_key UNIQUE (name);


--
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- Name: resource_catalog resource_catalog_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resource_catalog
    ADD CONSTRAINT resource_catalog_name_key UNIQUE (name);


--
-- Name: resource_catalog resource_catalog_name_sku_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resource_catalog
    ADD CONSTRAINT resource_catalog_name_sku_key UNIQUE (name_sku);


--
-- Name: resource_catalog resource_catalog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resource_catalog
    ADD CONSTRAINT resource_catalog_pkey PRIMARY KEY (id);


--
-- Name: units units_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_name_key UNIQUE (name);


--
-- Name: units units_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_pkey PRIMARY KEY (id);


--
-- Name: work_categories work_categories_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_categories
    ADD CONSTRAINT work_categories_code_key UNIQUE (code);


--
-- Name: work_categories work_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_categories
    ADD CONSTRAINT work_categories_pkey PRIMARY KEY (id);


--
-- Name: work_resources work_resources_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_resources
    ADD CONSTRAINT work_resources_pkey PRIMARY KEY (id);


--
-- Name: work_schedules work_schedules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_schedules
    ADD CONSTRAINT work_schedules_pkey PRIMARY KEY (id);


--
-- Name: works works_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT works_pkey PRIMARY KEY (id);


--
-- Name: works works_unique_uzbek; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT works_unique_uzbek UNIQUE (name_uzbek);


--
-- Name: idx-auth_assignment-user_id; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "idx-auth_assignment-user_id" ON public.auth_assignment USING btree (user_id);


--
-- Name: idx-auth_item-type; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "idx-auth_item-type" ON public.auth_item USING btree (type);


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

CREATE INDEX ix_customers_name_lower ON public.customers USING btree (lower(name));


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

CREATE INDEX ix_object_members_object ON public.object_members USING btree (object_id);


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

CREATE INDEX ix_object_members_user ON public.object_members USING btree (user_id);


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

CREATE INDEX ix_objects_project ON public.objects USING btree (project_id);


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

CREATE INDEX ix_parts_object ON public.object_parts USING btree (object_id);


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

CREATE INDEX ix_projects_customer_id ON public.projects USING btree (customer_id);


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

CREATE INDEX ix_resource_catalog_name ON public.resource_catalog USING gin (to_tsvector('simple'::regconfig, name));


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

CREATE INDEX ix_resource_catalog_type ON public.resource_catalog USING btree (resource_type);


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

CREATE INDEX ix_work_cat_active ON public.work_categories USING btree (is_active);


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

CREATE INDEX ix_work_cat_parent ON public.work_categories USING btree (parent_id);


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

CREATE INDEX ix_work_cat_sort ON public.work_categories USING btree (sort_order);


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

CREATE INDEX ix_work_resources_object ON public.work_resources USING btree (object_id);


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

CREATE INDEX ix_work_schedules_object ON public.work_schedules USING btree (object_id);


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

CREATE INDEX ix_works_object ON public.works USING btree (object_id);


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

CREATE INDEX ix_works_unit ON public.works USING btree (unit_id);


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

CREATE INDEX ix_wr_resource ON public.work_resources USING btree (resource_id);


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

CREATE INDEX ix_wr_unit ON public.work_resources USING btree (unit_id);


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

CREATE INDEX ix_wr_work ON public.work_resources USING btree (work_id);


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

CREATE UNIQUE INDEX uq_object_members_user_object_role ON public.object_members USING btree (user_id, object_id, role_key);


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

CREATE UNIQUE INDEX uq_work_cat_parent_name_uz ON public.work_categories USING btree (parent_id, name_uz);


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

CREATE UNIQUE INDEX ux_work_schedules_work ON public.work_schedules USING btree (work_id);


--
-- Name: auth_assignment auth_assignment_item_name_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_assignment
    ADD CONSTRAINT auth_assignment_item_name_fkey FOREIGN KEY (item_name) REFERENCES public.auth_item(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: auth_item_child auth_item_child_child_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_item_child
    ADD CONSTRAINT auth_item_child_child_fkey FOREIGN KEY (child) REFERENCES public.auth_item(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: auth_item_child auth_item_child_parent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_item_child
    ADD CONSTRAINT auth_item_child_parent_fkey FOREIGN KEY (parent) REFERENCES public.auth_item(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: auth_item auth_item_rule_name_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_item
    ADD CONSTRAINT auth_item_rule_name_fkey FOREIGN KEY (rule_name) REFERENCES public.auth_rule(name) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: object_members fk_object_members_object_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.object_members
    ADD CONSTRAINT fk_object_members_object_id FOREIGN KEY (object_id) REFERENCES public.objects(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: object_members fk_object_members_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.object_members
    ADD CONSTRAINT fk_object_members_user_id FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: object_parts fk_object_parts_object_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.object_parts
    ADD CONSTRAINT fk_object_parts_object_id FOREIGN KEY (object_id) REFERENCES public.objects(id) ON DELETE CASCADE;


--
-- Name: objects fk_objects_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.objects
    ADD CONSTRAINT fk_objects_project_id FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE RESTRICT;


--
-- Name: projects fk_projects_customer; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT fk_projects_customer FOREIGN KEY (customer_id) REFERENCES public.customers(id) ON DELETE RESTRICT;


--
-- Name: projects fk_projects_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT fk_projects_user FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: resource_catalog fk_resource_catalog_unit; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.resource_catalog
    ADD CONSTRAINT fk_resource_catalog_unit FOREIGN KEY (unit_id) REFERENCES public.units(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: work_categories fk_work_categories_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_categories
    ADD CONSTRAINT fk_work_categories_parent_id FOREIGN KEY (parent_id) REFERENCES public.work_categories(id) ON DELETE SET NULL;


--
-- Name: work_resources fk_work_resources_object; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_resources
    ADD CONSTRAINT fk_work_resources_object FOREIGN KEY (object_id) REFERENCES public.objects(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: work_resources fk_work_resources_resource; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_resources
    ADD CONSTRAINT fk_work_resources_resource FOREIGN KEY (resource_id) REFERENCES public.resource_catalog(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: work_resources fk_work_resources_unit; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_resources
    ADD CONSTRAINT fk_work_resources_unit FOREIGN KEY (unit_id) REFERENCES public.units(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: work_resources fk_work_resources_work; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_resources
    ADD CONSTRAINT fk_work_resources_work FOREIGN KEY (work_id) REFERENCES public.works(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: work_schedules fk_work_schedules_object; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_schedules
    ADD CONSTRAINT fk_work_schedules_object FOREIGN KEY (object_id) REFERENCES public.objects(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: work_schedules fk_work_schedules_work; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_schedules
    ADD CONSTRAINT fk_work_schedules_work FOREIGN KEY (work_id) REFERENCES public.works(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: works fk_works_category; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT fk_works_category FOREIGN KEY (work_category_id) REFERENCES public.work_categories(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: works fk_works_object; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT fk_works_object FOREIGN KEY (object_id) REFERENCES public.objects(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: works fk_works_object_part; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT fk_works_object_part FOREIGN KEY (object_part_id) REFERENCES public.object_parts(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: works fk_works_unit; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.works
    ADD CONSTRAINT fk_works_unit FOREIGN KEY (unit_id) REFERENCES public.units(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
--

