tbl_bankaccountallocationhistory

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_bankaccountallocationhistory_id_seq'::regclass)
bankaccountmasterid int8 19 null
tbl_bankaccountmaster.id fk_tbl_bankaccountallocationhistory_bankaccountmasterid R
bankaccountmasterhistoryid int8 19 null
tbl_bankaccountmasterhistory.id fk_tbl_bankaccountallocationhistory_bankaccountmasterhistoryid R
allocationtype varchar 100 null
allocationid int8 19 null
isdefault 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_bankaccountallocationhistory_id Primary key Asc id

Relationships

Close relationships within degrees of separation