Variable bankTransactionTableConst
bankTransactionTable: Omit< PgTableWithColumns< { columns: { accountNumber: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "accountNumber"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; amount: PgColumn< { baseColumn: never; columnType: "PgNumeric"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "amount"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; bankId: PgColumn< { baseColumn: never; columnType: "PgText"; data: "greendot" | "metcap" | "dart" | "burling" | "jiko"; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "bankId"; notNull: true; tableName: "bank_transaction"; }, {}, { $type: "greendot" | "metcap" | "dart" | "burling" | "jiko" }, >; bankStatus: PgColumn< { baseColumn: never; columnType: "PgText"; data: "POSTED"; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "bankStatus"; notNull: true; tableName: "bank_transaction"; }, {}, { $type: "POSTED" }, >; bankTransactionId: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "bankTransactionId"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; createdAt: PgColumn< { baseColumn: never; columnType: "PgTimestamp"; data: Date; dataType: "date"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "createdAt"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; data: PgColumn< { baseColumn: never; columnType: "PgJsonb"; 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; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: 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; ffcMemo?: string | undefined; })
)
; reconciliation: { id: string; type: | "WITHDRAWAL" | "DEPOSIT" | "REDEMPTION" | "ACH_BATCH" | "DIRECT_DEPOSIT" | "BANK_INTERNAL_TRANSFER"; }[]; }; dataType: "json"; driverParam: unknown; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "data"; notNull: true; tableName: "bank_transaction"; }, {}, { $type: { 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; } | { method: "ACH_DEBIT"; senderName?: string | undefined; achId?: string | undefined; achTraceId?: 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; ffcMemo?: string | undefined; })
)
; reconciliation: { id: string; type: | "WITHDRAWAL" | "DEPOSIT" | "REDEMPTION" | "ACH_BATCH" | "DIRECT_DEPOSIT" | "BANK_INTERNAL_TRANSFER"; }[]; }; }, >; description: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "description"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; externalId: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: true; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "externalId"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; id: PgColumn< { baseColumn: never; columnType: "PgInteger"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: "byDefault"; isAutoincrement: false; isPrimaryKey: true; name: "id"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; postedAt: PgColumn< { baseColumn: never; columnType: "PgTimestamp"; data: Date; dataType: "date"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "postedAt"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; routingNumber: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "routingNumber"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; statementDescription: PgColumn< { baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "statementDescription"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; type: PgColumn< { baseColumn: never; columnType: "PgText"; data: "CREDIT" | "DEBIT"; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "type"; notNull: true; tableName: "bank_transaction"; }, {}, { $type: "CREDIT" | "DEBIT" }, >; updatedAt: PgColumn< { baseColumn: never; columnType: "PgTimestamp"; data: Date; dataType: "date"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updatedAt"; notNull: true; tableName: "bank_transaction"; }, {}, {}, >; }; dialect: "pg"; name: "bank_transaction"; schema: "b2b"; }, >, "enableRLS",> = ...