localityattachment

Table info.

Title Locality Attachment
Description Locality Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
LocalityAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal ordinal
Remarks text Remarks remarks
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
AttachmentID int(11) MUL
LocalityID int(11) MUL

Indexes

Name Fields Unique Nullable
FKB39C36C65327F942 ModifiedByAgentID
FKB39C36C67699B003 CreatedByAgentID
FKB39C36C6A666A5C4 LocalityID
FKB39C36C6C7E55084 AttachmentID
PRIMARY LocalityAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKB39C36C65327F942 ModifiedByAgentID agent AgentID
FKB39C36C67699B003 CreatedByAgentID agent AgentID
FKB39C36C6A666A5C4 LocalityID locality LocalityID
FKB39C36C6C7E55084 AttachmentID attachment AttachmentID