--
-- PostgreSQL database dump
--

-- Dumped from database version 12.5
-- Dumped by pg_dump version 13.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;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: address; Type: TABLE; Schema: public; Owner: burrowh
--

CREATE TABLE public.address (
    housenumorname character varying(50) NOT NULL,
    streetname1 character varying(50) NOT NULL,
    streetname2 character varying(50) NOT NULL,
    townorcity character varying(50) NOT NULL,
    post_code character varying(50) NOT NULL,
    licenceid bigint NOT NULL,
    registrationid character varying(50) NOT NULL
);


ALTER TABLE public.address OWNER TO burrowh;

--
-- Name: address_licenceid_seq; Type: SEQUENCE; Schema: public; Owner: burrowh
--

CREATE SEQUENCE public.address_licenceid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.address_licenceid_seq OWNER TO burrowh;

--
-- Name: address_licenceid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: burrowh
--

ALTER SEQUENCE public.address_licenceid_seq OWNED BY public.address.licenceid;


--
-- Name: driver; Type: TABLE; Schema: public; Owner: burrowh
--

CREATE TABLE public.driver (
    licenceid bigint NOT NULL,
    first_name character varying(50) NOT NULL,
    last_name character varying(50) NOT NULL,
    email character varying(50) NOT NULL,
    phone character varying(50),
    CONSTRAINT licenceid_constraint CHECK ((licenceid > 0))
);


ALTER TABLE public.driver OWNER TO burrowh;

--
-- Name: driver_licenceid_seq; Type: SEQUENCE; Schema: public; Owner: burrowh
--

CREATE SEQUENCE public.driver_licenceid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.driver_licenceid_seq OWNER TO burrowh;

--
-- Name: driver_licenceid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: burrowh
--

ALTER SEQUENCE public.driver_licenceid_seq OWNED BY public.driver.licenceid;


--
-- Name: vehicle; Type: TABLE; Schema: public; Owner: burrowh
--

CREATE TABLE public.vehicle (
    registrationid character varying(20) NOT NULL,
    manufacturer character varying(20) NOT NULL,
    model character varying(20) NOT NULL,
    transmission character varying(10) NOT NULL,
    fuel_type character varying(10) NOT NULL,
    year integer NOT NULL,
    colour character varying(20) NOT NULL,
    licenceid bigint NOT NULL,
    CONSTRAINT year_constraint CHECK ((year > 1940)),
    CONSTRAINT year_constraint2 CHECK ((year < 2022))
);


ALTER TABLE public.vehicle OWNER TO burrowh;

--
-- Name: vehicle_licenceid_seq; Type: SEQUENCE; Schema: public; Owner: burrowh
--

CREATE SEQUENCE public.vehicle_licenceid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vehicle_licenceid_seq OWNER TO burrowh;

--
-- Name: vehicle_licenceid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: burrowh
--

ALTER SEQUENCE public.vehicle_licenceid_seq OWNED BY public.vehicle.licenceid;


--
-- Name: vehicle_registrationid_seq; Type: SEQUENCE; Schema: public; Owner: burrowh
--

CREATE SEQUENCE public.vehicle_registrationid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vehicle_registrationid_seq OWNER TO burrowh;

--
-- Name: vehicle_registrationid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: burrowh
--

ALTER SEQUENCE public.vehicle_registrationid_seq OWNED BY public.vehicle.registrationid;


--
-- Name: vehicle_tax; Type: TABLE; Schema: public; Owner: burrowh
--

CREATE TABLE public.vehicle_tax (
    tax_expiry date NOT NULL,
    last_tax_date date NOT NULL,
    sorn boolean NOT NULL,
    taxid bigint NOT NULL,
    registrationid character varying(50),
    CONSTRAINT taxid_constraint CHECK ((taxid > 0))
);


ALTER TABLE public.vehicle_tax OWNER TO burrowh;

--
-- Name: vehicle_tax_taxid_seq; Type: SEQUENCE; Schema: public; Owner: burrowh
--

CREATE SEQUENCE public.vehicle_tax_taxid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vehicle_tax_taxid_seq OWNER TO burrowh;

--
-- Name: vehicle_tax_taxid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: burrowh
--

