2024 is the year of the connector - vote here

Explore the Teamwork API data model

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

Try our interactive ERD

Pulling data from the Teamwork 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 Teamwork 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

Allocation

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
InstallationID int - -
ProjectID int Project → ID -
Title string - -
StartedAt datetime - -
EndedAt datetime - -
Duration decimal - -
HoursPerDay decimal - -
Color string - -
Status string - -
DistributeType string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
CreatedBy long Person → ID -
UpdatedBy long Person → ID -
DeletedBy long Person → ID -
AssignedUserID long Person → ID -
RecurringRule string - -

Budget

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProjectID int Project → ID -
Type string - -
Status string - -
CapacityUsed int - -
Capacity int - -
IsRepeating boolean - -
RepeatPeriod int - -
RepeatUnit string - -
RepeatsRemaining int - -
SequenceNumber int - -
StartDateTime datetime - -
EndDateTime datetime - -
CurrencyCode string - -
TimelogType string - -
ExpenseType string - -
DefaultRate decimal - -
CreatedByUserID long Person → ID -
DateCreated datetime - -
UpdatedByUserID long Person → ID -
DateUpdated datetime - -

Company

Documentation: https://apidocs.teamwork.com/docs/teamwork/acfee1f502698-get-all-companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Accounts int - -
AddressOne string - -
AddressTwo string - -
CanSeePrivate boolean - -
Cid string - -
City string - -
Clients int - -
Collaborators int - -
CompanyNameUrl string - -
Contacts int - -
CountryCode string - -
CreatedAt datetime - -
EmailOne string - -
EmailThree string - -
EmailTwo string - -
Fax string - -
IndustryID int - -
IsOwner boolean - -
LogoUrl string - -
Phone string - -
PrivateNotes string - -
PrivateNotesText string - -
ProfileText string - -
State string - -
UpdatedAt datetime - -
Website string - -
Zip string - -

CustomField

Documentation: https://apidocs.teamwork.com/docs/teamwork/275ac473ca2eb-get-all-custom-fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
ProjectID int - -
Entity string - -
Type string - -
IsPrivate boolean - -
Required boolean - -
CreatedAt datetime - -
CreatedByUserID int - -
UpdatedAt datetime - -
UpdatedByUserID int - -
Deleted boolean - -
DeletedAt datetime - -
DeletedByUserID int - -

Event

Documentation: https://apidocs.teamwork.com/docs/teamwork/2714bb8ca5e74-get-events

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
Title string - -
Where string - -
SequenceID long - -
ProjectUsersCanEdit boolean - -
AttendeesCanEdit boolean - -
Status string - -
DateDeleted datetime - -
DeletedByUserID long Person → ID -
DeletedByUserFirstName string - -
DeletedByUserLastName string - -
Utc boolean - -
CanEdit boolean - -
AllDay boolean - -
IsUnavailable boolean - -
AttendingUserNames string - -
AttendingUserFirstNames string - -
AttendingUserLastNames string - -
AttendingUserCompanyIDs string - -
AttendingUserCompanyNames string - -
AttendingUserAvatarURLs string - -
NotifyUserNames string - -
NotifyUserFirstNames string - -
NotifyUserLastNames string - -
NotifyUserAvatarURLs string - -
ShowAsBusy boolean - -
LastChangedOn datetime - -
CreatedAt datetime - -
Start datetime - -
End datetime - -
OwnerID long Person → ID -
OwnerFirstName string - -
OwnerLastName string - -
OwnerAvatarURL string - -
TypeID long -
  • 16 Mar 2023 Foreign Key for EventTypes which is currently unimplemented
TypeColor string - -
TypeName string - -
RepeatFrequency string - -
RepeatEnds boolean - -
RepeatEndDate datetime - -

Invoice

Documentation: https://apidocs.teamwork.com/docs/teamwork/d7ff00359e06f-get-all-invoices-across-your-projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
ProjectID int Project → ID -
TimeCost decimal - -
FixedCost decimal - -
Status string - -
DateCreated datetime - -
Number string - -
PoNumber string - -
UpdateByUserID long Person → ID -
CreatedByUserID int - -
Pricing string - -
CompanyName string - -
TotalTimeDecimal decimal - -
TotalCost decimal - -
ExpensesCost decimal - -
CompanyID int Company → ID -
TotalTime decimal - -
DisplayDate string - -
DateUpdated datetime - -
CurrencyCode string - -

