picklistitem

Table info.

Title Pick List Item
Description Pick List Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
PickListItemID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal ordinal
Title varchar(128) Title title
Value varchar(128) Value value
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
PickListID int(11) MUL

Indexes

Name Fields Unique Nullable
FK30C57BD25327F942 ModifiedByAgentID
FK30C57BD2718D489C PickListID
FK30C57BD27699B003 CreatedByAgentID
PRIMARY PickListItemID

Many-to-one relationships

Name Field Related table Related field
FK30C57BD25327F942 ModifiedByAgentID agent AgentID
FK30C57BD2718D489C PickListID picklist PickListID
FK30C57BD27699B003 CreatedByAgentID agent AgentID