@cfxlabsinc/b2b-services
    Preparing search index...
    girasolCardSelection: {
        cardholderName: SQL<string>;
        createdAt: PgBuildColumn<
            "girasol_card",
            SetHasDefault<SetNotNull<PgTimestampBuilder>>,
            {
                data: Date;
                dataType: "object date";
                driverParam: string;
                enumValues: undefined;
                generated: undefined;
                hasDefault: true;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: true;
                tableName: "girasol_card";
            },
        >;
        customerExternalId: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        customerId: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        displayName: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        expiryMonth: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        expiryYear: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        externalId: PgBuildColumn<
            "girasol_card",
            SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
            {
                data: string;
                dataType: "string";
                driverParam: string;
                enumValues: undefined;
                generated: undefined;
                hasDefault: true;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: true;
                tableName: "girasol_card";
            },
        >;
        firstName: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        girasolAccountExternalId: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        girasolAccountId: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        girasolCardId: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        id: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        lastFourDigits: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        lastName: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        maskedCardNumber: SQL<string>;
        phone: PgBuildColumn<
            "girasol_card",
            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: "girasol_card";
            },
        >;
        shippingAddress: PgBuildColumn<
            "girasol_card",
            Set$Type<
                PgJsonbBuilder,
                {
                    city: string;
                    countryCode: string;
                    line1: string;
                    line2?: string;
                    postalCode: string;
                    region?: string;
                },
            >,
            {
                data: {
                    city: string;
                    countryCode: string;
                    line1: string;
                    line2?: string;
                    postalCode: string;
                    region?: string;
                };
                dataType: "object json";
                driverParam: unknown;
                enumValues: undefined;
                generated: undefined;
                hasDefault: false;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: false;
                tableName: "girasol_card";
            },
        >;
        status: PgBuildColumn<
            "girasol_card",
            Set$Type<
                SetHasDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,

                    | "ACTIVE"
                    | "DELETED"
                    | "BLOCKED"
                    | "REJECTED"
                    | "UNKNOWN"
                    | "CREATED"
                    | "REQUESTED"
                    | "EXPIRED"
                    | "FROZEN"
                    | "DELIVERED",
            >,
            {
                data: | "ACTIVE"
                | "DELETED"
                | "BLOCKED"
                | "REJECTED"
                | "UNKNOWN"
                | "CREATED"
                | "REQUESTED"
                | "EXPIRED"
                | "FROZEN"
                | "DELIVERED";
                dataType: "string";
                driverParam: string;
                enumValues: undefined;
                generated: undefined;
                hasDefault: true;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: true;
                tableName: "girasol_card";
            },
        >;
        statusDescription: SQL<string>;
        type: PgBuildColumn<
            "girasol_card",
            Set$Type<
                SetNotNull<PgTextBuilder<[string, ...string[]]>>,
                "VIRTUAL" | "PHYSICAL",
            >,
            {
                data: "VIRTUAL" | "PHYSICAL";
                dataType: "string";
                driverParam: string;
                enumValues: undefined;
                generated: undefined;
                hasDefault: false;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: true;
                tableName: "girasol_card";
            },
        >;
        typeDescription: SQL<string>;
        updatedAt: PgBuildColumn<
            "girasol_card",
            SetHasDefault<SetHasDefault<SetNotNull<PgTimestampBuilder>>>,
            {
                data: Date;
                dataType: "object date";
                driverParam: string;
                enumValues: undefined;
                generated: undefined;
                hasDefault: true;
                hasRuntimeDefault: false;
                identity: undefined;
                isAutoincrement: false;
                isPrimaryKey: false;
                name: string;
                notNull: true;
                tableName: "girasol_card";
            },
        >;
    } = ...

    The card row every read and write selects: the table's columns plus the display fields, computed in SQL.

    Type Declaration

    • cardholderName: SQL<string>
    • createdAt: PgBuildColumn<
          "girasol_card",
          SetHasDefault<SetNotNull<PgTimestampBuilder>>,
          {
              data: Date;
              dataType: "object date";
              driverParam: string;
              enumValues: undefined;
              generated: undefined;
              hasDefault: true;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: true;
              tableName: "girasol_card";
          },
      >
    • customerExternalId: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • customerId: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • displayName: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • expiryMonth: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • expiryYear: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • externalId: PgBuildColumn<
          "girasol_card",
          SetHasRuntimeDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
          {
              data: string;
              dataType: "string";
              driverParam: string;
              enumValues: undefined;
              generated: undefined;
              hasDefault: true;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: true;
              tableName: "girasol_card";
          },
      >
    • firstName: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • girasolAccountExternalId: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • girasolAccountId: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • girasolCardId: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • id: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • lastFourDigits: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >

      Four digits, never Girasol's 0000 placeholder; NULL until known.

    • lastName: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • maskedCardNumber: SQL<string>
    • phone: PgBuildColumn<
          "girasol_card",
          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: "girasol_card";
          },
      >
    • shippingAddress: PgBuildColumn<
          "girasol_card",
          Set$Type<
              PgJsonbBuilder,
              {
                  city: string;
                  countryCode: string;
                  line1: string;
                  line2?: string;
                  postalCode: string;
                  region?: string;
              },
          >,
          {
              data: {
                  city: string;
                  countryCode: string;
                  line1: string;
                  line2?: string;
                  postalCode: string;
                  region?: string;
              };
              dataType: "object json";
              driverParam: unknown;
              enumValues: undefined;
              generated: undefined;
              hasDefault: false;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: false;
              tableName: "girasol_card";
          },
      >
    • status: PgBuildColumn<
          "girasol_card",
          Set$Type<
              SetHasDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,

                  | "ACTIVE"
                  | "DELETED"
                  | "BLOCKED"
                  | "REJECTED"
                  | "UNKNOWN"
                  | "CREATED"
                  | "REQUESTED"
                  | "EXPIRED"
                  | "FROZEN"
                  | "DELIVERED",
          >,
          {
              data: | "ACTIVE"
              | "DELETED"
              | "BLOCKED"
              | "REJECTED"
              | "UNKNOWN"
              | "CREATED"
              | "REQUESTED"
              | "EXPIRED"
              | "FROZEN"
              | "DELIVERED";
              dataType: "string";
              driverParam: string;
              enumValues: undefined;
              generated: undefined;
              hasDefault: true;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: true;
              tableName: "girasol_card";
          },
      >

      Last status Girasol reported; UNKNOWN until a writer or the sync stores one.

    • statusDescription: SQL<string>
    • type: PgBuildColumn<
          "girasol_card",
          Set$Type<
              SetNotNull<PgTextBuilder<[string, ...string[]]>>,
              "VIRTUAL" | "PHYSICAL",
          >,
          {
              data: "VIRTUAL" | "PHYSICAL";
              dataType: "string";
              driverParam: string;
              enumValues: undefined;
              generated: undefined;
              hasDefault: false;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: true;
              tableName: "girasol_card";
          },
      >
    • typeDescription: SQL<string>
    • updatedAt: PgBuildColumn<
          "girasol_card",
          SetHasDefault<SetHasDefault<SetNotNull<PgTimestampBuilder>>>,
          {
              data: Date;
              dataType: "object date";
              driverParam: string;
              enumValues: undefined;
              generated: undefined;
              hasDefault: true;
              hasRuntimeDefault: false;
              identity: undefined;
              isAutoincrement: false;
              isPrimaryKey: false;
              name: string;
              notNull: true;
              tableName: "girasol_card";
          },
      >