Skip to content

A desktop coding agent with free access to frontier models.

TypeScript
37.6 KB
Raw Blame
import { relations, sql } from "drizzle-orm"
import {
  boolean,
  index,
  int,
  json,
  mysqlEnum,
  mysqlTable,
  text,
  timestamp,
  uniqueIndex,
  varchar,
} from "drizzle-orm/mysql-core"
import { denTypeIdColumn, encryptedColumn, encryptedMediumTextColumn } from "../../columns"
import { MemberTable, OrganizationTable } from "../org"
import { TeamTable } from "../teams"

export const configObjectTypeValues = ["skill", "agent", "command", "tool", "mcp", "hook", "context", "custom", "script", "workflow", "app"] as const
export const configObjectSourceModeValues = ["cloud", "import", "connector"] as const
export const configObjectStatusValues = ["active", "inactive", "deleted", "archived", "ingestion_error"] as const
export const configObjectCreatedViaValues = ["cloud", "import", "connector", "system"] as const
export const pluginStatusValues = ["active", "inactive", "deleted", "archived"] as const
export const marketplaceStatusValues = ["active", "inactive", "deleted", "archived"] as const
export const membershipSourceValues = ["manual", "connector", "api", "system"] as const
export const accessRoleValues = ["viewer", "editor", "manager"] as const
export const connectorTypeValues = ["github"] as const
export const connectorAccountStatusValues = ["active", "inactive", "disconnected", "error"] as const
export const connectorInstanceStatusValues = ["active", "disabled", "archived", "error"] as const
export const connectorTargetKindValues = ["repository_branch"] as const
export const connectorMappingKindValues = ["path", "api", "custom"] as const
export const connectorSyncEventTypeValues = ["push", "installation", "installation_repositories", "repository", "manual_resync"] as const
export const connectorSyncStatusValues = ["pending", "queued", "running", "completed", "failed", "partial", "ignored"] as const

function encryptedJsonColumn<TData extends Record<string, unknown> | Array<unknown> | null>(columnName: string) {
  return encryptedColumn<TData>(columnName, {
    dataType: "mediumtext",
    deserialize: (value) => JSON.parse(value) as TData,
    serialize: (value) => JSON.stringify(value),
  })
}

