Newer
Older
sqlmarker / STINK_student_records / Test_classes / Student / STINK_student_records_Fixture_Student.xml.in
<dataset>
  <table name="person">
    <column>person_id</column>
    <column>surname</column>
    <column>other_names</column>
    <column>contact_phone</column>
    <column>contact_address</column>
    <column>email</column>
    <column>username</column>
    <row>
      <value>1234567</value>
      <value>Dyson</value>
      <value>Sang Russell</value>
      <value>02139414116</value>
      <value>74 Patmos Avenue</value>
      <value>sang.dyson@stink.ac.nz</value>
      <value>dyssa123</value>
    </row>
    <row>
      <value>1234569</value>
      <value>Kwak</value>
      <value>Patricia Helen</value>
      <value>02137254888</value>
      <value>28 Cherry Drive</value>
      <value>pat.kwak@stink.ac.nz</value>
      <value>kwapa999</value>
    </row>
    <row>
      <value>1234568</value>
      <value>Soto</value>
      <value>Teresa Stephanie</value>
      <value>02737076169</value>
      <value>21 Elwyn Crescent</value>
      <value>sotte123@stink.ac.nz</value>
      <value>sotte123</value>
    </row>
    <row>
      <value>1234570</value>
      <value>Reed</value>
      <value>John Clifford</value>
      <value>02136507402</value>
      <value>45 Pine Hill Road</value>
      <value>reejo282@stink.ac.nz</value>
      <value>reejo282</value>
    </row>
    <row>
      <value>1234571</value>
      <value>Barajas</value>
      <value>Charles William</value>
      <value>02232104933</value>
      <value>34 Scobie Road</value>
      <value>barch087@stink.ac.nz</value>
      <value>barch087</value>
    </row>
  </table>
  <table name="staff">
    <column>staff_id</column>
    <column>rank</column>
    <column>salary</column>
    <row>
      <value>1234567</value>
      <value>L</value>
      <value>55000.00</value>
    </row>
  </table>
  <table name="student">
    <column>student_id</column>
    <column>home_phone</column>
    <column>home_address</column>
    <column>international</column>
    <column>supervisor_id</column>
    <row>
      <value>1234568</value>
      <value>+16461234567</value>
      <value>Los Angeles</value>
      <value>##TRUE_VALUE##</value>
      <value />
    </row>
    <row>
      <value>1234570</value>
      <value>02136507402</value>
      <value>45 Pine Hill Road</value>
      <value>##FALSE_VALUE##</value>
      <value>1234567</value>
    </row>
  </table>
</dataset>