spfieldvaluedefault

Table info.

Title Sp Field Value Default
Description Sp Field Value Default

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpFieldValueDefaultID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
FieldName varchar(32) Field Name fieldName
IdValue int(11) Id Value idValue
StrValue varchar(64) Str Value strValue
TableName varchar(32) Table Name tableName
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK14E6C4ED5327F942 ModifiedByAgentID
FK14E6C4ED7699B003 CreatedByAgentID
PRIMARY SpFieldValueDefaultID
SpFieldValueDefaultColMemIDX CollectionMemberID

Many-to-one relationships

Name Field Related table Related field
FK14E6C4ED5327F942 ModifiedByAgentID agent AgentID
FK14E6C4ED7699B003 CreatedByAgentID agent AgentID