permitattachment

Table info.

Title Permit Attachment
Description Permit Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
PermitAttachmentID 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
AttachmentID int(11) MUL
PermitID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK7064B77E5327F942 ModifiedByAgentID
FK7064B77E7699B003 CreatedByAgentID
FK7064B77EAD1F31F4 PermitID
FK7064B77EC7E55084 AttachmentID
PRIMARY PermitAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK7064B77E5327F942 ModifiedByAgentID agent AgentID
FK7064B77E7699B003 CreatedByAgentID agent AgentID
FK7064B77EAD1F31F4 PermitID permit PermitID
FK7064B77EC7E55084 AttachmentID attachment AttachmentID