CREATE TABLE clearing_agents (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    nin VARCHAR(50) UNIQUE NOT NULL,
    exihandler_id INT NOT NULL,
    created_at TIMESTAMP DEFAULT NOW(),
    updated_at TIMESTAMP DEFAULT NOW(),
    CONSTRAINT fk_exihandler FOREIGN KEY (exihandler_id) REFERENCES exithandlers(id) ON DELETE CASCADE
);
