export const viewsSchema = pgSchema('views')
const optionsByReleaseWithGroups = viewsSchema
.view('options_by_group_and_subgroup_by_release', {
releaseId: integer('release_id').notNull(),
id: integer('option_id').notNull(),
name: text('version_name').notNull(),
wholesalePrice: integer('version_wholesale_price'),
uom: text('version_uom').notNull(),
groupId: integer('group_id'),
groupName: text('group_name'),
subgroupId: integer('subgroup_id'),
subgroupName: text('subgroup_name'),
packageOnly: boolean('version_package_only'),
optionType: text('option_type').notNull(),
_versionId: integer('version_id').notNull(),
seriesId: integer('series_id').notNull(),
// vvv PROBLEM FIELD vvv
modelIds: integer('model_ids').array(),
// ^^^ PROBLEM FIELD ^^^
})
.existing()
export const viewsSchema = pgSchema('views')
const optionsByReleaseWithGroups = viewsSchema
.view('options_by_group_and_subgroup_by_release', {
releaseId: integer('release_id').notNull(),
id: integer('option_id').notNull(),
name: text('version_name').notNull(),
wholesalePrice: integer('version_wholesale_price'),
uom: text('version_uom').notNull(),
groupId: integer('group_id'),
groupName: text('group_name'),
subgroupId: integer('subgroup_id'),
subgroupName: text('subgroup_name'),
packageOnly: boolean('version_package_only'),
optionType: text('option_type').notNull(),
_versionId: integer('version_id').notNull(),
seriesId: integer('series_id').notNull(),
// vvv PROBLEM FIELD vvv
modelIds: integer('model_ids').array(),
// ^^^ PROBLEM FIELD ^^^
})
.existing()