datatype

Table info.

Title Data Type
Description Data Type

Fields

Name Type Required Index Hidden On form Title Pick list Description
DataTypeID 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
Name varchar(50) Name name
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK6AB199E45327F942 ModifiedByAgentID
FK6AB199E47699B003 CreatedByAgentID
PRIMARY DataTypeID

One-to-many relationships

Name Field Related table Related field
FK157B9B70D62E36A6 DataTypeID discipline DataTypeID

Many-to-one relationships

Name Field Related table Related field
FK6AB199E45327F942 ModifiedByAgentID agent AgentID
FK6AB199E47699B003 CreatedByAgentID agent AgentID