open-init-db/sharix_open_schema.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.7
-- Dumped by pg_dump version 12.7

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

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: client; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.client (
    id integer NOT NULL,
    userid integer,
    requirements name,
    status character(1),
    ticket_status integer,
    id_metaservice integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.client OWNER TO sharix;

--
-- Name: client_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.client_id_seq OWNER TO sharix;

--
-- Name: client_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.client_id_seq OWNED BY public.client.id;


--
-- Name: company; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.company (
    id integer NOT NULL,
    legalname character varying(255),
    representative integer,
    inn integer,
    kpp integer,
    ogrn integer,
    bank_name integer,
    bik integer,
    ks integer,
    rs integer,
    address integer,
    requirements name,
    status character(1),
    ticket_status integer,
    id_metaservice integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.company OWNER TO sharix;

--
-- Name: company_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.company_id_seq OWNER TO sharix;

--
-- Name: company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.company_id_seq OWNED BY public.company.id;


--
-- Name: current_orders; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.current_orders (
    id integer NOT NULL,
    service_id integer,
    service_type_id integer,
    state integer,
    id_metaservice integer,
    time_placed timestamp with time zone,
    time_start timestamp with time zone,
    time_finish_predicted timestamp with time zone,
    time_finish_real timestamp with time zone,
    provider integer,
    receiver integer,
    client integer,
    predicted_price integer,
    real_price integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.current_orders OWNER TO sharix;

--
-- Name: current_orders_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.current_orders_id_seq OWNER TO sharix;

--
-- Name: current_orders_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.current_orders_id_seq OWNED BY public.current_orders.id;


--
-- Name: current_timetable; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.current_timetable (
    id integer NOT NULL,
    order_id integer,
    service_type_id integer,
    provider_id integer,
    resource_id integer,
    time_start_predicted timestamp with time zone,
    time_finished_predicted timestamp with time zone,
    gap integer
);


ALTER TABLE public.current_timetable OWNER TO sharix;

--
-- Name: current_timetable_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.current_timetable_id_seq OWNER TO sharix;

--
-- Name: current_timetable_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.current_timetable_id_seq OWNED BY public.current_timetable.id;


--
-- Name: documents; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.documents (
    id integer NOT NULL,
    id_metaservice integer,
    doctype character varying(2),
    datalink character varying(255),
    userid integer,
    company_id integer,
    is_visible character(1),
    is_global character(1),
    check_level character(1),
    checked_by integer,
    check_date timestamp with time zone,
    status character(1),
    ticket_status integer
);


ALTER TABLE public.documents OWNER TO sharix;

--
-- Name: documents_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.documents_id_seq OWNER TO sharix;

--
-- Name: documents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.documents_id_seq OWNED BY public.documents.id;


--
-- Name: order_list_log; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.order_list_log (
    id integer NOT NULL,
    payment_transaction_id integer,
    service_id integer,
    time_placed timestamp with time zone,
    time_start timestamp with time zone,
    time_finish_predicted timestamp with time zone,
    time_finish_real timestamp with time zone,
    order_place_start name,
    order_place_predicted name,
    order_place_real name,
    price integer,
    provider integer,
    receiver integer,
    client integer
);


ALTER TABLE public.order_list_log OWNER TO sharix;

--
-- Name: order_list_log_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.order_list_log_id_seq OWNER TO sharix;

--
-- Name: order_list_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.order_list_log_id_seq OWNED BY public.order_list_log.id;


--
-- Name: orders; Type: TABLE; Schema: public; Owner: drive
--

CREATE TABLE public.orders (
    id integer DEFAULT 0 NOT NULL,
    car text,
    model text,
    color text,
    rate text,
    customer text,
    organization text,
    start integer,
    final integer,
    adress text
);


ALTER TABLE public.orders OWNER TO drive;

--
-- Name: permissions; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.permissions (
    id integer NOT NULL,
    id_metaservice integer,
    id_permission name,
    user_id integer,
    is_visible character(1),
    is_global character(1),
    check_level character(1),
    checked_by integer,
    check_date timestamp with time zone,
    status character(1),
    ticket_status integer
);


ALTER TABLE public.permissions OWNER TO sharix;

--
-- Name: permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.permissions_id_seq OWNER TO sharix;

--
-- Name: permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.permissions_id_seq OWNED BY public.permissions.id;


--
-- Name: provider; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.provider (
    id integer NOT NULL,
    type integer,
    company integer,
    userid integer,
    id_metaservice integer,
    requirements name,
    status character(1),
    ticket_status integer,
    is_visible character(1),
    is_global character(1),
    location_type name,
    default_location name
);


ALTER TABLE public.provider OWNER TO sharix;

--
-- Name: provider_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.provider_id_seq OWNER TO sharix;

--
-- Name: provider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.provider_id_seq OWNED BY public.provider.id;


--
-- Name: relationship; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.relationship (
    id integer NOT NULL,
    user_id_who integer,
    user_id_whom integer,
    neg_type character(1),
    id_metaservice integer,
    is_visible character(1),
    requirements name,
    status integer,
    ticket_status integer,
    is_global character(1)
);


ALTER TABLE public.relationship OWNER TO sharix;

--
-- Name: relationship_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.relationship_id_seq OWNER TO sharix;

--
-- Name: relationship_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.relationship_id_seq OWNED BY public.relationship.id;


--
-- Name: resources; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.resources (
    id integer NOT NULL,
    type_id integer,
    user_id integer,
    requirements name,
    status character(1),
    ticket_status integer,
    id_metaservice integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.resources OWNER TO sharix;

--
-- Name: resources_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.resources_id_seq OWNER TO sharix;

--
-- Name: resources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.resources_id_seq OWNED BY public.resources.id;


--
-- Name: service; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.service (
    id integer NOT NULL,
    servicetype_id integer,
    id_provider integer,
    resource_id integer,
    requirements name,
    id_metaservice integer,
    price_alg character(1),
    price_km integer,
    price_min integer,
    price_amount integer,
    service_status character(1),
    status character(1),
    ticket_status integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.service OWNER TO sharix;

--
-- Name: service_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.service_id_seq OWNER TO sharix;

--
-- Name: service_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.service_id_seq OWNED BY public.service.id;


--
-- Name: servicetype; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.servicetype (
    id integer NOT NULL,
    codename character varying(255),
    caption character varying(255),
    description text,
    requirements name,
    pricetype integer,
    status character(1),
    ticket_status integer,
    id_metaservice integer,
    is_visible character(1),
    is_global character(1)
);


ALTER TABLE public.servicetype OWNER TO sharix;

--
-- Name: servicetype_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.servicetype_id_seq OWNER TO sharix;

--
-- Name: servicetype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.servicetype_id_seq OWNED BY public.servicetype.id;


--
-- Name: tickets; Type: TABLE; Schema: public; Owner: sharix
--

CREATE TABLE public.tickets (
    id integer NOT NULL,
    id_reporter integer,
    id_asignee integer,
    time_created timestamp with time zone,
    time_assigned timestamp with time zone,
    time_changed timestamp with time zone,
    time_closed timestamp with time zone,
    status integer,
    description text
);


ALTER TABLE public.tickets OWNER TO sharix;

--
-- Name: tickets_id_seq; Type: SEQUENCE; Schema: public; Owner: sharix
--

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


ALTER TABLE public.tickets_id_seq OWNER TO sharix;

--
-- Name: tickets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: sharix
--

ALTER SEQUENCE public.tickets_id_seq OWNED BY public.tickets.id;


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

CREATE TABLE public.users (
    id integer DEFAULT 0 NOT NULL,
    name text,
    access text,
    login text,
    password text
);


ALTER TABLE public.users OWNER TO drive;

--
-- Name: client id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: company id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: current_orders id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: current_timetable id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: documents id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: order_list_log id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: permissions id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: provider id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: relationship id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: resources id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: service id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: servicetype id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: tickets id; Type: DEFAULT; Schema: public; Owner: sharix
--

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


--
-- Name: client client_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.client
    ADD CONSTRAINT client_pkey PRIMARY KEY (id);


--
-- Name: company company_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.company
    ADD CONSTRAINT company_pkey PRIMARY KEY (id);


--
-- Name: current_orders current_orders_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.current_orders
    ADD CONSTRAINT current_orders_pkey PRIMARY KEY (id);


--
-- Name: current_timetable current_timetable_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.current_timetable
    ADD CONSTRAINT current_timetable_pkey PRIMARY KEY (id);


--
-- Name: documents documents_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.documents
    ADD CONSTRAINT documents_pkey PRIMARY KEY (id);


--
-- Name: order_list_log order_list_log_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.order_list_log
    ADD CONSTRAINT order_list_log_pkey PRIMARY KEY (id);


--
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- Name: provider provider_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.provider
    ADD CONSTRAINT provider_pkey PRIMARY KEY (id);


--
-- Name: relationship relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.relationship
    ADD CONSTRAINT relationship_pkey PRIMARY KEY (id);


--
-- Name: resources resources_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.resources
    ADD CONSTRAINT resources_pkey PRIMARY KEY (id);


--
-- Name: service service_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.service
    ADD CONSTRAINT service_pkey PRIMARY KEY (id);


--
-- Name: servicetype servicetype_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.servicetype
    ADD CONSTRAINT servicetype_pkey PRIMARY KEY (id);


--
-- Name: tickets tickets_pkey; Type: CONSTRAINT; Schema: public; Owner: sharix
--

ALTER TABLE ONLY public.tickets
    ADD CONSTRAINT tickets_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--