//tsconfig.json

{
  "compilerOptions": {
    "paths": {
      "@/*": ["./src/*"]
    }
  }
}

//drizzle.config.ts

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  schema: ['./src/**/schema.ts'],
  //...
});

//src/entites/profile/schema.ts

import { pgTable } from 'drizzle-orm/pg-core';

export const profile = pgTable('profile', (t) => ({
  id: t.integer().primaryKey().generatedAlwaysAsIdentity()
}));

//src/entites/user/schema.ts
import { pgTable } from "drizzle-orm/pg-core";
import { profile } from "@/entities/profile/schema"; // this import fails  

export const user = pgTable(
  'user',
  (t) => ({
    id: t.integer().primaryKey().generatedAlwaysAsIdentity(),
    profileId: t
      .integer()
      .unique()
      .references(() => profile.id)
      .notNull()
  })
);