ALTER SEQUENCE public.vehicle_tax_taxid_seq OWNED BY public.vehicle_tax.taxid;


--
-- Name: address licenceid; Type: DEFAULT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.address ALTER COLUMN licenceid SET DEFAULT nextval('public.address_licenceid_seq'::regclass);


--
-- Name: driver licenceid; Type: DEFAULT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.driver ALTER COLUMN licenceid SET DEFAULT nextval('public.driver_licenceid_seq'::regclass);


--
-- Name: vehicle registrationid; Type: DEFAULT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle ALTER COLUMN registrationid SET DEFAULT nextval('public.vehicle_registrationid_seq'::regclass);


--
-- Name: vehicle licenceid; Type: DEFAULT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle ALTER COLUMN licenceid SET DEFAULT nextval('public.vehicle_licenceid_seq'::regclass);


--
-- Name: vehicle_tax taxid; Type: DEFAULT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle_tax ALTER COLUMN taxid SET DEFAULT nextval('public.vehicle_tax_taxid_seq'::regclass);


--
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: burrowh
--

COPY public.address (housenumorname, streetname1, streetname2, townorcity, post_code, licenceid, registrationid) FROM stdin;
21	Kinley	Street	Swansea	SA18HE	2	HEB12346
21	Kinley	Street	Swansea	SA18HE	109468	LMH12346
40	Hafod	Street	Swansea	SA10NE	181364656	CEF123567
13	Pantycelyn	Heol	Llanelli	SA149BS	186569451	VVA123478
\.


--
-- Data for Name: driver; Type: TABLE DATA; Schema: public; Owner: burrowh
--

