-- Create workplace_registrations table
CREATE TABLE IF NOT EXISTS workplace_registrations (
    id SERIAL PRIMARY KEY,
    company_name VARCHAR(255) NOT NULL,
    address TEXT,
    contact_email VARCHAR(255),
    contact_phone VARCHAR(50),
    status VARCHAR(50) DEFAULT 'pending',
    assigned_reviewer_id INTEGER,
    isDeleted BOOLEAN NOT NULL DEFAULT FALSE,
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX workplace_registrations_status_idx ON workplace_registrations(status);
CREATE INDEX workplace_registrations_reviewer_idx ON workplace_registrations(assigned_reviewer_id);
CREATE INDEX workplace_registrations_email_idx ON workplace_registrations(contact_email);
