Diagrams


Table

Graph Contact

Fields

# Name Type
1 Id (Id) Text250
2 CreatedDateTime (CreatedDateTime) DateTime
3 LastModifiedDateTime (LastModifiedDateTime) DateTime
4 ChangeKey (ChangeKey) Text250
5 Categories (Categories) BLOB [Json]
6 ParentFolderId (ParentFolderId) Text250
7 Birthday (Birthday) DateTime
8 FileAs (FileAs) Text250
9 DisplayName (DisplayName) Text250
10 GivenName (GivenName) Text250
11 Initials (Initials) Text250
12 MiddleName (MiddleName) Text250
13 NickName (NickName) Text250
14 Surname (Surname) Text250
15 Title (Title) Text250
16 YomiGivenName (YomiGivenName) Text250
17 YomiSurname (YomiSurname) Text250
18 YomiCompanyName (YomiCompanyName) Text250
19 Generation (Generation) Text250
20 EmailAddresses (EmailAddresses) BLOB [Json]
21 Websites (Websites) BLOB [Json]
22 ImAddresses (ImAddresses) BLOB [Json]
23 JobTitle (JobTitle) Text250
24 CompanyName (CompanyName) Text250
25 Department (Department) Text250
26 OfficeLocation (OfficeLocation) Text250
27 Profession (Profession) Text250
28 AssistantName (AssistantName) Text250
29 Manager (Manager) Text250
30 Phones (Phones) BLOB [Json]
31 PostalAddresses (PostalAddresses) BLOB [Json]
32 SpouseName (SpouseName) Text250
33 PersonalNotes (PersonalNotes) BLOB [Memo]
34 Children (Children) BLOB [Json]
35 WeddingAnniversary (WeddingAnniversary) DateTime
36 Gender (Gender) Text250
37 IsFavorite (IsFavorite) Boolean
38 Flag (Flag) BLOB [Json]
40 DeltaToken (DeltaToken) Text250
41 BusinessType (BusinessType) BLOB [Json]
42 IsBank (IsBank) BLOB [Json]
43 IsContact (IsContact) BLOB [Json]
44 IsCustomer (IsCustomer) BLOB [Json]
45 IsLead (IsLead) BLOB [Json]
46 IsPartner (IsPartner) BLOB [Json]
47 IsVendor (IsVendor) BLOB [Json]
48 IsNavCreated (IsNavCreated) BLOB [Json]
49 NavIntegrationId (NavIntegrationId) BLOB [Json]
50 XrmId (XrmId) BLOB [Json]

Keys

# Fields
0 Id (Id) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field