Database – Company Profile (company_profile_entity)
Description
This refers to the company profile found inside My Account > Company Profile. The Company Profile stores important company information such as contact information. The company information variables in the API can be seen in the API - Company Information article.
Table Fields
Column | Data Type | Column Info | Value Notes |
id | int(11) | This is the ID or identifier of the company profile. | |
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 address belongs to. | |
slug | varchar(255) | The subdomain for your customer-facing website. | |
created | datetime | The date the company profile was created. | |
lastUpdated | timestamp | The date the company profile was last updated. | |
deleted | tinyint(1) | Determines whether the company profile is deleted or not. | 1 - yes, 2 - no |