taxonattribute

Table info.

Title Taxon Attribute
Description Taxon Attribute

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaxonAttributeID int(11) PRI
TimestampCreated datetime Timestamp Created Timestamp Created
TimestampModified datetime Timestamp Modified Timestamp Modified
Version int(11) Version Version
Date1 date Date1 Date1
Date1Precision tinyint(4) Date1 Precision Date1 Precision
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
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 varchar(128) Text1 Text1
Text10 varchar(128) Text10 Text10
Text11 varchar(128) Text11 Text11
Text12 varchar(128) Text12 Text12
Text13 varchar(128) Text13 Text13
Text14 varchar(128) Text14 Text14
Text15 varchar(128) Text15 Text15
Text16 varchar(128) Text16 Text16
Text17 varchar(128) Text17 Text17
Text18 varchar(128) Text18 Text18
Text19 varchar(128) Text19 Text19
Text2 varchar(128) Text2 Text2
Text20 varchar(128) Text20 Text20
Text21 varchar(128) Text21 Text21
Text22 varchar(128) Text22 Text22
Text23 varchar(128) Text23 Text23
Text24 varchar(128) Text24 Text24
Text25 varchar(128) Text25 Text25
Text26 varchar(128) Text26 Text26
Text27 varchar(256) Text27 Text27
Text28 varchar(256) Text28 Text28
Text29 varchar(256) Text29 Text29
Text3 varchar(128) Text3 Text3
Text30 varchar(256) Text30 Text30
Text31 varchar(256) Text31 Text31
Text32 varchar(256) Text32 Text32
Text33 varchar(256) Text33 Text33
Text34 varchar(256) Text34 Text34
Text35 varchar(256) Text35 Text35
Text36 varchar(256) Text36 Text36
Text37 varchar(256) Text37 Text37
Text38 varchar(256) Text38 Text38
Text39 varchar(256) Text39 Text39
Text4 varchar(128) Text4 Text4
Text40 varchar(256) Text40 Text40
Text41 varchar(256) Text41 Text41
Text42 varchar(256) Text42 Text42
Text43 varchar(256) Text43 Text43
Text44 varchar(256) Text44 Text44
Text45 varchar(256) Text45 Text45
Text46 varchar(256) Text46 Text46
Text47 varchar(256) Text47 Text47
Text48 varchar(256) Text48 Text48
Text49 text Text49 Text49
Text5 varchar(128) Text5 Text5
Text50 text Text50 Text50
Text51 text Text51 Text51
Text52 text Text52 Text52
Text53 text Text53 Text53
Text54 text Text54 Text54
Text55 text Text55 Text55
Text56 text Text56 Text56
Text57 text Text57 Text57
Text58 text Text58 Text58
Text6 varchar(128) Text6 Text6
Text7 varchar(128) Text7 Text7
Text8 varchar(128) Text8 Text8
Text9 varchar(128) Text9 Text9
YesNo1 bit(1) Yes No1 Yes No1
YesNo10 bit(1) Yes No10 Yes No10
YesNo11 bit(1) Yes No11 Yes No11
YesNo12 bit(1) Yes No12 Yes No12
YesNo13 bit(1) Yes No13 Yes No13
YesNo14 bit(1) Yes No14 Yes No14
YesNo15 bit(1) Yes No15 Yes No15
YesNo16 bit(1) Yes No16 Yes No16
YesNo17 bit(1) Yes No17 Yes No17
YesNo18 bit(1) Yes No18 Yes No18
YesNo19 bit(1) Yes No19 Yes No19
YesNo2 bit(1) Yes No2 Yes No2
YesNo20 bit(1) Yes No20 Yes No20
YesNo21 bit(1) Yes No21 Yes No21
YesNo22 bit(1) Yes No22 Yes No22
YesNo23 bit(1) Yes No23 Yes No23
YesNo24 bit(1) Yes No24 Yes No24
YesNo25 bit(1) Yes No25 Yes No25
YesNo26 bit(1) Yes No26 Yes No26
YesNo27 bit(1) Yes No27 Yes No27
YesNo28 bit(1) Yes No28 Yes No28
YesNo29 bit(1) Yes No29 Yes No29
YesNo3 bit(1) Yes No3 Yes No3
YesNo30 bit(1) Yes No30 Yes No30
YesNo31 bit(1) Yes No31 Yes No31
YesNo32 bit(1) Yes No32 Yes No32
YesNo33 bit(1) Yes No33 Yes No33
YesNo34 bit(1) Yes No34 Yes No34
YesNo35 bit(1) Yes No35 Yes No35
YesNo36 bit(1) Yes No36 Yes No36
YesNo37 bit(1) Yes No37 Yes No37
YesNo38 bit(1) Yes No38 Yes No38
YesNo39 bit(1) Yes No39 Yes No39
YesNo4 bit(1) Yes No4 Yes No4
YesNo40 bit(1) Yes No40 Yes No40
YesNo41 bit(1) Yes No41 Yes No41
YesNo42 bit(1) Yes No42 Yes No42
YesNo43 bit(1) Yes No43 Yes No43
YesNo44 bit(1) Yes No44 Yes No44
YesNo45 bit(1) Yes No45 Yes No45
YesNo46 bit(1) Yes No46 Yes No46
YesNo47 bit(1) Yes No47 Yes No47
YesNo48 bit(1) Yes No48 Yes No48
YesNo49 bit(1) Yes No49 Yes No49
YesNo5 bit(1) Yes No5 Yes No5
YesNo50 bit(1) Yes No50 Yes No50
YesNo51 bit(1) Yes No51 Yes No51
YesNo52 bit(1) Yes No52 Yes No52
YesNo53 bit(1) Yes No53 Yes No53
YesNo54 bit(1) Yes No54 Yes No54
YesNo55 bit(1) Yes No55 Yes No55
YesNo56 bit(1) Yes No56 Yes No56
YesNo57 bit(1) Yes No57 Yes No57
YesNo58 bit(1) Yes No58 Yes No58
YesNo59 bit(1) Yes No59 Yes No59
YesNo6 bit(1) Yes No6 Yes No6
YesNo60 bit(1) Yes No60 Yes No60
YesNo61 bit(1) Yes No61 Yes No61
YesNo62 bit(1) Yes No62 Yes No62
YesNo63 bit(1) Yes No63 Yes No63
YesNo64 bit(1) Yes No64 Yes No64
YesNo65 bit(1) Yes No65 Yes No65
YesNo66 bit(1) Yes No66 Yes No66
YesNo67 bit(1) Yes No67 Yes No67
YesNo68 bit(1) Yes No68 Yes No68
YesNo69 bit(1) Yes No69 Yes No69
YesNo7 bit(1) Yes No7 Yes No7
YesNo70 bit(1) Yes No70 Yes No70
YesNo71 bit(1) Yes No71 Yes No71
YesNo72 bit(1) Yes No72 Yes No72
YesNo73 bit(1) Yes No73 Yes No73
YesNo74 bit(1) Yes No74 Yes No74
YesNo75 bit(1) Yes No75 Yes No75
YesNo76 bit(1) Yes No76 Yes No76
YesNo77 bit(1) Yes No77 Yes No77
YesNo78 bit(1) Yes No78 Yes No78
YesNo79 bit(1) Yes No79 Yes No79
YesNo8 bit(1) Yes No8 Yes No8
YesNo80 bit(1) Yes No80 Yes No80
YesNo81 bit(1) Yes No81 Yes No81
YesNo82 bit(1) Yes No82 Yes No82
YesNo9 bit(1) Yes No9 Yes No9
Agent1ID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKDAEA1F125327F942 ModifiedByAgentID
FKDAEA1F127699B003 CreatedByAgentID
FKDAEA1F12CF197B29 Agent1ID
PRIMARY TaxonAttributeID

One-to-many relationships

Name Field Related table Related field
FK6908ECA83339302 TaxonAttributeID taxon TaxonAttributeID

Many-to-one relationships

Name Field Related table Related field
FKDAEA1F125327F942 ModifiedByAgentID agent AgentID
FKDAEA1F127699B003 CreatedByAgentID agent AgentID
FKDAEA1F12CF197B29 Agent1ID agent AgentID