tbl_bankaccountmaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_bankaccountmaster_id_seq'::regclass)
tbl_bankaccountallocation.bankaccountmasterid fk_tbl_bankaccountallocation_bankaccountmasterid R
tbl_bankaccountallocationhistory.bankaccountmasterid fk_tbl_bankaccountallocationhistory_bankaccountmasterid R
tbl_bankaccountkeyvalues.bankaccountmasterid fk_tbl_bankaccountkeyvalues_bankaccountmasterid R
tbl_bankaccountmasterhistory.bankaccountmasterid fk_tbl_bankaccountmasterhistory_bankaccountmasterid R
tbl_paymentsystembatch.fromaccountid fk_tbl_paymentsystembatch_fromaccountid R
status varchar 100 null
accountname varchar 200 null
bankmasterid int8 19 null
tbl_bankmaster.id fk_tbl_bankaccountmaster_bankmasterid R
accounttype varchar 100 null
accountholdername varchar 200 null
accountno varchar 100 null
ifsc varchar 50 null
branchname varchar 200 √ null
branchcode varchar 50 √ null
isallocated bool 1 √ 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_bankaccountmaster_id Primary key Asc id
uq_tbl_bankaccountmaster_accountname Must be unique Asc accountname

Relationships

Close relationships within degrees of separation