| ### Showing:
Annotations
Attributes
Diagrams
Facets
Instances
Model
Properties

Imported schema eml-storedProcedure.xsd

Namespace | https://eml.ecoinformatics.org/storedProcedure-2.2.0
Annotations |
    '$RCSfile: eml-storedProcedure.xsd,v $'
           Copyright: 1997-2002 Regents of the University of California,
                                University of New Mexico, and
                                Arizona State University
            Sponsors: National Center for Ecological Analysis and Synthesis and
                      Partnership for Interdisciplinary Studies of Coastal Oceans,
                         University of California Santa Barbara
                      Long-Term Ecological Research Network Office,
                         University of New Mexico
                      Center for Environmental Studies, Arizona State University
       Other funding: National Science Foundation (see README for details)
                      The David and Lucile Packard Foundation
         For Details: http://knb.ecoinformatics.org/

            '$Author: obrien $'
              '$Date: 2009-02-25 23:51:54 $'
          '$Revision: 1.46 $'

        This program is free software; you can redistribute it and/or modify
        it under the terms of the GNU General Public License as published by
        the Free Software Foundation; either version 2 of the License, or
        (at your option) any later version.

        This program is distributed in the hope that it will be useful,
        but WITHOUT ANY WARRANTY; without even the implied warranty of
        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
        GNU General Public License for more details.

        You should have received a copy of the GNU General Public License
        along with this program; if not, write to the Free Software
        Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
    moduleName: eml-storedProcedure

    moduleDescription:

                The eml-storedProcedure module - Data tables
                resulting from procedures stored in a database

    recommendedUsage: Use the storedProcedure module to document
            datasets that use storedProcedures to retrieve archived
            data.

    standAlone: yes
Properties |
attribute form default | unqualified
element form default | unqualified

Element StoredProcedureType / attributeList

Namespace | No namespace
Annotations |
    tooltip: Attribute List

    summary: The list of attributes associated with this
                  entity.

    description: The list of attributes associated with this
                  entity.  For more information see the eml-attribute
                  module.
Diagram |
Type | AttributeListType
Properties |
content | complex
Model | attribute+ | (references)
Children | attribute, references
Instance |
    <attributeList id="">
      <attribute id="" scope="document" system="">{1,unbounded}</attribute>
      <references system="">{1,1}</references>
    </attributeList>
Attributes |
QName | Type | Use |
--- | --- | --- | ---
id | IDType | optional |

Element StoredProcedureType / constraint

Namespace | No namespace
Annotations |
    tooltip: Constraint

    summary:

    description: Description of any relational constraints on '
                  this entity.  For more information see the eml-constraint
                  module.
Diagram |
Type | ConstraintType
Properties |
content | complex
minOccurs | 0
maxOccurs | unbounded
Model | primaryKey | uniqueKey | checkConstraint | foreignKey | joinCondition | notNullConstraint
Children | checkConstraint, foreignKey, joinCondition, notNullConstraint, primaryKey, uniqueKey
Instance |
    <constraint id="" scope="document" system="">
      <primaryKey>{1,1}</primaryKey>
      <uniqueKey>{1,1}</uniqueKey>
      <checkConstraint language="">{1,1}</checkConstraint>
      <foreignKey>{1,1}</foreignKey>
      <joinCondition>{1,1}</joinCondition>
      <notNullConstraint>{1,1}</notNullConstraint>
    </constraint>
Attributes |
QName | Type | Default | Use |
--- | --- | --- | --- | ---
id | IDType |  | optional |
scope | ScopeType | document | optional |
system | SystemType |  | optional |

Element StoredProcedureType / parameter

Namespace | No namespace
Annotations |
    tooltip: Parameter

    summary: A parameter that is required as input to the
                  stored procedure.

    description: The parameter elements defines the fields that
                  may be required to invoke a stored procedure.
Diagram |
Type | ParameterType
Properties |
content | complex
minOccurs | 0
maxOccurs | unbounded
Model | name , domainDescription , required , repeats
Children | domainDescription, name, repeats, required
Instance |
    <parameter>
      <name>{1,1}</name>
      <domainDescription>{1,1}</domainDescription>
      <required>{1,1}</required>
      <repeats>{1,1}</repeats>
    </parameter>

Element ParameterType / name

Namespace | No namespace
Annotations |
    tooltip: Parameter Name

    summary: The name of the parameter.

    description: The value of the name field is the name of the
                parameter.

    example: SiteID
Diagram |
Type | NonEmptyStringType
Properties |
content | simple
Facets |
minLength | 1 |
pattern | [\s]*[\S][\s\S]* |

Element ParameterType / domainDescription

Namespace | No namespace
Annotations |
    tooltip: Domain Description

    summary: A description of domain of valid values for the
                parameter.

    description: The domainDescription field is used to describe
                the valid entries for the parameter being described. A stored
                procedure will work only when the parameter's value corresponds to
                an actual value in a database.

    example: The database has SiteId values that range from cap1 to
                cap10, however the allowable SiteId values for this stored procedure
                are cap1,cap2,cap4 or cap7.