Milestone

Documentation: https://developer.teamwork.com/projects/api-v1/ref/milestones/get-milestones-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
Deadline string - -
Completed boolean - -
ProjectID int Project → ID -
CreatedOn datetime - -
LastChangedOn datetime - -
CreatorUserID long Person → ID -
Reminder string - -
IsPrivate boolean - -
Status string - -
UserFollowingComments boolean - -
UserFollowingChanges boolean - -
CanEdit boolean - -
CanComplete boolean - -
CommentsCount int - -

Person

Documentation: https://developer.teamwork.com/projects/api-v1/ref/people/get-people-json

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CanAccessTemplatesPermission boolean - -
CanViewProjectTemplates boolean - -
CanAddProjectsPermission boolean - -
CanManageCustomFieldsPermission boolean - -
CanManageProjectTemplatesPermission boolean - -
CanAccessCalendarPermission boolean - -
CanViewSchedulePermission boolean - -
CanManagePeoplePermission boolean - -
CanManageScheudlePermission boolean - -
AvatarUrl string - -
CurrentFeatureAnnouncementID string CurrentFeatureAnnouncement → ID -
LastChangedOn datetime - -
EmailAddress string - -
LastLogin datetime - -
DocumentEditorInstalled boolean - -
UserName string - -
PhoneNumberFax string - -
SiteOwner boolean - -
CompanyName string - -
UserInvitedDate string - -
UserType string - -
PhoneNumberMobile string - -
HasFeatureUpdates boolean - -
OpenID string - -
PhoneNumberOffice string - -
ImHandle string - -
TwoFactorAuthEnabled boolean - -
IsClientUser boolean - -
HasAccessToNewProjects boolean - -
ImService string - -
Deleted boolean - -
Notes string - -
InOwnerCompany string - -
Profile string - -
UserInvitedStatus string - -
UserUUID string - -
UserInvited string - -
CreatedAt datetime - -
CompanyID string -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
HasDeskAccount boolean - -
PhoneNumberHome string - -
ProfileText string - -
PrivateNotesText string - -
Pid string - -
PhoneNumberCountryCode string - -
PhoneNumberPrefix string - -
PhoneNumberPhone string - -
LoginCount string - -
PrivateNotes string - -
EmailAlt1 string - -
Administrator boolean - -
EmailAlt2 string - -
EmailAlt3 string - -
FeatureUpdatesCount string - -
LastName string - -
Title string - -
FirstName string - -
PhoneNumberOfficeExt string - -
Twitter string - -
LengthOfDay string - -

Project

Documentation: https://developer.teamwork.com/projects/api-v2/ref/custom-fields/getprojectsapiv2projectsjson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
ReplyByEmailEnabled boolean - -
Starred boolean - -
ShowAnnouncement boolean - -
HarvestTimersEnabled boolean - -
SubStatus string - -
Status string - -
DefaultPrivacy string - -
CreatedOn datetime - -
FilesAutoNewVersion boolean - -
CategoryName string - -
CategoryID string Category → ID -
CategoryColor string - -
OverviewStartPage string - -
Logo string - -
StartDate string - -
Type string - -
EndDate string - -
CompanyID string -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
TasksStartPage string - -
PrivacyEnabled boolean - -
Announcement string - -
StartPage string - -
Notifyeveryone boolean - -
AnnouncementHTML string - -
LastChangedOn datetime -
  • 4 Jul 2023 Teamwork returns lastChangedOn when querying for multiple projects, and lastChangeOn for a single project. Note the difference in spelling. So here, we coalesce the two values
ProjectOwnerID long Person → ID -

ProjectLatestActivity

Documentation: https://developer.teamwork.com/projects/api-v3/ref/activity/get-projects-api-v3-projects-projectid-latestactivity

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
UserID long Person → ID -
ProjectID int Project → ID -
CompanyID int - -
SctivityType string - -
DateTime datetime - -
ExtraDescription string - -
DueDate string - -
ForUserID int - -
ForUserName string - -
IsPrivate int - -
ItemID int - -
ItemLink string - -
LatestActivityType string - -
Link string - -
LockdownID int - -
PublicInfo string - -
Type string - -

ProjectUpdate

