tbl_paymentbankbatch

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_paymentbankbatch_id_seq'::regclass)
tbl_paymentsystembankchildbatch.paymentbankbatchid fk_tbl_paymentsystembankchildbatch_paymentbankbatchid R
batchname varchar 200 null
paymentsystembatchid int8 19 null
tbl_paymentsystembatch.id fk_tbl_paymentbankbatch_paymentsystembatchid R
status varchar 100 null
statusby varchar 50 √ null
statusdate timestamp 29,6 √ null
statusremark varchar 100 √ null
otprequestpayload varchar 2147483647 √ null
otpresponsepayload varchar 2147483647 √ null
otp varchar 50 √ null
transactionrequestpayload varchar 2147483647 √ null
transactionresponsepayload varchar 2147483647 √ null
importantkeyvalues varchar 2147483647 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_paymentbankbatch_id Primary key Asc id
uq_tbl_paymentbankbatch_batchname Must be unique Asc batchname

Relationships

Close relationships within degrees of separation