Companies
Create, update, delete, and query Highrise Companies. This table is dynamic.
テーブル固有の情報
Select
Datetime カラムでは、'>'、および'>=' の演算子だけがサポートされています。
SELECT * FROM Companies WHERE UpdatedAt > '2012-01-12'
Insert
新しいCompany の追加には、Company Name およびCompany のBackground の設定が必須です。
INSERT INTO Companies (Name, Background) VALUES ('Company name', 'The description')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | False |
The Id column for the table Companies. | |
| Name | String | False |
The Name column for the table Companies. | |
| Background | String | False |
The Background column for the table Companies. | |
| EmailAddressAggregate | String | False |
The EmailAddressAggregate column for the table Companies. | |
| PhoneNumberAggregate | String | False |
The PhoneNumberAggregate column for the table Companies. | |
| AddressAggregate | String | False |
The AddressAggregate column for the table Companies. | |
| InstantMessengerAggregate | String | False |
The InstantMessengerAggregate column for the table Companies. | |
| TwitterAccountAggregate | String | False |
The TwitterAccountAggregate column for the table Companies. | |
| WebAddressAggregate | String | False |
The WebAddressAggregate column for the table Companies. | |
| AvatarURL | String | False |
The AvatarURL column for the table Companies. | |
| VisibleTo | String | False |
The VisibleTo column for the table Companies. | |
| OwnerId | Integer | False |
The OwnerId column for the table Companies. | |
| GroupId | String | False |
The GroupId column for the table Companies. | |
| AuthorId | String | True |
The AuthorId column for the table Companies. | |
| CreatedAt | Datetime | True |
The CreatedAt column for the table Companies. | |
| UpdatedAt | Datetime | True |
The UpdatedAt column for the table Companies. | |
| PartyCustomField1 | String | False |
A CustomField of type party. | |
| PartyCustomField2 | String | False |
A CustomField of type party. |