soa-type.ts

// SOA
import { AppAccount, Collaborator } from "@prisma/client";

// list of all row type in the app
enum TableRowTypeString {
  Collaborator,
  AppAccount,
}

// list of all fields for app accounts
enum AppAccountPaths {
  role = "role",
  status = "status",
}

// list of all fields for collaborator
enum CollaboratorPaths {
  hello = "hello",
  world = "world",
}

// list of all fields for all row types
type Fields = {
  [TableRowTypeString.Collaborator]: CollaboratorPaths;
  [TableRowTypeString.AppAccount]: AppAccountPaths;
};

type TData = {
  [TableRowTypeString.Collaborator]: Partial<Collaborator>;
  [TableRowTypeString.AppAccount]: Partial<AppAccount>;
};

// example of a type that forces a given enum based on the TableRowTypeString
type Column<T extends TableRowTypeString> = {
  requiredFields: Fields[T];
  data: TData[T];
};

function getTextColumnDef<T extends TableRowTypeString>(
  props: Partial<Column<T>> & { requiredFields: Fields[T] },
): Column<T> {
  return { ...props, data: { id: "a" } };
}

const prout: Column<TableRowTypeString.AppAccount> = getTextColumnDef({
  requiredFields: AppAccountPaths.role,
});

console.log(prout);