app-event-routing.entity.ts•1.37 kB
import { FlowId, ProjectId } from '@activepieces/shared'
import { EntitySchema } from 'typeorm'
import { ApIdSchema, BaseColumnSchemaPart } from '../../database/database-common'
export type AppEventRoutingId = string
export type AppEventRouting = {
id: AppEventRoutingId
created: string
updated: string
appName: string
projectId: ProjectId
flowId: FlowId
identifierValue: string
event: string
}
export const AppEventRoutingEntity = new EntitySchema<AppEventRouting>({
name: 'app_event_routing',
columns: {
...BaseColumnSchemaPart,
appName: {
type: String,
},
projectId: ApIdSchema,
flowId: ApIdSchema,
identifierValue: {
type: String,
},
event: {
type: String,
},
},
indices: [
{
name: 'idx_app_event_routing_flow_id',
columns: ['flowId'],
unique: false,
},
{
name: 'idx_app_event_flow_id_project_id_appName_identifier_value_event',
columns: ['appName', 'projectId', 'flowId', 'identifierValue', 'event'],
unique: true,
},
{
name: 'idx_app_event_appName_identifier_event',
columns: ['appName', 'identifierValue', 'event'],
unique: false,
},
],
})