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. | |
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. |