# Idea: Idea - Name: `Idea` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Idea ## Table Columns The columns of the table `Idea` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Body` | `string` | Body | ☐ | | | `Categories` | `string` | Categories | ☐ | | | `CommunityId` | `string` | Community ID | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `CreatorFullPhotoUrl` | `string` | Creator Full Photo URL | ☐ | | | `CreatorName` | `string` | Creator Name | ☐ | | | `CreatorSmallPhotoUrl` | `string` | Creator Small Photo URL | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsHtml` | `boolean` | Is HTML | ☐ | | | `IsMerged` | `boolean` | Is Merged | ☐ | | | `LastCommentDate` | `datetime` | Last Comment Date | ☐ | | | `LastCommentId` | `string` | Last Comment ID | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `NumComments` | `int32` | Num Comments | ☐ | | | `ParentIdeaId` | `string` | Parent Idea ID | ☐ | | | `RecordTypeId` | `string` | Record Type ID | ☐ | | | `Status` | `string` | Status | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Title` | `string` | Title | ☐ | | | `VoteScore` | `double` | Vote Score | ☐ | | | `VoteTotal` | `double` | Vote Total | ☐ | |