Clients
Primary Key
| Primary Key |
Field Type |
| ID |
int |
Fields
| 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 |
yes |
|
|
| RECountryMask |
int |
yes |
|
|
| defPrivacy |
int |
yes |
|
|
| SearchEnabled |
bit |
|
Default = 0 |
|
| Options |
ntext |
yes |
|
|
| Name |
nvarchar(510) |
yes |
|
|
| RESerialNumber |
nvarchar(100) |
yes |
|
|
| OrigID |
nvarchar(20) |
yes |
|
|
| Address1 |
nvarchar(200) |
yes |
|
|
| Address2 |
nvarchar(200) |
yes |
|
|
| City |
nvarchar(200) |
yes |
|
|
| PostCode |
nvarchar(20) |
yes |
|
|
| OrganizationPhoneType |
int |
yes |
|
|
| WebSitePhoneType |
int |
yes |
|
|
| Phone1Type |
int |
yes |
|
|
| Phone2Type |
int |
yes |
|
|
| Phone3Type |
int |
yes |
|
|
| Phone4Type |
int |
yes |
|
|
| Phone5Type |
int |
yes |
|
|
| LinkedInPhoneType |
int |
yes |
Default = 0 |
|
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| PK_Clients |
ID |
yes |
yes |
yes |
Referenced by