Documentation: https://apidocs.teamwork.com/docs/teamwork/2e4f8bf140cab-get-all-project-updates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Text string - -
Health int - -
Color string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Deleted boolean - -
ProjectID int Project → ID -
CreatedBy long Person → ID -
ReactionsCountLike int - -
ReactionsCountDislike int - -
ReactionsCountJoy int - -
ReactionsCountFrown int - -
ReactionsCountHeart int - -

Proof

Documentation: https://apidocs.teamwork.com/docs/teamwork/cd449cb1e17cb-proof

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Title string - -
Due datetime - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
Product string - -
FeedbackCount int - -
Status string - -
State string - -
InstallationID int - -
TaskID long Task → ID -
ProjectID int Project → ID -
CompanyID int Company → ID -
CreatedByID long Person → ID -
UpdatedByID long Person → ID -
DeletedByID long Person → ID -

Risk

Documentation: https://developer.teamwork.com/projects/api-v3/ref/risks/get-projects-api-v3-risksjson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProjectID int Project → ID -
Source string - -
Probability string - -
ProbabilityValue decimal - -
Impact string - -
ImpactValue decimal - -
ImpactCost boolean - -
ImpactSchedule boolean - -
ImpactPerformance boolean - -
CreatedAt datetime - -
CreatedBy long Person → ID -
UpdatedAt datetime - -
UpdatedBy long Person → ID -
Result decimal - -
MitigationPlan string - -
Status string - -
Deleted boolean - -
CanEdit boolean - -

Tag

Documentation: https://developer.teamwork.com/projects/api-v3/ref/tags/get-projects-api-v3-tagsjson

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

Task

Documentation: https://apidocs.teamwork.com/docs/teamwork/54bdf625aa2f3-get-all-tasks-across-all-projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
BoardColumnID int - -
BoardColumnName string - -
BoardColumnColor string - -
CardID int - -
CanComplete boolean - -
CommentsCount int - -
HasReminders boolean - -
HasUnreadComments boolean - -
PrivateInt int - -
CompleterID long Person → ID
  • 24 Jan 2024 This field is only available once the task has been completed
CompletedOn datetime -
  • 24 Jan 2024 This field is only available once the task has been completed
Content string - -
Order int - -
ProjectID int Project → ID -
ProjectName string - -
TaskListID int TaskList → ID -
TodoListID int - -
TodoListName string - -
TasklistPrivate boolean - -
TasklistIsTemplate boolean - -
Status string - -
CompanyName string - -
CompanyID int -
  • 28 Jul 2020 Foreign Key - References `Companies` (not implemented).
CreatorID long Person → ID -
CreatorFirstname string - -
CreatorLastname string - -
UpdaterID long Person → ID -
UpdaterFirstname string - -
UpdaterLastname string - -
Completed boolean - -
StartDate string - -
DueDateBase string - -
DueDate string -
  • 21 Jul 2020 Format is yyyyMMdd
CreatedOn datetime - -
Position int - -
EstimatedMinutes int - -
Priority string - -
Progress int - -
HarvestEnabled boolean - -
ParentTaskID long Task → ID -
LockdownID string - -
TasklistLockdownID string - -
HasDependencies int - -
HasPredecessors int - -
HasTickets boolean - -
TimeIsLogged int - -
MinutesLogged decimal - -
BillableMinutesLogged decimal - -
AttachmentsCount int - -
ResponsiblePartyIds string - -
ResponsiblePartyID string - -
ResponsiblePartyNames string - -
ResponsiblePartyType string - -
ResponsiblePartyFirstname string - -
ResponsiblePartyLastname string - -
ResponsiblePartySummary string - -
CanEdit boolean - -
ViewEstimatedTime boolean - -
CreatorAvatarUrl string - -
CanLogTime boolean - -
UserFollowingComments boolean - -
UserFollowingChanges boolean - -
DLM int - -
LastChangedOn datetime - -

TaskCustomField

Documentation: https://developer.teamwork.com/projects/api/v3/tasks.json?includeCustomFields=true

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomfieldID int CustomField → ID -
TaskID long Task → ID -
Value string - -
CreatedAt datetime - -
CreatedBy long Person → ID -

TaskDependent

Documentation: https://apidocs.teamwork.com/docs/teamwork/c2736f23bca8c-retrieve-task-dependencies

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
PredecessorTaskID long Task → ID -
DependentTaskID long Task → ID -
DependentCant string - -
CanSeeTask boolean - -
PredecessorMust string - -
Hardness string - -

TaskList

