Skill 02 / 03

SQL & PostgreSQL

Two database schemas drawn from their SQL files, and the queries of a Bash script.

SQL, PostgreSQL and Bash(verified)

marks a verified skill

Overview

Two freeCodeCamp database projects, from my public repositories: a PostgreSQL schema of galaxies, stars, planets and moons, and a salon appointment scheduler written in Bash on top of psql. The diagrams are drawn from the SQL files themselves.

Claim
SQL, PostgreSQL and Bash
✓ Verified
Evidence
- freeCodeCamp: Relational Database · freecodecamp · checked 29 September 2026Issued 27 Sep 2026. Checked on the public freeCodeCamp API.
- freeCodeCamp: Relational Database V8 · freecodecamp · checked 29 September 2026Issued 26 Sep 2026. Checked on the public freeCodeCamp API.
- celestial-bodies-database · github · checked 28 September 2026PostgreSQL database project (freeCodeCamp).
- salon-appointment-scheduler · github · checked 28 September 2026Bash + SQL appointment scheduler (freeCodeCamp).
- Celestial bodies database: the whole SQL file (universe.sql, lines 1–464) · manual · checked 2 October 2026From commit c2b1392 (18 Sep 2026) by zurukzuruk1 in the celestial-bodies-database repository. Copied whole on 02/10/2026 (line endings normalised).
- Salon appointment scheduler: the whole SQL file (salon.sql, lines 1–267) · manual · checked 2 October 2026From commit 5c04648 (25 Sep 2026) by zurukzuruk1 in the salon-appointment-scheduler repository. Copied whole on 02/10/2026 (line endings normalised).
- Salon appointment scheduler: the query lines of the script (salon.sh, lines 14–57) · manual · checked 2 October 2026From commit 5c04648 (25 Sep 2026) by zurukzuruk1 in the salon-appointment-scheduler repository. Copied verbatim on 02/10/2026 (line endings normalised).
Result
Two freeCodeCamp Relational Database certifications (one with 5 projects) and two public database projects on GitHub.

Who wrote this code

“I wrote the freeCodeCamp exercise code shown on the Skills pages.”

See proof

Claim
I wrote the freeCodeCamp exercise code shown on the Skills pages.
Stated by Danilo
Evidence
- Case converter source: the four case functions (build-a-case-converter/case_converter/index.js, lines 1–20) · manual · checked 2 October 2026From commit a3d68af (26 Sep 2026) by zurukzuruk1 in the back-end-development-and-apis repository. Copied verbatim on 02/10/2026 (line endings normalised).
- Case converter test: four assert.strictEqual checks (build-a-case-converter/case_converter/index.test.js, lines 1–18) · manual · checked 2 October 2026From commit a3d68af (26 Sep 2026) by zurukzuruk1 in the back-end-development-and-apis repository. Copied verbatim on 02/10/2026 (line endings normalised).
- Prime number checker source: isPrime (build-a-prime-number-checker-module/index.js, lines 1–11) · manual · checked 2 October 2026From commit a3d68af (26 Sep 2026) by zurukzuruk1 in the back-end-development-and-apis repository. Copied verbatim on 02/10/2026 (line endings normalised).
- JWT-protected routes source: register and login with bcrypt and JWT (build-jwt-protected-routes/routes/auth.js, lines 11–52) · manual · checked 2 October 2026From commit a3d68af (26 Sep 2026) by zurukzuruk1 in the back-end-development-and-apis repository. Copied verbatim on 02/10/2026 (line endings normalised).
- Bank API source: the transfer route and its checks (build-a-bank-api/server.js, lines 30–71) · manual · checked 2 October 2026From commit a3d68af (26 Sep 2026) by zurukzuruk1 in the back-end-development-and-apis repository. Copied verbatim on 02/10/2026 (line endings normalised).
- Celestial bodies database: the whole SQL file (universe.sql, lines 1–464) · manual · checked 2 October 2026From commit c2b1392 (18 Sep 2026) by zurukzuruk1 in the celestial-bodies-database repository. Copied whole on 02/10/2026 (line endings normalised).
- Salon appointment scheduler: the whole SQL file (salon.sql, lines 1–267) · manual · checked 2 October 2026From commit 5c04648 (25 Sep 2026) by zurukzuruk1 in the salon-appointment-scheduler repository. Copied whole on 02/10/2026 (line endings normalised).
- Salon appointment scheduler: the query lines of the script (salon.sh, lines 14–57) · manual · checked 2 October 2026From commit 5c04648 (25 Sep 2026) by zurukzuruk1 in the salon-appointment-scheduler repository. Copied verbatim on 02/10/2026 (line endings normalised).
Result
The code is copied verbatim from public repositories, where it was committed by Danilo's GitHub account (zurukzuruk1). That he wrote it himself is his statement of 2 Oct 2026.

