DataSet1.xsd 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  3. <xs:annotation>
  4. <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5. <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6. <Connections />
  7. <Tables />
  8. <Sources />
  9. </DataSource>
  10. </xs:appinfo>
  11. </xs:annotation>
  12. <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
  13. <xs:complexType>
  14. <xs:choice minOccurs="0" maxOccurs="unbounded">
  15. <xs:element name="tb_vehi" msprop:Generator_TableClassName="tb_vehiDataTable" msprop:Generator_TableVarName="tabletb_vehi" msprop:Generator_RowChangedName="tb_vehiRowChanged" msprop:Generator_TablePropName="tb_vehi" msprop:Generator_RowDeletingName="tb_vehiRowDeleting" msprop:Generator_RowChangingName="tb_vehiRowChanging" msprop:Generator_RowEvHandlerName="tb_vehiRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_vehiRowDeleted" msprop:Generator_RowClassName="tb_vehiRow" msprop:Generator_UserTableName="tb_vehi" msprop:Generator_RowEvArgName="tb_vehiRowChangeEvent">
  16. <xs:complexType>
  17. <xs:sequence>
  18. <xs:element name="key_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="key_vehi" msprop:Generator_ColumnVarNameInTable="columnkey_vehi" msprop:Generator_ColumnPropNameInTable="key_vehiColumn" msprop:Generator_UserColumnName="key_vehi" type="xs:string" />
  19. <xs:element name="num_vehi" msprop:Generator_ColumnVarNameInTable="columnnum_vehi" msprop:Generator_ColumnPropNameInRow="num_vehi" msprop:Generator_ColumnPropNameInTable="num_vehiColumn" msprop:Generator_UserColumnName="num_vehi" type="xs:unsignedShort" minOccurs="0" />
  20. <xs:element name="cmpnum_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cmpnum_vehi" msprop:Generator_ColumnVarNameInTable="columncmpnum_vehi" msprop:Generator_ColumnPropNameInTable="cmpnum_vehiColumn" msprop:Generator_UserColumnName="cmpnum_vehi" type="xs:string" minOccurs="0" />
  21. <xs:element name="immat_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="immat_vehi" msprop:Generator_ColumnVarNameInTable="columnimmat_vehi" msprop:Generator_ColumnPropNameInTable="immat_vehiColumn" msprop:Generator_UserColumnName="immat_vehi" type="xs:string" minOccurs="0" />
  22. <xs:element name="ope_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ope_vehi" msprop:Generator_ColumnVarNameInTable="columnope_vehi" msprop:Generator_ColumnPropNameInTable="ope_vehiColumn" msprop:Generator_UserColumnName="ope_vehi" type="xs:string" minOccurs="0" />
  23. <xs:element name="type_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="type_vehi" msprop:Generator_ColumnVarNameInTable="columntype_vehi" msprop:Generator_ColumnPropNameInTable="type_vehiColumn" msprop:Generator_UserColumnName="type_vehi" type="xs:string" minOccurs="0" />
  24. <xs:element name="cond_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cond_vehi" msprop:Generator_ColumnVarNameInTable="columncond_vehi" msprop:Generator_ColumnPropNameInTable="cond_vehiColumn" msprop:Generator_UserColumnName="cond_vehi" type="xs:string" default="" minOccurs="0" />
  25. <xs:element name="famille_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="famille_vehi" msprop:Generator_ColumnVarNameInTable="columnfamille_vehi" msprop:Generator_ColumnPropNameInTable="famille_vehiColumn" msprop:Generator_UserColumnName="famille_vehi" type="xs:string" minOccurs="0" />
  26. <xs:element name="carbu_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="carbu_vehi" msprop:Generator_ColumnVarNameInTable="columncarbu_vehi" msprop:Generator_ColumnPropNameInTable="carbu_vehiColumn" msprop:Generator_UserColumnName="carbu_vehi" type="xs:string" minOccurs="0" />
  27. <xs:element name="kmdep_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kmdep_vehi" msprop:Generator_ColumnVarNameInTable="columnkmdep_vehi" msprop:Generator_ColumnPropNameInTable="kmdep_vehiColumn" msprop:Generator_UserColumnName="kmdep_vehi" type="xs:string" minOccurs="0" />
  28. <xs:element name="kmarr_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kmarr_vehi" msprop:Generator_ColumnVarNameInTable="columnkmarr_vehi" msprop:Generator_ColumnPropNameInTable="kmarr_vehiColumn" msprop:Generator_UserColumnName="kmarr_vehi" type="xs:string" minOccurs="0" />
  29. <xs:element name="categ_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="categ_vehi" msprop:Generator_ColumnVarNameInTable="columncateg_vehi" msprop:Generator_ColumnPropNameInTable="categ_vehiColumn" msprop:Generator_UserColumnName="categ_vehi" minOccurs="0">
  30. <xs:simpleType>
  31. <xs:restriction base="xs:string">
  32. <xs:maxLength value="1" />
  33. </xs:restriction>
  34. </xs:simpleType>
  35. </xs:element>
  36. <xs:element name="sort1_vehi" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="sort1_vehi" msprop:Generator_ColumnVarNameInTable="columnsort1_vehi" msprop:Generator_ColumnPropNameInTable="sort1_vehiColumn" msprop:Generator_UserColumnName="sort1_vehi" type="xs:string" minOccurs="0" />
  37. </xs:sequence>
  38. </xs:complexType>
  39. </xs:element>
  40. <xs:element name="tb_epreuve" msprop:Generator_TableClassName="tb_epreuveDataTable" msprop:Generator_TableVarName="tabletb_epreuve" msprop:Generator_TablePropName="tb_epreuve" msprop:Generator_RowDeletingName="tb_epreuveRowDeleting" msprop:Generator_RowChangingName="tb_epreuveRowChanging" msprop:Generator_RowEvHandlerName="tb_epreuveRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_epreuveRowDeleted" msprop:Generator_UserTableName="tb_epreuve" msprop:Generator_RowChangedName="tb_epreuveRowChanged" msprop:Generator_RowEvArgName="tb_epreuveRowChangeEvent" msprop:Generator_RowClassName="tb_epreuveRow">
  41. <xs:complexType>
  42. <xs:sequence>
  43. <xs:element name="key_epr" msprop:Generator_ColumnVarNameInTable="columnkey_epr" msprop:Generator_ColumnPropNameInRow="key_epr" msprop:Generator_ColumnPropNameInTable="key_eprColumn" msprop:Generator_UserColumnName="key_epr" type="xs:string" />
  44. <xs:element name="nom_epr" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="nom_epr" msprop:Generator_ColumnVarNameInTable="columnnom_epr" msprop:Generator_ColumnPropNameInTable="nom_eprColumn" msprop:Generator_UserColumnName="nom_epr" type="xs:string" default="" minOccurs="0" />
  45. <xs:element name="deb_epr" msprop:Generator_ColumnVarNameInTable="columndeb_epr" msprop:Generator_ColumnPropNameInRow="deb_epr" msprop:Generator_ColumnPropNameInTable="deb_eprColumn" msprop:Generator_UserColumnName="deb_epr" type="xs:dateTime" minOccurs="0" />
  46. <xs:element name="fin_epr" msprop:Generator_ColumnVarNameInTable="columnfin_epr" msprop:Generator_ColumnPropNameInRow="fin_epr" msprop:Generator_ColumnPropNameInTable="fin_eprColumn" msprop:Generator_UserColumnName="fin_epr" type="xs:dateTime" minOccurs="0" />
  47. <xs:element name="abrev_epr" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="abrev_epr" msprop:Generator_ColumnVarNameInTable="columnabrev_epr" msprop:Generator_ColumnPropNameInTable="abrev_eprColumn" msprop:Generator_UserColumnName="abrev_epr" type="xs:string" default="" minOccurs="0" />
  48. </xs:sequence>
  49. </xs:complexType>
  50. </xs:element>
  51. <xs:element name="tb_etape" msprop:Generator_TableClassName="tb_etapeDataTable" msprop:Generator_TableVarName="tabletb_etape" msprop:Generator_TablePropName="tb_etape" msprop:Generator_RowDeletingName="tb_etapeRowDeleting" msprop:Generator_RowChangingName="tb_etapeRowChanging" msprop:Generator_RowEvHandlerName="tb_etapeRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_etapeRowDeleted" msprop:Generator_UserTableName="tb_etape" msprop:Generator_RowChangedName="tb_etapeRowChanged" msprop:Generator_RowEvArgName="tb_etapeRowChangeEvent" msprop:Generator_RowClassName="tb_etapeRow">
  52. <xs:complexType>
  53. <xs:sequence>
  54. <xs:element name="epr_etp" msprop:Generator_ColumnVarNameInTable="columnepr_etp" msprop:Generator_ColumnPropNameInRow="epr_etp" msprop:Generator_ColumnPropNameInTable="epr_etpColumn" msprop:Generator_UserColumnName="epr_etp" type="xs:string" />
  55. <xs:element name="num_etp" msprop:Generator_ColumnVarNameInTable="columnnum_etp" msprop:Generator_ColumnPropNameInRow="num_etp" msprop:Generator_ColumnPropNameInTable="num_etpColumn" msprop:Generator_UserColumnName="num_etp" type="xs:unsignedShort" />
  56. <xs:element name="date_etp" msprop:Generator_ColumnVarNameInTable="columndate_etp" msprop:Generator_ColumnPropNameInRow="date_etp" msprop:Generator_ColumnPropNameInTable="date_etpColumn" msprop:Generator_UserColumnName="date_etp" type="xs:dateTime" minOccurs="0" />
  57. <xs:element name="nom_etp" msprop:Generator_ColumnVarNameInTable="columnnom_etp" msprop:Generator_ColumnPropNameInRow="nom_etp" msprop:Generator_ColumnPropNameInTable="nom_etpColumn" msprop:Generator_UserColumnName="nom_etp" type="xs:string" minOccurs="0" />
  58. </xs:sequence>
  59. </xs:complexType>
  60. </xs:element>
  61. <xs:element name="tb_pays" msprop:Generator_TableClassName="tb_paysDataTable" msprop:Generator_TableVarName="tabletb_pays" msprop:Generator_TablePropName="tb_pays" msprop:Generator_RowDeletingName="tb_paysRowDeleting" msprop:Generator_RowChangingName="tb_paysRowChanging" msprop:Generator_RowEvHandlerName="tb_paysRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_paysRowDeleted" msprop:Generator_UserTableName="tb_pays" msprop:Generator_RowChangedName="tb_paysRowChanged" msprop:Generator_RowEvArgName="tb_paysRowChangeEvent" msprop:Generator_RowClassName="tb_paysRow">
  62. <xs:complexType>
  63. <xs:sequence>
  64. <xs:element name="key_pays" msprop:Generator_ColumnVarNameInTable="columnkey_pays" msprop:Generator_ColumnPropNameInRow="key_pays" msprop:Generator_ColumnPropNameInTable="key_paysColumn" msprop:Generator_UserColumnName="key_pays" type="xs:string" />
  65. <xs:element name="nom_pays" msprop:Generator_ColumnVarNameInTable="columnnom_pays" msprop:Generator_ColumnPropNameInRow="nom_pays" msprop:Generator_ColumnPropNameInTable="nom_paysColumn" msprop:Generator_UserColumnName="nom_pays" type="xs:string" minOccurs="0" />
  66. <xs:element name="code_pays" msprop:Generator_ColumnVarNameInTable="columncode_pays" msprop:Generator_ColumnPropNameInRow="code_pays" msprop:Generator_ColumnPropNameInTable="code_paysColumn" msprop:Generator_UserColumnName="code_pays" type="xs:string" minOccurs="0" />
  67. <xs:element name="txchge_pays" msprop:Generator_ColumnVarNameInTable="columntxchge_pays" msprop:Generator_ColumnPropNameInRow="txchge_pays" msprop:Generator_ColumnPropNameInTable="txchge_paysColumn" msprop:Generator_UserColumnName="txchge_pays" type="xs:float" minOccurs="0" />
  68. <xs:element name="tva_pays" msprop:Generator_ColumnVarNameInTable="columntva_pays" msprop:Generator_ColumnPropNameInRow="tva_pays" msprop:Generator_ColumnPropNameInTable="tva_paysColumn" msprop:Generator_UserColumnName="tva_pays" type="xs:float" minOccurs="0" />
  69. <xs:element name="img_pays" msprop:Generator_ColumnVarNameInTable="columnimg_pays" msprop:Generator_ColumnPropNameInRow="img_pays" msprop:Generator_ColumnPropNameInTable="img_paysColumn" msprop:Generator_UserColumnName="img_pays" type="xs:string" minOccurs="0" />
  70. <xs:element name="order_pays" msprop:Generator_ColumnVarNameInTable="columnorder_pays" msprop:Generator_ColumnPropNameInRow="order_pays" msprop:Generator_ColumnPropNameInTable="order_paysColumn" msprop:Generator_UserColumnName="order_pays" type="xs:unsignedShort" minOccurs="0" />
  71. </xs:sequence>
  72. </xs:complexType>
  73. </xs:element>
  74. <xs:element name="tb_station" msprop:Generator_TableClassName="tb_stationDataTable" msprop:Generator_TableVarName="tabletb_station" msprop:Generator_TablePropName="tb_station" msprop:Generator_RowDeletingName="tb_stationRowDeleting" msprop:Generator_RowChangingName="tb_stationRowChanging" msprop:Generator_RowEvHandlerName="tb_stationRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_stationRowDeleted" msprop:Generator_UserTableName="tb_station" msprop:Generator_RowChangedName="tb_stationRowChanged" msprop:Generator_RowEvArgName="tb_stationRowChangeEvent" msprop:Generator_RowClassName="tb_stationRow">
  75. <xs:complexType>
  76. <xs:sequence>
  77. <xs:element name="key_sta" msprop:Generator_ColumnVarNameInTable="columnkey_sta" msprop:Generator_ColumnPropNameInRow="key_sta" msprop:Generator_ColumnPropNameInTable="key_staColumn" msprop:Generator_UserColumnName="key_sta" type="xs:string" />
  78. <xs:element name="epr_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="epr_sta" msprop:Generator_ColumnVarNameInTable="columnepr_sta" msprop:Generator_ColumnPropNameInTable="epr_staColumn" msprop:Generator_UserColumnName="epr_sta" type="xs:string" default="" minOccurs="0" />
  79. <xs:element name="etp_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="etp_sta" msprop:Generator_ColumnVarNameInTable="columnetp_sta" msprop:Generator_ColumnPropNameInTable="etp_staColumn" msprop:Generator_UserColumnName="etp_sta" type="xs:string" default="" minOccurs="0" />
  80. <xs:element name="date_sta" msprop:Generator_ColumnVarNameInTable="columndate_sta" msprop:Generator_ColumnPropNameInRow="date_sta" msprop:Generator_ColumnPropNameInTable="date_staColumn" msprop:Generator_UserColumnName="date_sta" type="xs:dateTime" minOccurs="0" />
  81. <xs:element name="num_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="num_sta" msprop:Generator_ColumnVarNameInTable="columnnum_sta" msprop:Generator_ColumnPropNameInTable="num_staColumn" msprop:Generator_UserColumnName="num_sta" type="xs:string" default="" minOccurs="0" />
  82. <xs:element name="nom_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="nom_sta" msprop:Generator_ColumnVarNameInTable="columnnom_sta" msprop:Generator_ColumnPropNameInTable="nom_staColumn" msprop:Generator_UserColumnName="nom_sta" type="xs:string" default="" minOccurs="0" />
  83. <xs:element name="adr1_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="adr1_sta" msprop:Generator_ColumnVarNameInTable="columnadr1_sta" msprop:Generator_ColumnPropNameInTable="adr1_staColumn" msprop:Generator_UserColumnName="adr1_sta" type="xs:string" default="" minOccurs="0" />
  84. <xs:element name="adr2_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="adr2_sta" msprop:Generator_ColumnVarNameInTable="columnadr2_sta" msprop:Generator_ColumnPropNameInTable="adr2_staColumn" msprop:Generator_UserColumnName="adr2_sta" type="xs:string" default="" minOccurs="0" />
  85. <xs:element name="cp_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cp_sta" msprop:Generator_ColumnVarNameInTable="columncp_sta" msprop:Generator_ColumnPropNameInTable="cp_staColumn" msprop:Generator_UserColumnName="cp_sta" type="xs:string" default="" minOccurs="0" />
  86. <xs:element name="ville_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ville_sta" msprop:Generator_ColumnVarNameInTable="columnville_sta" msprop:Generator_ColumnPropNameInTable="ville_staColumn" msprop:Generator_UserColumnName="ville_sta" type="xs:string" default="" minOccurs="0" />
  87. <xs:element name="pays_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pays_sta" msprop:Generator_ColumnVarNameInTable="columnpays_sta" msprop:Generator_ColumnPropNameInTable="pays_staColumn" msprop:Generator_UserColumnName="pays_sta" type="xs:string" default="" minOccurs="0" />
  88. <xs:element name="contact_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="contact_sta" msprop:Generator_ColumnVarNameInTable="columncontact_sta" msprop:Generator_ColumnPropNameInTable="contact_staColumn" msprop:Generator_UserColumnName="contact_sta" type="xs:string" default="" minOccurs="0" />
  89. <xs:element name="tel_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tel_sta" msprop:Generator_ColumnVarNameInTable="columntel_sta" msprop:Generator_ColumnPropNameInTable="tel_staColumn" msprop:Generator_UserColumnName="tel_sta" type="xs:string" default="" minOccurs="0" />
  90. <xs:element name="tva_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tva_sta" msprop:Generator_ColumnVarNameInTable="columntva_sta" msprop:Generator_ColumnPropNameInTable="tva_staColumn" msprop:Generator_UserColumnName="tva_sta" type="xs:string" default="" minOccurs="0" />
  91. <xs:element name="divers_sta" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="divers_sta" msprop:Generator_ColumnVarNameInTable="columndivers_sta" msprop:Generator_ColumnPropNameInTable="divers_staColumn" msprop:Generator_UserColumnName="divers_sta" type="xs:string" default="" minOccurs="0" />
  92. </xs:sequence>
  93. </xs:complexType>
  94. </xs:element>
  95. <xs:element name="tb_famille" msprop:Generator_TableClassName="tb_familleDataTable" msprop:Generator_TableVarName="tabletb_famille" msprop:Generator_TablePropName="tb_famille" msprop:Generator_RowDeletingName="tb_familleRowDeleting" msprop:Generator_RowChangingName="tb_familleRowChanging" msprop:Generator_RowEvHandlerName="tb_familleRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_familleRowDeleted" msprop:Generator_UserTableName="tb_famille" msprop:Generator_RowChangedName="tb_familleRowChanged" msprop:Generator_RowEvArgName="tb_familleRowChangeEvent" msprop:Generator_RowClassName="tb_familleRow">
  96. <xs:complexType>
  97. <xs:sequence>
  98. <xs:element name="key_fam" msprop:Generator_ColumnVarNameInTable="columnkey_fam" msprop:Generator_ColumnPropNameInRow="key_fam" msprop:Generator_ColumnPropNameInTable="key_famColumn" msprop:Generator_UserColumnName="key_fam" type="xs:string" />
  99. </xs:sequence>
  100. </xs:complexType>
  101. </xs:element>
  102. <xs:element name="tb_prod" msprop:Generator_TableClassName="tb_prodDataTable" msprop:Generator_TableVarName="tabletb_prod" msprop:Generator_TablePropName="tb_prod" msprop:Generator_RowDeletingName="tb_prodRowDeleting" msprop:Generator_RowChangingName="tb_prodRowChanging" msprop:Generator_RowEvHandlerName="tb_prodRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_prodRowDeleted" msprop:Generator_UserTableName="tb_prod" msprop:Generator_RowChangedName="tb_prodRowChanged" msprop:Generator_RowEvArgName="tb_prodRowChangeEvent" msprop:Generator_RowClassName="tb_prodRow">
  103. <xs:complexType>
  104. <xs:sequence>
  105. <xs:element name="key_prod" msprop:Generator_ColumnVarNameInTable="columnkey_prod" msprop:Generator_ColumnPropNameInRow="key_prod" msprop:Generator_ColumnPropNameInTable="key_prodColumn" msprop:Generator_UserColumnName="key_prod" type="xs:string" />
  106. <xs:element name="lib_prod" msprop:Generator_ColumnVarNameInTable="columnlib_prod" msprop:Generator_ColumnPropNameInRow="lib_prod" msprop:Generator_ColumnPropNameInTable="lib_prodColumn" msprop:Generator_UserColumnName="lib_prod" type="xs:string" minOccurs="0" />
  107. <xs:element name="type_prod" msprop:Generator_ColumnVarNameInTable="columntype_prod" msprop:Generator_ColumnPropNameInRow="type_prod" msprop:Generator_ColumnPropNameInTable="type_prodColumn" msprop:Generator_UserColumnName="type_prod" type="xs:string" minOccurs="0" />
  108. </xs:sequence>
  109. </xs:complexType>
  110. </xs:element>
  111. <xs:element name="tb_presta" msprop:Generator_TableClassName="tb_prestaDataTable" msprop:Generator_TableVarName="tabletb_presta" msprop:Generator_TablePropName="tb_presta" msprop:Generator_RowDeletingName="tb_prestaRowDeleting" msprop:Generator_RowChangingName="tb_prestaRowChanging" msprop:Generator_RowEvHandlerName="tb_prestaRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_prestaRowDeleted" msprop:Generator_UserTableName="tb_presta" msprop:Generator_RowChangedName="tb_prestaRowChanged" msprop:Generator_RowEvArgName="tb_prestaRowChangeEvent" msprop:Generator_RowClassName="tb_prestaRow">
  112. <xs:complexType>
  113. <xs:sequence>
  114. <xs:element name="sta_pr" msprop:Generator_ColumnVarNameInTable="columnsta_pr" msprop:Generator_ColumnPropNameInRow="sta_pr" msprop:Generator_ColumnPropNameInTable="sta_prColumn" msprop:Generator_UserColumnName="sta_pr" type="xs:string" />
  115. <xs:element name="prod_pr" msprop:Generator_ColumnVarNameInTable="columnprod_pr" msprop:Generator_ColumnPropNameInRow="prod_pr" msprop:Generator_ColumnPropNameInTable="prod_prColumn" msprop:Generator_UserColumnName="prod_pr" type="xs:string" />
  116. <xs:element name="kind_pr" msprop:Generator_ColumnVarNameInTable="columnkind_pr" msprop:Generator_ColumnPropNameInRow="kind_pr" msprop:Generator_ColumnPropNameInTable="kind_prColumn" msprop:Generator_UserColumnName="kind_pr" type="xs:string" minOccurs="0" />
  117. <xs:element name="unite_pr" msprop:Generator_ColumnVarNameInTable="columnunite_pr" msprop:Generator_ColumnPropNameInRow="unite_pr" msprop:Generator_ColumnPropNameInTable="unite_prColumn" msprop:Generator_UserColumnName="unite_pr" type="xs:string" minOccurs="0" />
  118. <xs:element name="pu_pr" msprop:Generator_ColumnVarNameInTable="columnpu_pr" msprop:Generator_ColumnPropNameInRow="pu_pr" msprop:Generator_ColumnPropNameInTable="pu_prColumn" msprop:Generator_UserColumnName="pu_pr" type="xs:decimal" minOccurs="0" />
  119. <xs:element name="tva_pr" msprop:Generator_ColumnVarNameInTable="columntva_pr" msprop:Generator_ColumnPropNameInRow="tva_pr" msprop:Generator_ColumnPropNameInTable="tva_prColumn" msprop:Generator_UserColumnName="tva_pr" type="xs:decimal" minOccurs="0" />
  120. <xs:element name="ttc_pr" msprop:Generator_ColumnVarNameInTable="columnttc_pr" msprop:Generator_ColumnPropNameInRow="ttc_pr" msprop:Generator_ColumnPropNameInTable="ttc_prColumn" msprop:Generator_UserColumnName="ttc_pr" type="xs:decimal" minOccurs="0" />
  121. </xs:sequence>
  122. </xs:complexType>
  123. </xs:element>
  124. <xs:element name="tb_vente" msprop:Generator_TableClassName="tb_venteDataTable" msprop:Generator_TableVarName="tabletb_vente" msprop:Generator_TablePropName="tb_vente" msprop:Generator_RowDeletingName="tb_venteRowDeleting" msprop:Generator_RowChangingName="tb_venteRowChanging" msprop:Generator_RowEvHandlerName="tb_venteRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_venteRowDeleted" msprop:Generator_UserTableName="tb_vente" msprop:Generator_RowChangedName="tb_venteRowChanged" msprop:Generator_RowEvArgName="tb_venteRowChangeEvent" msprop:Generator_RowClassName="tb_venteRow">
  125. <xs:complexType>
  126. <xs:sequence>
  127. <xs:element name="epreuve_vt" msprop:Generator_ColumnVarNameInTable="columnepreuve_vt" msprop:Generator_ColumnPropNameInRow="epreuve_vt" msprop:Generator_ColumnPropNameInTable="epreuve_vtColumn" msprop:Generator_UserColumnName="epreuve_vt" type="xs:string" />
  128. <xs:element name="station_vt" msprop:Generator_ColumnVarNameInTable="columnstation_vt" msprop:Generator_ColumnPropNameInRow="station_vt" msprop:Generator_ColumnPropNameInTable="station_vtColumn" msprop:Generator_UserColumnName="station_vt" type="xs:string" />
  129. <xs:element name="vehi_vt" msprop:Generator_ColumnVarNameInTable="columnvehi_vt" msprop:Generator_ColumnPropNameInRow="vehi_vt" msprop:Generator_ColumnPropNameInTable="vehi_vtColumn" msprop:Generator_UserColumnName="vehi_vt" type="xs:string" />
  130. <xs:element name="prod_vt" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="prod_vt" msprop:Generator_ColumnVarNameInTable="columnprod_vt" msprop:Generator_ColumnPropNameInTable="prod_vtColumn" msprop:Generator_UserColumnName="prod_vt" type="xs:string" />
  131. <xs:element name="date_vt" msdata:DateTimeMode="Utc" msprop:Generator_ColumnVarNameInTable="columndate_vt" msprop:Generator_ColumnPropNameInRow="date_vt" msprop:Generator_ColumnPropNameInTable="date_vtColumn" msprop:Generator_UserColumnName="date_vt" type="xs:dateTime" />
  132. <xs:element name="qtt_vt" msprop:Generator_ColumnVarNameInTable="columnqtt_vt" msprop:Generator_ColumnPropNameInRow="qtt_vt" msprop:Generator_ColumnPropNameInTable="qtt_vtColumn" msprop:Generator_UserColumnName="qtt_vt" type="xs:decimal" minOccurs="0" />
  133. <xs:element name="pu_vt" msprop:Generator_ColumnVarNameInTable="columnpu_vt" msprop:Generator_ColumnPropNameInRow="pu_vt" msprop:Generator_ColumnPropNameInTable="pu_vtColumn" msprop:Generator_UserColumnName="pu_vt" type="xs:decimal" minOccurs="0" />
  134. <xs:element name="ht_vt" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="ht_vt" msprop:Generator_ColumnVarNameInTable="columnht_vt" msprop:Generator_ColumnPropNameInTable="ht_vtColumn" msprop:Generator_UserColumnName="ht_vt" type="xs:decimal" default="0" minOccurs="0" />
  135. <xs:element name="tva_vt" msprop:Generator_ColumnVarNameInTable="columntva_vt" msprop:Generator_ColumnPropNameInRow="tva_vt" msprop:Generator_ColumnPropNameInTable="tva_vtColumn" msprop:Generator_UserColumnName="tva_vt" type="xs:decimal" minOccurs="0" />
  136. <xs:element name="ttc_vt" msprop:Generator_ColumnVarNameInTable="columnttc_vt" msprop:Generator_ColumnPropNameInRow="ttc_vt" msprop:Generator_ColumnPropNameInTable="ttc_vtColumn" msprop:Generator_UserColumnName="ttc_vt" type="xs:decimal" minOccurs="0" />
  137. </xs:sequence>
  138. </xs:complexType>
  139. </xs:element>
  140. </xs:choice>
  141. </xs:complexType>
  142. <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  143. <xs:selector xpath=".//mstns:tb_vehi" />
  144. <xs:field xpath="mstns:key_vehi" />
  145. </xs:unique>
  146. <xs:unique name="tb_epreuve_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  147. <xs:selector xpath=".//mstns:tb_epreuve" />
  148. <xs:field xpath="mstns:key_epr" />
  149. </xs:unique>
  150. <xs:unique name="tb_etape_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  151. <xs:selector xpath=".//mstns:tb_etape" />
  152. <xs:field xpath="mstns:epr_etp" />
  153. <xs:field xpath="mstns:num_etp" />
  154. </xs:unique>
  155. <xs:unique name="tb_pays_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  156. <xs:selector xpath=".//mstns:tb_pays" />
  157. <xs:field xpath="mstns:key_pays" />
  158. </xs:unique>
  159. <xs:unique name="tb_station_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  160. <xs:selector xpath=".//mstns:tb_station" />
  161. <xs:field xpath="mstns:key_sta" />
  162. </xs:unique>
  163. <xs:unique name="tb_famille_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  164. <xs:selector xpath=".//mstns:tb_famille" />
  165. <xs:field xpath="mstns:key_fam" />
  166. </xs:unique>
  167. <xs:unique name="tb_prod_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  168. <xs:selector xpath=".//mstns:tb_prod" />
  169. <xs:field xpath="mstns:key_prod" />
  170. </xs:unique>
  171. <xs:unique name="tb_presta_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  172. <xs:selector xpath=".//mstns:tb_presta" />
  173. <xs:field xpath="mstns:sta_pr" />
  174. <xs:field xpath="mstns:prod_pr" />
  175. </xs:unique>
  176. <xs:unique name="tb_vente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  177. <xs:selector xpath=".//mstns:tb_vente" />
  178. <xs:field xpath="mstns:epreuve_vt" />
  179. <xs:field xpath="mstns:station_vt" />
  180. <xs:field xpath="mstns:vehi_vt" />
  181. <xs:field xpath="mstns:prod_vt" />
  182. <xs:field xpath="mstns:date_vt" />
  183. </xs:unique>
  184. </xs:element>
  185. </xs:schema>