Documentation: https://developer.teamwork.com/projects/api-v3/ref/task-lists/get-projects-api-v3-projects-projectid-tasklists

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
DisplayOrder decimal - -
ProjectID int Project → ID -
MilestoneID int Milestone → ID -
IsPinned boolean - -
IsPrivate boolean - -
LockdownID boolean - -
Status string - -
DefaultTaskID long Task → ID -

Team

Documentation: https://apidocs.teamwork.com/docs/teamwork/d1979017754ec-get-all-teams

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Description string - -
CreatedByUserID long Person → ID -
LogoIcon string - -
DeletedDate datetime - -
Handle string - -
DateUpdated datetime - -
NumMembers int - -
LogoUrl string - -
LogoColor string - -
NumDirectChildren int - -
CanEdit boolean - -
UpdatedByUserID int - -
IsPrivate boolean - -
DateCreated datetime - -
Deleted boolean - -
NumSubteams int - -

TimeLog

Documentation: https://developer.teamwork.com/projects/api-v3/ref/time-tracking/get-projects-api-v3-timejson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
CreatedAt datetime - -
Minutes decimal - -
TimeLogged datetime - -
Billable boolean - -
Deleted boolean - -
DeletedAt datetime - -
HasStartTime boolean - -
UpdatedAt datetime - -
DeskTicketID int - -
InvoiceNumber string - -
UserID long Person → ID -
TaskID long Task → ID -
ProjectID int Project → ID -
LoggedByUserID long Person → ID -
DeletedByUserID long Person → ID -
EditedByUserID long Person → ID -
TaskIdPreMove int - -
ProjectBillingInvoiceID int - -

EventReminder

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Iterator int - -
EventID int Event → ID
  • 16 Mar 2023 This is the id of the event, not the reminder
Before int - -
Period string - -
Type string - -

EventAttendingUser

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EventID int Event → ID -
PersonID long Person → ID -

EventNotifyUser

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EventID int Event → ID -
PersonID long Person → ID -

InvoiceLine

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Description string - -
InvoiceID int Invoice → ID -
Minutes decimal - -
DateLoggedUTC datetime - -
Rate decimal - -
DecimalHours decimal - -
Billable int - -
UserID long Person → ID -
TaskID long Task → ID -
Date datetime - -
Cost decimal - -
Hours decimal - -

MilestoneAssignee

Column Type Relates to Notes
RemoteID string - -
MilestoneRemoteID string Milestone → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MileStoneID int Milestone → ID -
PersonID long Person → ID -

MilestoneTaskList

Column Type Relates to Notes
RemoteID string - -
MilestoneRemoteID string Milestone → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MileStoneID int Milestone → ID -
TaskListID int TaskList → ID -

ProjectCustomField

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

ProjectPerson

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

ProjectTag

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagID int Tag → ID
  • 29 Jul 2020 This is the globally unique tag-id, it is not the ProjectTag relationship
ProjectID int Project → ID -

ProofObject

Column Type Relates to Notes
RemoteID string - -
ProofRemoteID string Proof → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProofID int Proof → ID -
Version int - -
ApprovalStatus string - -
State string - -
StateMessage string - -
Title string - -
Type string - -
URL string - -
Format string - -
SourceFormat string - -
TotalChunks int - -
Size int - -
Thumbnail string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
InstallationID int - -
CreatedByID long Person → ID -
UpdatedByID long Person → ID -
DeletedByID long Person → ID -

ProofAssignee

Column Type Relates to Notes
RemoteID string - -
ProofRemoteID string Proof → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
ProofID int Proof → ID -
UserID long Person → ID -
Decision string - -
Role string - -
IsExternal boolean - -

TaskTag

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagID int Tag → ID
  • 29 Jul 2020 This is the globally unique tag-id, it is not the TaskTag relationship
TaskID long Task → ID -

TaskAssignee

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

TaskTeam

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

TeamMember

Column Type Relates to Notes
RemoteID string - -
TeamRemoteID string Team → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PersonID long Person → ID -
TeamID int Team → ID -

TimeLogTag

Column Type Relates to Notes
RemoteID string - -
TimeLogRemoteID string TimeLog → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TimeLogID int TimeLog → ID -
TagID int Tag → ID -

CustomFieldOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -
Color string - -
Position int - -
CustomFieldID int CustomField → ID -

Need more?

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

Connect your own Teamwork data Interactive ERD Querying Teamwork using regular SQL