Schema

Both diagrams are generated when the site is built, by reading the CREATE TABLE statements and the key constraints of the verbatim SQL files: columns and types, primary keys, unique columns and foreign keys. Nothing is drawn by hand.

Celestial bodies database: universe.sql

Evidence tier: Existing evidence · drawn from the file

5 tables · 4 foreign keys · 27 columns

Entity diagram of universe.sql: 5 tables and 4 foreign keys, read from the file when this site was built. Each line joins a foreign-key column (○) to the column it references (●). PK primary key, FK foreign key, UQ unique.

Tables, columns and keys as text

galaxy

Column	Type	Not null	Keys
`galaxy_id`	`integer`	yes	primary key
`name`	`character varying(255)`	yes	unique
`galaxy_type_id`	`integer`	no	foreign key
`distance_from_earth`	`numeric`	yes	–
`has_dark_matter`	`boolean`	no	–
`diameter_light_years`	`integer`	no	–

galaxy_type

Column	Type	Not null	Keys
`galaxy_type_id`	`integer`	yes	primary key
`name`	`character varying(255)`	yes	unique
`description`	`text`	yes	–

moon

Column	Type	Not null	Keys
`moon_id`	`integer`	yes	primary key
`name`	`character varying(255)`	yes	unique
`planet_id`	`integer`	yes	foreign key
`has_atmosphere`	`boolean`	no	–
`diameter_km`	`numeric`	no	–
`discovery_year`	`integer`	no	–

planet

Column	Type	Not null	Keys
`planet_id`	`integer`	yes	primary key
`name`	`character varying(255)`	yes	unique
`star_id`	`integer`	yes	foreign key
`has_rings`	`boolean`	no	–
`orbital_period_days`	`numeric`	no	–
`moons_count`	`integer`	no	–

star

Column	Type	Not null	Keys
`star_id`	`integer`	yes	primary key
`name`	`character varying(255)`	yes	unique
`galaxy_id`	`integer`	yes	foreign key
`mass_solar_masses`	`numeric`	no	–
`is_variable`	`boolean`	no	–
`age_million_years`	`integer`	no	–

Foreign keys

Column	References
`galaxy.galaxy_type_id`	`galaxy_type.galaxy_type_id`
`moon.planet_id`	`planet.planet_id`
`planet.star_id`	`star.star_id`
`star.galaxy_id`	`galaxy.galaxy_id`

universe.sql lines 1–464

Raw Repo

