-- Create applicant_status enum
CREATE TYPE app.applicant_status AS ENUM (
    'Initial',
    'Invalid',
    'Pending',
    'Complete'
);

-- Add status field to candidate table
ALTER TABLE app.candidate
ADD COLUMN status app.applicant_status DEFAULT 'Initial' NOT NULL;