/ion-two/jewel-design/dataset/ds_custom_jewel.xsd

https://github.com/mamluka/JonOldBackOffice · XML Schema · 151 lines · 151 code · 0 blank · 0 comment · 0 complexity · 3f7aa229402294b68e194635ff35411a MD5 · raw file 

    

  1. <?xml version="1.0" encoding="utf-8" ?>

    2. 

  2. <xs:schema id="ds_custom_jewel" targetNamespace="http://tempuri.org/ds_custom_jewel.xsd" elementFormDefault="qualified"

    3. 

  3. 	attributeFormDefault="qualified" xmlns="http://tempuri.org/ds_custom_jewel.xsd" xmlns:mstns="http://tempuri.org/ds_custom_jewel.xsd"

    4. 

  4. 	xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    5. 

  5. 	<xs:element name="ds_custom_jewel" msdata:IsDataSet="true">

    6. 

  6. 		<xs:complexType>

    7. 

  7. 			<xs:choice maxOccurs="unbounded">

    8. 

  8. 				<xs:element name="usr_CUSTOMERS">

    9. 

  9. 					<xs:complexType>

    10. 

  10. 						<xs:sequence>

    11. 

  11. 							<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />

    12. 

  12. 							<xs:element name="email" type="xs:string" />

    13. 

  13. 							<xs:element name="password" type="xs:string" minOccurs="0" />

    14. 

  14. 							<xs:element name="firstname" type="xs:string" minOccurs="0" />

    15. 

  15. 							<xs:element name="lastname" type="xs:string" minOccurs="0" />

    16. 

  16. 							<xs:element name="street1" type="xs:string" minOccurs="0" />

    17. 

  17. 							<xs:element name="city1" type="xs:string" minOccurs="0" />

    18. 

  18. 							<xs:element name="state1_id" type="xs:int" />

    19. 

  19. 							<xs:element name="zip1" type="xs:string" minOccurs="0" />

    20. 

  20. 							<xs:element name="pobox1" type="xs:string" minOccurs="0" />

    21. 

  21. 							<xs:element name="country1_id" type="xs:int" />

    22. 

  22. 							<xs:element name="phone1" type="xs:string" minOccurs="0" />

    23. 

  23. 							<xs:element name="fax1" type="xs:string" minOccurs="0" />

    24. 

  24. 							<xs:element name="street2" type="xs:string" minOccurs="0" />

    25. 

  25. 							<xs:element name="city2" type="xs:string" minOccurs="0" />

    26. 

  26. 							<xs:element name="state2_id" type="xs:int" />

    27. 

  27. 							<xs:element name="zip2" type="xs:string" minOccurs="0" />

    28. 

  28. 							<xs:element name="pobox2" type="xs:string" minOccurs="0" />

    29. 

  29. 							<xs:element name="country2_id" type="xs:int" />

    30. 

  30. 							<xs:element name="phone2" type="xs:string" minOccurs="0" />

    31. 

  31. 							<xs:element name="fax2" type="xs:string" minOccurs="0" />

    32. 

  32. 							<xs:element name="inv_mail" type="xs:boolean" minOccurs="0" />

    33. 

  33. 							<xs:element name="inv_update" type="xs:boolean" minOccurs="0" />

    34. 

  34. 							<xs:element name="lastmodify_date" type="xs:dateTime" minOccurs="0" />

    35. 

  35. 							<xs:element name="lastmodify_user" type="xs:string" minOccurs="0" />

    36. 

  36. 							<xs:element name="lastmodify_user_id" type="xs:int" />

    37. 

  37. 							<xs:element name="create_date" type="xs:dateTime" minOccurs="0" />

    38. 

  38. 							<xs:element name="active" type="xs:boolean" minOccurs="0" />

    39. 

  39. 							<xs:element name="dealer" type="xs:boolean" minOccurs="0" />

    40. 

  40. 							<xs:element name="b_name" type="xs:string" minOccurs="0" />

    41. 

  41. 							<xs:element name="b_street" type="xs:string" minOccurs="0" />

    42. 

  42. 							<xs:element name="b_city" type="xs:string" minOccurs="0" />

    43. 

  43. 							<xs:element name="b_state_id" type="xs:int" />

    44. 

  44. 							<xs:element name="b_country_id" type="xs:int" />

    45. 

  45. 							<xs:element name="b_pobox" type="xs:string" minOccurs="0" />

    46. 

  46. 							<xs:element name="b_zip" type="xs:string" minOccurs="0" />

    47. 

  47. 							<xs:element name="b_phone" type="xs:string" minOccurs="0" />

    48. 

  48. 							<xs:element name="b_fax" type="xs:string" minOccurs="0" />

    49. 

  49. 							<xs:element name="b_tradingass" type="xs:string" minOccurs="0" />

    50. 

  50. 							<xs:element name="b_type_id" type="xs:int" />

    51. 

  51. 							<xs:element name="b_siteurl" type="xs:string" minOccurs="0" />

    52. 

  52. 							<xs:element name="b_specialization" type="xs:string" minOccurs="0" />

    53. 

  53. 							<xs:element name="historical_user" type="xs:boolean" minOccurs="0" />

    54. 

  54. 							<xs:element name="old_id" type="xs:int" minOccurs="0" />

    55. 

  55. 							<xs:element name="userdeleted" type="xs:boolean" minOccurs="0" />

    56. 

  56. 							<xs:element name="prf_srtkey_diamonds" type="xs:string" minOccurs="0" />

    57. 

  57. 							<xs:element name="prf_srtkey_gemstones" type="xs:string" minOccurs="0" />

    58. 

  58. 							<xs:element name="prf_srtkey_jewelry" type="xs:string" minOccurs="0" />

    59. 

  59. 							<xs:element name="prf_srtkey_newitems" type="xs:string" minOccurs="0" />

    60. 

  60. 							<xs:element name="prf_srtkey_specials" type="xs:string" minOccurs="0" />

    61. 

  61. 							<xs:element name="prf_srtkey_search" type="xs:string" minOccurs="0" />

    62. 

  62. 							<xs:element name="prf_list_amount" type="xs:int" minOccurs="0" />

    63. 

  63. 							<xs:element name="prf_language_id" type="xs:int" minOccurs="0" />

    64. 

  64. 							<xs:element name="prf_timesvisited" type="xs:int" minOccurs="0" />

    65. 

  65. 							<xs:element name="online_message" type="xs:string" minOccurs="0" />

    66. 

  66. 							<xs:element name="last_visit" type="xs:dateTime" minOccurs="0" />

    67. 

  67. 							<xs:element name="dateofbirth" type="xs:dateTime" minOccurs="0" />

    68. 

  68. 							<xs:element name="aid" type="xs:int" minOccurs="0" />

    69. 

  69. 							<xs:element name="registration_ip" type="xs:string" minOccurs="0" />

    70. 

  70. 							<xs:element name="idex_percent" type="xs:int" minOccurs="0" />

    71. 

  71. 						</xs:sequence>

    72. 

  72. 					</xs:complexType>

    73. 

  73. 				</xs:element>

    74. 

  74. 				<xs:element name="inv_JEWELDESIGN_SAVE">

    75. 

  75. 					<xs:complexType>

    76. 

  76. 						<xs:sequence>

    77. 

  77. 							<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />

    78. 

  78. 							<xs:element name="random_index" type="xs:int" />

    79. 

  79. 							<xs:element name="userid" type="xs:int" />

    80. 

  80. 							<xs:element name="ss_price" type="xs:decimal" minOccurs="0" />

    81. 

  81. 							<xs:element name="ss_price_formatted" type="xs:string" minOccurs="0" />

    82. 

  82. 							<xs:element name="ss_weight" type="xs:decimal" minOccurs="0" />

    83. 

  83. 							<xs:element name="ss_weight_formatted" type="xs:string" minOccurs="0" />

    84. 

  84. 							<xs:element name="ss_shapeid" type="xs:int" minOccurs="0" />

    85. 

  85. 							<xs:element name="ss_shape" type="xs:string" minOccurs="0" />

    86. 

  86. 							<xs:element name="ss_quality" type="xs:string" minOccurs="0" />

    87. 

  87. 							<xs:element name="ss_qualityid" type="xs:int" minOccurs="0" />

    88. 

  88. 							<xs:element name="ss_size" type="xs:string" minOccurs="0" />

    89. 

  89. 							<xs:element name="ss_slider_val" type="xs:int" minOccurs="0" />

    90. 

  90. 							<xs:element name="ss_desc" type="xs:string" minOccurs="0" />

    91. 

  91. 							<xs:element name="ss_extrainfo" type="xs:string" minOccurs="0" />

    92. 

  92. 							<xs:element name="ss_trueid" type="xs:int" minOccurs="0" />

    93. 

  93. 							<xs:element name="ss_link" type="xs:string" minOccurs="0" />

    94. 

  94. 							<xs:element name="ss_full_link" type="xs:string" minOccurs="0" />

    95. 

  95. 							<xs:element name="cs_price" type="xs:decimal" minOccurs="0" />

    96. 

  96. 							<xs:element name="cs_price_formatted" type="xs:string" minOccurs="0" />

    97. 

  97. 							<xs:element name="cs_weight" type="xs:decimal" minOccurs="0" />

    98. 

  98. 							<xs:element name="cs_weight_formatted" type="xs:string" minOccurs="0" />

    99. 

  99. 							<xs:element name="cs_shapeid" type="xs:int" minOccurs="0" />

    100. 

  100. 							<xs:element name="cs_shape" type="xs:string" minOccurs="0" />

    101. 

  101. 							<xs:element name="cs_item_link" type="xs:string" minOccurs="0" />

    102. 

  102. 							<xs:element name="cs_icon_pic" type="xs:string" minOccurs="0" />

    103. 

  103. 							<xs:element name="cs_size" type="xs:string" minOccurs="0" />

    104. 

  104. 							<xs:element name="cs_item_id" type="xs:string" minOccurs="0" />

    105. 

  105. 							<xs:element name="cs_txt_type" type="xs:string" minOccurs="0" />

    106. 

  106. 							<xs:element name="cs_shape_txt_preview" type="xs:string" minOccurs="0" />

    107. 

  107. 							<xs:element name="set_model_id" type="xs:int" minOccurs="0" />

    108. 

  108. 							<xs:element name="set_price" type="xs:decimal" minOccurs="0" />

    109. 

  109. 							<xs:element name="cs_color" type="xs:string" minOccurs="0" />

    110. 

  110. 							<xs:element name="set_price_formatted" type="xs:string" minOccurs="0" />

    111. 

  111. 							<xs:element name="set_metal_type" type="xs:string" minOccurs="0" />

    112. 

  112. 							<xs:element name="set_metal_id" type="xs:int" minOccurs="0" />

    113. 

  113. 							<xs:element name="set_model_picsrc" type="xs:string" minOccurs="0" />

    114. 

  114. 							<xs:element name="deliver_mathod" type="xs:int" minOccurs="0" />

    115. 

  115. 							<xs:element name="set_ring_size" type="xs:string" minOccurs="0" />

    116. 

  116. 							<xs:element name="semi_model_id" type="xs:int" minOccurs="0" />

    117. 

  117. 							<xs:element name="semi_price" type="xs:decimal" minOccurs="0" />

    118. 

  118. 							<xs:element name="semi_price_formatted" type="xs:string" minOccurs="0" />

    119. 

  119. 							<xs:element name="semi_metal_type" type="xs:string" minOccurs="0" />

    120. 

  120. 							<xs:element name="semi_metal_id" type="xs:int" minOccurs="0" />

    121. 

  121. 							<xs:element name="semi_ring_size" type="xs:string" minOccurs="0" />

    122. 

  122. 							<xs:element name="semi_model_picsrc" type="xs:string" minOccurs="0" />

    123. 

  123. 							<xs:element name="semi_style" type="xs:string" minOccurs="0" />

    124. 

  124. 							<xs:element name="semi_weight_formatted" type="xs:string" minOccurs="0" />

    125. 

  125. 							<xs:element name="semi_ss_full_desc" type="xs:string" minOccurs="0" />

    126. 

  126. 							<xs:element name="has_cs" type="xs:boolean" minOccurs="0" />

    127. 

  127. 							<xs:element name="has_ss" type="xs:boolean" minOccurs="0" />

    128. 

  128. 							<xs:element name="has_style" type="xs:boolean" minOccurs="0" />

    129. 

  129. 							<xs:element name="has_semi" type="xs:boolean" minOccurs="0" />

    130. 

  130. 							<xs:element name="cs_inithtml" type="xs:string" minOccurs="0" />

    131. 

  131. 							<xs:element name="ss_inithtml" type="xs:string" minOccurs="0" />

    132. 

  132. 							<xs:element name="set_inithtml" type="xs:string" minOccurs="0" />

    133. 

  133. 						</xs:sequence>

    134. 

  134. 					</xs:complexType>

    135. 

  135. 				</xs:element>

    136. 

  136. 			</xs:choice>

    137. 

  137. 		</xs:complexType>

    138. 

  138. 		<xs:unique name="ds_custom_jewelKey2" msdata:PrimaryKey="true">

    139. 

  139. 			<xs:selector xpath=".//mstns:usr_CUSTOMERS" />

    140. 

  140. 			<xs:field xpath="mstns:id" />

    141. 

  141. 		</xs:unique>

    142. 

  142. 		<xs:keyref name="inv_JEWELDESIGN_SAVEusr_CUSTOMERS" refer="ds_custom_jewelKey1">

    143. 

  143. 			<xs:selector xpath=".//mstns:usr_CUSTOMERS" />

    144. 

  144. 			<xs:field xpath="mstns:id" />

    145. 

  145. 		</xs:keyref>

    146. 

  146. 		<xs:unique name="ds_custom_jewelKey1" msdata:PrimaryKey="true">

    147. 

  147. 			<xs:selector xpath=".//mstns:inv_JEWELDESIGN_SAVE" />

    148. 

  148. 			<xs:field xpath="mstns:id" />

    149. 

  149. 		</xs:unique>

    150. 

  150. 	</xs:element>

    151. 

  151. </xs:schema>
    152.