BBDM_Fields

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Name	nvarchar(128)	yes
IsEmailAddress	bit	yes
IsEmailDisplay	bit	yes
IsUnique	bit	yes
CreateDate	datetime		Default = getutcdate()
IsFinderNumber	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
DataSourceID	int		DataSources.DataSourceID

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_BBDM_Fields	ID	yes	yes	yes