--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.5
-- Dumped by pg_dump version 9.5.5

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;
SET row_security = off;

--
-- Name: postgres; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE postgres IS 'default administrative connection database';


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

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


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

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

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

CREATE TABLE person (
    id_pers integer NOT NULL,
    first_name character(20),
    name character(20) NOT NULL
);


ALTER TABLE person OWNER TO postgres;

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

CREATE SEQUENCE "PERSON_ID_PERS_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "PERSON_ID_PERS_seq" OWNER TO postgres;

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

ALTER SEQUENCE "PERSON_ID_PERS_seq" OWNED BY person.id_pers;


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

CREATE TABLE client (
    id_client integer NOT NULL,
    gender character varying(45) NOT NULL,
    birth_last_name character varying(45) NOT NULL,
    common_last_name character varying(45) NOT NULL,
    first_name character varying(45) NOT NULL,
    email character varying(45) NOT NULL,
    birthdate date NOT NULL,
    birthplace_city character varying(45) NOT NULL,
    birthplace_county character varying(45) NOT NULL,
    login integer NOT NULL,
    password integer NOT NULL,
    address character varying(45) NOT NULL,
    postcode integer NOT NULL,
    city character varying(45) NOT NULL,
    country character varying(45) NOT NULL,
    nationality character varying(45) NOT NULL,
    phone_number integer NOT NULL,
    socioprofessional_group character varying(45) NOT NULL,
    salary numeric,
    status character varying(45) NOT NULL,
    id_group integer
);


ALTER TABLE client OWNER TO postgres;

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

CREATE SEQUENCE client_id_client_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE client_id_client_seq OWNER TO postgres;

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

ALTER SEQUENCE client_id_client_seq OWNED BY client.id_client;


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

CREATE TABLE conseiller (
    id_pers integer NOT NULL,
    first_name character varying(40) NOT NULL,
    name character varying(40) NOT NULL,
    email character varying(40) NOT NULL,
    birthdate date,
    startdate date,
    phonenumber character varying,
    group_fa character varying
);


ALTER TABLE conseiller OWNER TO postgres;

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

CREATE SEQUENCE conseiller_id_pers_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE conseiller_id_pers_seq OWNER TO postgres;

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

ALTER SEQUENCE conseiller_id_pers_seq OWNED BY conseiller.id_pers;


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

CREATE TABLE param_agios (
    id_agios integer NOT NULL,
    begin_mt double precision,
    last_mt double precision,
    nb_days integer,
    rate_agios double precision,
    id_cat integer
);


ALTER TABLE param_agios OWNER TO postgres;

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

CREATE SEQUENCE seq_id_param
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE seq_id_param OWNER TO postgres;

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

CREATE SEQUENCE seq_id_wk
    START WITH 24
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE seq_id_wk OWNER TO postgres;

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

CREATE TABLE status (
    id_status integer NOT NULL,
    name_status character varying(40) NOT NULL,
    slice_top real NOT NULL,
    slice_low real NOT NULL,
    alert_type character varying(255),
    banktransfer integer,
    overdraft integer
);


ALTER TABLE status OWNER TO postgres;

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

CREATE SEQUENCE status_id_status_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE status_id_status_seq OWNER TO postgres;

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

ALTER SEQUENCE status_id_status_seq OWNED BY status.id_status;


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

CREATE TABLE workgroup (
    id_workgroup integer NOT NULL,
    id_categorie integer NOT NULL,
    name character varying(10) NOT NULL
);


ALTER TABLE workgroup OWNER TO postgres;

--
-- Name: id_client; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY client ALTER COLUMN id_client SET DEFAULT nextval('client_id_client_seq'::regclass);


--
-- Name: id_pers; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY conseiller ALTER COLUMN id_pers SET DEFAULT nextval('conseiller_id_pers_seq'::regclass);


--
-- Name: id_status; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY status ALTER COLUMN id_status SET DEFAULT nextval('status_id_status_seq'::regclass);


--
-- Name: PERSON_ID_PERS_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('"PERSON_ID_PERS_seq"', 3, true);


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