export const ConfigObjectTable = mysqlTable(
  "config_object",
  {
    id: denTypeIdColumn("configObject", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    objectType: mysqlEnum("object_type", configObjectTypeValues).notNull(),
    sourceMode: mysqlEnum("source_mode", configObjectSourceModeValues).notNull(),
    title: varchar("title", { length: 255 }).notNull(),
    description: text("description"),
    searchText: text("search_text"),
    currentFileName: varchar("current_file_name", { length: 255 }),
    currentFileExtension: varchar("current_file_extension", { length: 64 }),
    currentRelativePath: varchar("current_relative_path", { length: 255 }),
    status: mysqlEnum("status", configObjectStatusValues).notNull().default("active"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
    deletedAt: timestamp("deleted_at", { fsp: 3 }),
  },
  (table) => [
    index("config_object_organization_id").on(table.organizationId),
    index("config_object_type").on(table.objectType),
    index("config_object_source_mode").on(table.sourceMode),
    index("config_object_status").on(table.status),
    index("config_object_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("config_object_connector_instance_id").on(table.connectorInstanceId),
    index("config_object_current_relative_path").on(table.currentRelativePath),
  ],
)

export const ConfigObjectVersionTable = mysqlTable(
  "config_object_version",
  {
    id: denTypeIdColumn("configObjectVersion", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    configObjectId: denTypeIdColumn("configObject", "config_object_id").notNull(),
    normalizedPayloadJson: encryptedJsonColumn<Record<string, unknown> | null>("normalized_payload_json"),
    rawSourceText: encryptedMediumTextColumn("raw_source_text"),
    schemaVersion: varchar("schema_version", { length: 100 }),
    createdVia: mysqlEnum("created_via", configObjectCreatedViaValues).notNull(),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id"),
    connectorSyncEventId: denTypeIdColumn("connectorSyncEvent", "connector_sync_event_id"),
    sourceRevisionRef: varchar("source_revision_ref", { length: 255 }),
    isDeletedVersion: boolean("is_deleted_version").notNull().default(false),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("config_object_version_organization_id").on(table.organizationId),
    index("config_object_version_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("config_object_version_connector_sync_event_id").on(table.connectorSyncEventId),
    index("config_object_version_source_revision_ref").on(table.sourceRevisionRef),
    index("config_object_version_lookup_latest").on(table.configObjectId, table.createdAt, table.id),
  ],
)

export const PluginTable = mysqlTable(
  "plugin",
  {
    id: denTypeIdColumn("plugin", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    name: varchar("name", { length: 255 }).notNull(),
    description: text("description"),
    sourceRepositoryUrl: varchar("source_repository_url", { length: 1024 }),
    sourceFormat: varchar("source_format", { length: 64 }),
    sourceSchemaVersion: varchar("source_schema_version", { length: 100 }),
    status: mysqlEnum("status", pluginStatusValues).notNull().default("active"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
    deletedAt: timestamp("deleted_at", { fsp: 3 }),
  },
  (table) => [
    index("plugin_organization_id").on(table.organizationId),
    index("plugin_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("plugin_status").on(table.status),
    index("plugin_name").on(table.name),
  ],
)

export const MarketplaceTable = mysqlTable(
  "marketplace",
  {
    externalKey: varchar("external_key", { length: 128 }),
    id: denTypeIdColumn("marketplace", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    name: varchar("name", { length: 255 }).notNull(),
    description: text("description"),
    logoUrl: varchar("logo_url", { length: 1024 }),
    status: mysqlEnum("status", marketplaceStatusValues).notNull().default("active"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
    deletedAt: timestamp("deleted_at", { fsp: 3 }),
  },
  (table) => [
    uniqueIndex("marketplace_org_external_key").on(table.organizationId, table.externalKey),
    index("marketplace_organization_id").on(table.organizationId),
    index("marketplace_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("marketplace_status").on(table.status),
    index("marketplace_name").on(table.name),
  ],
)

export const MarketplacePluginTable = mysqlTable(
  "marketplace_plugin",
  {
    id: denTypeIdColumn("marketplacePlugin", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    marketplaceId: denTypeIdColumn("marketplace", "marketplace_id").notNull(),
    pluginId: denTypeIdColumn("plugin", "plugin_id").notNull(),
    membershipSource: mysqlEnum("membership_source", membershipSourceValues).notNull().default("manual"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("marketplace_plugin_organization_id").on(table.organizationId),
    index("marketplace_plugin_plugin_id").on(table.pluginId),
    uniqueIndex("marketplace_plugin_marketplace_plugin").on(table.marketplaceId, table.pluginId),
  ],
)

export const MarketplaceAccessGrantTable = mysqlTable(
  "marketplace_access_grant",
  {
    id: denTypeIdColumn("marketplaceAccessGrant", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    marketplaceId: denTypeIdColumn("marketplace", "marketplace_id").notNull(),
    orgMembershipId: denTypeIdColumn("member", "org_membership_id"),
    teamId: denTypeIdColumn("team", "team_id"),
    orgWide: boolean("org_wide").notNull().default(false),
    role: mysqlEnum("role", accessRoleValues).notNull(),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("marketplace_access_grant_organization_id").on(table.organizationId),
    index("marketplace_access_grant_org_membership_id").on(table.orgMembershipId),
    index("marketplace_access_grant_team_id").on(table.teamId),
    index("marketplace_access_grant_org_wide").on(table.orgWide),
    uniqueIndex("marketplace_access_grant_marketplace_org_membership").on(table.marketplaceId, table.orgMembershipId),
    uniqueIndex("marketplace_access_grant_marketplace_team").on(table.marketplaceId, table.teamId),
  ],
)

export const PluginConfigObjectTable = mysqlTable(
  "plugin_config_object",
  {
    id: denTypeIdColumn("pluginConfigObject", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    pluginId: denTypeIdColumn("plugin", "plugin_id").notNull(),
    configObjectId: denTypeIdColumn("configObject", "config_object_id").notNull(),
    membershipSource: mysqlEnum("membership_source", membershipSourceValues).notNull().default("manual"),
    connectorMappingId: denTypeIdColumn("connectorMapping", "connector_mapping_id"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("plugin_config_object_organization_id").on(table.organizationId),
    index("plugin_config_object_config_object_id").on(table.configObjectId),
    index("plugin_config_object_connector_mapping_id").on(table.connectorMappingId),
    uniqueIndex("plugin_config_object_plugin_config_object").on(table.pluginId, table.configObjectId),
  ],
)

export const ConfigObjectAccessGrantTable = mysqlTable(
  "config_object_access_grant",
  {
    id: denTypeIdColumn("configObjectAccessGrant", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    configObjectId: denTypeIdColumn("configObject", "config_object_id").notNull(),
    orgMembershipId: denTypeIdColumn("member", "org_membership_id"),
    teamId: denTypeIdColumn("team", "team_id"),
    orgWide: boolean("org_wide").notNull().default(false),
    role: mysqlEnum("role", accessRoleValues).notNull(),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("config_object_access_grant_organization_id").on(table.organizationId),
    index("config_object_access_grant_org_membership_id").on(table.orgMembershipId),
    index("config_object_access_grant_team_id").on(table.teamId),
    index("config_object_access_grant_org_wide").on(table.orgWide),
    uniqueIndex("config_object_access_grant_object_org_membership").on(table.configObjectId, table.orgMembershipId),
    uniqueIndex("config_object_access_grant_object_team").on(table.configObjectId, table.teamId),
  ],
)

export const PluginAccessGrantTable = mysqlTable(
  "plugin_access_grant",
  {
    id: denTypeIdColumn("pluginAccessGrant", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    pluginId: denTypeIdColumn("plugin", "plugin_id").notNull(),
    orgMembershipId: denTypeIdColumn("member", "org_membership_id"),
    teamId: denTypeIdColumn("team", "team_id"),
    orgWide: boolean("org_wide").notNull().default(false),
    role: mysqlEnum("role", accessRoleValues).notNull(),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("plugin_access_grant_organization_id").on(table.organizationId),
    index("plugin_access_grant_org_membership_id").on(table.orgMembershipId),
    index("plugin_access_grant_team_id").on(table.teamId),
    index("plugin_access_grant_org_wide").on(table.orgWide),
    uniqueIndex("plugin_access_grant_plugin_org_membership").on(table.pluginId, table.orgMembershipId),
    uniqueIndex("plugin_access_grant_plugin_team").on(table.pluginId, table.teamId),
  ],
)

export const ConnectorAccountTable = mysqlTable(
  "connector_account",
  {
    id: denTypeIdColumn("connectorAccount", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }).notNull(),
    externalAccountRef: varchar("external_account_ref", { length: 255 }),
    displayName: varchar("display_name", { length: 255 }).notNull(),
    status: mysqlEnum("status", connectorAccountStatusValues).notNull().default("active"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    metadataJson: json("metadata_json").$type<Record<string, unknown> | null>(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [
    index("connector_account_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("connector_account_connector_type").on(table.connectorType),
    index("idx_connector_account_on_remote_id").on(table.remoteId),
    index("connector_account_status").on(table.status),
    uniqueIndex("connector_account_org_type_remote_id").on(table.organizationId, table.connectorType, table.remoteId),
  ],
)

export const ConnectorInstanceTable = mysqlTable(
  "connector_instance",
  {
    id: denTypeIdColumn("connectorInstance", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorAccountId: denTypeIdColumn("connectorAccount", "connector_account_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }),
    name: varchar("name", { length: 255 }).notNull(),
    status: mysqlEnum("status", connectorInstanceStatusValues).notNull().default("active"),
    instanceConfigJson: json("instance_config_json").$type<Record<string, unknown> | null>(),
    lastSyncedAt: timestamp("last_synced_at", { fsp: 3 }),
    lastSyncStatus: mysqlEnum("last_sync_status", connectorSyncStatusValues),
    lastSyncCursor: text("last_sync_cursor"),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [
    index("connector_instance_connector_account_id").on(table.connectorAccountId),
    index("connector_instance_created_by_org_membership_id").on(table.createdByOrgMembershipId),
    index("connector_instance_connector_type").on(table.connectorType),
    index("connector_instance_status").on(table.status),
    uniqueIndex("connector_instance_org_name").on(table.organizationId, table.name),
  ],
)

export const ConnectorInstanceAccessGrantTable = mysqlTable(
  "connector_instance_access_grant",
  {
    id: denTypeIdColumn("connectorInstanceAccessGrant", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    orgMembershipId: denTypeIdColumn("member", "org_membership_id"),
    teamId: denTypeIdColumn("team", "team_id"),
    orgWide: boolean("org_wide").notNull().default(false),
    role: mysqlEnum("role", accessRoleValues).notNull(),
    createdByOrgMembershipId: denTypeIdColumn("member", "created_by_org_membership_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
  },
  (table) => [
    index("connector_instance_access_grant_organization_id").on(table.organizationId),
    index("connector_instance_access_grant_org_membership_id").on(table.orgMembershipId),
    index("connector_instance_access_grant_team_id").on(table.teamId),
    index("connector_instance_access_grant_org_wide").on(table.orgWide),
    uniqueIndex("connector_instance_access_grant_instance_org_membership").on(table.connectorInstanceId, table.orgMembershipId),
    uniqueIndex("connector_instance_access_grant_instance_team").on(table.connectorInstanceId, table.teamId),
  ],
)

export const ConnectorTargetTable = mysqlTable(
  "connector_target",
  {
    id: denTypeIdColumn("connectorTarget", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }).notNull(),
    targetKind: mysqlEnum("target_kind", connectorTargetKindValues).notNull(),
    externalTargetRef: varchar("external_target_ref", { length: 255 }),
    targetConfigJson: json("target_config_json").$type<Record<string, unknown>>().notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [
    index("connector_target_organization_id").on(table.organizationId),
    index("connector_target_connector_type").on(table.connectorType),
    index("connector_target_type_created_id").on(table.connectorType, table.createdAt, table.id),
    index("connector_target_target_kind").on(table.targetKind),
    uniqueIndex("connector_target_instance_remote_id").on(table.connectorInstanceId, table.remoteId),
  ],
)

export const ConnectorMappingTable = mysqlTable(
  "connector_mapping",
  {
    id: denTypeIdColumn("connectorMapping", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    connectorTargetId: denTypeIdColumn("connectorTarget", "connector_target_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }),
    mappingKind: mysqlEnum("mapping_kind", connectorMappingKindValues).notNull(),
    selector: varchar("selector", { length: 255 }).notNull(),
    objectType: mysqlEnum("object_type", configObjectTypeValues).notNull(),
    pluginId: denTypeIdColumn("plugin", "plugin_id"),
    autoAddToPlugin: boolean("auto_add_to_plugin").notNull().default(false),
    mappingConfigJson: json("mapping_config_json").$type<Record<string, unknown> | null>(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [
    index("connector_mapping_organization_id").on(table.organizationId),
    index("connector_mapping_connector_instance_id").on(table.connectorInstanceId),
    index("connector_mapping_object_type").on(table.objectType),
    index("connector_mapping_plugin_id").on(table.pluginId),
    uniqueIndex("connector_mapping_target_selector_object_type").on(table.connectorTargetId, table.selector, table.objectType),
  ],
)

export const ConnectorSyncEventTable = mysqlTable(
  "connector_sync_event",
  {
    id: denTypeIdColumn("connectorSyncEvent", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    connectorTargetId: denTypeIdColumn("connectorTarget", "connector_target_id"),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }),
    eventType: mysqlEnum("event_type", connectorSyncEventTypeValues).notNull(),
    externalEventRef: varchar("external_event_ref", { length: 255 }),
    sourceRevisionRef: varchar("source_revision_ref", { length: 255 }),
    status: mysqlEnum("status", connectorSyncStatusValues).notNull().default("pending"),
    attemptCount: int("attempt_count").notNull().default(0),
    nextAttemptAt: timestamp("next_attempt_at", { fsp: 3 }),
    summaryJson: json("summary_json").$type<Record<string, unknown> | null>(),
    startedAt: timestamp("started_at", { fsp: 3 }).notNull().defaultNow(),
    completedAt: timestamp("completed_at", { fsp: 3 }),
  },
  (table) => [
    index("connector_sync_event_organization_id").on(table.organizationId),
    index("connector_sync_event_connector_instance_id").on(table.connectorInstanceId),
    index("connector_sync_event_connector_target_id").on(table.connectorTargetId),
    index("connector_sync_event_target_status").on(table.connectorTargetId, table.status),
    index("connector_sync_event_event_type").on(table.eventType),
    index("connector_sync_event_status").on(table.status),
    index("connector_sync_event_status_next_attempt_at").on(table.status, table.nextAttemptAt),
    index("connector_sync_event_source_revision_ref").on(table.sourceRevisionRef),
    index("connector_sync_event_external_event_ref").on(table.externalEventRef),
  ],
)

export const ConnectorSourceBindingTable = mysqlTable(
  "connector_source_binding",
  {
    id: denTypeIdColumn("connectorSourceBinding", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    configObjectId: denTypeIdColumn("configObject", "config_object_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    connectorTargetId: denTypeIdColumn("connectorTarget", "connector_target_id").notNull(),
    connectorMappingId: denTypeIdColumn("connectorMapping", "connector_mapping_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }),
    externalLocator: varchar("external_locator", { length: 255 }).notNull(),
    externalStableRef: varchar("external_stable_ref", { length: 255 }),
    lastSeenSourceRevisionRef: varchar("last_seen_source_revision_ref", { length: 255 }),
    status: mysqlEnum("status", configObjectStatusValues).notNull().default("active"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
    deletedAt: timestamp("deleted_at", { fsp: 3 }),
  },
  (table) => [
    index("connector_source_binding_organization_id").on(table.organizationId),
    index("connector_source_binding_connector_instance_id").on(table.connectorInstanceId),
    index("connector_source_binding_connector_target_id").on(table.connectorTargetId),
    index("connector_source_binding_connector_mapping_id").on(table.connectorMappingId),
    index("connector_source_binding_external_locator").on(table.externalLocator),
    uniqueIndex("connector_source_binding_config_object").on(table.configObjectId),
  ],
)

export const ConnectorSourceTombstoneTable = mysqlTable(
  "connector_source_tombstone",
  {
    id: denTypeIdColumn("connectorSourceTombstone", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    connectorInstanceId: denTypeIdColumn("connectorInstance", "connector_instance_id").notNull(),
    connectorTargetId: denTypeIdColumn("connectorTarget", "connector_target_id").notNull(),
    connectorMappingId: denTypeIdColumn("connectorMapping", "connector_mapping_id").notNull(),
    connectorType: mysqlEnum("connector_type", connectorTypeValues).notNull(),
    remoteId: varchar("remote_id", { length: 255 }),
    externalLocator: varchar("external_locator", { length: 255 }).notNull(),
    formerConfigObjectId: denTypeIdColumn("configObject", "former_config_object_id").notNull(),
    deletedInSyncEventId: denTypeIdColumn("connectorSyncEvent", "deleted_in_sync_event_id").notNull(),
    deletedSourceRevisionRef: varchar("deleted_source_revision_ref", { length: 255 }),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("connector_source_tombstone_organization_id").on(table.organizationId),
    index("connector_source_tombstone_connector_instance_id").on(table.connectorInstanceId),
    index("connector_source_tombstone_connector_target_id").on(table.connectorTargetId),
    index("connector_source_tombstone_connector_mapping_id").on(table.connectorMappingId),
    index("connector_source_tombstone_external_locator").on(table.externalLocator),
    index("connector_source_tombstone_former_config_object_id").on(table.formerConfigObjectId),
  ],
)

export const configObjectRelations = relations(ConfigObjectTable, ({ many, one }) => ({
  accessGrants: many(ConfigObjectAccessGrantTable),
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConfigObjectTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  createdByOrgMembership: one(MemberTable, {
    fields: [ConfigObjectTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  memberships: many(PluginConfigObjectTable),
  organization: one(OrganizationTable, {
    fields: [ConfigObjectTable.organizationId],
    references: [OrganizationTable.id],
  }),
  sourceBindings: many(ConnectorSourceBindingTable),
  versions: many(ConfigObjectVersionTable),
}))

export const configObjectVersionRelations = relations(ConfigObjectVersionTable, ({ one }) => ({
  configObject: one(ConfigObjectTable, {
    fields: [ConfigObjectVersionTable.configObjectId],
    references: [ConfigObjectTable.id],
  }),
  connectorSyncEvent: one(ConnectorSyncEventTable, {
    fields: [ConfigObjectVersionTable.connectorSyncEventId],
    references: [ConnectorSyncEventTable.id],
  }),
  createdByOrgMembership: one(MemberTable, {
    fields: [ConfigObjectVersionTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
}))

export const pluginRelations = relations(PluginTable, ({ many, one }) => ({
  accessGrants: many(PluginAccessGrantTable),
  createdByOrgMembership: one(MemberTable, {
    fields: [PluginTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  marketplaces: many(MarketplacePluginTable),
  memberships: many(PluginConfigObjectTable),
  organization: one(OrganizationTable, {
    fields: [PluginTable.organizationId],
    references: [OrganizationTable.id],
  }),
  mappings: many(ConnectorMappingTable),
}))

export const marketplaceRelations = relations(MarketplaceTable, ({ many, one }) => ({
  accessGrants: many(MarketplaceAccessGrantTable),
  createdByOrgMembership: one(MemberTable, {
    fields: [MarketplaceTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  memberships: many(MarketplacePluginTable),
  organization: one(OrganizationTable, {
    fields: [MarketplaceTable.organizationId],
    references: [OrganizationTable.id],
  }),
}))

export const marketplacePluginRelations = relations(MarketplacePluginTable, ({ one }) => ({
  createdByOrgMembership: one(MemberTable, {
    fields: [MarketplacePluginTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  marketplace: one(MarketplaceTable, {
    fields: [MarketplacePluginTable.marketplaceId],
    references: [MarketplaceTable.id],
  }),
  plugin: one(PluginTable, {
    fields: [MarketplacePluginTable.pluginId],
    references: [PluginTable.id],
  }),
}))

export const marketplaceAccessGrantRelations = relations(MarketplaceAccessGrantTable, ({ one }) => ({
  createdByOrgMembership: one(MemberTable, {
    fields: [MarketplaceAccessGrantTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  marketplace: one(MarketplaceTable, {
    fields: [MarketplaceAccessGrantTable.marketplaceId],
    references: [MarketplaceTable.id],
  }),
  orgMembership: one(MemberTable, {
    fields: [MarketplaceAccessGrantTable.orgMembershipId],
    references: [MemberTable.id],
  }),
  team: one(TeamTable, {
    fields: [MarketplaceAccessGrantTable.teamId],
    references: [TeamTable.id],
  }),
}))

export const pluginConfigObjectRelations = relations(PluginConfigObjectTable, ({ one }) => ({
  configObject: one(ConfigObjectTable, {
    fields: [PluginConfigObjectTable.configObjectId],
    references: [ConfigObjectTable.id],
  }),
  connectorMapping: one(ConnectorMappingTable, {
    fields: [PluginConfigObjectTable.connectorMappingId],
    references: [ConnectorMappingTable.id],
  }),
  createdByOrgMembership: one(MemberTable, {
    fields: [PluginConfigObjectTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  plugin: one(PluginTable, {
    fields: [PluginConfigObjectTable.pluginId],
    references: [PluginTable.id],
  }),
}))

export const configObjectAccessGrantRelations = relations(ConfigObjectAccessGrantTable, ({ one }) => ({
  configObject: one(ConfigObjectTable, {
    fields: [ConfigObjectAccessGrantTable.configObjectId],
    references: [ConfigObjectTable.id],
  }),
  createdByOrgMembership: one(MemberTable, {
    fields: [ConfigObjectAccessGrantTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  orgMembership: one(MemberTable, {
    fields: [ConfigObjectAccessGrantTable.orgMembershipId],
    references: [MemberTable.id],
  }),
  team: one(TeamTable, {
    fields: [ConfigObjectAccessGrantTable.teamId],
    references: [TeamTable.id],
  }),
}))

export const pluginAccessGrantRelations = relations(PluginAccessGrantTable, ({ one }) => ({
  createdByOrgMembership: one(MemberTable, {
    fields: [PluginAccessGrantTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  orgMembership: one(MemberTable, {
    fields: [PluginAccessGrantTable.orgMembershipId],
    references: [MemberTable.id],
  }),
  plugin: one(PluginTable, {
    fields: [PluginAccessGrantTable.pluginId],
    references: [PluginTable.id],
  }),
  team: one(TeamTable, {
    fields: [PluginAccessGrantTable.teamId],
    references: [TeamTable.id],
  }),
}))

export const connectorAccountRelations = relations(ConnectorAccountTable, ({ many, one }) => ({
  createdByOrgMembership: one(MemberTable, {
    fields: [ConnectorAccountTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  instances: many(ConnectorInstanceTable),
  organization: one(OrganizationTable, {
    fields: [ConnectorAccountTable.organizationId],
    references: [OrganizationTable.id],
  }),
}))

export const connectorInstanceRelations = relations(ConnectorInstanceTable, ({ many, one }) => ({
  accessGrants: many(ConnectorInstanceAccessGrantTable),
  account: one(ConnectorAccountTable, {
    fields: [ConnectorInstanceTable.connectorAccountId],
    references: [ConnectorAccountTable.id],
  }),
  configObjects: many(ConfigObjectTable),
  createdByOrgMembership: one(MemberTable, {
    fields: [ConnectorInstanceTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  mappings: many(ConnectorMappingTable),
  organization: one(OrganizationTable, {
    fields: [ConnectorInstanceTable.organizationId],
    references: [OrganizationTable.id],
  }),
  sourceBindings: many(ConnectorSourceBindingTable),
  syncEvents: many(ConnectorSyncEventTable),
  targets: many(ConnectorTargetTable),
  tombstones: many(ConnectorSourceTombstoneTable),
}))

export const connectorInstanceAccessGrantRelations = relations(ConnectorInstanceAccessGrantTable, ({ one }) => ({
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorInstanceAccessGrantTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  createdByOrgMembership: one(MemberTable, {
    fields: [ConnectorInstanceAccessGrantTable.createdByOrgMembershipId],
    references: [MemberTable.id],
  }),
  orgMembership: one(MemberTable, {
    fields: [ConnectorInstanceAccessGrantTable.orgMembershipId],
    references: [MemberTable.id],
  }),
  team: one(TeamTable, {
    fields: [ConnectorInstanceAccessGrantTable.teamId],
    references: [TeamTable.id],
  }),
}))

export const connectorTargetRelations = relations(ConnectorTargetTable, ({ many, one }) => ({
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorTargetTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  mappings: many(ConnectorMappingTable),
  sourceBindings: many(ConnectorSourceBindingTable),
  syncEvents: many(ConnectorSyncEventTable),
  tombstones: many(ConnectorSourceTombstoneTable),
}))

export const connectorMappingRelations = relations(ConnectorMappingTable, ({ many, one }) => ({
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorMappingTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  connectorTarget: one(ConnectorTargetTable, {
    fields: [ConnectorMappingTable.connectorTargetId],
    references: [ConnectorTargetTable.id],
  }),
  plugin: one(PluginTable, {
    fields: [ConnectorMappingTable.pluginId],
    references: [PluginTable.id],
  }),
  pluginMemberships: many(PluginConfigObjectTable),
  sourceBindings: many(ConnectorSourceBindingTable),
  tombstones: many(ConnectorSourceTombstoneTable),
}))

export const connectorSyncEventRelations = relations(ConnectorSyncEventTable, ({ many, one }) => ({
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorSyncEventTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  connectorTarget: one(ConnectorTargetTable, {
    fields: [ConnectorSyncEventTable.connectorTargetId],
    references: [ConnectorTargetTable.id],
  }),
  tombstones: many(ConnectorSourceTombstoneTable),
  versions: many(ConfigObjectVersionTable),
}))

export const connectorSourceBindingRelations = relations(ConnectorSourceBindingTable, ({ one }) => ({
  configObject: one(ConfigObjectTable, {
    fields: [ConnectorSourceBindingTable.configObjectId],
    references: [ConfigObjectTable.id],
  }),
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorSourceBindingTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  connectorMapping: one(ConnectorMappingTable, {
    fields: [ConnectorSourceBindingTable.connectorMappingId],
    references: [ConnectorMappingTable.id],
  }),
  connectorTarget: one(ConnectorTargetTable, {
    fields: [ConnectorSourceBindingTable.connectorTargetId],
    references: [ConnectorTargetTable.id],
  }),
}))

export const connectorSourceTombstoneRelations = relations(ConnectorSourceTombstoneTable, ({ one }) => ({
  connectorInstance: one(ConnectorInstanceTable, {
    fields: [ConnectorSourceTombstoneTable.connectorInstanceId],
    references: [ConnectorInstanceTable.id],
  }),
  connectorMapping: one(ConnectorMappingTable, {
    fields: [ConnectorSourceTombstoneTable.connectorMappingId],
    references: [ConnectorMappingTable.id],
  }),
  connectorTarget: one(ConnectorTargetTable, {
    fields: [ConnectorSourceTombstoneTable.connectorTargetId],
    references: [ConnectorTargetTable.id],
  }),
  deletedInSyncEvent: one(ConnectorSyncEventTable, {
    fields: [ConnectorSourceTombstoneTable.deletedInSyncEventId],
    references: [ConnectorSyncEventTable.id],
  }),
  formerConfigObject: one(ConfigObjectTable, {
    fields: [ConnectorSourceTombstoneTable.formerConfigObjectId],
    references: [ConfigObjectTable.id],
  }),
}))

export const configObject = ConfigObjectTable
export const configObjectVersion = ConfigObjectVersionTable
export const plugin = PluginTable
export const marketplace = MarketplaceTable
export const marketplacePlugin = MarketplacePluginTable
export const marketplaceAccessGrant = MarketplaceAccessGrantTable
export const pluginConfigObject = PluginConfigObjectTable
export const configObjectAccessGrant = ConfigObjectAccessGrantTable
export const pluginAccessGrant = PluginAccessGrantTable
export const connectorAccount = ConnectorAccountTable
export const connectorInstance = ConnectorInstanceTable
export const connectorInstanceAccessGrant = ConnectorInstanceAccessGrantTable
export const connectorTarget = ConnectorTargetTable
export const connectorMapping = ConnectorMappingTable
export const connectorSyncEvent = ConnectorSyncEventTable
export const connectorSourceBinding = ConnectorSourceBindingTable
export const connectorSourceTombstone = ConnectorSourceTombstoneTable