wehub-resource-sync
267 lines
6.4 KiB
SQL
267 lines
6.4 KiB
SQL
-- Downloaded from: https://github.com/A-lang209/Salon-Appointment-Scheduler/blob/65664c1eca91624676853a6b56a8db25e807ed7c/salon.sql
|
|
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
-- Dumped from database version 12.17 (Ubuntu 12.17-1.pgdg22.04+1)
|
|
-- Dumped by pg_dump version 12.17 (Ubuntu 12.17-1.pgdg22.04+1)
|
|
|
|
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;
|
|
|
|
DROP DATABASE salon;
|
|
--
|
|
-- Name: salon; Type: DATABASE; Schema: -; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE DATABASE salon WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C.UTF-8' LC_CTYPE = 'C.UTF-8';
|
|
|
|
|
|
ALTER DATABASE salon OWNER TO freecodecamp;
|
|
|
|
\connect salon
|
|
|
|
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: appointments; Type: TABLE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE TABLE public.appointments (
|
|
appointment_id integer NOT NULL,
|
|
"time" character varying(255),
|
|
service_id integer,
|
|
customer_id integer
|
|
);
|
|
|
|
|
|
ALTER TABLE public.appointments OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: appointments_appointment_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE SEQUENCE public.appointments_appointment_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.appointments_appointment_id_seq OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: appointments_appointment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER SEQUENCE public.appointments_appointment_id_seq OWNED BY public.appointments.appointment_id;
|
|
|
|
|
|
--
|
|
-- Name: customers; Type: TABLE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE TABLE public.customers (
|
|
customer_id integer NOT NULL,
|
|
phone character varying(30),
|
|
name character varying(255)
|
|
);
|
|
|
|
|
|
ALTER TABLE public.customers OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: customers_customer_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE SEQUENCE public.customers_customer_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.customers_customer_id_seq OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: customers_customer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER SEQUENCE public.customers_customer_id_seq OWNED BY public.customers.customer_id;
|
|
|
|
|
|
--
|
|
-- Name: services; Type: TABLE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE TABLE public.services (
|
|
service_id integer NOT NULL,
|
|
name character varying(255)
|
|
);
|
|
|
|
|
|
ALTER TABLE public.services OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: services_service_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
CREATE SEQUENCE public.services_service_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
ALTER TABLE public.services_service_id_seq OWNER TO freecodecamp;
|
|
|
|
--
|
|
-- Name: services_service_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER SEQUENCE public.services_service_id_seq OWNED BY public.services.service_id;
|
|
|
|
|
|
--
|
|
-- Name: appointments appointment_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.appointments ALTER COLUMN appointment_id SET DEFAULT nextval('public.appointments_appointment_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Name: customers customer_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.customers ALTER COLUMN customer_id SET DEFAULT nextval('public.customers_customer_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Name: services service_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.services ALTER COLUMN service_id SET DEFAULT nextval('public.services_service_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- Data for Name: appointments; Type: TABLE DATA; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
|
|
|
|
--
|
|
-- Data for Name: services; Type: TABLE DATA; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
INSERT INTO public.services VALUES (1, 'Haircut');
|
|
INSERT INTO public.services VALUES (2, 'Shave');
|
|
INSERT INTO public.services VALUES (3, 'Pedicure');
|
|
|
|
|
|
--
|
|
-- Name: appointments_appointment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.appointments_appointment_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: customers_customer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.customers_customer_id_seq', 1, false);
|
|
|
|
|
|
--
|
|
-- Name: services_service_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
SELECT pg_catalog.setval('public.services_service_id_seq', 3, true);
|
|
|
|
|
|
--
|
|
-- Name: appointments appointments_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.appointments
|
|
ADD CONSTRAINT appointments_pkey PRIMARY KEY (appointment_id);
|
|
|
|
|
|
--
|
|
-- Name: customers customers_phone_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.customers
|
|
ADD CONSTRAINT customers_phone_key UNIQUE (phone);
|
|
|
|
|
|
--
|
|
-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.customers
|
|
ADD CONSTRAINT customers_pkey PRIMARY KEY (customer_id);
|
|
|
|
|
|
--
|
|
-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.services
|
|
ADD CONSTRAINT services_pkey PRIMARY KEY (service_id);
|
|
|
|
|
|
--
|
|
-- Name: appointments appointment_customer; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.appointments
|
|
ADD CONSTRAINT appointment_customer FOREIGN KEY (customer_id) REFERENCES public.customers(customer_id);
|
|
|
|
|
|
--
|
|
-- Name: appointments appointment_service; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
|
|
--
|
|
|
|
ALTER TABLE ONLY public.appointments
|
|
ADD CONSTRAINT appointment_service FOREIGN KEY (service_id) REFERENCES public.services(service_id);
|
|
|
|
|
|
--
|
|
-- PostgreSQL database dump complete
|
|
--
|
|
|