COPY client (id_client, gender, birth_last_name, common_last_name, first_name, email, birthdate, birthplace_city, birthplace_county, login, password, address, postcode, city, country, nationality, phone_number, socioprofessional_group, salary, status, id_group) FROM stdin;
2	Masculin	Lesguer	Lesguer	Florian	florian.lesguer@laposte.net	1994-07-08	Chartres	Eure-et-Loir	1234567890	12345	14 rue des Alouettes	94000	Créteil	\tFrance	Français	620764590	Salariés de l’agriculture	535	Célibataire	1
1	Masculin	Lesguer	Lesguer	Florian	florian.lesguer@laposte.net	1994-07-08	Chartres	Eure-et-loi	1234567890	12345	14 rue des Alouettes	94000	14 rue des Alouettes	France	France	689979262	Ouvriers	535	Célibataire	\N
3	Masculin	Lesguer	Lesguer	Florian	florian.lesguer@laposte.net	1994-08-07	Chartres	Eur-et-loir	1234567890	12345	14 rue des Alouettes	53000	14 rue des Alouettes	France	France	1234567890	Agriculteurs exploitants	535	Célibataire	\N
4	Masculin	Lesguer	Lesguer	Florian	florian.lesguer@laposte.net	1994-07-08	Chartres	Eure-et-loi	1234567890	12345	14 rue des Alouettes	94000	14 rue des Alouettes	France	France	766554433	Ouvriers	535	Célibataire	\N
5	Masculin	Lesguer	Lesguer	Florian	florian.lesguer@laposte.net	1994-07-08	Chartres	Eure-et-loi	1234567890	12345	14 rue des Alouettes	94000	14 rue des Alouettes	France	France	766554433	Professions libérales et cadres supérieurs	535	Célibataire	\N
\.


--
-- Name: client_id_client_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('client_id_client_seq', 5, true);


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

COPY conseiller (id_pers, first_name, name, email, birthdate, startdate, phonenumber, group_fa) FROM stdin;
1	Anne	Barthes	anne.barthes@bem.fr	1970-01-30	2000-01-10	0648375840	2
6	Carole	Paul	carole.paul@bem.fr	1975-01-13	2000-01-14	0164264348	3
\.


--
-- Name: conseiller_id_pers_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('conseiller_id_pers_seq', 7, true);


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

COPY param_agios (id_agios, begin_mt, last_mt, nb_days, rate_agios, id_cat) FROM stdin;
352	12	13	14	15	10
355	10	32	2	19	10
\.


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

COPY person (id_pers, first_name, name) FROM stdin;
1	Baptiste            	SARDA
2	Van                 	DUONG
3	Zouhair             	HAJJI
4	Baptiste            	SARDA
5	Mouna               	Izouggarhan
6	Florian             	LESGUER
7	Coline              	MARIN
8	Aicha               	DIOP
9	Anthony             	PERAULT
10	Jacques             	PAUL
\.


--
-- Name: seq_id_param; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('seq_id_param', 8, true);


--
-- Name: seq_id_wk; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('seq_id_wk', 40, true);


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

COPY status (id_status, name_status, slice_top, slice_low, alert_type, banktransfer, overdraft) FROM stdin;
5	Cadre supérieur	10000	5000	Message	1250	1500
4	Cadre	5000	2500	Message	500	750
8	Très grande fortune	10000000	100000	Appel	15250	15000
6	Fortune	50000	10000	Appel	5000	7500
10	Inactif/Etudaint	800	0	SMS	100	50
3	Actif supérieur	2500	1500	Message	270	250
7	Grande fortune	50000	100000	Appel	15250	15000
12	Actif	1500	800	Message	150	100
\.


--
-- Name: status_id_status_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('status_id_status_seq', 12, true);


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

COPY workgroup (id_workgroup, id_categorie, name) FROM stdin;
31	1	Cadre-1
32	1	Cadre-2
33	2	Fortune-2
\.


--
-- Name: PARAM_AGIOS_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY param_agios
    ADD CONSTRAINT "PARAM_AGIOS_pkey" PRIMARY KEY (id_agios);


--
-- Name: PERSON_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY person
    ADD CONSTRAINT "PERSON_pkey" PRIMARY KEY (id_pers);


--
-- Name: client_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY client
    ADD CONSTRAINT client_pkey PRIMARY KEY (id_client);


--
-- Name: pk_id; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY conseiller
    ADD CONSTRAINT pk_id PRIMARY KEY (id_pers);


--
-- Name: status_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY status
    ADD CONSTRAINT status_pkey PRIMARY KEY (id_status);


--
-- Name: workgroup_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY workgroup
    ADD CONSTRAINT workgroup_pkey PRIMARY KEY (id_workgroup);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--