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