foodmartsale dw.dsv

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DSV 代码 · 共 692 行 · 第 1/4 页

                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="phone2" msprop:FriendlyName="phone2" msprop:DbColumnName="phone2" msprop:design-time-name="7ac65a6d-d6d8-43e3-ac4b-72aac7777f63" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="birthdate" msprop:FriendlyName="birthdate" msprop:DbColumnName="birthdate" msprop:design-time-name="f43e5653-a344-491f-9234-6c23d9c8664b" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="marital_status" msprop:FriendlyName="marital_status" msprop:DbColumnName="marital_status" msprop:design-time-name="d961d629-b917-478a-88fd-dc70f8b69373" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="yearly_income" msprop:FriendlyName="yearly_income" msprop:DbColumnName="yearly_income" msprop:design-time-name="d8b1032b-4311-4628-8e38-28d5123711d4" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="gender" msprop:FriendlyName="gender" msprop:DbColumnName="gender" msprop:design-time-name="321cadb4-e756-4094-8fcf-8ecc6889e480" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="total_children" msprop:FriendlyName="total_children" msprop:DbColumnName="total_children" msprop:design-time-name="986a7f98-1b34-49e9-92aa-4070388b27e3" type="xs:short" minOccurs="0" />
                  <xs:element name="num_children_at_home" msprop:FriendlyName="num_children_at_home" msprop:DbColumnName="num_children_at_home" msprop:design-time-name="213d946a-ec65-4963-8dbb-ea9e950e4382" type="xs:short" minOccurs="0" />
                  <xs:element name="education" msprop:FriendlyName="education" msprop:DbColumnName="education" msprop:design-time-name="837ef12e-8dc2-45f5-9c8c-2cda98e07151" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="30" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="date_accnt_opened" msprop:FriendlyName="date_accnt_opened" msprop:DbColumnName="date_accnt_opened" msprop:design-time-name="37e3e77b-ebbb-44f8-b6d7-545f4d2ddefd" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="member_card" msprop:FriendlyName="member_card" msprop:DbColumnName="member_card" msprop:design-time-name="8ee06c01-b008-46d3-9604-cbdb9c6d04a4" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="occupation" msprop:FriendlyName="occupation" msprop:DbColumnName="occupation" msprop:design-time-name="a07d333a-106b-44f0-bbc2-e5604538e637" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="houseowner" msprop:FriendlyName="houseowner" msprop:DbColumnName="houseowner" msprop:design-time-name="41507158-8d34-412e-8f6e-0515b9c03c3e" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="num_cars_owned" msprop:FriendlyName="num_cars_owned" msprop:DbColumnName="num_cars_owned" msprop:design-time-name="f7de4a74-b7d7-41d1-8bbe-b9d79372a6dc" type="xs:short" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_product" msprop:FriendlyName="product" msprop:DbSchemaName="dbo" msprop:DbTableName="product" msprop:design-time-name="4d842f65-9d53-4676-9766-650d0ec86c51" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="product_class_id" msprop:FriendlyName="product_class_id" msprop:DbColumnName="product_class_id" msprop:design-time-name="40ca0393-e3b2-4463-a4c4-a6edb023f51a" type="xs:int" minOccurs="0" />
                  <xs:element name="product_id" msprop:FriendlyName="product_id" msprop:DbColumnName="product_id" msprop:design-time-name="677f63d0-1957-445f-9377-30b4d2b491f2" type="xs:int" />
                  <xs:element name="brand_name" msprop:FriendlyName="brand_name" msprop:DbColumnName="brand_name" msprop:design-time-name="fb1ca63b-1e58-47e1-b4b6-ff6b35fceaa4" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="product_name" msprop:FriendlyName="product_name" msprop:DbColumnName="product_name" msprop:design-time-name="5ec46ae4-7450-48e2-a743-318d9582fb43" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SKU" msprop:FriendlyName="SKU" msprop:DbColumnName="SKU" msprop:design-time-name="e4aae74d-d84a-40e9-84b0-9fd28572617e" type="xs:double" minOccurs="0" />
                  <xs:element name="SRP" msprop:FriendlyName="SRP" msprop:DbColumnName="SRP" msprop:design-time-name="c66cab96-b6e2-436f-803f-fe9fd9454aa3" type="xs:decimal" minOccurs="0" />
                  <xs:element name="gross_weight" msprop:FriendlyName="gross_weight" msprop:DbColumnName="gross_weight" msprop:design-time-name="535570f6-b806-4c78-941f-c5760266d150" type="xs:float" minOccurs="0" />
                  <xs:element name="net_weight" msprop:FriendlyName="net_weight" msprop:DbColumnName="net_weight" msprop:design-time-name="35bb94b3-2a01-42d0-9288-2ca7c4316daf" type="xs:float" minOccurs="0" />
                  <xs:element name="recyclable_package" msprop:FriendlyName="recyclable_package" msprop:DbColumnName="recyclable_package" msprop:design-time-name="445adda6-1d0e-404e-b608-739ad01b8b0a" type="xs:boolean" />
                  <xs:element name="low_fat" msprop:FriendlyName="low_fat" msprop:DbColumnName="low_fat" msprop:design-time-name="5572dcdf-c58c-438b-84e5-b53bfb684362" type="xs:boolean" />
                  <xs:element name="units_per_case" msprop:FriendlyName="units_per_case" msprop:DbColumnName="units_per_case" msprop:design-time-name="3d3ac74b-ecc0-40e4-b595-b48d9f1481c3" type="xs:short" minOccurs="0" />
                  <xs:element name="cases_per_pallet" msprop:FriendlyName="cases_per_pallet" msprop:DbColumnName="cases_per_pallet" msprop:design-time-name="113e722b-f5cf-443e-8e56-7c4dc5a880e9" type="xs:short" minOccurs="0" />
                  <xs:element name="shelf_width" msprop:FriendlyName="shelf_width" msprop:DbColumnName="shelf_width" msprop:design-time-name="93b38d02-3053-41ec-98f7-366f82b0a7d9" type="xs:float" minOccurs="0" />
                  <xs:element name="shelf_height" msprop:FriendlyName="shelf_height" msprop:DbColumnName="shelf_height" msprop:design-time-name="f9ae57f2-e07c-44f0-9fba-4c92742b1431" type="xs:float" minOccurs="0" />
                  <xs:element name="shelf_depth" msprop:FriendlyName="shelf_depth" msprop:DbColumnName="shelf_depth" msprop:design-time-name="e5245f2b-391a-4b96-9dfc-d935a4c78e05" type="xs:float" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_product_class" msprop:FriendlyName="product_class" msprop:DbSchemaName="dbo" msprop:DbTableName="product_class" msprop:design-time-name="ae82a4ac-7f71-4b3d-b504-406d28aac0eb" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="product_class_id" msprop:FriendlyName="product_class_id" msprop:DbColumnName="product_class_id" msprop:design-time-name="c58e5e42-32ec-421c-a1af-b0569c1d1bcb" type="xs:int" />
                  <xs:element name="product_subcategory" msprop:FriendlyName="product_subcategory" msprop:DbColumnName="product_subcategory" msprop:design-time-name="99e90bda-6d66-49ef-ab70-4cabee5204a4" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="product_category" msprop:FriendlyName="product_category" msprop:DbColumnName="product_category" msprop:design-time-name="5f868f72-c154-4cb6-a2ca-88c387030373" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="product_department" msprop:FriendlyName="product_department" msprop:DbColumnName="product_department" msprop:design-time-name="09e6ad72-0932-4992-b68a-3d22f1b3f750" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="product_family" msprop:FriendlyName="product_family" msprop:DbColumnName="product_family" msprop:design-time-name="5c5abd80-fe90-46ad-a6b2-874224138737" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_promotion" msprop:FriendlyName="promotion" msprop:DbSchemaName="dbo" msprop:DbTableName="promotion" msprop:design-time-name="f3199f2e-649a-454a-9418-29343c341fa7" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="promotion_id" msprop:FriendlyName="promotion_id" msprop:DbColumnName="promotion_id" msprop:design-time-name="3b089555-62e9-4abc-9796-2c45e59045fa" type="xs:int" />
                  <xs:element name="promotion_district_id" msprop:FriendlyName="promotion_district_id" msprop:DbColumnName="promotion_district_id" msprop:design-time-name="4f5d89b5-ba8d-45e3-b558-aca687789f4e" type="xs:int" minOccurs="0" />
                  <xs:element name="promotion_name" msprop:FriendlyName="promotion_name" msprop:DbColumnName="promotion_name" msprop:design-time-name="df93df7c-eb07-482b-860a-a591fdc1bcce" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="media_type" msprop:FriendlyName="media_type" msprop:DbColumnName="media_type" msprop:design-time-name="65db9344-320c-4a87-9fa0-60e736355d8b" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="cost" msprop:FriendlyName="cost" msprop:DbColumnName="cost" msprop:design-time-name="8397d1cc-193a-45b2-8c16-bbb90218da8b" type="xs:double" minOccurs="0" />
                  <xs:element name="start_date" msprop:FriendlyName="start_date" msprop:DbColumnName="start_date" msprop:design-time-name="57e3c9ae-06c3-47c8-81c1-26f225c20695" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="end_date" msprop:FriendlyName="end_date" msprop:DbColumnName="end_date" msprop:design-time-name="f926c14f-ec03-4414-a971-a51f9b746e7e" type="xs:dateTime" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_sales_fact_1998" msprop:FriendlyName="sales_fact_1998" msprop:DbSchemaName="dbo" msprop:DbTableName="sales_fact_1998" msprop:design-time-name="92b01e98-cf8b-457e-b116-57fd440eacf6" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="product_id" msprop:FriendlyName="product_id" msprop:DbColumnName="product_id" msprop:design-time-name="d8f780f5-7bb1-4df9-b489-d883a562a46c" type="xs:int" minOccurs="0" />
                  <xs:element name="time_id" msprop:FriendlyName="time_id" msprop:DbColumnName="time_id" msprop:design-time-name="b6b00ee8-df26-4adf-af56-93a104af650d" type="xs:int" minOccurs="0" />
                  <xs:element name="customer_id" msprop:FriendlyName="customer_id" msprop:DbColumnName="customer_id" msprop:design-time-name="9f776360-6a83-48a9-802e-c44a76959f04" type="xs:int" minOccurs="0" />
                  <xs:element name="promotion_id" msprop:FriendlyName="promotion_id" msprop:DbColumnName="promotion_id" msprop:design-time-name="d203778b-e87c-422c-a7a4-5ba45a4be42b" type="xs:int" minOccurs="0" />
                  <xs:element name="store_id" msprop:FriendlyName="store_id" msprop:DbColumnName="store_id" msprop:design-time-name="347e2ba4-18b6-4e6f-9003-d9045df04918" type="xs:int" minOccurs="0" />
                  <xs:element name="store_sales" msprop:FriendlyName="store_sales" msprop:DbColumnName="store_sales" msprop:design-time-name="84262a2c-2f92-4688-8e73-45c629fc7988" type="xs:decimal" minOccurs="0" />
                  <xs:element name="store_cost" msprop:FriendlyName="store_cost" msprop:DbColumnName="store_cost" msprop:design-time-name="39f51214-4a1d-4161-b78a-36f5bb2dddc3" type="xs:decimal" minOccurs="0" />
                  <xs:element name="unit_sales" msprop:FriendlyName="unit_sales" msprop:DbColumnName="unit_sales" msprop:design-time-name="6f54be25-af8d-4692-b83b-fccf8e540b90" type="xs:double" minOccurs="0" />
                </xs:sequence>
              </xs:complexType>