COPY public.driver (licenceid, first_name, last_name, email, phone) FROM stdin;
127326577	Theadora	Tregien	ttregienp@macromedia.com	\N
168125069	Gennie	Gever	ggeverq@springer.com	\N
164195170	Orrin	Goolden	ogooldenr@netlog.com	\N
145150257	Donn	Corse	dcorses@bigcartel.com	\N
132219232	Kaycee	Anneslie	kannesliet@bloomberg.com	\N
194346361	Orelee	Jakobssen	ojakobssenu@sbwire.com	\N
183952857	Hayes	Freear	hfreearv@hc360.com	\N
146374923	Everard	Snasel	esnaselw@meetup.com	\N
124756177	Reese	Klempke	rklempkex@nytimes.com	\N
195726690	Manon	Zisneros	mzisnerosy@geocities.jp	\N
135824169	Munmro	Keyhoe	mkeyhoez@tinyurl.com	\N
197384021	Brigg	Dufaur	bdufaur10@altervista.org	\N
133392209	Paloma	Hemshall	phemshall11@dion.ne.jp	\N
192898098	Myrna	Powder	mpowder12@si.edu	\N
144871522	Deloria	Linebarger	dlinebarger13@i2i.jp	\N
182621330	Emmi	Tong	etong14@forbes.com	\N
186569451	Vinita	Vannikov	vvannikov15@mit.edu	\N
160961147	Orelle	Steddall	osteddall17@arizona.edu	\N
174810339	Abbot	Wagerfield	awagerfield18@oracle.com	\N
166118350	Timmie	Jennery	tjennery19@accuweather.com	\N
148466435	Cassius	Hutchings	chutchings1a@godaddy.com	\N
190439667	Mignon	Olexa	molexa1b@biglobe.ne.jp	\N
126184730	Alyse	Gelder	agelder1c@prweb.com	\N
136825566	Dana	Pittendreigh	dpittendreigh1d@bing.com	\N
144647415	Averil	Bains	abains1e@howstuffworks.com	\N
146333566	Oralee	Booley	obooley1f@mashable.com	\N
165656155	Elena	Macguire	emacguire1g@businesswire.com	\N
164231487	Dania	Colling	dcolling1h@51.la	\N
140836497	Milli	Phelip	mphelip1i@geocities.com	\N
157066824	Tedi	Bedder	tbedder1j@paginegialle.it	\N
181458895	Clio	MacRedmond	cmacredmond1k@unicef.org	\N
152063291	Camilla	McElrath	cmcelrath1l@sogou.com	\N
154713658	Bevin	Beckford	bbeckford1m@irs.gov	\N
124169528	Bernadina	Sargant	bsargant1n@shareasale.com	\N
197221736	Johnathon	Soughton	jsoughton1o@google.ca	\N
137260936	Barri	Baroc	bbaroc1p@timesonline.co.uk	\N
163748237	Skye	Hindenberger	shindenberger1q@blogs.com	\N
137622098	Maxie	O'Doireidh	modoireidh1r@alibaba.com	\N
160148849	Roland	Zorzi	rzorzi1t@mac.com	\N
190517014	Geoffry	Rymell	grymell1u@feedburner.com	\N
161364432	Markos	Speare	mspeare1v@yellowbook.com	\N
128353210	Charity	Bromfield	cbromfield1w@kickstarter.com	\N
165969266	Vikki	Trow	vtrow1x@oakley.com	\N
152800137	Arnuad	Tempest	atempest1y@de.vu	\N
168120984	John	Klass	sklass16@tiny.cc	\N
169426909	Fiorenze	Plaster	fplaster1z@chronoengine.com	\N
160140403	Jaquelin	Delhay	jdelhay20@bluehost.com	\N
185268620	Stearn	Fallowfield	sfallowfield21@blogs.com	\N
177100027	Cherye	Schaumann	cschaumann22@hibu.com	\N
123800435	Mannie	Bulluck	mbulluck23@tuttocitta.it	\N
180541675	Tansy	Birchall	tbirchall24@utexas.edu	\N
193203207	Gradeigh	Kinnach	gkinnach25@weibo.com	\N
124579040	Andra	Ivanyutin	aivanyutin26@blogtalkradio.com	\N
167939559	Lesley	Juliano	ljuliano27@economist.com	\N
181364656	Candice	Effemy	ceffemy28@hud.gov	\N
133105785	Mischa	Farris	mfarris29@house.gov	\N
138566252	Beryle	Ferby	bferby2a@yahoo.co.jp	\N
131543848	Saunder	Deering	sdeering2b@reuters.com	\N
142915157	Toma	Raggles	traggles2c@github.com	\N
129320268	Mose	Feldon	mfeldon2d@patch.com	\N
174954835	Sheilakathryn	Bamling	sbamling2f@usatoday.com	\N
168439845	Tessie	Izhak	tizhak2g@independent.co.uk	\N
187420078	Ollie	Chappelle	ochappelle2h@stanford.edu	\N
160346551	Rozalie	de Werk	rdewerk2i@nyu.edu	\N
145224578	Berget	McConnachie	bmcconnachie2j@wikia.com	\N
168135153	Karlis	Okeshott	kokeshott2k@oakley.com	\N
183691801	Stella	Lohmeyer	slohmeyer2l@prlog.org	\N
156987558	Starr	Ockendon	sockendon2m@creativecommons.org	\N
125469312	Abdul	Nunson	anunson2n@lulu.com	\N
180127045	Edgar	Buard	ebuard2o@fastcompany.com	\N
131865816	Zorine	Nevison	znevison2p@photobucket.com	\N
173527264	Thelma	Pinyon	tpinyon2q@jigsy.com	\N
174444447	Carmencita	Philott	cphilott2r@spiegel.de	\N
109468	Lwin	Htun	lhtun@weather.com	\N
2	Harley	Burrow	he.burrow@yahoo.co.uk	0794037928
19877432	John	Petrucci	PetrucciJ@gmail.com	39874543
19877433	Jordan	Ruddess	RuddesJ@gmail.com	06944383
19877434	Mike	Portnoy	PortnoyM@gmail.com	3095745
19877435	John	Myung	MyungJ@gmail.com	34987345
19877436	James	Labrie	labrieJ@gmail.com	34097834
4566746	Jacob	Davies	Jdavies@gmail.com	047548975
\.


--
-- Data for Name: vehicle; Type: TABLE DATA; Schema: public; Owner: burrowh
--

