Database – Company Profile (company_profile_entity)

Description

This table holds records of Associated Companies. These are groups you partner with, like repo companies or law firms, whose information you can save in a tenant-level directory. You can then use them in Associated Company fields on individual loans.

Table Fields

Column

Data Type

Column Info

Value Notes

id

int(11)

This is the ID or identifier of the company.

company_name

varchar(255)

The name of the company.

contact_name

varchar(255)

The contact name of the specific person representing the company.

phone_number

char(20)

Phone number associated with the company. 

fax_number

char(20)

Fax number associated with the company.

email

char(50)

Email address associated with the company.

nickname

char(50)

This is used to identify the company by a specific nickname if one is used.

notes

text

This includes any additional information regarding the company.

address_id

int(11)

The ID or identifier of the company address.

directroy_id

int(11)

The ID or identifier of the directory the associated company belongs to.

slug

varchar(255)

The subdomain for your customer-facing website.

created

datetime

The date the company was created.

lastUpdated

timestamp

The date the company was last updated.

deleted

tinyint(1)

Determines whether the company has been deleted. 

1 - Deleted.

0 - Not deleted.


How did we do?


Powered by HelpDocs (opens in a new tab)