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 |