// Organization Chart (org-chart) v1 — Prisma seed
// Synthetic sample data, CC0-1.0. Generated deterministically; re-running the
// generator with the same spec and seed reproduces this file exactly.
//
// Delegates are named after the tables (prisma.job_titles), which assumes models
// mapped to those table names. Rename the delegates if your models differ.
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function main() {
    await prisma.job_titles.createMany({
        data: [
            { id: 1, title: "executive associate", level: "mid", base_salary: "46548.52" },
            { id: 2, title: "director strategist", level: "manager", base_salary: "76044.38" },
            { id: 3, title: "technician specialist trainer", level: "senior", base_salary: "44450.77" },
            { id: 4, title: "associate strategist", level: "mid", base_salary: "84693.52" },
            { id: 5, title: "strategist", level: "senior", base_salary: "51376.47" },
            { id: 6, title: "representative", level: "lead", base_salary: "64990.54" },
            { id: 7, title: "consultant specialist lead", level: "manager", base_salary: "76707.62" },
            { id: 8, title: "strategist director", level: "manager", base_salary: "47192.28" },
            { id: 9, title: "developer", level: "manager", base_salary: "96418.67" },
            { id: 10, title: "supervisor technician", level: "junior", base_salary: "34106.74" },
            { id: 11, title: "assistant manager supervisor", level: "manager", base_salary: "51646.02" },
            { id: 12, title: "strategist associate trainer", level: "mid", base_salary: "124330.94" },
            { id: 13, title: "director designer", level: "junior", base_salary: "31305.33" },
            { id: 14, title: "associate", level: "mid", base_salary: "35691.79" },
            { id: 15, title: "analyst", level: "manager", base_salary: "31206.74" },
            { id: 16, title: "supervisor technician", level: "manager", base_salary: "34790.18" },
            { id: 17, title: "specialist trainer officer", level: "junior", base_salary: "43942.92" },
            { id: 18, title: "analyst", level: "senior", base_salary: "74216.04" },
            { id: 19, title: "trainer lead", level: "manager", base_salary: "37236.76" },
            { id: 20, title: "coordinator", level: "mid", base_salary: "70338.86" },
            { id: 21, title: "strategist administrator analyst", level: "mid", base_salary: "36265.19" },
            { id: 22, title: "supervisor technician representative", level: "lead", base_salary: "55820.96" },
            { id: 23, title: "researcher strategist supervisor", level: "junior", base_salary: "56451.24" },
            { id: 24, title: "associate strategist designer", level: "junior", base_salary: "77228.99" },
            { id: 25, title: "technician strategist engineer", level: "mid", base_salary: "91292.41" },
            { id: 26, title: "officer specialist", level: "senior", base_salary: "119712.61" },
            { id: 27, title: "representative", level: "mid", base_salary: "36226.71" },
            { id: 28, title: "officer", level: "senior", base_salary: "42069.68" },
            { id: 29, title: "associate researcher lead", level: "manager", base_salary: "55940.19" },
            { id: 30, title: "technician developer", level: "mid", base_salary: "122982.87" },
        ],
    });
    await prisma.departments.createMany({
        data: [
            { id: 1, name: "research", job_title_id: 29, budget: "2221706.08" },
            { id: 2, name: "research support", job_title_id: 6, budget: "379136.65" },
            { id: 3, name: "compliance", job_title_id: 6, budget: "242073.27" },
            { id: 4, name: "research analytics strategy", job_title_id: 16, budget: "143280.17" },
            { id: 5, name: "operations legal engineering", job_title_id: 7, budget: "1380562.35" },
            { id: 6, name: "marketing", job_title_id: 25, budget: "4763662.34" },
            { id: 7, name: "operations", job_title_id: 15, budget: "222390.97" },
            { id: 8, name: "compliance strategy", job_title_id: 17, budget: "3035707.56" },
            { id: 9, name: "it sales operations", job_title_id: 24, budget: "3579434.21" },
            { id: 10, name: "customer operations", job_title_id: 1, budget: "3595712.78" },
            { id: 11, name: "operations", job_title_id: 11, budget: "4029784.88" },
            { id: 12, name: "compliance marketing", job_title_id: 7, budget: "52802.70" },
            { id: 13, name: "legal", job_title_id: 13, budget: "4901687.99" },
            { id: 14, name: "development", job_title_id: 23, budget: "3562784.50" },
            { id: 15, name: "administration", job_title_id: 9, budget: "3232729.43" },
            { id: 16, name: "operations", job_title_id: 4, budget: "1589665.45" },
            { id: 17, name: "engineering", job_title_id: 6, budget: "186414.15" },
            { id: 18, name: "engineering it", job_title_id: 9, budget: "4473289.03" },
            { id: 19, name: "product support", job_title_id: 7, budget: "2102739.85" },
            { id: 20, name: "research customer", job_title_id: 6, budget: "429872.74" },
        ],
    });
    await prisma.employees.createMany({
        data: [
            { id: 1, full_name: "Kai Castro", job_title_id: 27, department_id: 17, manager_id: null, hire_date: "2022-06-09", salary: "172558.15", employment_status: "active" },
            { id: 2, full_name: "Ethan Andersen", job_title_id: 20, department_id: 13, manager_id: null, hire_date: "2016-12-29", salary: "150099.53", employment_status: "active" },
            { id: 3, full_name: "Mohamed Jansen", job_title_id: 24, department_id: 20, manager_id: 1, hire_date: "2018-04-14", salary: "117163.57", employment_status: "active" },
            { id: 4, full_name: "Grace Mendes", job_title_id: 2, department_id: 11, manager_id: 1, hire_date: "2010-11-18", salary: "40842.70", employment_status: "active" },
            { id: 5, full_name: "Mohamed Jensen", job_title_id: 11, department_id: 17, manager_id: 3, hire_date: "2010-04-16", salary: "52355.12", employment_status: "on leave" },
            { id: 6, full_name: "Mei Lopez", job_title_id: 17, department_id: 20, manager_id: 2, hire_date: "2021-09-24", salary: "156467.30", employment_status: "active" },
            { id: 7, full_name: "Olivia Shah", job_title_id: 20, department_id: 20, manager_id: 3, hire_date: "2010-11-13", salary: "32860.05", employment_status: "on leave" },
            { id: 8, full_name: "Arjun Ahmed", job_title_id: 7, department_id: 16, manager_id: 6, hire_date: "2015-09-01", salary: "117591.79", employment_status: "active" },
            { id: 9, full_name: "Maja Reyes", job_title_id: 25, department_id: 15, manager_id: null, hire_date: "2020-04-28", salary: "98119.16", employment_status: "on leave" },
            { id: 10, full_name: "Liam Cruz", job_title_id: 4, department_id: 7, manager_id: null, hire_date: "2022-08-23", salary: "39525.57", employment_status: "on leave" },
            { id: 11, full_name: "Ethan Castro", job_title_id: 26, department_id: 19, manager_id: null, hire_date: "2014-02-20", salary: "57150.88", employment_status: "inactive" },
            { id: 12, full_name: "Wei Wright", job_title_id: 1, department_id: 8, manager_id: 7, hire_date: "2011-07-28", salary: "87967.89", employment_status: "active" },
            { id: 13, full_name: "David Hansen", job_title_id: 22, department_id: 16, manager_id: 9, hire_date: "2015-04-14", salary: "99265.07", employment_status: "inactive" },
            { id: 14, full_name: "Sven Ruiz", job_title_id: 2, department_id: 1, manager_id: 3, hire_date: "2018-05-25", salary: "89260.53", employment_status: "active" },
            { id: 15, full_name: "Daniel Evans", job_title_id: 26, department_id: 20, manager_id: 5, hire_date: "2012-05-13", salary: "30038.58", employment_status: "inactive" },
            { id: 16, full_name: "Ethan Vargas", job_title_id: 29, department_id: 5, manager_id: null, hire_date: "2018-08-06", salary: "30016.79", employment_status: "active" },
            { id: 17, full_name: "Mohamed Carter", job_title_id: 3, department_id: 6, manager_id: 15, hire_date: "2013-09-26", salary: "95051.70", employment_status: "active" },
            { id: 18, full_name: "Yara Bauer", job_title_id: 16, department_id: 6, manager_id: 8, hire_date: "2014-07-06", salary: "38501.72", employment_status: "active" },
            { id: 19, full_name: "Wei Nguyen", job_title_id: 21, department_id: 15, manager_id: 5, hire_date: "2011-01-12", salary: "107515.74", employment_status: "active" },
            { id: 20, full_name: "Victor Tanaka", job_title_id: 12, department_id: 14, manager_id: 16, hire_date: "2017-10-15", salary: "33290.46", employment_status: "active" },
            { id: 21, full_name: "Anna Torres", job_title_id: 14, department_id: 19, manager_id: 4, hire_date: "2017-12-16", salary: "63692.46", employment_status: "active" },
            { id: 22, full_name: "Tomas Cruz", job_title_id: 21, department_id: 3, manager_id: 13, hire_date: "2015-07-14", salary: "191717.35", employment_status: "active" },
            { id: 23, full_name: "Diego Klein", job_title_id: 28, department_id: 11, manager_id: 14, hire_date: "2016-01-16", salary: "73913.44", employment_status: "active" },
            { id: 24, full_name: "Sofia Wang", job_title_id: 3, department_id: 2, manager_id: 16, hire_date: "2022-09-23", salary: "188424.43", employment_status: "inactive" },
            { id: 25, full_name: "Jack Ali", job_title_id: 9, department_id: 15, manager_id: 16, hire_date: "2010-02-09", salary: "35871.39", employment_status: "active" },
            { id: 26, full_name: "Oscar Vargas", job_title_id: 2, department_id: 8, manager_id: 20, hire_date: "2013-04-22", salary: "79685.54", employment_status: "inactive" },
            { id: 27, full_name: "Ivan Gupta", job_title_id: 27, department_id: 2, manager_id: 18, hire_date: "2013-03-22", salary: "33485.12", employment_status: "inactive" },
            { id: 28, full_name: "Leo Miller", job_title_id: 17, department_id: 14, manager_id: 3, hire_date: "2014-02-15", salary: "44593.49", employment_status: "inactive" },
            { id: 29, full_name: "Mateo Singh", job_title_id: 8, department_id: 2, manager_id: 17, hire_date: "2018-06-27", salary: "37046.36", employment_status: "active" },
            { id: 30, full_name: "Mila Ruiz", job_title_id: 27, department_id: 16, manager_id: 8, hire_date: "2012-07-28", salary: "33356.43", employment_status: "active" },
            { id: 31, full_name: "Hugo Flores", job_title_id: 22, department_id: 10, manager_id: 26, hire_date: "2019-01-21", salary: "65850.88", employment_status: "active" },
            { id: 32, full_name: "Sven Reyes", job_title_id: 7, department_id: 12, manager_id: 8, hire_date: "2014-09-07", salary: "33126.44", employment_status: "active" },
            { id: 33, full_name: "Amir Murphy", job_title_id: 26, department_id: 1, manager_id: 27, hire_date: "2018-09-18", salary: "162016.01", employment_status: "inactive" },
            { id: 34, full_name: "Julia Wang", job_title_id: 5, department_id: 11, manager_id: 19, hire_date: "2014-04-14", salary: "157331.52", employment_status: "inactive" },
            { id: 35, full_name: "Felix Evans", job_title_id: 16, department_id: 12, manager_id: 22, hire_date: "2012-08-10", salary: "61648.98", employment_status: "inactive" },
            { id: 36, full_name: "Ana Silva", job_title_id: 7, department_id: 6, manager_id: 17, hire_date: "2018-02-16", salary: "39616.82", employment_status: "active" },
            { id: 37, full_name: "Wei Wright", job_title_id: 11, department_id: 5, manager_id: null, hire_date: "2021-08-26", salary: "149070.03", employment_status: "active" },
            { id: 38, full_name: "Ethan Larsen", job_title_id: 12, department_id: 5, manager_id: 5, hire_date: "2012-04-09", salary: "78964.29", employment_status: "active" },
            { id: 39, full_name: "Carla Tanaka", job_title_id: 22, department_id: 12, manager_id: 29, hire_date: "2019-10-13", salary: "33360.77", employment_status: "inactive" },
            { id: 40, full_name: "Deniz Smith", job_title_id: 8, department_id: 13, manager_id: 18, hire_date: "2022-12-14", salary: "55426.38", employment_status: "active" },
            { id: 41, full_name: "Ravi Ruiz", job_title_id: 19, department_id: 16, manager_id: 38, hire_date: "2013-11-29", salary: "87011.05", employment_status: "active" },
            { id: 42, full_name: "Amir Lopez", job_title_id: 28, department_id: 4, manager_id: 11, hire_date: "2013-03-09", salary: "89553.35", employment_status: "inactive" },
            { id: 43, full_name: "Lena Rossi", job_title_id: 22, department_id: 7, manager_id: 36, hire_date: "2012-12-28", salary: "153629.56", employment_status: "inactive" },
            { id: 44, full_name: "Julia Clark", job_title_id: 24, department_id: 8, manager_id: 16, hire_date: "2018-03-02", salary: "31032.69", employment_status: "active" },
            { id: 45, full_name: "Felix Shah", job_title_id: 22, department_id: 7, manager_id: 24, hire_date: "2018-04-18", salary: "93736.59", employment_status: "inactive" },
            { id: 46, full_name: "Ruby Diaz", job_title_id: 20, department_id: 11, manager_id: 3, hire_date: "2013-06-18", salary: "198666.87", employment_status: "active" },
            { id: 47, full_name: "Chen Gupta", job_title_id: 1, department_id: 10, manager_id: 30, hire_date: "2015-07-24", salary: "199788.21", employment_status: "active" },
            { id: 48, full_name: "Theo Mendes", job_title_id: 25, department_id: 20, manager_id: 25, hire_date: "2019-12-14", salary: "30053.20", employment_status: "active" },
            { id: 49, full_name: "Deniz Meyer", job_title_id: 3, department_id: 16, manager_id: 23, hire_date: "2016-04-10", salary: "107977.56", employment_status: "active" },
            { id: 50, full_name: "Mei Gomez", job_title_id: 20, department_id: 8, manager_id: 26, hire_date: "2016-04-29", salary: "184982.04", employment_status: "active" },
            { id: 51, full_name: "Mateo Mendes", job_title_id: 20, department_id: 7, manager_id: null, hire_date: "2012-06-19", salary: "107874.44", employment_status: "active" },
            { id: 52, full_name: "Daniel Bauer", job_title_id: 6, department_id: 15, manager_id: 23, hire_date: "2012-06-17", salary: "114812.26", employment_status: "inactive" },
            { id: 53, full_name: "Yusuf Torres", job_title_id: 5, department_id: 3, manager_id: 42, hire_date: "2013-12-10", salary: "118617.31", employment_status: "active" },
            { id: 54, full_name: "Liam Reyes", job_title_id: 13, department_id: 7, manager_id: 43, hire_date: "2015-08-05", salary: "118180.13", employment_status: "active" },
            { id: 55, full_name: "Nour Almeida", job_title_id: 23, department_id: 7, manager_id: 18, hire_date: "2012-05-14", salary: "59227.43", employment_status: "active" },
            { id: 56, full_name: "Chloe Hoffmann", job_title_id: 9, department_id: 6, manager_id: 9, hire_date: "2014-07-28", salary: "52387.09", employment_status: "active" },
            { id: 57, full_name: "Victor Sousa", job_title_id: 13, department_id: 13, manager_id: 37, hire_date: "2023-03-25", salary: "63988.18", employment_status: "active" },
            { id: 58, full_name: "Ibrahim Demir", job_title_id: 11, department_id: 11, manager_id: 35, hire_date: "2015-09-21", salary: "30441.40", employment_status: "active" },
            { id: 59, full_name: "Mateo Meyer", job_title_id: 9, department_id: 1, manager_id: 17, hire_date: "2014-10-04", salary: "144580.09", employment_status: "active" },
            { id: 60, full_name: "Tomas Jensen", job_title_id: 27, department_id: 1, manager_id: null, hire_date: "2019-11-04", salary: "119686.58", employment_status: "active" },
            { id: 61, full_name: "Isaac Oliveira", job_title_id: 29, department_id: 15, manager_id: 26, hire_date: "2011-06-18", salary: "152994.70", employment_status: "active" },
            { id: 62, full_name: "Chloe Carter", job_title_id: 24, department_id: 19, manager_id: 53, hire_date: "2015-04-24", salary: "36782.28", employment_status: "active" },
            { id: 63, full_name: "Sven Jansen", job_title_id: 8, department_id: 13, manager_id: 40, hire_date: "2015-11-12", salary: "57172.90", employment_status: "active" },
            { id: 64, full_name: "James Novak", job_title_id: 24, department_id: 13, manager_id: 10, hire_date: "2019-10-12", salary: "136155.65", employment_status: "active" },
            { id: 65, full_name: "Ben Adams", job_title_id: 13, department_id: 19, manager_id: 1, hire_date: "2012-01-12", salary: "112443.99", employment_status: "inactive" },
            { id: 66, full_name: "Hannah Oliveira", job_title_id: 14, department_id: 20, manager_id: 42, hire_date: "2015-09-10", salary: "149242.81", employment_status: "active" },
            { id: 67, full_name: "James Nakamura", job_title_id: 28, department_id: 2, manager_id: 20, hire_date: "2012-04-11", salary: "33642.93", employment_status: "active" },
            { id: 68, full_name: "Hugo Mendes", job_title_id: 5, department_id: 4, manager_id: null, hire_date: "2021-01-24", salary: "139012.48", employment_status: "active" },
            { id: 69, full_name: "Lina Andersen", job_title_id: 9, department_id: 19, manager_id: 47, hire_date: "2016-03-02", salary: "193568.39", employment_status: "active" },
            { id: 70, full_name: "Rafael Yilmaz", job_title_id: 26, department_id: 13, manager_id: 13, hire_date: "2011-09-25", salary: "159350.83", employment_status: "active" },
            { id: 71, full_name: "Karim Martin", job_title_id: 18, department_id: 7, manager_id: 21, hire_date: "2020-10-08", salary: "151452.94", employment_status: "inactive" },
            { id: 72, full_name: "Ibrahim Kumar", job_title_id: 20, department_id: 16, manager_id: 61, hire_date: "2020-02-26", salary: "33917.57", employment_status: "active" },
            { id: 73, full_name: "Mohamed Patel", job_title_id: 12, department_id: 11, manager_id: 65, hire_date: "2010-02-05", salary: "52331.07", employment_status: "active" },
            { id: 74, full_name: "Ibrahim Zhang", job_title_id: 8, department_id: 4, manager_id: 24, hire_date: "2011-10-01", salary: "32298.48", employment_status: "active" },
            { id: 75, full_name: "Lena Larsen", job_title_id: 10, department_id: 18, manager_id: 30, hire_date: "2018-12-18", salary: "39446.49", employment_status: "on leave" },
            { id: 76, full_name: "Nour Tanaka", job_title_id: 15, department_id: 19, manager_id: 69, hire_date: "2022-02-07", salary: "41185.69", employment_status: "active" },
            { id: 77, full_name: "Chloe Martin", job_title_id: 15, department_id: 1, manager_id: 67, hire_date: "2012-03-20", salary: "46748.63", employment_status: "active" },
            { id: 78, full_name: "Sara Demir", job_title_id: 4, department_id: 14, manager_id: 45, hire_date: "2015-03-02", salary: "44110.70", employment_status: "active" },
            { id: 79, full_name: "Deniz Almeida", job_title_id: 2, department_id: 13, manager_id: 71, hire_date: "2019-02-23", salary: "97204.05", employment_status: "active" },
            { id: 80, full_name: "Maria Murphy", job_title_id: 10, department_id: 3, manager_id: 5, hire_date: "2010-05-27", salary: "80986.54", employment_status: "active" },
            { id: 81, full_name: "Sam Gupta", job_title_id: 11, department_id: 19, manager_id: 1, hire_date: "2022-09-09", salary: "35134.38", employment_status: "active" },
            { id: 82, full_name: "Oscar Shah", job_title_id: 24, department_id: 7, manager_id: 39, hire_date: "2020-08-30", salary: "50209.57", employment_status: "inactive" },
            { id: 83, full_name: "Rafael Reyes", job_title_id: 14, department_id: 20, manager_id: 7, hire_date: "2023-07-30", salary: "152709.81", employment_status: "active" },
            { id: 84, full_name: "Elena Chen", job_title_id: 7, department_id: 1, manager_id: 15, hire_date: "2022-12-20", salary: "133728.41", employment_status: "active" },
            { id: 85, full_name: "Rosa Sousa", job_title_id: 7, department_id: 13, manager_id: 69, hire_date: "2012-08-03", salary: "85956.66", employment_status: "active" },
            { id: 86, full_name: "Rafael Evans", job_title_id: 12, department_id: 8, manager_id: 6, hire_date: "2012-08-01", salary: "113019.15", employment_status: "inactive" },
            { id: 87, full_name: "Hannah Hassan", job_title_id: 17, department_id: 3, manager_id: null, hire_date: "2015-02-22", salary: "106026.73", employment_status: "active" },
            { id: 88, full_name: "Jonas Gupta", job_title_id: 21, department_id: 17, manager_id: 1, hire_date: "2015-11-19", salary: "92362.21", employment_status: "active" },
            { id: 89, full_name: "Laura Singh", job_title_id: 16, department_id: 14, manager_id: 2, hire_date: "2015-09-03", salary: "39824.43", employment_status: "active" },
            { id: 90, full_name: "Rafael Sato", job_title_id: 14, department_id: 15, manager_id: 13, hire_date: "2012-03-31", salary: "57719.72", employment_status: "active" },
            { id: 91, full_name: "Mateo Kaya", job_title_id: 7, department_id: 12, manager_id: 2, hire_date: "2018-06-18", salary: "130099.07", employment_status: "active" },
            { id: 92, full_name: "Ana Schneider", job_title_id: 5, department_id: 11, manager_id: 27, hire_date: "2018-10-27", salary: "38963.88", employment_status: "active" },
            { id: 93, full_name: "Paula Walker", job_title_id: 27, department_id: 12, manager_id: null, hire_date: "2017-01-20", salary: "110634.23", employment_status: "on leave" },
            { id: 94, full_name: "Hana Adams", job_title_id: 5, department_id: 2, manager_id: 69, hire_date: "2023-05-09", salary: "49686.53", employment_status: "active" },
            { id: 95, full_name: "Yara Oliveira", job_title_id: 8, department_id: 15, manager_id: 39, hire_date: "2020-12-09", salary: "94841.76", employment_status: "active" },
            { id: 96, full_name: "Pedro Kim", job_title_id: 9, department_id: 3, manager_id: null, hire_date: "2017-02-14", salary: "51183.84", employment_status: "active" },
            { id: 97, full_name: "Zoe Murphy", job_title_id: 22, department_id: 4, manager_id: 76, hire_date: "2016-06-30", salary: "37021.26", employment_status: "inactive" },
            { id: 98, full_name: "Maja Hassan", job_title_id: 18, department_id: 1, manager_id: null, hire_date: "2023-02-18", salary: "55852.50", employment_status: "active" },
            { id: 99, full_name: "Amir Smith", job_title_id: 16, department_id: 3, manager_id: 10, hire_date: "2015-05-15", salary: "33472.20", employment_status: "active" },
            { id: 100, full_name: "Priya Ruiz", job_title_id: 15, department_id: 2, manager_id: 27, hire_date: "2019-12-06", salary: "139592.17", employment_status: "active" },
        ],
    });
}

main()
    .then(() => prisma.$disconnect())
    .catch(async error => {
        console.error(error);
        await prisma.$disconnect();
        process.exit(1);
    });