Difference between revisions of "HumanResources.HRResumeSchemaCollection (xml schema collection)"

From dbscript Online Help
Jump to: navigation, search
Line 159: Line 159:
 
       </xsd:restriction>
 
       </xsd:restriction>
 
     </xsd:complexContent>
 
     </xsd:complexContent>
 +
  </xsd:complexType>
 +
</xsd:schema>
 +
</pre>
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''xmlschemacollection
 +
| HumanResources.HRResumeSchemaCollection
 +
|-
 +
 +
| '''Description
 +
| Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table.
 +
|-
 +
 +
|}
 +
 +
<pre>
 +
<?xml version="1.0" encoding="UTF-8"?>
 +
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
 +
  <xsd:element name="Resume" type="ResumeType" />
 +
  <xsd:element name="Address" type="AddressType" />
 +
  <xsd:element name="Education" type="EducationType" />
 +
  <xsd:element name="Employment" type="EmploymentType" />
 +
  <xsd:element name="Location" type="LocationType" />
 +
  <xsd:element name="Name" type="NameType" />
 +
  <xsd:element name="Telephone" type="TelephoneType" />
 +
  <xsd:complexType name="ResumeType">
 +
    <xsd:sequence>
 +
      <xsd:element ref="Name" />
 +
      <xsd:element name="Skills" type="xsd:string" minOccurs="0" />
 +
      <xsd:element ref="Employment" maxOccurs="unbounded" />
 +
      <xsd:element ref="Education" maxOccurs="unbounded" />
 +
      <xsd:element ref="Address" maxOccurs="unbounded" />
 +
      <xsd:element ref="Telephone" minOccurs="0" />
 +
      <xsd:element name="EMail" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="WebSite" type="xsd:string" minOccurs="0" />
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="AddressType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Addr.Type" type="xsd:string">
 +
        <xsd:annotation>
 +
          <xsd:documentation>Home|Work|Permanent</xsd:documentation>
 +
        </xsd:annotation>
 +
      </xsd:element>
 +
      <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded" />
 +
      <xsd:element name="Addr.Location">
 +
        <xsd:complexType>
 +
          <xsd:sequence>
 +
            <xsd:element ref="Location" />
 +
          </xsd:sequence>
 +
        </xsd:complexType>
 +
      </xsd:element>
 +
      <xsd:element name="Addr.PostalCode" type="xsd:string" />
 +
      <xsd:element name="Addr.Telephone" minOccurs="0">
 +
        <xsd:complexType>
 +
          <xsd:sequence>
 +
            <xsd:element ref="Telephone" maxOccurs="unbounded" />
 +
          </xsd:sequence>
 +
        </xsd:complexType>
 +
      </xsd:element>
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="EducationType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Edu.Level" type="xsd:string">
 +
        <xsd:annotation>
 +
          <xsd:documentation>High School|Associate|Bachelor|Master|Doctorate</xsd:documentation>
 +
        </xsd:annotation>
 +
      </xsd:element>
 +
      <xsd:element name="Edu.StartDate" type="xsd:date" />
 +
      <xsd:element name="Edu.EndDate" type="xsd:date" />
 +
      <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0">
 +
        <xsd:annotation>
 +
          <xsd:documentation>In case the institution does not follow a GPA system</xsd:documentation>
 +
        </xsd:annotation>
 +
      </xsd:element>
 +
      <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0" />
 +
      <xsd:element name="Edu.School" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Edu.Location" minOccurs="0">
 +
        <xsd:complexType>
 +
          <xsd:sequence>
 +
            <xsd:element ref="Location" />
 +
          </xsd:sequence>
 +
        </xsd:complexType>
 +
      </xsd:element>
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="EmploymentType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0" />
 +
      <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0" />
 +
      <xsd:element name="Emp.OrgName" type="xsd:string" />
 +
      <xsd:element name="Emp.JobTitle" type="xsd:string" />
 +
      <xsd:element name="Emp.Responsibility" type="xsd:string" />
 +
      <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Emp.Location" minOccurs="0">
 +
        <xsd:complexType>
 +
          <xsd:sequence>
 +
            <xsd:element ref="Location" />
 +
          </xsd:sequence>
 +
        </xsd:complexType>
 +
      </xsd:element>
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="LocationType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Loc.CountryRegion" type="xsd:string">
 +
        <xsd:annotation>
 +
          <xsd:documentation>ISO 3166 Country Code</xsd:documentation>
 +
        </xsd:annotation>
 +
      </xsd:element>
 +
      <xsd:element name="Loc.State" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Loc.City" type="xsd:string" minOccurs="0" />
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="NameType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Name.First" type="xsd:string" />
 +
      <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0" />
 +
      <xsd:element name="Name.Last" type="xsd:string" />
 +
      <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0" />
 +
    </xsd:sequence>
 +
  </xsd:complexType>
 +
  <xsd:complexType name="TelephoneType">
 +
    <xsd:sequence>
 +
      <xsd:element name="Tel.Type" minOccurs="0">
 +
        <xsd:annotation>
 +
          <xsd:documentation>Voice|Fax|Pager</xsd:documentation>
 +
        </xsd:annotation>
 +
      </xsd:element>
 +
      <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0" />
 +
      <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0" />
 +
      <xsd:element name="Tel.Number" type="xsd:string" />
 +
      <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0" />
 +
    </xsd:sequence>
 
   </xsd:complexType>
 
   </xsd:complexType>
 
</xsd:schema>
 
</xsd:schema>
 
</pre>
 
</pre>

Revision as of 23:28, 26 November 2009

wikibot

xmlschemacollection HumanResources.HRResumeSchemaCollection 
<?xml version="1.0" encoding="utf-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" elementFormDefault="qualified">
  <xsd:element name="Address" type="t:AddressType" />
  <xsd:element name="Education" type="t:EducationType" />
  <xsd:element name="Employment" type="t:EmploymentType" />
  <xsd:element name="Location" type="t:LocationType" />
  <xsd:element name="Name" type="t:NameType" />
  <xsd:element name="Resume" type="t:ResumeType" />
  <xsd:element name="Telephone" type="t:TelephoneType" />
  <xsd:complexType name="AddressType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Addr.Type" type="xsd:string" />
          <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0" />
          <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded" />
          <xsd:element name="Addr.Location">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="Addr.PostalCode" type="xsd:string" />
          <xsd:element name="Addr.Telephone" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Telephone" maxOccurs="unbounded" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="EducationType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Edu.Level" type="xsd:string" />
          <xsd:element name="Edu.StartDate" type="xsd:date" />
          <xsd:element name="Edu.EndDate" type="xsd:date" />
          <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0" />
          <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0" />
          <xsd:element name="Edu.School" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Location" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="EmploymentType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0" />
          <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0" />
          <xsd:element name="Emp.OrgName" type="xsd:string" />
          <xsd:element name="Emp.JobTitle" type="xsd:string" />
          <xsd:element name="Emp.Responsibility" type="xsd:string" />
          <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0" />
          <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0" />
          <xsd:element name="Emp.Location" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="LocationType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Loc.CountryRegion" type="xsd:string" />
          <xsd:element name="Loc.State" type="xsd:string" minOccurs="0" />
          <xsd:element name="Loc.City" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="NameType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0" />
          <xsd:element name="Name.First" type="xsd:string" />
          <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0" />
          <xsd:element name="Name.Last" type="xsd:string" />
          <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="ResumeType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element ref="t:Name" />
          <xsd:element name="Skills" type="xsd:string" minOccurs="0" />
          <xsd:element ref="t:Employment" maxOccurs="unbounded" />
          <xsd:element ref="t:Education" maxOccurs="unbounded" />
          <xsd:element ref="t:Address" maxOccurs="unbounded" />
          <xsd:element ref="t:Telephone" minOccurs="0" />
          <xsd:element name="EMail" type="xsd:string" minOccurs="0" />
          <xsd:element name="WebSite" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="TelephoneType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Tel.Type" type="xsd:anyType" minOccurs="0" />
          <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0" />
          <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0" />
          <xsd:element name="Tel.Number" type="xsd:string" />
          <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
</xsd:schema>

automatically generated

xmlschemacollection HumanResources.HRResumeSchemaCollection
Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. 
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xsd:element name="Resume" type="ResumeType" />
  <xsd:element name="Address" type="AddressType" />
  <xsd:element name="Education" type="EducationType" />
  <xsd:element name="Employment" type="EmploymentType" />
  <xsd:element name="Location" type="LocationType" />
  <xsd:element name="Name" type="NameType" />
  <xsd:element name="Telephone" type="TelephoneType" />
  <xsd:complexType name="ResumeType">
    <xsd:sequence>
      <xsd:element ref="Name" />
      <xsd:element name="Skills" type="xsd:string" minOccurs="0" />
      <xsd:element ref="Employment" maxOccurs="unbounded" />
      <xsd:element ref="Education" maxOccurs="unbounded" />
      <xsd:element ref="Address" maxOccurs="unbounded" />
      <xsd:element ref="Telephone" minOccurs="0" />
      <xsd:element name="EMail" type="xsd:string" minOccurs="0" />
      <xsd:element name="WebSite" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="AddressType">
    <xsd:sequence>
      <xsd:element name="Addr.Type" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>Home|Work|Permanent</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0" />
      <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded" />
      <xsd:element name="Addr.Location">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element name="Addr.PostalCode" type="xsd:string" />
      <xsd:element name="Addr.Telephone" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Telephone" maxOccurs="unbounded" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="EducationType">
    <xsd:sequence>
      <xsd:element name="Edu.Level" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>High School|Associate|Bachelor|Master|Doctorate</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Edu.StartDate" type="xsd:date" />
      <xsd:element name="Edu.EndDate" type="xsd:date" />
      <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>In case the institution does not follow a GPA system</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0" />
      <xsd:element name="Edu.School" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Location" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="EmploymentType">
    <xsd:sequence>
      <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0" />
      <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0" />
      <xsd:element name="Emp.OrgName" type="xsd:string" />
      <xsd:element name="Emp.JobTitle" type="xsd:string" />
      <xsd:element name="Emp.Responsibility" type="xsd:string" />
      <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0" />
      <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0" />
      <xsd:element name="Emp.Location" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="LocationType">
    <xsd:sequence>
      <xsd:element name="Loc.CountryRegion" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>ISO 3166 Country Code</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Loc.State" type="xsd:string" minOccurs="0" />
      <xsd:element name="Loc.City" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="NameType">
    <xsd:sequence>
      <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0" />
      <xsd:element name="Name.First" type="xsd:string" />
      <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0" />
      <xsd:element name="Name.Last" type="xsd:string" />
      <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="TelephoneType">
    <xsd:sequence>
      <xsd:element name="Tel.Type" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Voice|Fax|Pager</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0" />
      <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0" />
      <xsd:element name="Tel.Number" type="xsd:string" />
      <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
</xsd:schema>
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.HRResumeSchemaCollection_(xml_schema_collection)&oldid=1159"