テーブル
本製品 はSugarCRM のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。
一般的には、SugarCRM テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。
CData ODBC Driver for SugarCRM テーブル
| Name | Description |
| Accounts | Create, update, delete, and query the Accounts module in SugarCRM. |
| ACLRoles | Create, update, delete, and query the ACLRoles module in SugarCRM. |
| Activities | Create, update, delete, and query the Activities module in SugarCRM. |
| Administration | Create, update, delete, and query the Administration module in SugarCRM. |
| Bugs | Create, update, delete, and query the Bugs module in SugarCRM. |
| Calls | Create, update, delete, and query the Calls module in SugarCRM. |
| CampaignLog | Create, update, delete, and query the CampaignLog module in SugarCRM. |
| Campaigns | Create, update, delete, and query the Campaigns module in SugarCRM. |
| CampaignTrackers | Create, update, delete, and query the CampaignTrackers module in SugarCRM. |
| Cases | Create, update, delete, and query the Cases module in SugarCRM. |
| Comments | Create, update, delete, and query the Comments module in SugarCRM. |
| Contacts | Create, update, delete, and query the Contacts module in SugarCRM. |
| Contracts | Create, update, delete, and query the Contracts module in SugarCRM. |
| ContractTypes | Create, update, delete, and query the ContractTypes module in SugarCRM. |
| Currencies | Create, update, delete, and query the Currencies module in SugarCRM. |
| CustomQueries | Create, update, delete, and query the CustomQueries module in SugarCRM. |
| DataSets | Create, update, delete, and query the DataSets module in SugarCRM. |
| DocumentRevisions | Create, update, delete, and query the DocumentRevisions module in SugarCRM. |
| Documents | Create, update, delete, and query the Documents module in SugarCRM. |
| EAPM | Create, update, delete, and query the EAPM (external API module) in SugarCRM. |
| EmailAddresses | Create, update, delete, and query the EmailAddresses module in SugarCRM. |
| EmailMarketing | Create, update, delete, and query the EmailMarketing module in SugarCRM. |
| Emails | Create, update, delete, and query the Emails module in SugarCRM. |
| EmailTemplates | Create, update, delete, and query the EmailTemplates module in SugarCRM. |
| Employees | Create, update, delete, and query the Employees module in SugarCRM. |
| Filters | Create, update, delete, and query the Filters module in SugarCRM. |
| ForecastManagerWorksheets | Create, update, delete, and query the ForecastManagerWorksheets module in SugarCRM. |
| Forecasts | Create, update, delete, and query the Forecasts module in SugarCRM. |
| ForecastSchedule | Create, update, delete, and query the ForecastSchedule module in SugarCRM. |
| ForecastWorksheets | Create, update, delete, and query the ForecastWorksheets module in SugarCRM. |
| InboundEmail | Create, update, delete, and query the InboundEmail module in SugarCRM. |
| KBDocuments | Create, update, delete, and query the KBDocuments module in SugarCRM. |
| Leads | Create, update, delete, and query the Leads module in SugarCRM. |
| Manufacturers | Create, update, delete, and query the Manufacturers module in SugarCRM. |
| Meetings | Create, update, delete, and query the Meetings module in SugarCRM. |
| Notes | Create, update, delete, and query the Notes module in SugarCRM. |
| Notifications | Create, update, delete, and query the Notifications module in SugarCRM. |
| OAuthKeys | Create, update, delete, and query the OAuthKeys module in SugarCRM. |
| OAuthTokens | Create, update, delete, and query the OAuthTokens module in SugarCRM. |
| Opportunities | Create, update, delete, and query the Opportunities module in SugarCRM. |
| PdfManager | Create, update, delete, and query the PdfManager module in SugarCRM. |
| ProductCategories | Create, update, delete, and query the ProductCategories module in SugarCRM. |
| Products | Create, update, delete, and query the Products module in SugarCRM. |
| ProductTemplates | Create, udpate, delete, and query the ProductTemplates module in SugarCRM. |
| ProductTypes | Create, udpate, delete, and query the ProductTypes module in SugarCRM. |
| Project | Create, update, delete, and query the Project module in SugarCRM. |
| ProjectTask | Create, update, delete, and query the ProjectTask module in SugarCRM. |
| ProspectLists | Create, update, delete, and query the ProspectLists module in SugarCRM. |
| Prospects | Create, update, delete, and query the Prospects module in SugarCRM. |
| Quotas | Create, update, delete, and query the Quotas module in SugarCRM. |
| Quotes | Create, update, delete, and query the Quotes module in SugarCRM. |
| Releases | Create, update, delete, and query the Releases module in SugarCRM. |
| ReportMaker | This is a table representing the ReportMaker module in SugarCRM. |
| Reports | This is a table representing the Reports module in SugarCRM. |
| Reports_1 | This is a table representing the Reports module in SugarCRM. |
| RevenueLineItems | This is a table representing the RevenueLineItems module in SugarCRM. |
| Roles | This is a table representing the Roles module in SugarCRM. |
| SavedSearch | This is a table representing the SavedSearch module in SugarCRM. |
| Schedulers | This is a table representing the Schedulers module in SugarCRM. |
| Shippers | This is a table representing the Shippers module in SugarCRM. |
| Styleguide | This is a table representing the Styleguide module in SugarCRM. |
| Subscriptions | This is a table representing the Subscriptions module in SugarCRM. |
| SugarFavorites | This is a table representing the SugarFavorites module in SugarCRM. |
| Tasks | This is a table representing the Tasks module in SugarCRM. |
| TaxRates | This is a table representing the TaxRates module in SugarCRM. |
| TeamNotices | This is a table representing the TeamNotices module in SugarCRM. |
| Teams | This is a table representing the Teams module in SugarCRM. |
| TimePeriods | This is a table representing the TimePeriods module in SugarCRM. |
| TrackerPerfs | This is a table representing the TrackerPerfs module in SugarCRM. |
| TrackerQueries | This is a table representing the TrackerQueries module in SugarCRM. |
| Trackers | This is a table representing the Trackers module in SugarCRM. |
| TrackerSessions | This is a table representing the TrackerSessions module in SugarCRM. |
| Users | This is a table representing the Users module in SugarCRM. |
| UserSignatures | This is a table representing the UserSignatures module in SugarCRM. |
| WebLogicHooks | This is a table representing the WebLogicHooks module in SugarCRM. |
| WorkFlow | This is a table representing the WorkFlow module in SugarCRM. |
本製品 は、テーブル に記載されていないSugarCRM アカウントにもカスタムモジュールを公開できます。普通のテーブルと同様に、このカスタムモジュールに対してクエリを実行できます。さらに、標準モジュールのカスタムフィールドをクエリすることができます。