picklist

Table info.

Title Pick List
Description Pick List

Fields

Name Type Required Index Hidden On form Title Pick list Description
PickListID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
FieldName varchar(64) Field Name fieldName
FilterFieldName varchar(32) Filter Field Name filterFieldName
FilterValue varchar(32) Filter Value filterValue
Formatter varchar(64) Formatter formatter
IsSystem bit(1) Is System Where system form rely on this picklist, not user defined
Name varchar(64) MUL Name name
ReadOnly bit(1) Read Only readOnly
SizeLimit int(11) Size Limit sizeLimit
SortType tinyint(4) Sort Type sortType
TableName varchar(64) Table Name tableName
Type tinyint(4) Type type
ModifiedByAgentID int(11) MUL
CollectionID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKD3F8383F5327F942 ModifiedByAgentID
FKD3F8383F7699B003 CreatedByAgentID
FKD3F8383F8C2288BA CollectionID
PickListNameIDX Name
PRIMARY PickListID

One-to-many relationships

Name Field Related table Related field
FK30C57BD2718D489C PickListID picklistitem PickListID

Many-to-one relationships

Name Field Related table Related field
FKD3F8383F5327F942 ModifiedByAgentID agent AgentID
FKD3F8383F7699B003 CreatedByAgentID agent AgentID
FKD3F8383F8C2288BA CollectionID collection UserGroupScopeId