collectingtripauthorization

Table info.

Title Collecting Trip Authorization
Description Collecting Trip Authorization

Fields

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

Indexes

Name Fields Unique Nullable
FKDDDC20FC5327F942 ModifiedByAgentID
FKDDDC20FC697B3F98 CollectingTripID
FKDDDC20FC7699B003 CreatedByAgentID
FKDDDC20FCAD1F31F4 PermitID
PRIMARY CollectingTripAuthorizationID

Many-to-one relationships

Name Field Related table Related field
FKDDDC20FC5327F942 ModifiedByAgentID agent AgentID
FKDDDC20FC697B3F98 CollectingTripID collectingtrip CollectingTripID
FKDDDC20FC7699B003 CreatedByAgentID agent AgentID
FKDDDC20FCAD1F31F4 PermitID permit PermitID