reset.sql

DELIMITER '//';

DO $$ BEGIN
    DROP TABLE IF EXISTS "application";

IF EXISTS (
    SELECT
        1
    FROM
        pg_type
    WHERE
        typname = 'application_status'
) THEN DROP TYPE APPLICATION_STATUS;

END IF;

DROP TABLE IF EXISTS "employee";

DROP TABLE IF EXISTS "organization";

DROP TABLE IF EXISTS "internship";

DROP TABLE IF EXISTS "candidate_info";

IF EXISTS (
    SELECT
        1
    FROM
        pg_type
    WHERE
        typname = 'internship_direction'
) THEN DROP TYPE INTERNSHIP_DIRECTION;

END IF;

IF EXISTS (
    SELECT
        1
    FROM
        pg_type
    WHERE
        typname = 'work_schedule'
) THEN DROP TYPE WORK_SCHEDULE;

END IF;

DROP TABLE IF EXISTS "referral";

DROP TABLE IF EXISTS "user_profile";

DROP TABLE IF EXISTS "user";

IF EXISTS (
    SELECT
        1
    FROM
        pg_type
    WHERE
        typname = 'user_role'
) THEN DROP TYPE USER_ROLE;

END IF;

END $$