Table: ContactTouchpoint

Database schema and system attributes for ContactTouchpoint.

---

CommunicationMedium

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

CompletedDateTime

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

ContactId

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignGuid

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

ForeignId

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

ForeignKey

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 200

Guid

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: uniqueidentifier
• Property Values:
  • MaxLength = 16

Id

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4

Note

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 1000

ScheduledDateTime

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: datetime
• Property Values:
  • MaxLength = 8

SystemNote

• Required Property: false
• Lava Supported Property: true
• Database Property: true
• Data Type: nvarchar
• Property Values:
  • MaxLength = 2000

Type

• Required Property: true
• Lava Supported Property: true
• Database Property: true
• Data Type: int
• Property Values:
  • MaxLength = 4