Hey All, having a problem with a column that is unique and supposed to be nullable. Prisma seems to default everything to 'not null' but I dont see a keyword where to allow now.

Do you mean the

?

modifier? https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#-modifier-1

I have that but its still sending a 'Not Null' to the database DDL

Did you run the migration and regenerate client?

yes. This is how the DDL is defined in the backend:

CREATE TABLE [dbo].[Category](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](1000) NOT NULL,
	[url] [nvarchar](1000) NOT NULL,
	[uploadId] [int] NULL,
	[parentId] [int] NULL,
	[updatedAt] [datetime2](7) NOT NULL,
	[createdAt] [datetime2](7) NOT NULL,
 CONSTRAINT [Category_pkey] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
 CONSTRAINT [Category_uploadId_key] UNIQUE NONCLUSTERED 
(
	[uploadId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Category] ADD  CONSTRAINT [Category_createdAt_df]  DEFAULT (getdate()) FOR [createdAt]
GO

ALTER TABLE [dbo].[Category]  WITH CHECK ADD  CONSTRAINT [Category_parentId_fkey] FOREIGN KEY([parentId])
REFERENCES [dbo].[Category] ([id])
GO

ALTER TABLE [dbo].[Category] CHECK CONSTRAINT [Category_parentId_fkey]
GO

ALTER TABLE [dbo].[Category]  WITH CHECK ADD  CONSTRAINT [Category_uploadId_fkey] FOREIGN KEY([uploadId])
REFERENCES [dbo].[Upload] ([id])
ON UPDATE CASCADE
ON DELETE SET NULL
GO

ALTER TABLE [dbo].[Category] CHECK CONSTRAINT [Category_uploadId_fkey]
GO