emprds.xsd

humar resourse management

<?xml version="1.0" standalone="yes"?>
<xs:schema id="emPRDS" targetNamespace="http://www.tempuri.org/emPRDS.xsd" xmlns:mstns="http://www.tempuri.org/emPRDS.xsd" xmlns="http://www.tempuri.org/emPRDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="emPRDS" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="ePayroll">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="_x0024_Amount" type="xs:decimal" minOccurs="0" />
              <xs:element name="emp_fname" type="xs:string" minOccurs="0" />
              <xs:element name="emp_idno" type="xs:string" minOccurs="0" />
              <xs:element name="netPay" type="xs:int" minOccurs="0" />
              <xs:element name="payDate" type="xs:string" minOccurs="0" />
              <xs:element name="payID" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="wHours" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblEmployee">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="emp_addr" type="xs:string" minOccurs="0" />
              <xs:element name="emp_age" type="xs:int" minOccurs="0" />
              <xs:element name="emp_dob" type="xs:dateTime" minOccurs="0" />
              <xs:element name="emp_fname" type="xs:string" minOccurs="0" />
              <xs:element name="emp_idno" type="xs:string" />
              <xs:element name="emp_lname" type="xs:string" minOccurs="0" />
              <xs:element name="emp_mname" type="xs:string" minOccurs="0" />
              <xs:element name="emp_pass" type="xs:string" minOccurs="0" />
              <xs:element name="emp_pos" type="xs:string" minOccurs="0" />
              <xs:element name="emp_stat" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ePayroll" />
      <xs:field xpath="mstns:payID" />
    </xs:unique>
    <xs:unique name="tblEmployee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblEmployee" />
      <xs:field xpath="mstns:emp_idno" />
    </xs:unique>
  </xs:element>
</xs:schema>