attributedef

Table info.

Title Attribute Definition
Description Attribute Definition

Fields

Name Type Required Index Hidden On form Title Pick list Description
AttributeDefID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
DataType smallint(6) Data Type The data type of the attribute.
FieldName varchar(32) Field Name The field name of the attribute.
TableType smallint(6) Table Type The type of table it is attached to, this is internal to Specify.
ModifiedByAgentID int(11) MUL
PrepTypeID int(11) MUL
CreatedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FKC36883E94CE675DE DisciplineID
FKC36883E95327F942 ModifiedByAgentID
FKC36883E96E8973EC PrepTypeID
FKC36883E97699B003 CreatedByAgentID
PRIMARY AttributeDefID

One-to-many relationships

Name Field Related table Related field
FK42A08813E84BA7B0 AttributeDefID collectingeventattr AttributeDefID
FK303746CEE84BA7B0 AttributeDefID collectionobjectattr AttributeDefID
FK4592DD08E84BA7B0 AttributeDefID preparationattr AttributeDefID

Many-to-one relationships

Name Field Related table Related field
FKC36883E94CE675DE DisciplineID discipline UserGroupScopeId
FKC36883E95327F942 ModifiedByAgentID agent AgentID
FKC36883E96E8973EC PrepTypeID preptype PrepTypeID
FKC36883E97699B003 CreatedByAgentID agent AgentID