Show the whole file (464 lines)

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)
6-- Dumped by pg_dump version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19SET default_tablespace = '';
20
21SET default_table_access_method = heap;
22
23--
24-- Name: galaxy; Type: TABLE; Schema: public; Owner: -
25--
26
27CREATE TABLE public.galaxy (
28    galaxy_id integer NOT NULL,
29    name character varying(255) NOT NULL,
30    galaxy_type_id integer,
31    distance_from_earth numeric NOT NULL,
32    has_dark_matter boolean,
33    diameter_light_years integer
34);
35
36
37--
38-- Name: galaxy_galaxy_id_seq; Type: SEQUENCE; Schema: public; Owner: -
39--
40
41CREATE SEQUENCE public.galaxy_galaxy_id_seq
42    AS integer
43    START WITH 1
44    INCREMENT BY 1
45    NO MINVALUE
46    NO MAXVALUE
47    CACHE 1;
48
49
50--
51-- Name: galaxy_galaxy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
52--
53
54ALTER SEQUENCE public.galaxy_galaxy_id_seq OWNED BY public.galaxy.galaxy_id;
55
56
57--
58-- Name: galaxy_type; Type: TABLE; Schema: public; Owner: -
59--
60
61CREATE TABLE public.galaxy_type (
62    galaxy_type_id integer NOT NULL,
63    name character varying(255) NOT NULL,
64    description text NOT NULL
65);
66
67
68--
69-- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE; Schema: public; Owner: -
70--
71
72CREATE SEQUENCE public.galaxy_type_galaxy_type_id_seq
73    AS integer
74    START WITH 1
75    INCREMENT BY 1
76    NO MINVALUE
77    NO MAXVALUE
78    CACHE 1;
79
80
81--
82-- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
83--
84
85ALTER SEQUENCE public.galaxy_type_galaxy_type_id_seq OWNED BY public.galaxy_type.galaxy_type_id;
86
87
88--
89-- Name: moon; Type: TABLE; Schema: public; Owner: -
90--
91
92CREATE TABLE public.moon (
93    moon_id integer NOT NULL,
94    name character varying(255) NOT NULL,
95    planet_id integer NOT NULL,
96    has_atmosphere boolean,
97    diameter_km numeric,
98    discovery_year integer
99);
100
101
102--
103-- Name: moon_moon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
104--
105
106CREATE SEQUENCE public.moon_moon_id_seq
107    AS integer
108    START WITH 1
109    INCREMENT BY 1
110    NO MINVALUE
111    NO MAXVALUE
112    CACHE 1;
113
114
115--
116-- Name: moon_moon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
117--
118
119ALTER SEQUENCE public.moon_moon_id_seq OWNED BY public.moon.moon_id;
120
121
122--
123-- Name: planet; Type: TABLE; Schema: public; Owner: -
124--
125
126CREATE TABLE public.planet (
127    planet_id integer NOT NULL,
128    name character varying(255) NOT NULL,
129    star_id integer NOT NULL,
130    has_rings boolean,
131    orbital_period_days numeric,
132    moons_count integer
133);
134
135
136--
137-- Name: planet_planet_id_seq; Type: SEQUENCE; Schema: public; Owner: -
138--
139
140CREATE SEQUENCE public.planet_planet_id_seq
141    AS integer
142    START WITH 1
143    INCREMENT BY 1
144    NO MINVALUE
145    NO MAXVALUE
146    CACHE 1;
147
148
149--
150-- Name: planet_planet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
151--
152
153ALTER SEQUENCE public.planet_planet_id_seq OWNED BY public.planet.planet_id;
154
155
156--
157-- Name: star; Type: TABLE; Schema: public; Owner: -
158--
159
160CREATE TABLE public.star (
161    star_id integer NOT NULL,
162    name character varying(255) NOT NULL,
163    galaxy_id integer NOT NULL,
164    mass_solar_masses numeric,
165    is_variable boolean,
166    age_million_years integer
167);
168
169
170--
171-- Name: star_star_id_seq; Type: SEQUENCE; Schema: public; Owner: -
172--
173
174CREATE SEQUENCE public.star_star_id_seq
175    AS integer
176    START WITH 1
177    INCREMENT BY 1
178    NO MINVALUE
179    NO MAXVALUE
180    CACHE 1;
181
182
183--
184-- Name: star_star_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
185--
186
187ALTER SEQUENCE public.star_star_id_seq OWNED BY public.star.star_id;
188
189
190--
191-- Name: galaxy galaxy_id; Type: DEFAULT; Schema: public; Owner: -
192--
193
194ALTER TABLE ONLY public.galaxy ALTER COLUMN galaxy_id SET DEFAULT nextval('public.galaxy_galaxy_id_seq'::regclass);
195
196
197--
198-- Name: galaxy_type galaxy_type_id; Type: DEFAULT; Schema: public; Owner: -
199--
200
201ALTER TABLE ONLY public.galaxy_type ALTER COLUMN galaxy_type_id SET DEFAULT nextval('public.galaxy_type_galaxy_type_id_seq'::regclass);
202
203
204--
205-- Name: moon moon_id; Type: DEFAULT; Schema: public; Owner: -
206--
207
208ALTER TABLE ONLY public.moon ALTER COLUMN moon_id SET DEFAULT nextval('public.moon_moon_id_seq'::regclass);
209
210
211--
212-- Name: planet planet_id; Type: DEFAULT; Schema: public; Owner: -
213--
214
215ALTER TABLE ONLY public.planet ALTER COLUMN planet_id SET DEFAULT nextval('public.planet_planet_id_seq'::regclass);
216
217
218--
219-- Name: star star_id; Type: DEFAULT; Schema: public; Owner: -
220--
221
222ALTER TABLE ONLY public.star ALTER COLUMN star_id SET DEFAULT nextval('public.star_star_id_seq'::regclass);
223
224
225--
226-- Data for Name: galaxy; Type: TABLE DATA; Schema: public; Owner: -
227--
228
229COPY public.galaxy (galaxy_id, name, galaxy_type_id, distance_from_earth, has_dark_matter, diameter_light_years) FROM stdin;
2301	Milky Way	1	0	t	105700
2312	Andromeda	1	2537000	t	220000
2323	Triangulum	1	2723000	t	60000
2334	Whirlpool	1	23160000	t	76000
2345	Cartwheel	3	500000000	t	150000
2356	Sombrero	4	29350000	t	50000
236\.
237
238
239--
240-- Data for Name: galaxy_type; Type: TABLE DATA; Schema: public; Owner: -
241--
242
243COPY public.galaxy_type (galaxy_type_id, name, description) FROM stdin;
2441	Spiral	A galaxy with a flat, rotating disk containing stars, gas and dust, and a central concentration of stars
2452	Elliptical	A galaxy with an ellipsoidal shape and a smooth, nearly featureless brightness profile
2463	Irregular	A galaxy that does not have a distinct regular shape
2474	Lenticular	A galaxy intermediate between elliptical and spiral galaxies
248\.
249
250
251--
252-- Data for Name: moon; Type: TABLE DATA; Schema: public; Owner: -
253--
254
255COPY public.moon (moon_id, name, planet_id, has_atmosphere, diameter_km, discovery_year) FROM stdin;
2561	The Moon	3	f	3474.8	\N
2572	Phobos	4	f	22.2	1877
2583	Deimos	4	f	12.4	1877
2594	Io	5	f	3643.2	1610
2605	Europa	5	f	3121.6	1610
2616	Ganymede	5	t	5268.2	1610
2627	Callisto	5	f	4820.6	1610
2638	Amalthea	5	f	167	1892
2649	Titan	6	t	5149.5	1655
26510	Rhea	6	f	1527	1672
26611	Iapetus	6	f	1469	1671
26712	Dione	6	f	1123	1684
26813	Tethys	6	f	1062	1684
26914	Enceladus	6	f	504	1789
27015	Titania	7	f	1578	1787
27116	Oberon	7	f	1523	1787
27217	Umbriel	7	f	1169	1851
27318	Ariel	7	f	1158	1851
27419	Miranda	7	f	471	1948
27520	Triton	8	t	2706.8	1846
27621	Nereid	8	f	340	1949
277\.
278
279
280--
281-- Data for Name: planet; Type: TABLE DATA; Schema: public; Owner: -
282--
283
284COPY public.planet (planet_id, name, star_id, has_rings, orbital_period_days, moons_count) FROM stdin;
2851	Mercury	1	f	88	0
2862	Venus	1	f	224.7	0
2873	Earth	1	f	365.25	1
2884	Mars	1	f	687	2
2895	Jupiter	1	t	4331	4
2906	Saturn	1	t	10747	5
2917	Uranus	1	t	30589	3
2928	Neptune	1	t	59800	2
2939	Proxima b	6	f	11.2	0
29410	Sirius Ab	2	f	300	0
29511	Rigel b	4	f	500	0
29612	Centauri Bb	5	f	3.2	0
297\.
298
299
300--
301-- Data for Name: star; Type: TABLE DATA; Schema: public; Owner: -
302--
303
304COPY public.star (star_id, name, galaxy_id, mass_solar_masses, is_variable, age_million_years) FROM stdin;
3051	Sun	1	1.0	f	4600
3062	Sirius	1	2.02	f	242
3073	Betelgeuse	1	16.5	t	10
3084	Rigel	1	21	t	8
3095	Alpha Centauri A	1	1.1	f	4850
3106	Proxima Centauri	1	0.12	t	4850
311\.
312
313
314--
315-- Name: galaxy_galaxy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
316--
317
318SELECT pg_catalog.setval('public.galaxy_galaxy_id_seq', 6, true);
319
320
321--
322-- Name: galaxy_type_galaxy_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
323--
324
325SELECT pg_catalog.setval('public.galaxy_type_galaxy_type_id_seq', 4, true);
326
327
328--
329-- Name: moon_moon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
330--
331
332SELECT pg_catalog.setval('public.moon_moon_id_seq', 21, true);
333
334
335--
336-- Name: planet_planet_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
337--
338
339SELECT pg_catalog.setval('public.planet_planet_id_seq', 12, true);
340
341
342--
343-- Name: star_star_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
344--
345
346SELECT pg_catalog.setval('public.star_star_id_seq', 6, true);
347
348
349--
350-- Name: galaxy galaxy_name_key; Type: CONSTRAINT; Schema: public; Owner: -
351--
352
353ALTER TABLE ONLY public.galaxy
354    ADD CONSTRAINT galaxy_name_key UNIQUE (name);
355
356
357--
358-- Name: galaxy galaxy_pkey; Type: CONSTRAINT; Schema: public; Owner: -
359--
360
361ALTER TABLE ONLY public.galaxy
362    ADD CONSTRAINT galaxy_pkey PRIMARY KEY (galaxy_id);
363
364
365--
366-- Name: galaxy_type galaxy_type_name_key; Type: CONSTRAINT; Schema: public; Owner: -
367--
368
369ALTER TABLE ONLY public.galaxy_type
370    ADD CONSTRAINT galaxy_type_name_key UNIQUE (name);
371
372
373--
374-- Name: galaxy_type galaxy_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -
375--
376
377ALTER TABLE ONLY public.galaxy_type
378    ADD CONSTRAINT galaxy_type_pkey PRIMARY KEY (galaxy_type_id);
379
380
381--
382-- Name: moon moon_name_key; Type: CONSTRAINT; Schema: public; Owner: -
383--
384
385ALTER TABLE ONLY public.moon
386    ADD CONSTRAINT moon_name_key UNIQUE (name);
387
388
389--
390-- Name: moon moon_pkey; Type: CONSTRAINT; Schema: public; Owner: -
391--
392
393ALTER TABLE ONLY public.moon
394    ADD CONSTRAINT moon_pkey PRIMARY KEY (moon_id);
395
396
397--
398-- Name: planet planet_name_key; Type: CONSTRAINT; Schema: public; Owner: -
399--
400
401ALTER TABLE ONLY public.planet
402    ADD CONSTRAINT planet_name_key UNIQUE (name);
403
404
405--
406-- Name: planet planet_pkey; Type: CONSTRAINT; Schema: public; Owner: -
407--
408
409ALTER TABLE ONLY public.planet
410    ADD CONSTRAINT planet_pkey PRIMARY KEY (planet_id);
411
412
413--
414-- Name: star star_name_key; Type: CONSTRAINT; Schema: public; Owner: -
415--
416
417ALTER TABLE ONLY public.star
418    ADD CONSTRAINT star_name_key UNIQUE (name);
419
420
421--
422-- Name: star star_pkey; Type: CONSTRAINT; Schema: public; Owner: -
423--
424
425ALTER TABLE ONLY public.star
426    ADD CONSTRAINT star_pkey PRIMARY KEY (star_id);
427
428
429--
430-- Name: galaxy galaxy_galaxy_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
431--
432
433ALTER TABLE ONLY public.galaxy
434    ADD CONSTRAINT galaxy_galaxy_type_id_fkey FOREIGN KEY (galaxy_type_id) REFERENCES public.galaxy_type(galaxy_type_id);
435
436
437--
438-- Name: moon moon_planet_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
439--
440
441ALTER TABLE ONLY public.moon
442    ADD CONSTRAINT moon_planet_id_fkey FOREIGN KEY (planet_id) REFERENCES public.planet(planet_id);
443
444
445--
446-- Name: planet planet_star_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
447--
448
449ALTER TABLE ONLY public.planet
450    ADD CONSTRAINT planet_star_id_fkey FOREIGN KEY (star_id) REFERENCES public.star(star_id);
451
452
453--
454-- Name: star star_galaxy_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
455--
456
457ALTER TABLE ONLY public.star
458    ADD CONSTRAINT star_galaxy_id_fkey FOREIGN KEY (galaxy_id) REFERENCES public.galaxy(galaxy_id);
459
460
461--
462-- PostgreSQL database dump complete
463--
464

