Companies
To Create, update, delete, and query from Companies table.
Table Specific Information
Select
For datetime columns only the '>' and '>=' operators are supported.
SELECT * FROM Companies WHERE UpdatedAt > '2012-01-12'
Insert
To insert a new Company, provide at least a Company Name and a Background for the Company.
INSERT INTO Companies (Name, Background) VALUES ('Company name', 'The description')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the company. | |
| Name | String | False |
The name of the company. | |
| Background | String | False |
Background notes about the company. | |
| EmailAddressAggregate | String | False |
The list of email addresses for the company, returned as an XML aggregate. | |
| PhoneNumberAggregate | String | False |
The list of phone numbers for the company, returned as an XML aggregate. | |
| AddressAggregate | String | False |
The list of addresses for the company, returned as an XML aggregate. | |
| InstantMessengerAggregate | String | False |
The list of instant messenger accounts for the company, returned as an XML aggregate. | |
| TwitterAccountAggregate | String | False |
The list of Twitter accounts for the company, returned as an XML aggregate. | |
| WebAddressAggregate | String | False |
The list of web addresses for the company, returned as an XML aggregate. | |
| AvatarURL | String | True |
The URL of the avatar image for the company. | |
| VisibleTo | String | False |
Who the company record is visible to. The allowed values are Everyone, Owner, and NamedGroup. | |
| OwnerId | Integer | True |
The Id of the user who owns the company record. | |
| GroupId | Integer | True |
The Id of the group associated with the company record. | |
| AuthorId | Integer | True |
The Id of the user who created the company record. | |
| CreatedAt | Datetime | True |
The date and time when the company record was created. | |
| UpdatedAt | Datetime | True |
The date and time when the company record was last updated. | |
| SubjectData | String | False |
The custom subject_data values for the company, returned as an XML aggregate. |