Explore the Daylite Data Model

Pulling data from the Daylite API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Daylite API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Appointment

Documentation: https://developer.marketcircle.com/reference/appointments

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Timezone	string	-	-
AllDay	boolean	-	-
Category	string	-	-
UtcStart	datetime	-	-
UtcEnd	datetime	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
ShowAs	string	-	-
Type	string	-	-
Status	string	-	-
Location	string	-	-
Details	string	-	-
Trashed	boolean	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
Subject	string	-	-
Self	string	-	-

Company

Documentation: https://developer.marketcircle.com/reference/companies

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Image	string	-	-
Category	string	-	-
Type	string	-	-
Industry	string	-	-
Region	string	-	-
Details	string	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Trashed	boolean	-	-
Self	string	-	-

Contact

Documentation: https://developer.marketcircle.com/reference/contacts

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Prefix	string	-	-
Suffix	string	-	-
FullName	string	-	-
Alias	string	-	-
Nickname	string	-	-
Image	string	-	-
Category	string	-	-
Birthday	datetime	-	-
Anniversary	datetime	-	-
Details	string	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
Trashed	boolean	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
FirstName	string	-	-
LastName	string	-	-
Self	string	-	-

Keyword

Documentation: https://developer.marketcircle.com/reference/keywords

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
CreateDate	datetime	-	-
IsActive	boolean	-	-
Self	string	-	-

Note

Documentation: https://developer.marketcircle.com/reference/notes

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Details	string	-	-
Category	string	-	-
Trashed	boolean	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Title	string	-	-
Self	string	-	-

Opportunity

Documentation: https://developer.marketcircle.com/reference/opportunities

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
State	string	-	-
Type	string	-	-
Probability	int	-	-
Forecasted	datetime	-	-
Start	datetime	-	-
End	datetime	-	-
Details	string	-	-
Priority	int	-	-
Category	string	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
Trashed	boolean	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Self	string	-	-

Project

Documentation: https://developer.marketcircle.com/reference/projects

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Status	string	-	-
Due	datetime	-	-
Started	datetime	-	-
Completed	datetime	-	-
Details	string	-	-
Priority	int	-	-
Category	string	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
Trashed	boolean	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Self	string	-	-

Relationship

Documentation: https://developer.marketcircle.com/reference/relationships

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Source	long	Contact → ID	-
Destination	long	Contact → ID	-
RelationshipType	long	RelationshipType → ID	-
CreateDate	datetime	-	-
Details	string	-	-
Self	string	-	-

RelationshipType

Documentation: https://developer.marketcircle.com/reference/relationship_types

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
ForContact	boolean	-	-
ForCompany	boolean	-	-
IsActive	boolean	-	-
CreateDate	datetime	-	-
Forward	string	-	-
Reverse	string	-	-
Self	string	-	-

Resource

Documentation: https://developer.marketcircle.com/reference/resources

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Location	string	-	-
Details	string	-	-
HexColour	string	-	-
IsActive	boolean	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Self	string	-	-

Role

Documentation: https://developer.marketcircle.com/reference/roles

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Department	string	-	-
Company	long	Company → ID	-
Contact	long	Contact → ID	-
Role	string	-	-
Type	long	RoleType → ID	-
CreateDate	datetime	-	-
Trashed	boolean	-	-
Title	string	-	-
Self	string	-	-

RoleType

Documentation: https://developer.marketcircle.com/reference/role_types

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
CreateDate	datetime	-	-
RoleName	string	-	-
IsActive	boolean	-	-
Self	string	-	-

Task

Documentation: https://developer.marketcircle.com/reference/tasks

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Details	string	-	-
Category	string	-	-
Due	datetime	-	-
Location	string	-	-
Type	string	-	-
Status	string	-	-
Priority	string	-	-
Started	datetime	-	-
Completed	datetime	-	-
EstimatedTime	int	-	-
ParentTask	long	Task → ID	-
Trashed	boolean	-	-
Owner	long	User → ID	-
Creator	long	User → ID	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Title	string	-	-
Self	string	-	-

User

Documentation: https://developer.marketcircle.com/reference/users

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
AccessLevel	string	-	-
HexColour	string	-	-
PrivateTeam	string	-	-
CreateDate	datetime	-	-
ModifyDate	datetime	-	-
Login	string	-	-
IsActive	boolean	-	-
Contact	long	Contact → ID	-
Self	string	-	-

AppointmentResource

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
ResourceID	long	Resource → ID	-

AppointmentInvitation

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
Invitee	long	User → ID	-
Status	string	-	-

AppointmentContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
Contact	long	Contact → ID	-

AppointmentNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
Note	long	Note → ID	-

