account


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
accountgrouprelation.accountId FKkvebjc2aumwgidu62g7dj6ags R
address.accountId FK67byjyhh5igpeofrgnaoosxp R
address_aud.accountId Implied Constraint R
addressmultilineview.ACCOUNTID Implied Constraint R
company.accountId FKrcpasgf6wx91hak4qaqsf67yx R
company_aud.accountId Implied Constraint R
contact.accountId FKf67wvsdh8abfrqd8cviobaa8j R
contact_aud.accountId Implied Constraint R
customer.accountId FK94bqsq44lb8q1t7yg3p4xbw7r R
customer_aud.accountId Implied Constraint R
vendor.accountId FKjwg91uh46u5hf3h71nd1mbj40 R
vendor_aud.accountId Implied Constraint R
typeId INT 10 √ null
accounttype.id FK5qx5ct769eas46fbd7e7dmo9v R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK5qx5ct769eas46fbd7e7dmo9v Performance Asc typeId

Relationships

Close relationships within degrees of separation