MEL Specify schema browser
melisr
development
App. version:
6.8.00
Schema version:
2.7
accession
accessionagent
accessionattachment
accessionauthorization
accessioncitation
address
addressofrecord
agent
agentattachment
agentgeography
agentspecialty
agentvariant
appraisal
attachment
attachmentimageattribute
attachmentmetadata
attachmenttag
attributedef
author
autonumberingscheme
autonumsch_coll
autonumsch_div
autonumsch_dsp
aux_highergeography
aux_highergeography_test
aux_highertaxonomy
aux_highertaxonomy_test
aux_island
avh_darwin_core_mapping
bionomia_attributions
borrow
borrowagent
borrowattachment
borrowmaterial
borrowreturnmaterial
collectingevent
collectingeventattachment
collectingeventattr
collectingeventattribute
collectingeventauthorization
collectingtrip
collectingtripattachment
collectingtripattribute
collectingtripauthorization
collection
collectionobject
collectionobjectattachment
collectionobjectattr
collectionobjectattribute
collectionobjectcitation
collectionobjectproperty
collectionrelationship
collectionreltype
collector
commonnametx
commonnametxcitation
conservdescription
conservdescriptionattachment
conservevent
conserveventattachment
container
continentcodes
countryinfo
datatype
deaccession
deaccessionagent
deaccessionpreparation
determination
determinationcitation
discipline
division
django_migrations
dnaprimer
dnasequence
dnasequenceattachment
dnasequencerunattachment
dnasequencingrun
dnasequencingruncitation
exchangein
exchangeinprep
exchangeout
exchangeoutprep
exsiccata
exsiccataitem
extractor
fieldnotebook
fieldnotebookattachment
fieldnotebookpage
fieldnotebookpageattachment
fieldnotebookpageset
fieldnotebookpagesetattachment
fundingagent
genusstorage
geocoorddetail
geography
geographytreedef
geographytreedefitem
geologictimeperiod
geologictimeperiodtreedef
geologictimeperiodtreedefitem
geoname
gift
giftagent
giftattachment
giftpreparation
groupperson
hibernate_unique_key
inforequest
institution
institutionnetwork
ios_colobjagents
ios_colobjbio
ios_colobjchron
ios_colobjcnts
ios_colobjgeo
ios_colobjlitho
ios_geogeo_cnt
ios_geogeo_cty
ios_geoloc
ios_geoloc_cnt
ios_geoloc_cty
ios_taxon_pid
journal
kosher_coordinates
latlonpolygon
latlonpolygonpnt
lithostrat
lithostrattreedef
lithostrattreedefitem
loan
loanagent
loanattachment
loanpreparation
loanreturnpreparation
locality
localityattachment
localitycitation
localitydetail
localitynamealias
materialsample
melnumbers
mel_avh_agent_action_extension
mel_avh_associated_sequences
mel_avh_multimedia
mel_avh_occurrence_core
mel_avh_occurrence_core_agent_id
mel_avh_occurrence_core_test
mel_deleted
mel_recataloguenumbered
migrations
morphbankview
notifications_message
numbers
otheridentifier
paleocontext
pcrperson
permit
permitattachment
picklist
picklistitem
preparation
preparationattachment
preparationattr
preparationattribute
preparationproperty
preptype
project
project_colobj
recordset
recordsetitem
referencework
referenceworkattachment
repositoryagreement
repositoryagreementattachment
sgrbatchmatchresultitem
sgrbatchmatchresultset
sgrmatchconfiguration
shipment
spappresource
spappresourcedata
spappresourcedir
spauditlog
spauditlogfield
specifyuser
specifyuser_spprincipal
spexportschema
spexportschemaitem
spexportschemaitemmapping
spexportschemamapping
spfieldvaluedefault
splocalecontainer
splocalecontaineritem
splocaleitemstr
sppermission
spprincipal
spprincipal_sppermission
spquery
spqueryfield
spreport
spschema_field
spschema_form
spschema_formfield
spschema_index
spschema_relationship
spschema_table
spsymbiotainstance
sptasksemaphore
spversion
spviewsetobj
spvisualquery
sp_schema_mapping
storage
storageattachment
storagetreedef
storagetreedefitem
taxon
taxonattachment
taxonattribute
taxoncitation
taxontreedef
taxontreedefitem
treatmentevent
treatmenteventattachment
voucherrelationship
workbench
workbenchdataitem
workbenchrow
workbenchrowexportedrelationship
workbenchrowimage
workbenchtemplate
workbenchtemplatemappingitem
taxonattribute
Table info.
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