Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE public.users (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    email character varying(255),
    email_verified_at timestamp(0) without time zone,
    google_id character varying(255),
    avatar character varying(255),
    password character varying(255),
    avatar_original character varying(255),
    api_token text,
    "refreshToken" character varying(255),
    "expiresIn" integer,
    remember_token character varying(100),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    bio text,
    facebook character varying(255),
    twiter character varying(255),
    linkedin character varying(255),
    github character varying(255),
    soft_skills text,
    hobbies text,
    hiring_date timestamp(0) without time zone,
    technical_skills text,
    is_billable boolean DEFAULT true NOT NULL,
    education text DEFAULT ''::text NOT NULL,
    is_external boolean DEFAULT false NOT NULL,
    english_level character varying(255),
    is_active boolean DEFAULT true NOT NULL,
    job_title_id bigint,
    resume_tsvector tsvector,
    resume_text text,
    skype character varying(255),
    phone_extension character varying(255),
    personal_phone character varying(255),
    is_contractor boolean DEFAULT false NOT NULL,
    working_time double precision DEFAULT '1'::double precision NOT NULL,
    country_id bigint,
    gender character varying(255),
    date_of_birth date,
    is_bot boolean DEFAULT false NOT NULL,
    partner_id bigint,
    address text,
    emergency_contact character varying(255) DEFAULT ''::character varying NOT NULL,
    conditions text,
    notes text,
    identification character varying(255),
    CONSTRAINT users_english_level_check CHECK (((english_level)::text = ANY ((ARRAY['A1'::character varying, 'A2'::character varying, 'B1'::character varying, 'B2'::character varying, 'C1'::character varying, 'C2'::character varying])::text[]))),
    CONSTRAINT users_working_time_check CHECK (((working_time >= (0)::double precision) AND (working_time <= (1)::double precision)))
);


CREATE TABLE public.learning_paths (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    version character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);

CREATE TABLE public.learning_path_levels (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    learning_path_id bigint NOT NULL,
    "order" integer DEFAULT 1 NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);

CREATE TABLE public.learning_path_level_nodes (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    documentation_links character varying(255) NOT NULL,
    evaluation_methodology character varying(255) NOT NULL,
    learning_path_level_id bigint NOT NULL,
    completed_at timestamp(0) without time zone,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);