Diagram |
Type | NonEmptyStringType
Properties |
content | simple
Facets |
minLength | 1 |
pattern | [\s]*[\S][\s\S]* |

Element ParameterType / required

Namespace | No namespace
Annotations |
    tooltip: Required

    summary: Whether or not the parameter is
                required.

    description: The required field is used to document whether the
                parameter being described is or is not required when invoking the
                stored procedure.

    example: true
Diagram |
Type | xs:boolean
Properties |
content | simple

Element ParameterType / repeats

Namespace | No namespace
Annotations |
    tooltip: Repeats

    summary: Whether or not the parameter repeats.

    description: The repeats field is used to document whether or
                not the parameter being described can be repeated when invoking the
                stored procedure.

    example: true
Diagram |
Type | xs:boolean
Properties |
content | simple

Element storedProcedure

Namespace | https://eml.ecoinformatics.org/storedProcedure-2.2.0
Annotations |
    tooltip: Stored Procedure>

    summary: The storedProcedure element documents stored
            procedures.

    description: The storedProcedure element is meant to capture
            information on procedures that produce data output in the form of a
            data table. In an RDBMS one can code complex queries and transactions
            into stored procedures and then invoke them directly from front-end
            applications. This element allows the optional description of any
            parameters that are expected to be passed to the procedure when it is
            called. A common use of a stored procedure is to rotate a data table
            from attributes in columns to attributes in rows for statistical
            analysis.
Diagram |
Type | StoredProcedureType
Properties |
content | complex
Model | (alternateIdentifier* , entityName , entityDescription{0,1} , physical* , coverage{0,1} , methods{0,1} , additionalInfo* , annotation* , attributeList , constraint* , parameter*) | (references)
Children | additionalInfo, alternateIdentifier, annotation, attributeList, constraint, coverage, entityDescription, entityName, methods, parameter, physical, references
Instance |
    <storedProcedure id="" scope="document" system="" xmlns="https://eml.ecoinformatics.org/storedProcedure-2.2.0">
      <alternateIdentifier system="">{0,unbounded}</alternateIdentifier>
      <entityName>{1,1}</entityName>
      <entityDescription>{0,1}</entityDescription>
      <physical id="" scope="document" system="">{0,unbounded}</physical>
      <coverage id="" scope="document" system="">{0,1}</coverage>
      <methods>{0,1}</methods>
      <additionalInfo xml:lang="">{0,unbounded}</additionalInfo>
      <annotation id="" scope="document" system="">{0,unbounded}</annotation>
      <attributeList id="">{1,1}</attributeList>
      <constraint id="" scope="document" system="">{0,unbounded}</constraint>
      <parameter>{0,unbounded}</parameter>
      <references system="">{1,1}</references>
    </storedProcedure>
Attributes |
QName | Type | Default | Use |
--- | --- | --- | --- | ---
id | IDType |  | optional |
scope | ScopeType | document | optional |
system | SystemType |  | optional |

Complex Type StoredProcedureType

Namespace | https://eml.ecoinformatics.org/storedProcedure-2.2.0
Annotations |
    tooltip: Stored Procedure complex type>

    summary: Structure for documenting a stored procedure

    description: The StoredProcedureType complex type defines the structure
            for documenting a stored procedure.
Diagram |
Model | (alternateIdentifier* , entityName , entityDescription{0,1} , physical* , coverage{0,1} , methods{0,1} , additionalInfo* , annotation* , attributeList , constraint* , parameter*) | (references)
Children | additionalInfo, alternateIdentifier, annotation, attributeList, constraint, coverage, entityDescription, entityName, methods, parameter, physical, references
Attributes |
QName | Type | Default | Use |
--- | --- | --- | --- | ---
id | IDType |  | optional |
scope | ScopeType | document | optional |
system | SystemType |  | optional |

Complex Type ParameterType

Namespace | https://eml.ecoinformatics.org/storedProcedure-2.2.0
Annotations |
    tooltip: Parameter complex type

    summary: The structure for defining a parameter that is required as
            input to the stored procedure.

    description: The parameter complex type defines the structure for
            documenting the parameters that may be required to invoke a stored
            procedure.
Diagram |
Model | name , domainDescription , required , repeats
Children | domainDescription, name, repeats, required

Attribute StoredProcedureType / @id

Namespace | No namespace
Type | IDType
Properties |
use | optional

Attribute StoredProcedureType / @system

Namespace | No namespace
Type | SystemType
Properties |
use | optional

Attribute StoredProcedureType / @scope

Namespace | No namespace
Type | ScopeType
Properties |
use | optional
default | document
Facets |
enumeration | system |
enumeration | document |