tbl_complianceaccount

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_complianceaccount_id_seq'::regclass)
name varchar 100 √ null
accountno varchar 100 √ null
stateid int8 19 √ null
tbl_statemaster.stateid Implied Constraint R
effectivedate date 13 √ null
types varchar 500 √ null
description varchar 500 √ null
status bool 1 √ null
createddate timestamp 29,6 √ null
statename varchar 60 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
sbuid int8 19 √ null
sbuname varchar 60 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_complianceaccount_pk__tbl__complianceaccount Primary key Asc id

Relationships

Close relationships within degrees of separation