DROP TABLE IF EXISTS job_seeker_documents;
DROP TABLE IF EXISTS job_applications;
DROP FUNCTION IF EXISTS set_job_application_reference_number();
DROP SEQUENCE IF EXISTS job_application_number_seq;

ALTER TABLE job_seeker_profiles
    DROP COLUMN IF EXISTS full_name,
    DROP COLUMN IF EXISTS location,
    DROP COLUMN IF EXISTS summary,
    DROP COLUMN IF EXISTS skills,
    DROP COLUMN IF EXISTS active_application_count,
    DROP COLUMN IF EXISTS status;
