Variable bankTransactionTableConst
bankTransactionTable: Omit< PgTableWithColumns< { columns: { accountNumber: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; amount: PgBuildColumn< "bank_transaction", SetNotNull<PgNumericBuilder>, { data: string; dataType: "string numeric"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: string; notNull: true; tableName: "bank_transaction"; }, >; bankId: PgBuildColumn< "bank_transaction", Set$Type<SetNotNull<PgTextBuilder<[string, ...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: "bank_transaction"; }, >; bankStatus: PgBuildColumn< "bank_transaction", Set$Type<SetNotNull<PgTextBuilder<[string, ...string[]]>>, "POSTED">, { data: "POSTED"; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: string; notNull: true; tableName: "bank_transaction"; }, >; bankTransactionId: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; createdAt: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; data: PgBuildColumn< "bank_transaction", Set$Type< SetHasDefault<SetNotNull<PgJsonbBuilder>>, { isManual?: boolean; methodData: | Record<string, never> | (
{ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
)
; reconciliation: Partial< Record<(...)
| (...)
| (...)
| (...)
| (...)
| (...)
, string>, > & Partial<Record<(...)
| (...)
| (...)
, (...)
[]>>; }, >, { data: { isManual?: boolean; methodData: | Record<string, never> | (
{ victorTransactionId?: string | undefined; victorReferenceId?: string | undefined; } & ({ method: "BOOK_TRANSFER"; } | { method: "ACH"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; } | { method: "RTP"; senderName?: string | undefined; tchInstitutionId?: string | undefined; } | { method: "SWIFT"; imad: string; omad?: string | undefined; senderName?: string | undefined; ffcMemo?: string | undefined; } | { method: "FEDWIRE"; imad: string; omad?: string | undefined; senderName?: string | undefined; sourceAccountNumber?: string | undefined; sourceRoutingNumber?: string | undefined; sourceBankName?: string | undefined; targetAccountName?: string | undefined; targetAccountNumber?: string | undefined; targetRoutingNumber?: string | undefined; targetBankName?: string | undefined; ffcMemo?: string | undefined; })
)
; reconciliation: Partial< Record<(...)
| (...)
| (...)
| (...)
| (...)
| (...)
, string>, > & Partial<Record<(...)
| (...)
| (...)
, (...)
[]>>; }; dataType: "object json"; driverParam: unknown; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: string; notNull: true; tableName: "bank_transaction"; }, >; description: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; externalId: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; id: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; postedAt: PgBuildColumn< "bank_transaction", SetNotNull<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: true; tableName: "bank_transaction"; }, >; routingNumber: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; statementDescription: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; type: PgBuildColumn< "bank_transaction", Set$Type< SetNotNull<PgTextBuilder<[string, ...string[]]>>, "CREDIT" | "DEBIT", >, { data: "CREDIT" | "DEBIT"; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: string; notNull: true; tableName: "bank_transaction"; }, >; updatedAt: PgBuildColumn< "bank_transaction", 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: "bank_transaction"; }, >; }; dialect: "pg"; name: "bank_transaction"; schema: "b2b"; }, >, "enableRLS",> = ...