CREATE TABLE IF NOT EXISTS categories (
  id UUID PRIMARY KEY,
  parent_id UUID NULL REFERENCES categories(id) ON DELETE SET NULL,
  name TEXT NOT NULL,
  slug TEXT NOT NULL UNIQUE,
  is_active BOOLEAN NOT NULL DEFAULT TRUE
);