ST_PROPERTIES

This table lists all properties.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	TypeID	int	4	Y	Class ID of type
3	ID	int	4	Y	ID
4	TypeName	varchar	254	N	Name of type that the property is for
5	TypeCode	varchar	254	N	Property type
6	ClassName	varchar	254	N	Class Name when the field type is an object
7	PropertyName	varchar	254	N	Property Name
8	DisplayName	varchar	254	N	Display Name
9	DefaultValue	varchar	254	N	Default Value
10	Enumerations	text	16	N	List of all Enumerations
11	MaxLength	int	4	N	Max Length
12	IsAdvanced	int	4	N	Whether Advanced property
13	IsCalculated	int	4	N	Whether Calculated
14	IsClientCalculated	int	4	N	Whether Calculated at the client
15	IsDescriptor	int	4	N	Whether Descriptor
16	IsGenericCalculated	int	4	N	Whether Generic Calculated
17	IsHeader	int	4	N	Whether Header
18	IsPrimaryDescriptor	int	4	N	Whether Primary Descriptor
19	IsRequired	int	4	N	Whether Required when editing item
20	IsRestricted	int	4	N	Whether field has restrictions
21	IsServerCalculated	int	4	N	Whether Calculated at the server
22	IsStored	int	4	N	Whether Stored in database
23	IsSystemDefined	int	4	N	Whether System Defined
24	IsTimeTruncated	int	4	N	Whether Time Truncated for date time fields
25	IsUserCustomized	int	4	N	Whether this is a custom field
26	IsUserDefined	int	4	N	Whether User Defined
27	IsUserModifiable	int	4	N	Whether User can Modify
28	Enabled	varchar	4	N	Whether property is enabled

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_PROPERTIES	ServerID	ST_ENUMVALUES	ServerID
2	ST_PROPERTIES	TypeID	ST_ENUMVALUES	TypeID
3	ST_PROPERTIES	ID	ST_ENUMVALUES	PropertyID
1	ST_TYPES	ServerID	ST_PROPERTIES	ServerID
2	STTYPES	ClassID	STPROPERTIES	TypeID