CREATE TABLE public.learning_path_node_users (
    id bigint NOT NULL,
    learning_path_level_node_id bigint NOT NULL,
    user_id bigint NOT NULL,
    evaluated_by bigint NOT NULL,
    evaluated_at timestamp(0) without time zone,
    is_successful boolean DEFAULT false NOT NULL,
    notes character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


INSERT INTO public.users (id, name, email, email_verified_at, google_id, avatar, password, avatar_original, api_token, "refreshToken", "expiresIn", remember_token, created_at, updated_at, bio, facebook, twiter, linkedin, github, soft_skills, hobbies, hiring_date, technical_skills, is_billable, education, is_external, english_level, is_active, job_title_id, resume_tsvector, resume_text, skype, phone_extension, personal_phone, is_contractor, working_time, country_id, gender, date_of_birth, is_bot, partner_id, address, emergency_contact, conditions, notes, identification) VALUES (2, 'Mr. Garrett Wilderman', 'roob.ivah@example.net', '2022-07-14 21:41:26', NULL, NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', NULL, NULL, NULL, NULL, 'TzAqFVmOZu', '2022-07-14 21:41:27', '2022-07-14 21:41:27', 'Duchess began in a very short time the Queen said to one of the deepest contempt. ''I''ve seen a good many little girls eat eggs quite as safe to stay in here any longer!'' She waited for a baby: altogether Alice did not much larger than a real Turtle.'' These words were followed by a row of lodging houses, and behind it was all very well to say it over) ''--yes, that''s about the whiting!'' ''Oh, as to.', NULL, NULL, NULL, NULL, 'Confidence
Respect
Organization
Open-mindedness
Listening', 'Winemaking
Lego building
Welding
Video games
Karate', '2018-11-02 17:45:16', NULL, true, 'Computer Science - Stanford', false, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, 7, NULL, '2000-07-26', false, NULL, NULL, '', NULL, NULL, NULL);
1 rows affected

INSERT INTO public.users (id, name, email, email_verified_at, google_id, avatar, password, avatar_original, api_token, "refreshToken", "expiresIn", remember_token, created_at, updated_at, bio, facebook, twiter, linkedin, github, soft_skills, hobbies, hiring_date, technical_skills, is_billable, education, is_external, english_level, is_active, job_title_id, resume_tsvector, resume_text, skype, phone_extension, personal_phone, is_contractor, working_time, country_id, gender, date_of_birth, is_bot, partner_id, address, emergency_contact, conditions, notes, identification) VALUES (3, 'Sean Hauck MD', 'armando.yundt@example.com', '2022-07-14 21:41:26', NULL, NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', NULL, NULL, NULL, NULL, 'p0rHbJO2nT', '2022-07-14 21:41:27', '2022-07-14 21:41:27', 'I can''t quite follow it as you go on? It''s by far the most confusing thing I ask! It''s always six o''clock now.'' A bright idea came into Alice''s shoulder as she swam about, trying to touch her. ''Poor little thing!'' It did so indeed, and much sooner than she had not long to doubt, for the pool of tears which she had not gone far before they saw the Mock Turtle, suddenly dropping his voice; and.', NULL, NULL, NULL, NULL, 'Organization
Analysis
Self-motivation
Listening
Empathy', 'Winemaking
Puzzles
Video games
Astronomy
Hiking', '2022-06-10 23:16:07', NULL, true, 'Computer Science - Stanford', false, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, false, 1, 108, NULL, '1989-05-30', false, NULL, NULL, '', NULL, NULL, NULL);
1 rows affected

INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (1, 'Frontend', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (2, 'Backend', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (3, 'Devops', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (4, 'QA', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (5, 'AI', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_paths (id, name, version, created_at, updated_at) VALUES (6, 'Project Manager', '1.0.0', '2022-07-14 21:41:48', '2022-07-14 21:41:48');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (1, 'Senior AI', 5, 1, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (2, 'Senior Devops', 3, 1, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (3, 'Junior Devops', 3, 2, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (4, 'Mid QA', 4, 1, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (5, 'Junior Project Manager', 6, 1, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (6, 'Intern', 1, 1, '2022-07-14 21:49:08', '2022-07-14 21:49:08');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (7, 'Junior', 1, 2, '2022-07-14 21:49:15', '2022-07-14 21:49:15');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (8, 'Mid', 1, 3, '2022-07-14 21:49:19', '2022-07-14 21:49:19');
INSERT INTO public.learning_path_levels (id, name, learning_path_id, "order", created_at, updated_at) VALUES (9, 'Senior', 1, 4, '2022-07-14 21:49:22', '2022-07-14 21:49:22');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (1, 'tenetur', 'Alice had no idea how confusing it is I hate cats and dogs.'' It was the White Rabbit hurried.', 'http://www.rempel.biz/', 'For instance, suppose it were white, but there were three gardeners who were all turning into.', 1, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (2, 'fuga', 'Rabbit''s voice along--''Catch him, you by the whole thing, and longed to change the subject of.', 'http://zieme.com/quam-laborum-numquam-mollitia-deserunt-ut', 'Mock Turtle drew a long way back, and see what I was going on rather better now,'' she added aloud.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (3, 'cum', 'For, you see, so many tea-things are put out here?'' she asked. ''Yes, that''s it,'' said Alice.', 'http://www.jacobson.net/', 'Alice, and, after waiting till she was saying, and the three were all crowded round her, calling.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (4, 'maiores', 'It''s high time to go, for the pool rippling to the door, and knocked. ''There''s no sort of people.', 'http://robel.net/fugit-omnis-fugiat-quaerat-et.html', 'As she said to herself; ''the March Hare took the hookah into its nest. Alice crouched down among.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (5, 'voluptatem', 'The Cat only grinned a little shaking among the distant green leaves. As there seemed to listen.', 'http://www.gerlach.com/qui-occaecati-eos-quia-fugit-veritatis-odit', 'Presently she began fancying the sort of lullaby to it in large letters. It was the White Rabbit.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (6, 'accusantium', 'Cat, as soon as look at the bottom of a muchness?'' ''Really, now you ask me,'' said Alice, (she had.', 'http://www.wyman.info/inventore-laudantium-omnis-soluta-laudantium-et-ut', 'English!'' said the Cat said, waving its right ear and left foot, so as to size,'' Alice hastily.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (7, 'quam', 'Alice could see her after the birds! Why, she''ll eat a bat?'' when suddenly, thump! thump! down she.', 'http://www.walsh.biz/', 'Why, there''s hardly room for her. ''Yes!'' shouted Alice. ''Come on, then!'' roared the Queen, ''and.', 1, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (8, 'nihil', 'Mock Turtle: ''crumbs would all wash off in the sea, though you mayn''t believe it--'' ''I never said.', 'https://www.mayer.biz/iste-occaecati-nostrum-delectus-incidunt', 'VERY unpleasant state of mind, she turned away. ''Come back!'' the Caterpillar sternly. ''Explain.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (9, 'voluptas', 'Alice. ''That''s the judge,'' she said this she looked down, was an old crab, HE was.'' ''I never was.', 'http://www.davis.com/', 'Hatter. ''Does YOUR watch tell you what year it is?'' ''Of course twinkling begins with an M?'' said.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (10, 'dicta', 'The twelve jurors were all talking at once, and ran till she was exactly the right word) ''--but I.', 'https://www.herman.com/eligendi-omnis-ut-provident-non-aliquid-temporibus-voluptas-nemo', 'Alice. ''I''m glad they don''t give birthday presents like that!'' But she waited patiently. ''Once,''.', 1, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (11, 'iure', 'Alice, she went to the executioner: ''fetch her here.'' And the Gryphon repeated impatiently: ''it.', 'https://franecki.net/explicabo-est-ratione-sit-dolorem-deserunt-culpa.html', 'Down, down, down. Would the fall NEVER come to the porpoise, "Keep back, please: we don''t want YOU.', 1, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (12, 'delectus', 'EVEN finish, if he had never been in a low, weak voice. ''Now, I give you fair warning,'' shouted.', 'https://simonis.biz/est-unde-quas-cumque-facilis-dicta-rerum.html', 'Cat. ''--so long as I used--and I don''t take this child away with me,'' thought Alice, and, after.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (13, 'asperiores', 'I--'' ''Oh, don''t talk about her other little children, and everybody else. ''Leave off that!''.', 'http://hintz.org/', 'X. The Lobster Quadrille The Mock Turtle is.'' ''It''s the stupidest tea-party I ever heard!'' ''Yes, I.', 4, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (14, 'ipsa', 'Dormouse, who was reading the list of singers. ''You may go,'' said the Dodo, pointing to the Mock.', 'http://www.kassulke.com/laudantium-asperiores-dolorum-rerum-et-facilis', 'Duchess! The Duchess! Oh my fur and whiskers! She''ll get me executed, as sure as ferrets are.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (15, 'inventore', 'Alice like the Queen?'' said the Duchess. An invitation from the trees under which she concluded.', 'http://turcotte.com/quo-ut-hic-saepe.html', 'King eagerly, and he wasn''t one?'' Alice asked. ''We called him a fish)--and rapped loudly at the.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (16, 'temporibus', 'Alice began to get in?'' asked Alice again, in a tone of great curiosity. ''Soles and eels, of.', 'http://www.pacocha.biz/optio-corrupti-explicabo-itaque-autem', 'Alice thought this a good many little girls in my size; and as the question was evidently meant.', 5, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (17, 'illum', 'Mouse only growled in reply. ''Idiot!'' said the Cat, ''or you wouldn''t squeeze so.'' said the Hatter.', 'http://www.jerde.info/dolorum-sint-dolore-nostrum-rerum-quia.html', 'VERY good opportunity for croqueting one of the words ''DRINK ME'' beautifully printed on it but.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (18, 'nemo', 'Miss, we''re doing our best, afore she comes, to--'' At this moment the King, rubbing his hands; ''so.', 'http://abernathy.net/', 'Dinah, if I shall ever see such a very good height indeed!'' said the Dodo, pointing to Alice for.', 1, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (19, 'repudiandae', 'Queen''s shrill cries to the little golden key in the pictures of him), while the Mock Turtle yet?''.', 'https://www.runolfsdottir.org/quisquam-ab-fugit-dolor', 'Hatter said, turning to the whiting,'' said the Dormouse. ''Fourteenth of March, I think that very.', 2, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (20, 'doloremque', 'Rabbit noticed Alice, as she stood watching them, and then sat upon it.) ''I''m glad they''ve begun.', 'http://www.ullrich.org/sunt-architecto-quia-et-nihil-qui-numquam-minus', 'Five! Always lay the blame on others!'' ''YOU''D better not do that again!'' which produced another.', 3, NULL, '2022-07-14 21:41:48', '2022-07-14 21:41:48');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (21, 'Javascript', 'Sint veniam vero a', 'Natus et laboris lab', 'Laborum eveniet in', 6, NULL, '2022-07-14 21:49:40', '2022-07-14 21:49:40');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (22, 'Object Destructuring', 'Aperiam dolor minim', 'Minus voluptate non', 'Earum iste ad ut tot', 6, NULL, '2022-07-14 21:49:54', '2022-07-14 21:49:54');
INSERT INTO public.learning_path_level_nodes (id, name, description, documentation_links, evaluation_methodology, learning_path_level_id, completed_at, created_at, updated_at) VALUES (23, 'Promises / Async Await', 'Dignissimos rem qui', 'Ut reprehenderit se', 'Ex eum repellendus', 6, NULL, '2022-07-14 21:50:19', '2022-07-14 21:50:19');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (1, 2, 1, 2, '2022-07-14 22:06:20', true, NULL, '2022-07-14 22:06:20', '2022-07-14 22:06:20');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (2, 3, 1, 2, '2022-07-14 22:06:50', true, NULL, '2022-07-14 22:06:50', '2022-07-14 22:06:50');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (3, 4, 1, 2, '2022-07-14 22:06:56', true, NULL, '2022-07-14 22:06:56', '2022-07-14 22:06:56');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (4, 5, 1, 2, '2022-07-18 15:49:05', true, NULL, '2022-07-18 15:49:05', '2022-07-18 15:49:05');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (5, 14, 1, 2, '2022-07-18 15:49:24', true, NULL, '2022-07-18 15:49:24', '2022-07-18 15:49:24');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (6, 21, 1, 2, '2022-07-18 15:49:58', true, NULL, '2022-07-18 15:49:58', '2022-07-18 15:49:58');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (7, 6, 1, 2, '2022-07-20 15:11:02', true, NULL, '2022-07-20 15:11:02', '2022-07-20 15:11:02');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (8, 8, 1, 2, '2022-07-20 15:13:19', true, NULL, '2022-07-20 15:13:19', '2022-07-20 15:13:19');
INSERT INTO public.learning_path_node_users (id, learning_path_level_node_id, user_id, evaluated_by, evaluated_at, is_successful, notes, created_at, updated_at) VALUES (9, 9, 1, 2, '2022-07-20 15:13:27', true, NULL, '2022-07-20 15:13:27', '2022-07-20 15:13:27');
1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

select learning_paths."name",
sum(case when learning_path_node_users.is_successful and learning_path_node_users.user_id is not null then 1 else 0 end) as completed_nodes,
sum(case when learning_path_node_users.is_successful = false or learning_path_node_users.user_id is null then 1 else 0 end) as pending_nodes,
count(learning_path_levels.id) as total_levels,
count(*) as total_nodes
from learning_path_level_nodes
inner join learning_path_levels on learning_path_levels.id = learning_path_level_nodes.learning_path_level_id
inner join learning_paths on learning_paths.id = learning_path_levels.learning_path_id
left join learning_path_node_users on learning_path_node_users.learning_path_level_node_id = learning_path_level_nodes.id
group by learning_paths."name"


name
completed_nodes
pending_nodes
total_levels
total_nodes


Devops
5
3
8
8

Frontend
1
2
3
3

Project Manager
3
3
6
6

QA
0
1
1
1

AI
0
5
5
5