collectingtripattribute

Table info.

Title Collecting Trip Attribute
Description Collecting Trip Attribute

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectingTripAttributeID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Integer1 int(11) Integer1 integer1
Integer10 int(11) Integer10 integer10
Integer2 int(11) Integer2 integer2
Integer3 int(11) Integer3 integer3
Integer4 int(11) Integer4 integer4
Integer5 int(11) Integer5 integer5
Integer6 int(11) Integer6 integer6
Integer7 int(11) Integer7 integer7
Integer8 int(11) Integer8 integer8
Integer9 int(11) Integer9 integer9
Number1 float Number1 number1
Number10 float Number10 number10
Number11 float Number11 number11
Number12 float Number12 number12
Number13 float Number13 number13
Number2 float Number2 number2
Number3 float Number3 number3
Number4 float Number4 number4
Number5 float Number5 number5
Number6 float Number6 number6
Number7 float Number7 number7
Number8 float Number8 number8
Number9 float Number9 number9
Remarks text Remarks remarks
Text1 text Text1 text1
Text10 varchar(50) Text10 text10
Text11 varchar(50) Text11 text11
Text12 varchar(50) Text12 text12
Text13 varchar(50) Text13 text13
Text14 varchar(50) Text14 text14
Text15 varchar(50) Text15 text15
Text16 varchar(50) Text16 text16
Text17 varchar(50) Text17 text17
Text2 text Text2 text2
Text3 text Text3 text3
Text4 varchar(100) Text4 text4
Text5 varchar(100) Text5 text5
Text6 varchar(50) Text6 text6
Text7 varchar(50) Text7 text7
Text8 varchar(50) Text8 text8
Text9 varchar(50) Text9 text9
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
YesNo3 bit(1) Yes No3 yesNo3
YesNo4 bit(1) Yes No4 yesNo4
YesNo5 bit(1) Yes No5 yesNo5
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK381CA49F4CE675DE DisciplineID
FK381CA49F5327F942 ModifiedByAgentID
FK381CA49F7699B003 CreatedByAgentID
PRIMARY CollectingTripAttributeID

One-to-many relationships

Name Field Related table Related field
FK1080269D169A9556 CollectingTripAttributeID collectingtrip CollectingTripAttributeID

Many-to-one relationships

Name Field Related table Related field
FK381CA49F4CE675DE DisciplineID discipline UserGroupScopeId
FK381CA49F5327F942 ModifiedByAgentID agent AgentID
FK381CA49F7699B003 CreatedByAgentID agent AgentID