Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 Guid uniqueidentifier   Default = (newid())
 OwnerID int  
 Deleted bit   Default = 0
 HomePhoneType int   Default = 0
 BusinessPhoneType int   Default = 0
 EmailPhoneType int   Default = 0
 InterestsTypeID int
 RECountryMask int
 defPrivacy int
 SearchEnabled bit   Default = 0
 Options ntext
 Name nvarchar(510)
 RESerialNumber nvarchar(100)
 OrigID nvarchar(20)
 Address1 nvarchar(200)
 Address2 nvarchar(200)
 City nvarchar(200)
 PostCode nvarchar(20)
 OrganizationPhoneType int
 WebSitePhoneType int
 Phone1Type int
 Phone2Type int
 Phone3Type int
 Phone4Type int
 Phone5Type int
 LinkedInPhoneType int Default = 0

Index Name Field(s) Unique Primary Clustered
 PK_Clients ID

Referenced by Field
 ClientContentTypes ClientsID
 ClientMerchantAccounts ClientsID

Entity-Relationship diagram of this table