@cfxlabsinc/b2b-services
    Preparing search index...

    Variable emailDeliveryTableConst

    emailDeliveryTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    contentHash: PgBuildColumn<
                        "email_delivery",
                        PgTextBuilder<[string, ...string[]]>,
                        {
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "email_delivery";
                        },
                    >;
                    createdAt: PgBuildColumn<
                        "email_delivery",
                        SetHasDefault<
                            SetNotNull<
                                PgCustomColumnBuilder<
                                    { data: Instant; dataType: "custom"; driverParam: string },
                                >,
                            >,
                        >,
                        {
                            data: Instant;
                            dataType: "custom";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    customerId: PgBuildColumn<
                        "email_delivery",
                        PgIntegerBuilder,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "email_delivery";
                        },
                    >;
                    eventId: PgBuildColumn<
                        "email_delivery",
                        SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                        {
                            data: string;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    id: PgBuildColumn<
                        "email_delivery",
                        HasIdentity<SetIsPrimaryKey<PgIntegerBuilder>, "byDefault">,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: "byDefault";
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    outcome: PgBuildColumn<
                        "email_delivery",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            "SENT" | "SKIPPED",
                        >,
                        {
                            data: "SENT" | "SKIPPED";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    reason: PgBuildColumn<
                        "email_delivery",
                        Set$Type<
                            PgTextBuilder<[string, ...string[]]>,
                            "REJECTED" | "NO_ACTIVE_TEMPLATE" | "NO_RECIPIENTS",
                        >,
                        {
                            data: "REJECTED" | "NO_ACTIVE_TEMPLATE" | "NO_RECIPIENTS";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "email_delivery";
                        },
                    >;
                    recipientCount: PgBuildColumn<
                        "email_delivery",
                        SetNotNull<PgIntegerBuilder>,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    rejectedRecipients: PgBuildColumn<
                        "email_delivery",
                        SetHasDefault<
                            SetNotNull<SetDimensions<PgTextBuilder<[string, ...string[]]>, 1>>,
                        >,
                        {
                            data: string[];
                            dataType: "string";
                            driverParam: string | string[];
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    statusVariant: PgBuildColumn<
                        "email_delivery",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                            StatusVariantOf<
                                | "IDENTITY"
                                | "ORGANIZATION"
                                | "LEDGER_ACCOUNT"
                                | "PAYMENT_INSTRUMENT"
                                | "DEPOSIT"
                                | "WITHDRAW"
                                | "TRANSFER"
                                | "CARD_TRANSACTION"
                                | "INVOICE"
                                | "RECEIPT"
                                | "AUTH"
                                | "APPLICATION",
                            >,
                        >,
                        {
                            data: StatusVariantOf;
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    templateKey: PgBuildColumn<
                        "email_delivery",
                        Set$Type<
                            SetNotNull<PgTextBuilder<[string, ...string[]]>>,

                                | "IDENTITY"
                                | "ORGANIZATION"
                                | "LEDGER_ACCOUNT"
                                | "PAYMENT_INSTRUMENT"
                                | "DEPOSIT"
                                | "WITHDRAW"
                                | "TRANSFER"
                                | "CARD_TRANSACTION"
                                | "INVOICE"
                                | "RECEIPT"
                                | "AUTH"
                                | "APPLICATION",
                        >,
                        {
                            data: | "IDENTITY"
                            | "ORGANIZATION"
                            | "LEDGER_ACCOUNT"
                            | "PAYMENT_INSTRUMENT"
                            | "DEPOSIT"
                            | "WITHDRAW"
                            | "TRANSFER"
                            | "CARD_TRANSACTION"
                            | "INVOICE"
                            | "RECEIPT"
                            | "AUTH"
                            | "APPLICATION";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "email_delivery";
                        },
                    >;
                    templateVersion: PgBuildColumn<
                        "email_delivery",
                        PgIntegerBuilder,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "email_delivery";
                        },
                    >;
                    termsVersion: PgBuildColumn<
                        "email_delivery",
                        PgIntegerBuilder,
                        {
                            data: number;
                            dataType: "number int32";
                            driverParam: string
                            | number;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "email_delivery";
                        },
                    >;
                };
                dialect: "pg";
                isAlias: false;
                name: "email_delivery";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    One send attempt for an event the email lambda handled, SENT or SKIPPED with the reason. Append-only: the newest row for an eventId is the answer a caller waiting on a real delivery (the recurring fee charge) reads.