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

    Variable swapDepositAddressTableConst

    swapDepositAddressTable: Omit<
        PgTableWithColumns<
            {
                columns: {
                    createdAt: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    customerExternalId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    customerId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    deletedAt: PgBuildColumn<
                        "swap_deposit_address",
                        PgTimestampBuilder,
                        {
                            data: Date;
                            dataType: "object date";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: false;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: false;
                            tableName: "swap_deposit_address";
                        },
                    >;
                    externalId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    id: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    ledgerAccountExternalId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    ledgerAccountId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    status: PgBuildColumn<
                        "swap_deposit_address",
                        Set$Type<
                            SetHasDefault<SetNotNull<PgTextBuilder<[string, ...string[]]>>>,
                            "DELETED" | "ACTIVE",
                        >,
                        {
                            data: "DELETED" | "ACTIVE";
                            dataType: "string";
                            driverParam: string;
                            enumValues: undefined;
                            generated: undefined;
                            hasDefault: true;
                            hasRuntimeDefault: false;
                            identity: undefined;
                            isAutoincrement: false;
                            isPrimaryKey: false;
                            name: string;
                            notNull: true;
                            tableName: "swap_deposit_address";
                        },
                    >;
                    tokenExternalId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    tokenId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    updatedAt: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    walletAddressExternalId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                    walletAddressId: PgBuildColumn<
                        "swap_deposit_address",
                        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: "swap_deposit_address";
                        },
                    >;
                };
                dialect: "pg";
                isAlias: false;
                name: "swap_deposit_address";
                schema: "b2b";
            },
        >,
        "enableRLS",
    > = ...

    A standing address a customer sends one token to, to have it swapped into MOVEUSD on one ledger account. Each row owns its own wallet_address, derived at a fresh account index, so the address alone says which token the deposit should be. A deposit that lands here becomes a swap with source = 'DEPOSIT' and this row's swap_deposit_address_id; the swap's owner, ledger account and token come from here.

    Soft-deleted: deleted_at is the source of truth, status = 'DELETED' its projection. At most one live row per (ledger account, token).

    Settings
    Member Visibility