--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: pmib6103; Type: SCHEMA; Schema: -; Owner: pmi-b6103
--

CREATE SCHEMA pmib6103;


ALTER SCHEMA pmib6103 OWNER TO "pmi-b6103";

SET search_path = pmib6103, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: j; Type: TABLE; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

CREATE TABLE j (
    n_izd character(6) NOT NULL,
    name character(20),
    town character(20)
);


ALTER TABLE pmib6103.j OWNER TO "pmi-b6103";

--
-- Name: p; Type: TABLE; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

CREATE TABLE p (
    n_det character(6) NOT NULL,
    name character(20),
    cvet character(20),
    ves smallint,
    town character(20)
);


ALTER TABLE pmib6103.p OWNER TO "pmi-b6103";

--
-- Name: s; Type: TABLE; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

CREATE TABLE s (
    n_post character(6) NOT NULL,
    name character(20),
    reiting smallint,
    town character(20)
);


ALTER TABLE pmib6103.s OWNER TO "pmi-b6103";

--
-- Name: spj; Type: TABLE; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

CREATE TABLE spj (
    n_post character(6),
    n_det character(6),
    n_izd character(6),
    kol smallint,
    data character(20)
);


ALTER TABLE pmib6103.spj OWNER TO "pmi-b6103";

--
-- Data for Name: j; Type: TABLE DATA; Schema: pmib6103; Owner: pmi-b6103
--

INSERT INTO j VALUES ('J1    ', 'Жесткий диск        ', 'Париж               ');
INSERT INTO j VALUES ('J2    ', 'Перфоратор          ', 'Рим                 ');
INSERT INTO j VALUES ('J3    ', 'Считыватель         ', 'Афины               ');
INSERT INTO j VALUES ('J4    ', 'Принтер             ', 'Афины               ');
INSERT INTO j VALUES ('J5    ', 'Флоппи-диск         ', 'Лондон              ');
INSERT INTO j VALUES ('J6    ', 'Терминал            ', 'Осло                ');
INSERT INTO j VALUES ('J7    ', 'Лента               ', 'Лондон              ');


--
-- Data for Name: p; Type: TABLE DATA; Schema: pmib6103; Owner: pmi-b6103
--

INSERT INTO p VALUES ('P1    ', 'Гайка               ', 'Красный             ', 12, 'Лондон              ');
INSERT INTO p VALUES ('P2    ', 'Болт                ', 'Зеленый             ', 17, 'Париж               ');
INSERT INTO p VALUES ('P3    ', 'Винт                ', 'Голубой             ', 17, 'Рим                 ');
INSERT INTO p VALUES ('P4    ', 'Винт                ', 'Красный             ', 14, 'Лондон              ');
INSERT INTO p VALUES ('P5    ', 'Кулачок             ', 'Голубой             ', 12, 'Париж               ');
INSERT INTO p VALUES ('P6    ', 'Блюм                ', 'Красный             ', 19, 'Лондон              ');


--
-- Data for Name: s; Type: TABLE DATA; Schema: pmib6103; Owner: pmi-b6103
--

INSERT INTO s VALUES ('S1    ', 'Смит                ', 20, 'Лондон              ');
INSERT INTO s VALUES ('S2    ', 'Джонс               ', 10, 'Париж               ');
INSERT INTO s VALUES ('S3    ', 'Блейк               ', 30, 'Париж               ');
INSERT INTO s VALUES ('S4    ', 'Кларк               ', 20, 'Лондон              ');
INSERT INTO s VALUES ('S5    ', 'Адамс               ', 30, 'Афины               ');


--
-- Data for Name: spj; Type: TABLE DATA; Schema: pmib6103; Owner: pmi-b6103
--

INSERT INTO spj VALUES ('S1    ', 'P1    ', 'J1    ', 200, '1.09.19             ');
INSERT INTO spj VALUES ('S1    ', 'P1    ', 'J4    ', 700, '1.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J1    ', 400, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J2    ', 200, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J3    ', 200, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J4    ', 500, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J5    ', 600, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J6    ', 400, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P3    ', 'J7    ', 800, '7.09.19             ');
INSERT INTO spj VALUES ('S2    ', 'P5    ', 'J2    ', 100, '8.09.19             ');
INSERT INTO spj VALUES ('S3    ', 'P3    ', 'J1    ', 200, '17.09.19            ');
INSERT INTO spj VALUES ('S3    ', 'P4    ', 'J2    ', 500, '7.10.19             ');
INSERT INTO spj VALUES ('S4    ', 'P6    ', 'J3    ', 300, '18.11.19            ');
INSERT INTO spj VALUES ('S4    ', 'P6    ', 'J7    ', 300, '18.11.19            ');
INSERT INTO spj VALUES ('S5    ', 'P2    ', 'J2    ', 200, '5.08.19             ');
INSERT INTO spj VALUES ('S5    ', 'P2    ', 'J4    ', 100, '5.08.19             ');
INSERT INTO spj VALUES ('S5    ', 'P5    ', 'J5    ', 500, '15.08.19            ');
INSERT INTO spj VALUES ('S5    ', 'P5    ', 'J7    ', 100, '15.08.19            ');
INSERT INTO spj VALUES ('S5    ', 'P6    ', 'J2    ', 200, '5.09.19             ');
INSERT INTO spj VALUES ('S5    ', 'P6    ', 'J4    ', 500, '5.09.19             ');
INSERT INTO spj VALUES ('S5    ', 'P1    ', 'J4    ', 100, '5.08.19             ');
INSERT INTO spj VALUES ('S5    ', 'P3    ', 'J4    ', 200, '12.08.19            ');
INSERT INTO spj VALUES ('S5    ', 'P4    ', 'J4    ', 800, '5.09.19             ');
INSERT INTO spj VALUES ('S5    ', 'P5    ', 'J4    ', 400, '23.09.19            ');


--
-- Name: j_pkey; Type: CONSTRAINT; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

ALTER TABLE ONLY j
    ADD CONSTRAINT j_pkey PRIMARY KEY (n_izd);


--
-- Name: p_pkey; Type: CONSTRAINT; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

ALTER TABLE ONLY p
    ADD CONSTRAINT p_pkey PRIMARY KEY (n_det);


--
-- Name: s_pkey; Type: CONSTRAINT; Schema: pmib6103; Owner: pmi-b6103; Tablespace: 
--

ALTER TABLE ONLY s
    ADD CONSTRAINT s_pkey PRIMARY KEY (n_post);


--
-- PostgreSQL database dump complete
--