Deals
Create, update, delete, and query Highrise Deals. This table is dynamic.
テーブル固有の情報
Select
Datetime カラムでは、WHERE 句にて'>'、および'>=' の演算子だけがサポートされています。次のクエリは、指定された日の後に更新されたDeal を取得します。
SELECT * FROM Deals WHERE UpdatedAt > '2012-01-12'
Insert
新しいDeal の作成には、Name、CategoryId、Background、Currency、Price、PriceType、Duration、およびPartyId が必須です。
INSERT INTO Deals (Name, CategoryId, Background, Currency, Price, PriceType, Duration, PartyId) VALUES ('deal with someone', 4195389, 'black', 'usd', 500, 'fixed', 123545, 149760370)
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | False |
The Id column for the table Deals. | |
| Name | String | False |
The Name column for the table Deals. | |
| AccountId | Integer | False |
The AccountId column for the table Deals. | |
| AuthorId | Integer | False |
The AuthorId column for the table Deals. | |
| Background | String | False |
The Background column for the table Deals. | |
| CategoryId | Integer | False |
The CategoryId column for the table Deals. | |
| Currency | String | False |
The Currency column for the table Deals. | |
| Duration | Integer | False |
The Duration column for the table Deals. | |
| VisibleTo | String | False |
The VisibleTo column for the table Deals. | |
| GroupId | String | False |
The GroupId column for the table Deals. | |
| OwnerId | Integer | False |
The OwnerId column for the table Deals. | |
| PartyId | Integer | False |
The PartyId column for the table Deals. | |
| Price | Long | False |
The Price column for the table Deals. | |
| PriceType | String | False |
The PriceType column for the table Deals. | |
| ResponsiblePartyId | Integer | False |
The ResponsiblePartyId column for the table Deals. | |
| Status | String | False |
The Status column for the table Deals. | |
| StatusChangedOn | String | True |
The StatusChangedOn column for the table Deals. | |
| CreatedAt | Datetime | True |
The CreatedAt column for the table Deals. | |
| UpdatedAt | Datetime | True |
The UpdatedAt column for the table Deals. | |
| DealCustomField1 | String | False |
A Custom Field of type deal. | |
| DealCustomField2 | String | False |
A Custom Field of type deal. |