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
lithostrat
Table info.
Table info.
Title
Lithostratigraphy
Description
Lithostratigraphy
Fields
Name
Type
Required
Index
Hidden
On form
Title
Pick list
Description
LithoStratID
int(11)
PRI
TimestampCreated
datetime
Timestamp Created
The timestamp the record was created.
TimestampModified
datetime
Timestamp Modified
The timestamp the record was last modified.
Version
int(11)
Version
version
FullName
varchar(255)
MUL
Full Name
fullName
GUID
varchar(128)
MUL
GUID
guid
HighestChildNodeNumber
int(11)
Highest Child Node Number
highestChildNodeNumber
IsAccepted
bit(1)
Is Preferred
isAccepted
Name
varchar(64)
MUL
Name
name
NodeNumber
int(11)
Node Number
nodeNumber
Number1
double
Number1
number1
Number2
double
Number2
number2
RankID
int(11)
Rank Id
rankId
Remarks
text
Remarks
Additional Comments.
Text1
text
Text1
text1
Text2
text
Text2
text2
YesNo1
bit(1)
Yes No1
yesNo1
YesNo2
bit(1)
Yes No2
yesNo2
ParentID
int(11)
MUL
ModifiedByAgentID
int(11)
MUL
CreatedByAgentID
int(11)
MUL
LithoStratTreeDefItemID
int(11)
MUL
LithoStratTreeDefID
int(11)
MUL
AcceptedID
int(11)
MUL
Indexes
Name
Fields
Unique
Nullable
FK329297065327F942
ModifiedByAgentID
FK3292970672939D3A
LithoStratTreeDefID
FK329297067699B003
CreatedByAgentID
FK329297067A1D53CB
AcceptedID
FK32929706943880E
ParentID
FK3292970699E26740
LithoStratTreeDefItemID
LithoFullNameIDX
FullName
LithoGuidIDX
GUID
LithoNameIDX
Name
PRIMARY
LithoStratID
One-to-many relationships
Name
Field
Related table
Related field
FK329297067A1D53CB
LithoStratID
lithostrat
AcceptedID
FK32929706943880E
LithoStratID
lithostrat
ParentID
FK99B5438A9B80EF6A
LithoStratID
paleocontext
LithoStratID
Many-to-one relationships
Name
Field
Related table
Related field
FK329297065327F942
ModifiedByAgentID
agent
AgentID
FK3292970672939D3A
LithoStratTreeDefID
lithostrattreedef
LithoStratTreeDefID
FK329297067699B003
CreatedByAgentID
agent
AgentID
FK329297067A1D53CB
AcceptedID
lithostrat
LithoStratID
FK32929706943880E
ParentID
lithostrat
LithoStratID
FK3292970699E26740
LithoStratTreeDefItemID
lithostrattreedefitem
LithoStratTreeDefItemID