tbl_paymentsystembankchildbatch

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_paymentsystembankchildbatch_id_seq'::regclass)
paymentsystembatchid int8 19 null
tbl_paymentsystembatch.id fk_tbl_paymentsystembankchildbatch_paymentsystembatchid R
childtype varchar 100 null
childtypeid varchar 50 null
amount float8 17,17 null
systemstatus varchar 100 null
systemstatusby varchar 50 √ null
systemstatusdate timestamp 29,6 √ null
systemstatusremark varchar 100 √ null
toaccountno varchar 100 null
toifsc varchar 50 null
paymentbankbatchid int8 19 √ null
tbl_paymentbankbatch.id fk_tbl_paymentsystembankchildbatch_paymentbankbatchid R
transactionstatus varchar 100 √ null
transactionstatuspayload 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_paymentsystembankchildbatch_id Primary key Asc id

Relationships

Close relationships within degrees of separation