AppointmentProject

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
Project	long	Project → ID	-

AppointmentKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
AppointmentRemoteID	string	Appointment → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AppointmentID	long	Appointment → ID	-
Keyword	string	-	-

CompanyKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Keyword	string	-	-

CompanyEmail

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Iterator	int	-	-
Label	string	-	-
Address	string	-	-
Ordering	int	-	-
Note	string	-	-

CompanyURL

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Iterator	int	-	-
Label	string	-	-
Url	string	-	-
Note	string	-	-
Ordering	string	-	-

CompanySocialProfile

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Iterator	int	-	-
Label	string	-	-
Service	string	-	-
Username	string	-	-
Ordering	int	-	-

CompanyPhoneNumber

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Iterator	int	-	-
Label	string	-	-
Format	string	-	-
Number	string	-	-
Note	string	-	-
Ordering	int	-	-

CompanyAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Iterator	int	-	-
Label	string	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Note	string	-	-

CompanyContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Role	string	-	-
Default	boolean	-	-
Department	string	-	-
Title	string	-	-
Contact	long	Contact → ID	-

CompanyOpportunity

Column	Type	Relates to	Notes
RemoteID	string	-	-
CompanyRemoteID	string	Company → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CompanyID	long	Company → ID	-
Opportunity	long	Opportunity → ID	-

ContactPhoneNumber

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Iterator	int	-	-
Label	string	-	-
Format	string	-	-
Number	string	-	-
Note	string	-	-
Ordering	int	-	-

ContactEmail

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Iterator	int	-	-
Label	string	-	-
Address	string	-	-
Ordering	int	-	-
Note	string	-	-

ContactSocialProfile

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Iterator	int	-	-
Label	string	-	-
Service	string	-	-
Username	string	-	-
Ordering	int	-	-

ContactURL

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Iterator	int	-	-
Label	string	-	-
Url	string	-	-
Note	string	-	-
Ordering	string	-	-

ContactAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Iterator	int	-	-
Label	string	-	-
Street	string	-	-
City	string	-	-
State	string	-	-
PostalCode	string	-	-
Country	string	-	-
Note	string	-	-
Ordering	int	-	-

ContactCompany

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Role	string	-	-
Default	boolean	-	-
Company	long	Company → ID	-

ContactOpportunity

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Opportunity	long	Opportunity → ID	-

ContactAppointment

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Appointment	long	Appointment → ID	-

ContactKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
ContactRemoteID	string	Contact → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ContactID	long	Contact → ID	-
Keyword	string	-	-

NoteKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Keyword	string	-	-

NoteAppointment

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Appointment	long	Appointment → ID	-

NoteContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Contact	long	Contact → ID	-

NoteCompany

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Company	long	Company → ID	-

NoteGroup

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Group	long	-	-

NoteOpportunity

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Opportunity	long	Opportunity → ID	-

NoteProject

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Project	long	Project → ID	-

NoteTask

Column	Type	Relates to	Notes
RemoteID	string	-	-
NoteRemoteID	string	Note → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
NoteID	long	Note → ID	-
Task	long	Task → ID	-

OpportunityContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
OpportunityRemoteID	string	Opportunity → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OpportunityID	long	Opportunity → ID	-
Contact	long	Contact → ID	-

OpportunityCompany

Column	Type	Relates to	Notes
RemoteID	string	-	-
OpportunityRemoteID	string	Opportunity → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OpportunityID	long	Opportunity → ID	-
Company	long	Company → ID	-

ProjectKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
ProjectRemoteID	string	Project → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ProjectID	long	Project → ID	-
Keyword	string	-	-

RoleTypeEntity

Column	Type	Relates to	Notes
RemoteID	string	-	-
RoleTypeRemoteID	string	RoleType → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
RoleTypeID	long	RoleType → ID	-
EntityType	string	-	-

TaskKeyword

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Keyword	string	-	-
Iterator	int	-	-

TaskAppointment

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Appointment	long	Appointment → ID	-

TaskSubtask

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Task	long	Task → ID	-

TaskContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Contact	long	Contact → ID	-

TaskCompany

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Company	long	Company → ID	-

TaskGroup

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Group	long	-	-

TaskNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Note	long	Note → ID	-

TaskOpportunity

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Opportunity	long	Opportunity → ID	-

TaskProject

Column	Type	Relates to	Notes
RemoteID	string	-	-
TaskRemoteID	string	Task → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TaskID	long	Task → ID	-
Project	long	Project → ID	-

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Daylite data Querying Daylite using regular SQL

Explore the Daylite API data model

See how the various Daylite endpoints relate to each other, using our handy Entity Relationship Diagram