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.

Common Uses

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.

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 address belongs to.

slug

varchar(255)

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


How did we do?


Powered by HelpDocs (opens in a new tab)