Addressbook

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
ClientsID	int
Deleted	bit		Default = 0
FirstName	nvarchar(255)	yes
LastName	nvarchar(255)	yes
EmailAddress	nvarchar(255)	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
UserID	int		ClientUsers.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_Addressbook	ID	yes	yes	yes