Evidence tier: Existing evidence

Celestial bodies database: the whole SQL file · copied 2 October 2026 · sha256 5404507373b9…

Salon appointment scheduler: salon.sql

Evidence tier: Existing evidence · drawn from the file

3 tables · 2 foreign keys · 9 columns

Entity diagram of salon.sql: 3 tables and 2 foreign keys, read from the file when this site was built. Each line joins a foreign-key column (○) to the column it references (●). PK primary key, FK foreign key, UQ unique.

Tables, columns and keys as text

appointments

Column	Type	Not null	Keys
`appointment_id`	`integer`	yes	primary key
`customer_id`	`integer`	yes	foreign key
`service_id`	`integer`	yes	foreign key
`time`	`character varying(20)`	yes	–

customers

Column	Type	Not null	Keys
`customer_id`	`integer`	yes	primary key
`phone`	`character varying(20)`	yes	unique
`name`	`character varying(50)`	yes	–

services

Column	Type	Not null	Keys
`service_id`	`integer`	yes	primary key
`name`	`character varying(50)`	yes	–

Foreign keys

Column	References
`appointments.customer_id`	`customers.customer_id`
`appointments.service_id`	`services.service_id`

salon.sql lines 1–267

Raw Repo

Show the whole file (267 lines)

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)
6-- Dumped by pg_dump version 12.22 (Ubuntu 12.22-0ubuntu0.20.04.4)
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19DROP DATABASE salon;
20--
21-- Name: salon; Type: DATABASE; Schema: -; Owner: freecodecamp
22--
23
24CREATE DATABASE salon WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C.UTF-8' LC_CTYPE = 'C.UTF-8';
25
26
27ALTER DATABASE salon OWNER TO freecodecamp;
28
29\connect salon
30
31SET statement_timeout = 0;
32SET lock_timeout = 0;
33SET idle_in_transaction_session_timeout = 0;
34SET client_encoding = 'UTF8';
35SET standard_conforming_strings = on;
36SELECT pg_catalog.set_config('search_path', '', false);
37SET check_function_bodies = false;
38SET xmloption = content;
39SET client_min_messages = warning;
40SET row_security = off;
41
42SET default_tablespace = '';
43
44SET default_table_access_method = heap;
45
46--
47-- Name: appointments; Type: TABLE; Schema: public; Owner: freecodecamp
48--
49
50CREATE TABLE public.appointments (
51    appointment_id integer NOT NULL,
52    customer_id integer NOT NULL,
53    service_id integer NOT NULL,
54    "time" character varying(20) NOT NULL
55);
56
57
58ALTER TABLE public.appointments OWNER TO freecodecamp;
59
60--
61-- Name: appointments_appointment_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
62--
63
64CREATE SEQUENCE public.appointments_appointment_id_seq
65    AS integer
66    START WITH 1
67    INCREMENT BY 1
68    NO MINVALUE
69    NO MAXVALUE
70    CACHE 1;
71
72
73ALTER TABLE public.appointments_appointment_id_seq OWNER TO freecodecamp;
74
75--
76-- Name: appointments_appointment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
77--
78
79ALTER SEQUENCE public.appointments_appointment_id_seq OWNED BY public.appointments.appointment_id;
80
81
82--
83-- Name: customers; Type: TABLE; Schema: public; Owner: freecodecamp
84--
85
86CREATE TABLE public.customers (
87    customer_id integer NOT NULL,
88    phone character varying(20) NOT NULL,
89    name character varying(50) NOT NULL
90);
91
92
93ALTER TABLE public.customers OWNER TO freecodecamp;
94
95--
96-- Name: customers_customer_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
97--
98
99CREATE SEQUENCE public.customers_customer_id_seq
100    AS integer
101    START WITH 1
102    INCREMENT BY 1
103    NO MINVALUE
104    NO MAXVALUE
105    CACHE 1;
106
107
108ALTER TABLE public.customers_customer_id_seq OWNER TO freecodecamp;
109
110--
111-- Name: customers_customer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
112--
113
114ALTER SEQUENCE public.customers_customer_id_seq OWNED BY public.customers.customer_id;
115
116
117--
118-- Name: services; Type: TABLE; Schema: public; Owner: freecodecamp
119--
120
121CREATE TABLE public.services (
122    service_id integer NOT NULL,
123    name character varying(50) NOT NULL
124);
125
126
127ALTER TABLE public.services OWNER TO freecodecamp;
128
129--
130-- Name: services_service_id_seq; Type: SEQUENCE; Schema: public; Owner: freecodecamp
131--
132
133CREATE SEQUENCE public.services_service_id_seq
134    AS integer
135    START WITH 1
136    INCREMENT BY 1
137    NO MINVALUE
138    NO MAXVALUE
139    CACHE 1;
140
141
142ALTER TABLE public.services_service_id_seq OWNER TO freecodecamp;
143
144--
145-- Name: services_service_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freecodecamp
146--
147
148ALTER SEQUENCE public.services_service_id_seq OWNED BY public.services.service_id;
149
150
151--
152-- Name: appointments appointment_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
153--
154
155ALTER TABLE ONLY public.appointments ALTER COLUMN appointment_id SET DEFAULT nextval('public.appointments_appointment_id_seq'::regclass);
156
157
158--
159-- Name: customers customer_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
160--
161
162ALTER TABLE ONLY public.customers ALTER COLUMN customer_id SET DEFAULT nextval('public.customers_customer_id_seq'::regclass);
163
164
165--
166-- Name: services service_id; Type: DEFAULT; Schema: public; Owner: freecodecamp
167--
168
169ALTER TABLE ONLY public.services ALTER COLUMN service_id SET DEFAULT nextval('public.services_service_id_seq'::regclass);
170
171
172--
173-- Data for Name: appointments; Type: TABLE DATA; Schema: public; Owner: freecodecamp
174--
175
176
177
178--
179-- Data for Name: customers; Type: TABLE DATA; Schema: public; Owner: freecodecamp
180--
181
182
183
184--
185-- Data for Name: services; Type: TABLE DATA; Schema: public; Owner: freecodecamp
186--
187
188INSERT INTO public.services VALUES (1, 'cut');
189INSERT INTO public.services VALUES (2, 'color');
190INSERT INTO public.services VALUES (3, 'perm');
191INSERT INTO public.services VALUES (4, 'style');
192INSERT INTO public.services VALUES (5, 'trim');
193
194
195--
196-- Name: appointments_appointment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
197--
198
199SELECT pg_catalog.setval('public.appointments_appointment_id_seq', 6, true);
200
201
202--
203-- Name: customers_customer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
204--
205
206SELECT pg_catalog.setval('public.customers_customer_id_seq', 5, true);
207
208
209--
210-- Name: services_service_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freecodecamp
211--
212
213SELECT pg_catalog.setval('public.services_service_id_seq', 5, true);
214
215
216--
217-- Name: appointments appointments_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
218--
219
220ALTER TABLE ONLY public.appointments
221    ADD CONSTRAINT appointments_pkey PRIMARY KEY (appointment_id);
222
223
224--
225-- Name: customers customers_phone_key; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
226--
227
228ALTER TABLE ONLY public.customers
229    ADD CONSTRAINT customers_phone_key UNIQUE (phone);
230
231
232--
233-- Name: customers customers_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
234--
235
236ALTER TABLE ONLY public.customers
237    ADD CONSTRAINT customers_pkey PRIMARY KEY (customer_id);
238
239
240--
241-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: freecodecamp
242--
243
244ALTER TABLE ONLY public.services
245    ADD CONSTRAINT services_pkey PRIMARY KEY (service_id);
246
247
248--
249-- Name: appointments appointments_customer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
250--
251
252ALTER TABLE ONLY public.appointments
253    ADD CONSTRAINT appointments_customer_id_fkey FOREIGN KEY (customer_id) REFERENCES public.customers(customer_id);
254
255
256--
257-- Name: appointments appointments_service_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freecodecamp
258--
259
260ALTER TABLE ONLY public.appointments
261    ADD CONSTRAINT appointments_service_id_fkey FOREIGN KEY (service_id) REFERENCES public.services(service_id);
262
263
264--
265-- PostgreSQL database dump complete
266--
267

