The capital project schema needs to explicitly outline which fields are nullable. Fields that can not be null should have a "notNull" constraint added to the drizzle schema. Fields that can be null should have their OpenAPI specification and entity schema updated.
We will also need spatial indexes on the long island state plane geometry columns in order to serve future tickets that perform spatial calculations (ie #247 and #246)
Acceptance criteria
The following drizzle fields have a notNull constraint added
[x] id
[x] managingCode
[x] managingAgency
[x] description
[x] minDate
[x] maxDate
The follow zod and open api fields have a nullable option added
Description
The capital project schema needs to explicitly outline which fields are nullable. Fields that can not be null should have a "notNull" constraint added to the drizzle schema. Fields that can be null should have their OpenAPI specification and entity schema updated.
We will also need spatial indexes on the long island state plane geometry columns in order to serve future tickets that perform spatial calculations (ie #247 and #246)
Acceptance criteria