API tools faq
paste
Advertisement
Guest User

BDD stricar

a guest
May 20th, 2019
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 9.46 KB | None | 0 0
raw download clone embed print report
  1. --
  2. -- Name: Avis; Type: TABLE; Schema: public; Owner: stricar
  3. --
  4.  
  5. CREATE TABLE public."Avis" (
  6.     id_avis integer NOT NULL,
  7.     note integer NOT NULL,
  8.     commentaire character varying(500) NOT NULL,
  9.     date_avis date NOT NULL,
  10.     heure_avis time without time zone NOT NULL,
  11.     id_salarie_donneur character varying(6) NOT NULL,
  12.     id_salarie_receveur character varying(6) NOT NULL,
  13.     id_trajet integer NOT NULL
  14. );
  15.  
  16.  
  17. ALTER TABLE public."Avis" OWNER TO stricar;
  18.  
  19. --
  20. -- Name: Avis_id_avis_seq; Type: SEQUENCE; Schema: public; Owner: stricar
  21. --
  22.  
  23. CREATE SEQUENCE public."Avis_id_avis_seq"
  24.     AS integer
  25.     START WITH 1
  26.     INCREMENT BY 1
  27.     NO MINVALUE
  28.     NO MAXVALUE
  29.     CACHE 1;
  30.  
  31.  
  32. ALTER TABLE public."Avis_id_avis_seq" OWNER TO stricar;
  33.  
  34. --
  35. -- Name: Avis_id_avis_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: stricar
  36. --
  37.  
  38. ALTER SEQUENCE public."Avis_id_avis_seq" OWNED BY public."Avis".id_avis;
  39.  
  40.  
  41. --
  42. -- Name: Compte; Type: TABLE; Schema: public; Owner: stricar
  43. --
  44.  
  45. CREATE TABLE public."Compte" (
  46.     id_salarie character varying(6) NOT NULL,
  47.     nom_compte character varying(50) NOT NULL,
  48.     mot_de_passe character varying(20) NOT NULL,
  49.     contrat character varying(50) NOT NULL,
  50.     admin boolean DEFAULT false NOT NULL,
  51.     mail character varying(80) NOT NULL,
  52.     num_tel character varying(10) NOT NULL,
  53.     prime double precision DEFAULT 0 NOT NULL,
  54.     prenom_compte character varying(50) NOT NULL,
  55.     desactive boolean DEFAULT false NOT NULL
  56. );
  57.  
  58.  
  59. ALTER TABLE public."Compte" OWNER TO stricar;
  60.  
  61. --
  62. -- Name: Compte_id_salarie_seq; Type: SEQUENCE; Schema: public; Owner: stricar
  63. --
  64.  
  65. CREATE SEQUENCE public."Compte_id_salarie_seq"
  66.     AS integer
  67.     START WITH 1
  68.     INCREMENT BY 1
  69.     NO MINVALUE
  70.     NO MAXVALUE
  71.     CACHE 1;
  72.  
  73.  
  74. ALTER TABLE public."Compte_id_salarie_seq" OWNER TO stricar;
  75.  
  76. --
  77. -- Name: Compte_id_salarie_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: stricar
  78. --
  79.  
  80. ALTER SEQUENCE public."Compte_id_salarie_seq" OWNED BY public."Compte".id_salarie;
  81.  
  82.  
  83. --
  84. -- Name: Depart; Type: TABLE; Schema: public; Owner: stricar
  85. --
  86.  
  87. CREATE TABLE public."Depart" (
  88.     id_trajet_dep integer NOT NULL,
  89.     id_site_dep integer NOT NULL
  90. );
  91.  
  92.  
  93. ALTER TABLE public."Depart" OWNER TO stricar;
  94.  
  95. --
  96. -- Name: Passager; Type: TABLE; Schema: public; Owner: stricar
  97. --
  98.  
  99. CREATE TABLE public."Passager" (
  100.     id_trajet integer NOT NULL,
  101.     id_salarie character varying(6) NOT NULL
  102. );
  103.  
  104.  
  105. ALTER TABLE public."Passager" OWNER TO stricar;
  106.  
  107. --
  108. -- Name: Passager_id_salarie_seq; Type: SEQUENCE; Schema: public; Owner: stricar
  109. --
  110.  
  111. CREATE SEQUENCE public."Passager_id_salarie_seq"
  112.     AS integer
  113.     START WITH 1
  114.     INCREMENT BY 1
  115.     NO MINVALUE
  116.     NO MAXVALUE
  117.     CACHE 1;
  118.  
  119.  
  120. ALTER TABLE public."Passager_id_salarie_seq" OWNER TO stricar;
  121.  
  122. --
  123. -- Name: Passager_id_salarie_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: stricar
  124. --
  125.  
  126. ALTER SEQUENCE public."Passager_id_salarie_seq" OWNED BY public."Passager".id_salarie;
  127.  
  128.  
  129. --
  130. -- Name: Passager_id_trajet_seq; Type: SEQUENCE; Schema: public; Owner: stricar
  131. --
  132.  
  133. CREATE SEQUENCE public."Passager_id_trajet_seq"
  134.     AS integer
  135.     START WITH 1
  136.     INCREMENT BY 1
  137.     NO MINVALUE
  138.     NO MAXVALUE
  139.     CACHE 1;
  140.  
  141.  
  142. ALTER TABLE public."Passager_id_trajet_seq" OWNER TO stricar;
  143.  
  144. --
  145. -- Name: Passager_id_trajet_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: stricar
  146. --
  147.  
  148. ALTER SEQUENCE public."Passager_id_trajet_seq" OWNED BY public."Passager".id_trajet;
  149.  
  150.  
  151. --
  152. -- Name: Site; Type: TABLE; Schema: public; Owner: stricar
  153. --
  154.  
  155. CREATE TABLE public."Site" (
  156.     nom_site character varying(50) NOT NULL,
  157.     adresse character varying(50) NOT NULL
  158. );
  159.  
  160.  
  161. ALTER TABLE public."Site" OWNER TO stricar;
  162.  
  163. --
  164. -- Name: Trajet; Type: TABLE; Schema: public; Owner: stricar
  165. --
  166.  
  167. CREATE TABLE public."Trajet" (
  168.     id_trajet integer NOT NULL,
  169.     vehicule character varying(10) NOT NULL,
  170.     nombre_passagers integer NOT NULL,
  171.     musique boolean DEFAULT false NOT NULL,
  172.     fumeur boolean DEFAULT false NOT NULL,
  173.     bavard boolean DEFAULT false NOT NULL,
  174.     date_trajet date NOT NULL,
  175.     heure_trajet time without time zone NOT NULL,
  176.     id_conducteur character varying(6) NOT NULL,
  177.     id_site character varying NOT NULL,
  178.     id_site_arrive character varying NOT NULL,
  179.     annule boolean DEFAULT false NOT NULL
  180. );
  181.  
  182.  
  183. ALTER TABLE public."Trajet" OWNER TO stricar;
  184.  
  185. --
  186. -- Name: Trajet_id_trajet_seq; Type: SEQUENCE; Schema: public; Owner: stricar
  187. --
  188.  
  189. CREATE SEQUENCE public."Trajet_id_trajet_seq"
  190.     AS integer
  191.     START WITH 1
  192.     INCREMENT BY 1
  193.     NO MINVALUE
  194.     NO MAXVALUE
  195.     CACHE 1;
  196.  
  197.  
  198. ALTER TABLE public."Trajet_id_trajet_seq" OWNER TO stricar;
  199.  
  200. --
  201. -- Name: Trajet_id_trajet_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: stricar
  202. --
  203.  
  204. ALTER SEQUENCE public."Trajet_id_trajet_seq" OWNED BY public."Trajet".id_trajet;
  205.  
  206.  
  207. --
  208. -- Name: Avis id_avis; Type: DEFAULT; Schema: public; Owner: stricar
  209. --
  210.  
  211. ALTER TABLE ONLY public."Avis" ALTER COLUMN id_avis SET DEFAULT nextval('public."Avis_id_avis_seq"'::regclass);
  212.  
  213.  
  214. --
  215. -- Name: Passager id_trajet; Type: DEFAULT; Schema: public; Owner: stricar
  216. --
  217.  
  218. ALTER TABLE ONLY public."Passager" ALTER COLUMN id_trajet SET DEFAULT nextval('public."Passager_id_trajet_seq"'::regclass);
  219.  
  220.  
  221. --
  222. -- Name: Trajet id_trajet; Type: DEFAULT; Schema: public; Owner: stricar
  223. --
  224.  
  225. ALTER TABLE ONLY public."Trajet" ALTER COLUMN id_trajet SET DEFAULT nextval('public."Trajet_id_trajet_seq"'::regclass);
  226.  
  227.  
  228. --
  229. -- Name: Avis Avis_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  230. --
  231.  
  232. ALTER TABLE ONLY public."Avis"
  233.     ADD CONSTRAINT "Avis_pkey" PRIMARY KEY (id_avis);
  234.  
  235.  
  236. --
  237. -- Name: Compte Compte_id_salarie_key; Type: CONSTRAINT; Schema: public; Owner: stricar
  238. --
  239.  
  240. ALTER TABLE ONLY public."Compte"
  241.     ADD CONSTRAINT "Compte_id_salarie_key" UNIQUE (id_salarie);
  242.  
  243.  
  244. --
  245. -- Name: Compte Compte_mail_num_tel_key; Type: CONSTRAINT; Schema: public; Owner: stricar
  246. --
  247.  
  248. ALTER TABLE ONLY public."Compte"
  249.     ADD CONSTRAINT "Compte_mail_num_tel_key" UNIQUE (mail, num_tel);
  250.  
  251.  
  252. --
  253. -- Name: Compte Compte_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  254. --
  255.  
  256. ALTER TABLE ONLY public."Compte"
  257.     ADD CONSTRAINT "Compte_pkey" PRIMARY KEY (id_salarie);
  258.  
  259.  
  260. --
  261. -- Name: Depart Depart_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  262. --
  263.  
  264. ALTER TABLE ONLY public."Depart"
  265.     ADD CONSTRAINT "Depart_pkey" PRIMARY KEY (id_site_dep, id_trajet_dep);
  266.  
  267.  
  268. --
  269. -- Name: Passager Passager_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  270. --
  271.  
  272. ALTER TABLE ONLY public."Passager"
  273.     ADD CONSTRAINT "Passager_pkey" PRIMARY KEY (id_trajet, id_salarie);
  274.  
  275.  
  276. --
  277. -- Name: Site Site_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  278. --
  279.  
  280. ALTER TABLE ONLY public."Site"
  281.     ADD CONSTRAINT "Site_pkey" PRIMARY KEY (nom_site);
  282.  
  283.  
  284. --
  285. -- Name: Trajet Trajet_pkey; Type: CONSTRAINT; Schema: public; Owner: stricar
  286. --
  287.  
  288. ALTER TABLE ONLY public."Trajet"
  289.     ADD CONSTRAINT "Trajet_pkey" PRIMARY KEY (id_trajet);
  290.  
  291.  
  292. --
  293. -- Name: fki_id_site_dep; Type: INDEX; Schema: public; Owner: stricar
  294. --
  295.  
  296. CREATE INDEX fki_id_site_dep ON public."Depart" USING btree (id_site_dep);
  297.  
  298.  
  299. --
  300. -- Name: fki_id_trajet_dep; Type: INDEX; Schema: public; Owner: stricar
  301. --
  302.  
  303. CREATE INDEX fki_id_trajet_dep ON public."Depart" USING btree (id_trajet_dep);
  304.  
  305.  
  306. --
  307. -- Name: Avis Avis_Trajet1; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  308. --
  309.  
  310. ALTER TABLE ONLY public."Avis"
  311.     ADD CONSTRAINT "Avis_Trajet1" FOREIGN KEY (id_trajet) REFERENCES public."Trajet"(id_trajet);
  312.  
  313.  
  314. --
  315. -- Name: Avis Avis_id_salarie_compte_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  316. --
  317.  
  318. ALTER TABLE ONLY public."Avis"
  319.     ADD CONSTRAINT "Avis_id_salarie_compte_fkey" FOREIGN KEY (id_salarie_receveur) REFERENCES public."Compte"(id_salarie);
  320.  
  321.  
  322. --
  323. -- Name: Avis Avis_id_salarie_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  324. --
  325.  
  326. ALTER TABLE ONLY public."Avis"
  327.     ADD CONSTRAINT "Avis_id_salarie_fkey" FOREIGN KEY (id_salarie_donneur) REFERENCES public."Compte"(id_salarie);
  328.  
  329.  
  330. --
  331. -- Name: Passager Passager_Trajet; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  332. --
  333.  
  334. ALTER TABLE ONLY public."Passager"
  335.     ADD CONSTRAINT "Passager_Trajet" FOREIGN KEY (id_trajet) REFERENCES public."Trajet"(id_trajet);
  336.  
  337.  
  338. --
  339. -- Name: Passager Passager_id_salarie_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  340. --
  341.  
  342. ALTER TABLE ONLY public."Passager"
  343.     ADD CONSTRAINT "Passager_id_salarie_fkey" FOREIGN KEY (id_salarie) REFERENCES public."Compte"(id_salarie);
  344.  
  345.  
  346. --
  347. -- Name: Trajet Trajet_id_conducteur_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  348. --
  349.  
  350. ALTER TABLE ONLY public."Trajet"
  351.     ADD CONSTRAINT "Trajet_id_conducteur_fkey" FOREIGN KEY (id_conducteur) REFERENCES public."Compte"(id_salarie);
  352.  
  353.  
  354. --
  355. -- Name: Trajet Trajet_id_site_arrive_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  356. --
  357.  
  358. ALTER TABLE ONLY public."Trajet"
  359.     ADD CONSTRAINT "Trajet_id_site_arrive_fkey" FOREIGN KEY (id_site_arrive) REFERENCES public."Site"(nom_site);
  360.  
  361.  
  362. --
  363. -- Name: Trajet Trajet_id_site_fkey; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  364. --
  365.  
  366. ALTER TABLE ONLY public."Trajet"
  367.     ADD CONSTRAINT "Trajet_id_site_fkey" FOREIGN KEY (id_site) REFERENCES public."Site"(nom_site);
  368.  
  369.  
  370. --
  371. -- Name: Depart id_trajet_dep; Type: FK CONSTRAINT; Schema: public; Owner: stricar
  372. --
  373.  
  374. ALTER TABLE ONLY public."Depart"
  375.     ADD CONSTRAINT id_trajet_dep FOREIGN KEY (id_trajet_dep) REFERENCES public."Trajet"(id_trajet);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!