COPY public.vehicle (registrationid, manufacturer, model, transmission, fuel_type, year, colour, licenceid) FROM stdin;
HEB12346	Hummer	H1	Automatic	Petrol	2006	Yellow	2
LMH12346	Ford	Mustang	Manual	Petrol	1969	Cherry Red	109468
CEF123567	Ford	Focus	Manual	Petrol	2015	Blue	181364656
VVA123478	Toyota	Yaris	Manual	Diesel	2013	Red	186569451
CHU123467	Toyota	Supra	Automatic	Disel	1999	Black	148466435
JPDT12356	Lambourghini	Diablo	Manual	Petrol	1997	Yellow	19877432
JRUD13874	Ferrari	360Spyder	Manual	Petrol	2003	White	19877433
P0RTN0Y5	Lotus	Elise	Manual	Diesel	2005	Orange	19877434
MYN48753	Mclaren	F1-GTR	Manual	Diesel	2010	Silver	19877435
LABR13	Bugatti	Veyron	Manual	Petrol	2012	Orange	19877436
HEB12999	Ferrari	F8	Manual	Petrol	2018	Red	2
\.


--
-- Data for Name: vehicle_tax; Type: TABLE DATA; Schema: public; Owner: burrowh
--

COPY public.vehicle_tax (tax_expiry, last_tax_date, sorn, taxid, registrationid) FROM stdin;
2021-06-06	2021-01-01	f	987123	HEB12346
2020-06-06	2020-01-01	t	987124	LMH12346
2021-01-02	2020-06-07	f	987125	CEF123567
2021-01-16	2020-08-16	f	987126	VVA123478
2021-01-19	2020-08-01	f	987127	LABR13
2021-02-10	2020-08-01	f	987128	MYN48753
2021-02-13	2020-08-01	f	9987543	JPDT12356
\.


--
-- Name: address_licenceid_seq; Type: SEQUENCE SET; Schema: public; Owner: burrowh
--

SELECT pg_catalog.setval('public.address_licenceid_seq', 1, false);


--
-- Name: driver_licenceid_seq; Type: SEQUENCE SET; Schema: public; Owner: burrowh
--

SELECT pg_catalog.setval('public.driver_licenceid_seq', 2, true);


--
-- Name: vehicle_licenceid_seq; Type: SEQUENCE SET; Schema: public; Owner: burrowh
--

SELECT pg_catalog.setval('public.vehicle_licenceid_seq', 1, true);


--
-- Name: vehicle_registrationid_seq; Type: SEQUENCE SET; Schema: public; Owner: burrowh
--

SELECT pg_catalog.setval('public.vehicle_registrationid_seq', 1, false);


--
-- Name: vehicle_tax_taxid_seq; Type: SEQUENCE SET; Schema: public; Owner: burrowh
--

SELECT pg_catalog.setval('public.vehicle_tax_taxid_seq', 1, false);


--
-- Name: address address_pkey; Type: CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.address
    ADD CONSTRAINT address_pkey PRIMARY KEY (licenceid, registrationid);


--
-- Name: driver driver_pkey; Type: CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.driver
    ADD CONSTRAINT driver_pkey PRIMARY KEY (licenceid);


--
-- Name: vehicle_tax not_null; Type: CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle_tax
    ADD CONSTRAINT not_null UNIQUE (registrationid);


--
-- Name: vehicle vehicle_pkey; Type: CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle
    ADD CONSTRAINT vehicle_pkey PRIMARY KEY (registrationid);


--
-- Name: vehicle_tax vehicle_tax_pkey; Type: CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle_tax
    ADD CONSTRAINT vehicle_tax_pkey PRIMARY KEY (taxid);


--
-- Name: address address_licenceid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.address
    ADD CONSTRAINT address_licenceid_fkey FOREIGN KEY (licenceid) REFERENCES public.driver(licenceid);


--
-- Name: address address_registrationid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.address
    ADD CONSTRAINT address_registrationid_fkey FOREIGN KEY (registrationid) REFERENCES public.vehicle(registrationid);


--
-- Name: vehicle vehicle_licenceid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle
    ADD CONSTRAINT vehicle_licenceid_fkey FOREIGN KEY (licenceid) REFERENCES public.driver(licenceid);


--
-- Name: vehicle_tax vehicle_tax_registrationid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: burrowh
--

ALTER TABLE ONLY public.vehicle_tax
    ADD CONSTRAINT vehicle_tax_registrationid_fkey FOREIGN KEY (registrationid) REFERENCES public.vehicle(registrationid);


--
-- PostgreSQL database dump complete
--

