export const menuTable = pgTable('menu', {
id: varchar('id', { length: 255 }).primaryKey(),
name: varchar('name', { length: 100 }),
urlRestrict: varchar('url_restrict', { length: 100 }),
svg: varchar('svg', { length: 512 })
});
export const menuTableRelations = relations(menuTable, ({ many }) => ({
menuRole: many(roleToMenuTable),
SubMenu: many(subMenuTable)
}));
export const subMenuTable = pgTable('sub_menu', {
id: varchar('id', { length: 255 }).primaryKey(),
name: varchar('name', { length: 100 }),
urlRestrict: varchar('url_restrict', { length: 100 }),
menuId: varchar('menu_id')
.notNull()
.references(() => menuTable.id, { onDelete: 'cascade' })
.notNull()
});
export const menuTable = pgTable('menu', {
id: varchar('id', { length: 255 }).primaryKey(),
name: varchar('name', { length: 100 }),
urlRestrict: varchar('url_restrict', { length: 100 }),
svg: varchar('svg', { length: 512 })
});
export const menuTableRelations = relations(menuTable, ({ many }) => ({
menuRole: many(roleToMenuTable),
SubMenu: many(subMenuTable)
}));
export const subMenuTable = pgTable('sub_menu', {
id: varchar('id', { length: 255 }).primaryKey(),
name: varchar('name', { length: 100 }),
urlRestrict: varchar('url_restrict', { length: 100 }),
menuId: varchar('menu_id')
.notNull()
.references(() => menuTable.id, { onDelete: 'cascade' })
.notNull()
});