Evidence tier: Existing evidence

Salon appointment scheduler: the whole SQL file · copied 2 October 2026 · sha256 9bca9e9176eb…

Queries

The salon script sends its SQL to PostgreSQL through psql: 6 statements (SELECT, INSERT) in these lines, from listing the services to booking the appointment.

The statements, in order

Evidence tier: Existing evidence

line 14SELECT service_id, name FROM services ORDER BY service_id
line 31SELECT name FROM services WHERE service_id = $SERVICE_ID_SELECTED
line 42SELECT name FROM customers WHERE phone = '$CUSTOMER_PHONE'
line 47INSERT INTO customers(phone, name) VALUES('$CUSTOMER_PHONE', '$CUSTOMER_NAME')
line 51SELECT customer_id FROM customers WHERE phone = '$CUSTOMER_PHONE'
line 57INSERT INTO appointments(customer_id, service_id, time) VALUES($CUSTOMER_ID, $SERVICE_ID_SELECTED, '$SERVICE_TIME')

Course exercise: user input goes straight into the SQL string; production code would use parameterised queries.

salon.sh lines 14–57

Raw Repo

14  SERVICES=$($PSQL "SELECT service_id, name FROM services ORDER BY service_id")
15  echo "$SERVICES" | while read SERVICE_ID BAR NAME
16  do
17    if [[ -n $SERVICE_ID ]]
18    then
19      echo "$SERVICE_ID) $NAME"
20    fi
21  done
22
23  read SERVICE_ID_SELECTED
24
25  if [[ ! $SERVICE_ID_SELECTED =~ ^[0-9]+$ ]]
26  then
27    MAIN_MENU "I could not find that service. What would you like today?"
28    return
29  fi
30
31  SERVICE_NAME=$($PSQL "SELECT name FROM services WHERE service_id = $SERVICE_ID_SELECTED")
32  if [[ -z $SERVICE_NAME ]]
33  then
34    MAIN_MENU "I could not find that service. What would you like today?"
35    return
36  fi
37  SERVICE_NAME=$(echo $SERVICE_NAME | sed -E 's/^ *| *$//g')
38
39  echo -e "\nWhat's your phone number?"
40  read CUSTOMER_PHONE
41
42  CUSTOMER_NAME=$($PSQL "SELECT name FROM customers WHERE phone = '$CUSTOMER_PHONE'")
43  if [[ -z $CUSTOMER_NAME ]]
44  then
45    echo -e "\nI don't have a record for that phone number, what's your name?"
46    read CUSTOMER_NAME
47    INSERT_CUSTOMER_RESULT=$($PSQL "INSERT INTO customers(phone, name) VALUES('$CUSTOMER_PHONE', '$CUSTOMER_NAME')")
48  fi
49  CUSTOMER_NAME=$(echo $CUSTOMER_NAME | sed -E 's/^ *| *$//g')
50
51  CUSTOMER_ID=$($PSQL "SELECT customer_id FROM customers WHERE phone = '$CUSTOMER_PHONE'")
52  CUSTOMER_ID=$(echo $CUSTOMER_ID | sed -E 's/^ *| *$//g')
53
54  echo -e "\nWhat time would you like your $SERVICE_NAME, $CUSTOMER_NAME?"
55  read SERVICE_TIME
56
57  INSERT_APPOINTMENT_RESULT=$($PSQL "INSERT INTO appointments(customer_id, service_id, time) VALUES($CUSTOMER_ID, $SERVICE_ID_SELECTED, '$SERVICE_TIME')")

