IdeaComment

Name	Label	Type	Description
Id	Idea Comment ID	ID
IdeaId	Idea ID	LOOKUP
CommunityId	Zone ID	LOOKUP
CommentBody	Comment Body	TEXT AREA (RICH)(4000)
CreatedById	Created By ID	LOOKUP
CreatedDate	Created Date	DATETIME
SystemModstamp	System Modstamp	DATETIME
IsDeleted	Deleted	CHECKBOX
IsHtml	IsHtml	CHECKBOX
CreatorFullPhotoUrl	Url of Creator's Profile Photo	TEXT(255)
CreatorSmallPhotoUrl	Url of Creator's Thumbnail Photo	TEXT(255)
CreatorName	Name of Creator	TEXT(121)
UpVotes	Up Votes	AUTO NUMBER

Name	Id
Label	Idea Comment ID
Type	ID
Required	Yes

Name	IdeaId
Label	Idea ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	CommunityId
Label	Zone ID
Type	LOOKUP
Foreign key	Yes

Name	CommentBody
Label	Comment Body
Type	TEXT AREA (RICH)(4000)

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsHtml
Label	IsHtml
Type	CHECKBOX
Required	Yes
Default value	false

Name	CreatorFullPhotoUrl
Label	Url of Creator's Profile Photo
Type	TEXT(255)

Name	CreatorSmallPhotoUrl
Label	Url of Creator's Thumbnail Photo
Type	TEXT(255)

Name	CreatorName
Label	Name of Creator
Type	TEXT(121)

Name	UpVotes
Label	Up Votes
Type	AUTO NUMBER

Name	Parent object	Child object	Parent object field	Child object field
LastComment	IdeaComment	Idea	Id	LastCommentId

Name	Parent object	Child object	Parent object field	Child object field
Idea	Idea	IdeaComment	Id	IdeaId
CommunityId	Community	IdeaComment	Id	CommunityId
CreatedBy	User	IdeaComment	Id	CreatedById

Label	Value