collectionobjectproperty

Table info.

Title Collection Object Property
Description Collection Object Property

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionObjectPropertyID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
Date1 date Date1 date1
Date10 date Date10 date10
Date11 date Date11 date11
Date12 date Date12 date12
Date13 date Date13 date13
Date14 date Date14 date14
Date15 date Date15 date15
Date16 date Date16 date16
Date17 date Date17 date17
Date18 date Date18 date18
Date19 date Date19 date19
Date2 date Date2 date2
Date20 date Date20 date20
Date3 date Date3 date3
Date4 date Date4 date4
Date5 date Date5 date5
Date6 date Date6 date6
Date7 date Date7 date7
Date8 date Date8 date8
Date9 date Date9 date9
GUID varchar(128) Guid guid
Integer1 smallint(6) Integer1 integer1
Integer10 smallint(6) Integer10 integer10
Integer11 smallint(6) Integer11 integer11
Integer12 smallint(6) Integer12 integer12
Integer13 smallint(6) Integer13 integer13
Integer14 smallint(6) Integer14 integer14
Integer15 smallint(6) Integer15 integer15
Integer16 smallint(6) Integer16 integer16
Integer17 smallint(6) Integer17 integer17
Integer18 smallint(6) Integer18 integer18
Integer19 smallint(6) Integer19 integer19
Integer2 smallint(6) Integer2 integer2
Integer20 smallint(6) Integer20 integer20
Integer21 int(11) Integer21 integer21
Integer22 int(11) Integer22 integer22
Integer23 int(11) Integer23 integer23
Integer24 int(11) Integer24 integer24
Integer25 int(11) Integer25 integer25
Integer26 int(11) Integer26 integer26
Integer27 int(11) Integer27 integer27
Integer28 int(11) Integer28 integer28
Integer29 int(11) Integer29 integer29
Integer3 smallint(6) Integer3 integer3
Integer30 int(11) Integer30 integer30
Integer4 smallint(6) Integer4 integer4
Integer5 smallint(6) Integer5 integer5
Integer6 smallint(6) Integer6 integer6
Integer7 smallint(6) Integer7 integer7
Integer8 smallint(6) Integer8 integer8
Integer9 smallint(6) Integer9 integer9
Number1 float Number1 number1
Number10 float Number10 number10
Number11 float Number11 number11
Number12 float Number12 number12
Number13 float Number13 number13
Number14 float Number14 number14
Number15 float Number15 number15
Number16 float Number16 number16
Number17 float Number17 number17
Number18 float Number18 number18
Number19 float Number19 number19
Number2 float Number2 number2
Number20 float Number20 number20
Number21 double Number21 number21
Number22 double Number22 number22
Number23 double Number23 number23
Number24 double Number24 number24
Number25 double Number25 number25
Number26 double Number26 number26
Number27 double Number27 number27
Number28 double Number28 number28
Number29 double Number29 number29
Number3 float Number3 number3
Number30 double Number30 number30
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 varchar(50) 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(100) Text16 text16
Text17 varchar(100) Text17 text17
Text18 varchar(100) Text18 text18
Text19 varchar(100) Text19 text19
Text2 varchar(50) Text2 text2
Text20 varchar(100) Text20 text20
Text21 varchar(100) Text21 text21
Text22 varchar(100) Text22 text22
Text23 varchar(100) Text23 text23
Text24 varchar(100) Text24 text24
Text25 varchar(100) Text25 text25
Text26 varchar(100) Text26 text26
Text27 varchar(100) Text27 text27
Text28 varchar(100) Text28 text28
Text29 varchar(100) Text29 text29
Text3 varchar(50) Text3 text3
Text30 varchar(100) Text30 text30
Text31 text Text31 text31
Text32 text Text32 text32
Text33 text Text33 text33
Text34 text Text34 text34
Text35 text Text35 text35
Text36 text Text36 text36
Text37 text Text37 text37
Text38 text Text38 text38
Text39 text Text39 text39
Text4 varchar(50) Text4 text4
Text40 text Text40 text40
Text5 varchar(50) 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
YesNo10 bit(1) Yes No10 yesNo10
YesNo11 bit(1) Yes No11 yesNo11
YesNo12 bit(1) Yes No12 yesNo12
YesNo13 bit(1) Yes No13 yesNo13
YesNo14 bit(1) Yes No14 yesNo14
YesNo15 bit(1) Yes No15 yesNo15
YesNo16 bit(1) Yes No16 yesNo16
YesNo17 bit(1) Yes No17 yesNo17
YesNo18 bit(1) Yes No18 yesNo18
YesNo19 bit(1) Yes No19 yesNo19
YesNo2 bit(1) Yes No2 yesNo2
YesNo20 bit(1) Yes No20 yesNo20
YesNo3 bit(1) Yes No3 yesNo3
YesNo4 bit(1) Yes No4 yesNo4
YesNo5 bit(1) Yes No5 yesNo5
YesNo6 bit(1) Yes No6 yesNo6
YesNo7 bit(1) Yes No7 yesNo7
YesNo8 bit(1) Yes No8 yesNo8
YesNo9 bit(1) Yes No9 yesNo9
Agent11ID int(11) MUL
Agent10ID int(11) MUL
Agent5ID int(11) MUL
CreatedByAgentID int(11) MUL
Agent12ID int(11) MUL
Agent2ID int(11) MUL
Agent18ID int(11) MUL
Agent6ID int(11) MUL
Agent8D int(11) MUL
Agent9ID int(11) MUL
Agent4ID int(11) MUL
Agent15ID int(11) MUL
Agent13ID int(11) MUL
Agent17ID int(11) MUL
ModifiedByAgentID int(11) MUL
Agent16ID int(11) MUL
Agent3ID int(11) MUL
Agent1ID int(11) MUL
CollectionObjectID int(11) MUL
Agent19ID int(11) MUL
Agent7ID int(11) MUL
Agent20ID int(11) MUL
Agent14ID int(11) MUL

