AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import {
AppConnection,
Cell,
ConcurrencyPool,
Field,
File,
Flow,
Folder,
PieceSet,
Platform,
Project,
Record,
Table,
TableWebhook,
TriggerEvent,
User,
} from '@activepieces/shared'
import { EntitySchema } from 'typeorm'
import {
ApIdSchema,
BaseColumnSchemaPart,
} from '../database/database-common'
type ProjectSchema = Project & {
owner: User
flows: Flow[]
files: File[]
folders: Folder[]
events: TriggerEvent[]
appConnections: AppConnection[]
platform: Platform
tables: Table[]
fields: Field[]
records: Record[]
cells: Cell[]
tableWebhooks: TableWebhook[]
pool?: ConcurrencyPool | null
pieceSet?: PieceSet | null
}
export const ProjectEntity = new EntitySchema<ProjectSchema>({
name: 'project',
columns: {
...BaseColumnSchemaPart,
deleted: {
type: 'timestamp with time zone',
deleteDate: true,
nullable: true,
},
ownerId: ApIdSchema,
displayName: {
type: String,
},
type: {
type: String,
nullable: false,
},
platformId: {
...ApIdSchema,
},
externalId: {
type: String,
nullable: true,
},
maxConcurrentJobs: {
type: Number,
nullable: true,
},
icon: {
type: 'jsonb',
nullable: false,
},
releasesEnabled: {
type: Boolean,
nullable: false,
default: false,
},
notifyFlowOwnerOnFailure: {
type: Boolean,
nullable: false,
default: false,
},
metadata: {
type: 'jsonb',
nullable: true,
},
poolId: {
...ApIdSchema,
nullable: true,
},
pieceSetId: {
...ApIdSchema,
nullable: true,
},
workerGroupId: {
type: String,
nullable: true,
},
executionDataRetentionDays: {
type: Number,
nullable: true,
},
sensitive: {
type: Boolean,
nullable: false,
default: false,
},
isDefault: {
type: Boolean,
nullable: false,
default: false,
},
},
checks: [
{
name: 'chk_project_is_default_team',
expression: '"type" = \'TEAM\' OR "isDefault" = false',
},
],
indices: [
{
name: 'idx_project_owner_id',
columns: ['ownerId'],
unique: false,
},
{
name: 'idx_project_platform_id_external_id',
columns: ['platformId', 'externalId'],
where: 'deleted IS NULL',
unique: true,
},
{
name: 'idx_project_platform_id',
columns: ['platformId'],
unique: false,
},
{
name: 'idx_project_pool_id',
columns: ['poolId'],
unique: false,
},
{
name: 'idx_project_piece_set_id',
columns: ['pieceSetId'],
unique: false,
},
{
name: 'idx_project_worker_group',
columns: ['workerGroupId'],
unique: false,
},
{
name: 'idx_project_execution_data_retention_days',
columns: ['executionDataRetentionDays'],
where: '"executionDataRetentionDays" IS NOT NULL',
unique: false,
},
],
relations: {
owner: {
type: 'many-to-one',
target: 'user',
joinColumn: {
name: 'ownerId',
foreignKeyConstraintName: 'fk_project_owner_id',
},
},
platform: {
type: 'many-to-one',
target: 'platform',
cascade: true,
onDelete: 'RESTRICT',
onUpdate: 'RESTRICT',
joinColumn: {
name: 'platformId',
foreignKeyConstraintName: 'fk_project_platform_id',
},
},
folders: {
type: 'one-to-many',
target: 'folder',
inverseSide: 'project',
},
appConnections: {
type: 'one-to-many',
target: 'app_connection',
inverseSide: 'project',
},
events: {
type: 'one-to-many',
target: 'trigger_event',
inverseSide: 'project',
},
files: {
type: 'one-to-many',
target: 'file',
inverseSide: 'project',
},
flows: {
type: 'one-to-many',
target: 'flow',
inverseSide: 'project',
},
tables: {
type: 'one-to-many',
target: 'table',
inverseSide: 'project',
},
fields: {
type: 'one-to-many',
target: 'field',
inverseSide: 'project',
},
records: {
type: 'one-to-many',
target: 'record',
inverseSide: 'project',
},
cells: {
type: 'one-to-many',
target: 'cell',
inverseSide: 'project',
},
tableWebhooks: {
type: 'one-to-many',
target: 'table_webhook',
inverseSide: 'project',
},
pool: {
type: 'many-to-one',
target: 'concurrency_pool',
onDelete: 'SET NULL',
nullable: true,
joinColumn: {
name: 'poolId',
foreignKeyConstraintName: 'fk_project_pool_id',
},
},
pieceSet: {
type: 'many-to-one',
target: 'piece_set',
onDelete: 'SET NULL',
nullable: true,
joinColumn: {
name: 'pieceSetId',
foreignKeyConstraintName: 'fk_project_piece_set_id',
},
},
},
})