ApplicationFields

Fields

Field	Field Type	Null	Notes	Description
FieldID	int
ParentFieldID	int	yes
FieldName	nvarchar(50)	yes
Sequence	int	yes
HasMultiples	bit		Default = 0
ApplicationsID	int
Searchable	bit		Default = 1
PrivateShowByDefault	bit	yes	Default = NULL
NeverPrivate	bit		Default = 0
FieldType	int
FormField	bit		Default = 1
HTMLEncode	bit		Default = 1
AttribTypeID	int		Default = 0
DataType	int		Default = 0
CodeTableID	int		Default = 0
AttribRequired	int		Default = 0
AttribRecordType	int		Default = 0
ClientsID	int		Default = 0
StaticCodeTable	bit		Default = 0
UseShortDescription	bit		Default = 0
CountryMask	int	yes	Default = 55
RowNumber	int	yes
StripSpanTags	bit		Default = 0
ToolTip	nvarchar(1024)	yes

Indexes

Index Name	Fields	Unique	Primary	Clustered
uk_ApplicationFields_FieldID	FieldID, AttribTypeID	yes