Indexes

Name Fields Unique Nullable
FKC66B94321213D341 Agent10ID
FKC66B94321213D702 Agent11ID
FKC66B94321213DAC3 Agent12ID
FKC66B94321213DE84 Agent13ID
FKC66B94321213E245 Agent14ID
FKC66B94321213E606 Agent15ID
FKC66B94321213E9C7 Agent16ID
FKC66B94321213ED88 Agent17ID
FKC66B94321213F149 Agent18ID
FKC66B94321213F50A Agent19ID
FKC66B9432121447A0 Agent20ID
FKC66B9432384B3033 Agent8D
FKC66B94325327F942 ModifiedByAgentID
FKC66B943275E37458 CollectionObjectID
FKC66B94327699B003 CreatedByAgentID
FKC66B9432CF197B29 Agent1ID
FKC66B9432CF197EEA Agent2ID
FKC66B9432CF1982AB Agent3ID
FKC66B9432CF19866C Agent4ID
FKC66B9432CF198A2D Agent5ID
FKC66B9432CF198DEE Agent6ID
FKC66B9432CF1991AF Agent7ID
FKC66B9432CF199931 Agent9ID
PRIMARY CollectionObjectPropertyID

Many-to-one relationships

Name Field Related table Related field
FKC66B94321213D341 Agent10ID agent AgentID
FKC66B94321213D702 Agent11ID agent AgentID
FKC66B94321213DAC3 Agent12ID agent AgentID
FKC66B94321213DE84 Agent13ID agent AgentID
FKC66B94321213E245 Agent14ID agent AgentID
FKC66B94321213E606 Agent15ID agent AgentID
FKC66B94321213E9C7 Agent16ID agent AgentID
FKC66B94321213ED88 Agent17ID agent AgentID
FKC66B94321213F149 Agent18ID agent AgentID
FKC66B94321213F50A Agent19ID agent AgentID
FKC66B9432121447A0 Agent20ID agent AgentID
FKC66B9432384B3033 Agent8D agent AgentID
FKC66B94325327F942 ModifiedByAgentID agent AgentID
FKC66B943275E37458 CollectionObjectID collectionobject CollectionObjectID
FKC66B94327699B003 CreatedByAgentID agent AgentID
FKC66B9432CF197B29 Agent1ID agent AgentID
FKC66B9432CF197EEA Agent2ID agent AgentID
FKC66B9432CF1982AB Agent3ID agent AgentID
FKC66B9432CF19866C Agent4ID agent AgentID
FKC66B9432CF198A2D Agent5ID agent AgentID
FKC66B9432CF198DEE Agent6ID agent AgentID
FKC66B9432CF1991AF Agent7ID agent AgentID
FKC66B9432CF199931 Agent9ID agent AgentID