| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212 |
- <?xml version="1.0" encoding="utf-8"?>
- <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">
- <xs:annotation>
- <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
- <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
- <Connections />
- <Tables />
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="tb_vehi" msprop:Generator_RowEvHandlerName="tb_vehiRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_vehiRowDeleted" msprop:Generator_RowDeletingName="tb_vehiRowDeleting" msprop:Generator_RowEvArgName="tb_vehiRowChangeEvent" msprop:Generator_TablePropName="tb_vehi" msprop:Generator_RowChangedName="tb_vehiRowChanged" msprop:Generator_RowChangingName="tb_vehiRowChanging" msprop:Generator_TableClassName="tb_vehiDataTable" msprop:Generator_RowClassName="tb_vehiRow" msprop:Generator_TableVarName="tabletb_vehi" msprop:Generator_UserTableName="tb_vehi">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_vehi" msprop:Generator_ColumnPropNameInTable="key_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="key_vehi" msprop:Generator_UserColumnName="key_vehi" msprop:Generator_ColumnVarNameInTable="columnkey_vehi" type="xs:string" />
- <xs:element name="num_vehi" msprop:Generator_ColumnPropNameInRow="num_vehi" msprop:Generator_ColumnPropNameInTable="num_vehiColumn" msprop:Generator_ColumnVarNameInTable="columnnum_vehi" msprop:Generator_UserColumnName="num_vehi" type="xs:unsignedShort" minOccurs="0" />
- <xs:element name="cmpnum_vehi" msprop:Generator_ColumnPropNameInTable="cmpnum_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cmpnum_vehi" msprop:Generator_UserColumnName="cmpnum_vehi" msprop:Generator_ColumnVarNameInTable="columncmpnum_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="immat_vehi" msprop:Generator_ColumnPropNameInTable="immat_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="immat_vehi" msprop:Generator_UserColumnName="immat_vehi" msprop:Generator_ColumnVarNameInTable="columnimmat_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="ope_vehi" msprop:Generator_ColumnPropNameInTable="ope_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ope_vehi" msprop:Generator_UserColumnName="ope_vehi" msprop:Generator_ColumnVarNameInTable="columnope_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="type_vehi" msprop:Generator_ColumnPropNameInTable="type_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="type_vehi" msprop:Generator_UserColumnName="type_vehi" msprop:Generator_ColumnVarNameInTable="columntype_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="cond_vehi" msprop:Generator_ColumnPropNameInTable="cond_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cond_vehi" msprop:Generator_UserColumnName="cond_vehi" msprop:Generator_ColumnVarNameInTable="columncond_vehi" type="xs:string" default="" minOccurs="0" />
- <xs:element name="famille_vehi" msprop:Generator_ColumnPropNameInTable="famille_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="famille_vehi" msprop:Generator_UserColumnName="famille_vehi" msprop:Generator_ColumnVarNameInTable="columnfamille_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="carbu_vehi" msprop:Generator_ColumnPropNameInTable="carbu_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="carbu_vehi" msprop:Generator_UserColumnName="carbu_vehi" msprop:Generator_ColumnVarNameInTable="columncarbu_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="kmdep_vehi" msprop:Generator_ColumnPropNameInTable="kmdep_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kmdep_vehi" msprop:Generator_UserColumnName="kmdep_vehi" msprop:Generator_ColumnVarNameInTable="columnkmdep_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="kmarr_vehi" msprop:Generator_ColumnPropNameInTable="kmarr_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="kmarr_vehi" msprop:Generator_UserColumnName="kmarr_vehi" msprop:Generator_ColumnVarNameInTable="columnkmarr_vehi" type="xs:string" minOccurs="0" />
- <xs:element name="categ_vehi" msprop:Generator_ColumnPropNameInTable="categ_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="categ_vehi" msprop:Generator_UserColumnName="categ_vehi" msprop:Generator_ColumnVarNameInTable="columncateg_vehi" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="1" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="sort1_vehi" msprop:Generator_ColumnPropNameInTable="sort1_vehiColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="sort1_vehi" msprop:Generator_UserColumnName="sort1_vehi" msprop:Generator_ColumnVarNameInTable="columnsort1_vehi" type="xs:string" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_epreuve" msprop:Generator_RowClassName="tb_epreuveRow" msprop:Generator_RowEvHandlerName="tb_epreuveRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_epreuveRowDeleted" msprop:Generator_RowDeletingName="tb_epreuveRowDeleting" msprop:Generator_RowEvArgName="tb_epreuveRowChangeEvent" msprop:Generator_TablePropName="tb_epreuve" msprop:Generator_RowChangedName="tb_epreuveRowChanged" msprop:Generator_RowChangingName="tb_epreuveRowChanging" msprop:Generator_TableClassName="tb_epreuveDataTable" msprop:Generator_UserTableName="tb_epreuve" msprop:Generator_TableVarName="tabletb_epreuve">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_epr" msprop:Generator_ColumnPropNameInRow="key_epr" msprop:Generator_ColumnPropNameInTable="key_eprColumn" msprop:Generator_ColumnVarNameInTable="columnkey_epr" msprop:Generator_UserColumnName="key_epr" type="xs:string" />
- <xs:element name="nom_epr" msprop:Generator_ColumnPropNameInTable="nom_eprColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="nom_epr" msprop:Generator_UserColumnName="nom_epr" msprop:Generator_ColumnVarNameInTable="columnnom_epr" type="xs:string" default="" minOccurs="0" />
- <xs:element name="deb_epr" msprop:Generator_ColumnPropNameInRow="deb_epr" msprop:Generator_ColumnPropNameInTable="deb_eprColumn" msprop:Generator_ColumnVarNameInTable="columndeb_epr" msprop:Generator_UserColumnName="deb_epr" type="xs:dateTime" minOccurs="0" />
- <xs:element name="fin_epr" msprop:Generator_ColumnPropNameInRow="fin_epr" msprop:Generator_ColumnPropNameInTable="fin_eprColumn" msprop:Generator_ColumnVarNameInTable="columnfin_epr" msprop:Generator_UserColumnName="fin_epr" type="xs:dateTime" minOccurs="0" />
- <xs:element name="abrev_epr" msprop:Generator_ColumnPropNameInTable="abrev_eprColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="abrev_epr" msprop:Generator_UserColumnName="abrev_epr" msprop:Generator_ColumnVarNameInTable="columnabrev_epr" type="xs:string" default="" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_etape" msprop:Generator_RowClassName="tb_etapeRow" msprop:Generator_RowEvHandlerName="tb_etapeRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_etapeRowDeleted" msprop:Generator_RowDeletingName="tb_etapeRowDeleting" msprop:Generator_RowEvArgName="tb_etapeRowChangeEvent" msprop:Generator_TablePropName="tb_etape" msprop:Generator_RowChangedName="tb_etapeRowChanged" msprop:Generator_RowChangingName="tb_etapeRowChanging" msprop:Generator_TableClassName="tb_etapeDataTable" msprop:Generator_UserTableName="tb_etape" msprop:Generator_TableVarName="tabletb_etape">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="epr_etp" msprop:Generator_ColumnPropNameInRow="epr_etp" msprop:Generator_ColumnPropNameInTable="epr_etpColumn" msprop:Generator_ColumnVarNameInTable="columnepr_etp" msprop:Generator_UserColumnName="epr_etp" type="xs:string" />
- <xs:element name="num_etp" msprop:Generator_ColumnPropNameInRow="num_etp" msprop:Generator_ColumnPropNameInTable="num_etpColumn" msprop:Generator_ColumnVarNameInTable="columnnum_etp" msprop:Generator_UserColumnName="num_etp" type="xs:unsignedShort" />
- <xs:element name="date_etp" msprop:Generator_ColumnPropNameInRow="date_etp" msprop:Generator_ColumnPropNameInTable="date_etpColumn" msprop:Generator_ColumnVarNameInTable="columndate_etp" msprop:Generator_UserColumnName="date_etp" type="xs:dateTime" minOccurs="0" />
- <xs:element name="nom_etp" msprop:Generator_ColumnPropNameInRow="nom_etp" msprop:Generator_ColumnPropNameInTable="nom_etpColumn" msprop:Generator_ColumnVarNameInTable="columnnom_etp" msprop:Generator_UserColumnName="nom_etp" type="xs:string" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_pays" msprop:Generator_RowClassName="tb_paysRow" msprop:Generator_RowEvHandlerName="tb_paysRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_paysRowDeleted" msprop:Generator_RowDeletingName="tb_paysRowDeleting" msprop:Generator_RowEvArgName="tb_paysRowChangeEvent" msprop:Generator_TablePropName="tb_pays" msprop:Generator_RowChangedName="tb_paysRowChanged" msprop:Generator_RowChangingName="tb_paysRowChanging" msprop:Generator_TableClassName="tb_paysDataTable" msprop:Generator_UserTableName="tb_pays" msprop:Generator_TableVarName="tabletb_pays">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_pays" msprop:Generator_ColumnPropNameInRow="key_pays" msprop:Generator_ColumnPropNameInTable="key_paysColumn" msprop:Generator_ColumnVarNameInTable="columnkey_pays" msprop:Generator_UserColumnName="key_pays" type="xs:string" />
- <xs:element name="nom_pays" msprop:Generator_ColumnPropNameInRow="nom_pays" msprop:Generator_ColumnPropNameInTable="nom_paysColumn" msprop:Generator_ColumnVarNameInTable="columnnom_pays" msprop:Generator_UserColumnName="nom_pays" type="xs:string" minOccurs="0" />
- <xs:element name="code_pays" msprop:Generator_ColumnPropNameInRow="code_pays" msprop:Generator_ColumnPropNameInTable="code_paysColumn" msprop:Generator_ColumnVarNameInTable="columncode_pays" msprop:Generator_UserColumnName="code_pays" type="xs:string" minOccurs="0" />
- <xs:element name="txchge_pays" msprop:Generator_ColumnPropNameInRow="txchge_pays" msprop:Generator_ColumnPropNameInTable="txchge_paysColumn" msprop:Generator_ColumnVarNameInTable="columntxchge_pays" msprop:Generator_UserColumnName="txchge_pays" type="xs:float" minOccurs="0" />
- <xs:element name="tva_pays" msprop:Generator_ColumnPropNameInRow="tva_pays" msprop:Generator_ColumnPropNameInTable="tva_paysColumn" msprop:Generator_ColumnVarNameInTable="columntva_pays" msprop:Generator_UserColumnName="tva_pays" type="xs:float" minOccurs="0" />
- <xs:element name="img_pays" msprop:Generator_ColumnPropNameInRow="img_pays" msprop:Generator_ColumnPropNameInTable="img_paysColumn" msprop:Generator_ColumnVarNameInTable="columnimg_pays" msprop:Generator_UserColumnName="img_pays" type="xs:string" minOccurs="0" />
- <xs:element name="order_pays" msprop:Generator_ColumnPropNameInRow="order_pays" msprop:Generator_ColumnPropNameInTable="order_paysColumn" msprop:Generator_ColumnVarNameInTable="columnorder_pays" msprop:Generator_UserColumnName="order_pays" type="xs:unsignedShort" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_station" msprop:Generator_RowClassName="tb_stationRow" msprop:Generator_RowEvHandlerName="tb_stationRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_stationRowDeleted" msprop:Generator_RowDeletingName="tb_stationRowDeleting" msprop:Generator_RowEvArgName="tb_stationRowChangeEvent" msprop:Generator_TablePropName="tb_station" msprop:Generator_RowChangedName="tb_stationRowChanged" msprop:Generator_RowChangingName="tb_stationRowChanging" msprop:Generator_TableClassName="tb_stationDataTable" msprop:Generator_UserTableName="tb_station" msprop:Generator_TableVarName="tabletb_station">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_sta" msprop:Generator_ColumnPropNameInRow="key_sta" msprop:Generator_ColumnPropNameInTable="key_staColumn" msprop:Generator_ColumnVarNameInTable="columnkey_sta" msprop:Generator_UserColumnName="key_sta" type="xs:string" />
- <xs:element name="epr_sta" msprop:Generator_ColumnPropNameInTable="epr_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="epr_sta" msprop:Generator_UserColumnName="epr_sta" msprop:Generator_ColumnVarNameInTable="columnepr_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="etp_sta" msprop:Generator_ColumnPropNameInTable="etp_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="etp_sta" msprop:Generator_UserColumnName="etp_sta" msprop:Generator_ColumnVarNameInTable="columnetp_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="date_sta" msprop:Generator_ColumnPropNameInRow="date_sta" msprop:Generator_ColumnPropNameInTable="date_staColumn" msprop:Generator_ColumnVarNameInTable="columndate_sta" msprop:Generator_UserColumnName="date_sta" type="xs:dateTime" minOccurs="0" />
- <xs:element name="num_sta" msprop:Generator_ColumnPropNameInTable="num_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="num_sta" msprop:Generator_UserColumnName="num_sta" msprop:Generator_ColumnVarNameInTable="columnnum_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="nom_sta" msprop:Generator_ColumnPropNameInTable="nom_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="nom_sta" msprop:Generator_UserColumnName="nom_sta" msprop:Generator_ColumnVarNameInTable="columnnom_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="adr1_sta" msprop:Generator_ColumnPropNameInTable="adr1_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="adr1_sta" msprop:Generator_UserColumnName="adr1_sta" msprop:Generator_ColumnVarNameInTable="columnadr1_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="adr2_sta" msprop:Generator_ColumnPropNameInTable="adr2_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="adr2_sta" msprop:Generator_UserColumnName="adr2_sta" msprop:Generator_ColumnVarNameInTable="columnadr2_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="cp_sta" msprop:Generator_ColumnPropNameInTable="cp_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="cp_sta" msprop:Generator_UserColumnName="cp_sta" msprop:Generator_ColumnVarNameInTable="columncp_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="ville_sta" msprop:Generator_ColumnPropNameInTable="ville_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="ville_sta" msprop:Generator_UserColumnName="ville_sta" msprop:Generator_ColumnVarNameInTable="columnville_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="pays_sta" msprop:Generator_ColumnPropNameInTable="pays_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="pays_sta" msprop:Generator_UserColumnName="pays_sta" msprop:Generator_ColumnVarNameInTable="columnpays_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="contact_sta" msprop:Generator_ColumnPropNameInTable="contact_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="contact_sta" msprop:Generator_UserColumnName="contact_sta" msprop:Generator_ColumnVarNameInTable="columncontact_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="tel_sta" msprop:Generator_ColumnPropNameInTable="tel_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tel_sta" msprop:Generator_UserColumnName="tel_sta" msprop:Generator_ColumnVarNameInTable="columntel_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="tva_sta" msprop:Generator_ColumnPropNameInTable="tva_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="tva_sta" msprop:Generator_UserColumnName="tva_sta" msprop:Generator_ColumnVarNameInTable="columntva_sta" type="xs:string" default="" minOccurs="0" />
- <xs:element name="divers_sta" msprop:Generator_ColumnPropNameInTable="divers_staColumn" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="divers_sta" msprop:Generator_UserColumnName="divers_sta" msprop:Generator_ColumnVarNameInTable="columndivers_sta" type="xs:string" default="" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_famille" msprop:Generator_RowClassName="tb_familleRow" msprop:Generator_RowEvHandlerName="tb_familleRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_familleRowDeleted" msprop:Generator_RowDeletingName="tb_familleRowDeleting" msprop:Generator_RowEvArgName="tb_familleRowChangeEvent" msprop:Generator_TablePropName="tb_famille" msprop:Generator_RowChangedName="tb_familleRowChanged" msprop:Generator_RowChangingName="tb_familleRowChanging" msprop:Generator_TableClassName="tb_familleDataTable" msprop:Generator_UserTableName="tb_famille" msprop:Generator_TableVarName="tabletb_famille">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_fam" msprop:Generator_ColumnPropNameInRow="key_fam" msprop:Generator_ColumnPropNameInTable="key_famColumn" msprop:Generator_ColumnVarNameInTable="columnkey_fam" msprop:Generator_UserColumnName="key_fam" type="xs:string" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_prod" msprop:Generator_RowClassName="tb_prodRow" msprop:Generator_RowEvHandlerName="tb_prodRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_prodRowDeleted" msprop:Generator_RowDeletingName="tb_prodRowDeleting" msprop:Generator_RowEvArgName="tb_prodRowChangeEvent" msprop:Generator_TablePropName="tb_prod" msprop:Generator_RowChangedName="tb_prodRowChanged" msprop:Generator_RowChangingName="tb_prodRowChanging" msprop:Generator_TableClassName="tb_prodDataTable" msprop:Generator_UserTableName="tb_prod" msprop:Generator_TableVarName="tabletb_prod">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="key_prod" msprop:Generator_ColumnPropNameInRow="key_prod" msprop:Generator_ColumnPropNameInTable="key_prodColumn" msprop:Generator_ColumnVarNameInTable="columnkey_prod" msprop:Generator_UserColumnName="key_prod" type="xs:string" />
- <xs:element name="lib_prod" msprop:Generator_ColumnPropNameInRow="lib_prod" msprop:Generator_ColumnPropNameInTable="lib_prodColumn" msprop:Generator_ColumnVarNameInTable="columnlib_prod" msprop:Generator_UserColumnName="lib_prod" type="xs:string" minOccurs="0" />
- <xs:element name="type_prod" msprop:Generator_ColumnPropNameInRow="type_prod" msprop:Generator_ColumnPropNameInTable="type_prodColumn" msprop:Generator_ColumnVarNameInTable="columntype_prod" msprop:Generator_UserColumnName="type_prod" type="xs:string" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_presta" msprop:Generator_RowClassName="tb_prestaRow" msprop:Generator_RowEvHandlerName="tb_prestaRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_prestaRowDeleted" msprop:Generator_RowDeletingName="tb_prestaRowDeleting" msprop:Generator_RowEvArgName="tb_prestaRowChangeEvent" msprop:Generator_TablePropName="tb_presta" msprop:Generator_RowChangedName="tb_prestaRowChanged" msprop:Generator_RowChangingName="tb_prestaRowChanging" msprop:Generator_TableClassName="tb_prestaDataTable" msprop:Generator_UserTableName="tb_presta" msprop:Generator_TableVarName="tabletb_presta">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="sta_pr" msprop:Generator_ColumnPropNameInRow="sta_pr" msprop:Generator_ColumnPropNameInTable="sta_prColumn" msprop:Generator_ColumnVarNameInTable="columnsta_pr" msprop:Generator_UserColumnName="sta_pr" type="xs:string" />
- <xs:element name="prod_pr" msprop:Generator_ColumnPropNameInRow="prod_pr" msprop:Generator_ColumnPropNameInTable="prod_prColumn" msprop:Generator_ColumnVarNameInTable="columnprod_pr" msprop:Generator_UserColumnName="prod_pr" type="xs:string" />
- <xs:element name="kind_pr" msprop:Generator_ColumnPropNameInRow="kind_pr" msprop:Generator_ColumnPropNameInTable="kind_prColumn" msprop:Generator_ColumnVarNameInTable="columnkind_pr" msprop:Generator_UserColumnName="kind_pr" type="xs:string" minOccurs="0" />
- <xs:element name="unite_pr" msprop:Generator_ColumnPropNameInRow="unite_pr" msprop:Generator_ColumnPropNameInTable="unite_prColumn" msprop:Generator_ColumnVarNameInTable="columnunite_pr" msprop:Generator_UserColumnName="unite_pr" type="xs:string" minOccurs="0" />
- <xs:element name="pu_pr" msprop:Generator_ColumnPropNameInRow="pu_pr" msprop:Generator_ColumnPropNameInTable="pu_prColumn" msprop:Generator_ColumnVarNameInTable="columnpu_pr" msprop:Generator_UserColumnName="pu_pr" type="xs:decimal" minOccurs="0" />
- <xs:element name="tva_pr" msprop:Generator_ColumnPropNameInRow="tva_pr" msprop:Generator_ColumnPropNameInTable="tva_prColumn" msprop:Generator_ColumnVarNameInTable="columntva_pr" msprop:Generator_UserColumnName="tva_pr" type="xs:decimal" minOccurs="0" />
- <xs:element name="ttc_pr" msprop:Generator_ColumnPropNameInRow="ttc_pr" msprop:Generator_ColumnPropNameInTable="ttc_prColumn" msprop:Generator_ColumnVarNameInTable="columnttc_pr" msprop:Generator_UserColumnName="ttc_pr" type="xs:decimal" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="tb_vente" msprop:Generator_RowClassName="tb_venteRow" msprop:Generator_RowEvHandlerName="tb_venteRowChangeEventHandler" msprop:Generator_RowDeletedName="tb_venteRowDeleted" msprop:Generator_RowDeletingName="tb_venteRowDeleting" msprop:Generator_RowEvArgName="tb_venteRowChangeEvent" msprop:Generator_TablePropName="tb_vente" msprop:Generator_RowChangedName="tb_venteRowChanged" msprop:Generator_RowChangingName="tb_venteRowChanging" msprop:Generator_TableClassName="tb_venteDataTable" msprop:Generator_UserTableName="tb_vente" msprop:Generator_TableVarName="tabletb_vente">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="epreuve_vt" msprop:Generator_ColumnPropNameInRow="epreuve_vt" msprop:Generator_ColumnPropNameInTable="epreuve_vtColumn" msprop:Generator_ColumnVarNameInTable="columnepreuve_vt" msprop:Generator_UserColumnName="epreuve_vt" type="xs:string" />
- <xs:element name="station_vt" msprop:Generator_ColumnPropNameInRow="station_vt" msprop:Generator_ColumnPropNameInTable="station_vtColumn" msprop:Generator_ColumnVarNameInTable="columnstation_vt" msprop:Generator_UserColumnName="station_vt" type="xs:string" />
- <xs:element name="vehi_vt" msprop:Generator_ColumnPropNameInRow="vehi_vt" msprop:Generator_ColumnPropNameInTable="vehi_vtColumn" msprop:Generator_ColumnVarNameInTable="columnvehi_vt" msprop:Generator_UserColumnName="vehi_vt" type="xs:string" />
- <xs:element name="prod_vt" msprop:Generator_ColumnPropNameInTable="prod_vtColumn" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="prod_vt" msprop:Generator_UserColumnName="prod_vt" msprop:Generator_ColumnVarNameInTable="columnprod_vt" type="xs:string" />
- <xs:element name="date_vt" msdata:DateTimeMode="Utc" msprop:Generator_ColumnPropNameInRow="date_vt" msprop:Generator_ColumnPropNameInTable="date_vtColumn" msprop:Generator_ColumnVarNameInTable="columndate_vt" msprop:Generator_UserColumnName="date_vt" type="xs:dateTime" />
- <xs:element name="qtt_vt" msprop:Generator_ColumnPropNameInRow="qtt_vt" msprop:Generator_ColumnPropNameInTable="qtt_vtColumn" msprop:Generator_ColumnVarNameInTable="columnqtt_vt" msprop:Generator_UserColumnName="qtt_vt" type="xs:decimal" minOccurs="0" />
- <xs:element name="pu_vt" msprop:Generator_ColumnPropNameInRow="pu_vt" msprop:Generator_ColumnPropNameInTable="pu_vtColumn" msprop:Generator_ColumnVarNameInTable="columnpu_vt" msprop:Generator_UserColumnName="pu_vt" type="xs:decimal" minOccurs="0" />
- <xs:element name="ht_vt" msprop:Generator_ColumnPropNameInTable="ht_vtColumn" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="ht_vt" msprop:Generator_UserColumnName="ht_vt" msprop:Generator_ColumnVarNameInTable="columnht_vt" type="xs:decimal" default="0" minOccurs="0" />
- <xs:element name="tva_vt" msprop:Generator_ColumnPropNameInRow="tva_vt" msprop:Generator_ColumnPropNameInTable="tva_vtColumn" msprop:Generator_ColumnVarNameInTable="columntva_vt" msprop:Generator_UserColumnName="tva_vt" type="xs:decimal" minOccurs="0" />
- <xs:element name="ttc_vt" msprop:Generator_ColumnPropNameInRow="ttc_vt" msprop:Generator_ColumnPropNameInTable="ttc_vtColumn" msprop:Generator_ColumnVarNameInTable="columnttc_vt" msprop:Generator_UserColumnName="ttc_vt" type="xs:decimal" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_vehi" />
- <xs:field xpath="mstns:key_vehi" />
- </xs:unique>
- <xs:unique name="tb_epreuve_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_epreuve" />
- <xs:field xpath="mstns:key_epr" />
- </xs:unique>
- <xs:unique name="tb_etape_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_etape" />
- <xs:field xpath="mstns:epr_etp" />
- <xs:field xpath="mstns:num_etp" />
- </xs:unique>
- <xs:unique name="tb_pays_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_pays" />
- <xs:field xpath="mstns:key_pays" />
- </xs:unique>
- <xs:unique name="tb_station_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_station" />
- <xs:field xpath="mstns:key_sta" />
- </xs:unique>
- <xs:unique name="tb_famille_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_famille" />
- <xs:field xpath="mstns:key_fam" />
- </xs:unique>
- <xs:unique name="tb_prod_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_prod" />
- <xs:field xpath="mstns:key_prod" />
- </xs:unique>
- <xs:unique name="tb_presta_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_presta" />
- <xs:field xpath="mstns:sta_pr" />
- <xs:field xpath="mstns:prod_pr" />
- </xs:unique>
- <xs:unique name="tb_vente_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:tb_vente" />
- <xs:field xpath="mstns:epreuve_vt" />
- <xs:field xpath="mstns:station_vt" />
- <xs:field xpath="mstns:vehi_vt" />
- <xs:field xpath="mstns:prod_vt" />
- <xs:field xpath="mstns:date_vt" />
- </xs:unique>
- <xs:keyref name="FK_tb_prod_tb_vente" refer="tb_prod_Constraint1" msprop:rel_Generator_UserParentTable="tb_prod" msprop:rel_Generator_UserChildTable="tb_vente" msprop:rel_Generator_RelationVarName="relationFK_tb_prod_tb_vente" msprop:rel_Generator_ChildPropName="Gettb_venteRows" msprop:rel_Generator_ParentPropName="tb_prodRow" msprop:rel_Generator_UserRelationName="FK_tb_prod_tb_vente" msdata:AcceptRejectRule="Cascade">
- <xs:selector xpath=".//mstns:tb_vente" />
- <xs:field xpath="mstns:prod_vt" />
- </xs:keyref>
- <xs:keyref name="FK_tb_epreuve_tb_vente" refer="tb_epreuve_Constraint1" msprop:rel_Generator_UserParentTable="tb_epreuve" msprop:rel_Generator_UserChildTable="tb_vente" msprop:rel_Generator_RelationVarName="relationFK_tb_epreuve_tb_vente" msprop:rel_Generator_ChildPropName="Gettb_venteRows" msprop:rel_Generator_ParentPropName="tb_epreuveRow" msprop:rel_Generator_UserRelationName="FK_tb_epreuve_tb_vente" msdata:AcceptRejectRule="Cascade">
- <xs:selector xpath=".//mstns:tb_vente" />
- <xs:field xpath="mstns:epreuve_vt" />
- </xs:keyref>
- <xs:keyref name="FK_tb_station_tb_presta" refer="tb_station_Constraint1" msprop:rel_Generator_UserParentTable="tb_station" msprop:rel_Generator_UserChildTable="tb_presta" msprop:rel_Generator_RelationVarName="relationFK_tb_station_tb_presta" msprop:rel_Generator_ChildPropName="Gettb_prestaRows" msprop:rel_Generator_ParentPropName="tb_stationRow" msprop:rel_Generator_UserRelationName="FK_tb_station_tb_presta" msdata:AcceptRejectRule="Cascade">
- <xs:selector xpath=".//mstns:tb_presta" />
- <xs:field xpath="mstns:sta_pr" />
- </xs:keyref>
- <xs:keyref name="FK_tb_epreuve_tb_station" refer="tb_epreuve_Constraint1" msprop:rel_Generator_UserParentTable="tb_epreuve" msprop:rel_Generator_UserChildTable="tb_station" msprop:rel_Generator_RelationVarName="relationFK_tb_epreuve_tb_station" msprop:rel_Generator_ChildPropName="Gettb_stationRows" msprop:rel_Generator_ParentPropName="tb_epreuveRow" msprop:rel_Generator_UserRelationName="FK_tb_epreuve_tb_station" msdata:AcceptRejectRule="Cascade">
- <xs:selector xpath=".//mstns:tb_station" />
- <xs:field xpath="mstns:epr_sta" />
- </xs:keyref>
- <xs:keyref name="FK_tb_epreuve_tb_etape" refer="tb_epreuve_Constraint1" msprop:rel_Generator_UserParentTable="tb_epreuve" msprop:rel_Generator_UserChildTable="tb_etape" msprop:rel_Generator_RelationVarName="relationFK_tb_epreuve_tb_etape" msprop:rel_Generator_ChildPropName="Gettb_etapeRows" msprop:rel_Generator_ParentPropName="tb_epreuveRow" msprop:rel_Generator_UserRelationName="FK_tb_epreuve_tb_etape" msdata:AcceptRejectRule="Cascade">
- <xs:selector xpath=".//mstns:tb_etape" />
- <xs:field xpath="mstns:epr_etp" />
- </xs:keyref>
- </xs:element>
- <xs:annotation>
- <xs:appinfo>
- <msdata:Relationship name="tb_prod_tb_presta" msdata:parent="tb_prod" msdata:child="tb_presta" msdata:parentkey="key_prod" msdata:childkey="prod_pr" msprop:Generator_UserParentTable="tb_prod" msprop:Generator_UserChildTable="tb_presta" msprop:Generator_RelationVarName="relationtb_prod_tb_presta" msprop:Generator_ChildPropName="Gettb_prestaRows" msprop:Generator_ParentPropName="tb_prodRow" msprop:Generator_UserRelationName="tb_prod_tb_presta" />
- <msdata:Relationship name="tb_vehi_tb_vente" msdata:parent="tb_vehi" msdata:child="tb_vente" msdata:parentkey="key_vehi" msdata:childkey="vehi_vt" msprop:Generator_UserParentTable="tb_vehi" msprop:Generator_UserChildTable="tb_vente" msprop:Generator_RelationVarName="relationtb_vehi_tb_vente" msprop:Generator_ChildPropName="Gettb_venteRows" msprop:Generator_ParentPropName="tb_vehiRow" msprop:Generator_UserRelationName="tb_vehi_tb_vente" />
- <msdata:Relationship name="tb_station_tb_vente" msdata:parent="tb_station" msdata:child="tb_vente" msdata:parentkey="key_sta" msdata:childkey="station_vt" msprop:Generator_UserParentTable="tb_station" msprop:Generator_UserChildTable="tb_vente" msprop:Generator_RelationVarName="relationtb_station_tb_vente" msprop:Generator_ChildPropName="Gettb_venteRows" msprop:Generator_ParentPropName="tb_stationRow" msprop:Generator_UserRelationName="tb_station_tb_vente" />
- </xs:appinfo>
- </xs:annotation>
- </xs:schema>
|