Evidence tier: Existing evidence

Salon appointment scheduler: the query lines of the script · copied 2 October 2026 · sha256 5994d6b57c0e…

Evidence

The two Relational Database certifications (an exam, and a certification with 5 projects) and the two public repositories the files above come from.

Certificates

Relational Database
Evidence tier: Existing evidence
freeCodeCamp · Exam
Issued 27 Sep 2026. Checked on the public freeCodeCamp API.
Open the certificate freeCodeCamp: Relational Database
Checked 29 September 2026.
Relational Database V8
Evidence tier: Existing evidence
freeCodeCamp · V8 · 5 projects
Issued 26 Sep 2026. Checked on the public freeCodeCamp API.
Open the certificate freeCodeCamp: Relational Database V8
Checked 29 September 2026.

Repositories

celestial-bodies-database
Evidence tier: Existing evidence
GitHub repository
PostgreSQL database project (freeCodeCamp).
Open the repository celestial-bodies-database
Checked 28 September 2026.
salon-appointment-scheduler
Evidence tier: Existing evidence
GitHub repository
Bash + SQL appointment scheduler (freeCodeCamp).
Open the repository salon-appointment-scheduler
Checked 28 September 2026.

On this page

Who wrote this code

galaxy

galaxy_type

moon

planet

star

Foreign keys

appointments

customers

services

Foreign keys

Certificates

Repositories