XML cube1

<DataSourceView xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="43ee0a35-b437-4cc5-8f82-a38f48a98d0c" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

DSVCube

DSVCube

0001-01-01T00:00:00Z

0001-01-01T00:00:00Z





http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames

true





http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name>

_ALL_TABLES_</Value>

</Annotation>



http://schemas.microsoft.com/DataWarehouse/Designer/1.0:NameMatchingCriteria</Name>

1</Value>

</Annotation>



http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name>

</Annotation>



http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name>

true</Value>

</Annotation>



http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name>



<Layouts xmlns="">

<Diagram>

_ALL_TABLES_</Name>

<DiagramLayout>

<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="69" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-6166" scrolltop="-2332" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="32782" y="17754" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="1" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">

<ddsxmlobjectstreamwrapper binary="01cc0000900144420100065461686f6d61" />

<ddsxmlobjectstreamwrapper binary="6c74000000000000" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_OTP" left="15661" top="7125" logicalid="31" controlid="1" masterid="0" hint1="0" hint2="0" width="3000" height="7275" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000b80b00006b1c0000" />

<property name="LogicalObject" value="dbo_vc_OTP" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_Good" left="22954" top="5379" logicalid="32" controlid="2" masterid="0" hint1="0" hint2="0" width="3598" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="000800000e0e000088130000" />

<property name="LogicalObject" value="dbo_vc_Good" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_SubdivisionShop" left="7491" top="12470" logicalid="33" controlid="3" masterid="0" hint1="0" hint2="0" width="4128" height="5952" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="000800002010000040170000" />

<property name="LogicalObject" value="dbo_vc_SubdivisionShop" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_Calendar" left="5434" top="7125" logicalid="34" controlid="4" masterid="0" hint1="0" hint2="0" width="3000" height="4657" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000b80b000031120000" />

<property name="LogicalObject" value="dbo_vc_Calendar" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="8134" top="7712" logicalid="35" controlid="5" masterid="0" hint1="0" hint2="0" width="7827" height="1041" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-vc_Calendar]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="4" destid="1" sourceattachpoint="15" destattachpoint="12" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="17411" top="6380" logicalid="36" controlid="6" masterid="0" hint1="0" hint2="0" width="5843" height="1045" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-vc_Good]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="1" sourceattachpoint="18" destattachpoint="6" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="11319" top="13397" logicalid="37" controlid="7" masterid="0" hint1="0" hint2="0" width="4642" height="965" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-vc_SubdivisionShop]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="3" destid="1" sourceattachpoint="19" destattachpoint="34" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<point x="11619" y="13796" />

<point x="13640" y="13796" />

<point x="13640" y="14062" />

<point x="15661" y="14062" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_StoreALL" left="21397" top="12190" logicalid="38" controlid="8" masterid="0" hint1="0" hint2="0" width="3625" height="4419" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000290e000043110000" />

<property name="LogicalObject" value="dbo_vc_StoreALL" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="18361" top="12662" logicalid="39" controlid="9" masterid="0" hint1="0" hint2="0" width="3336" height="1037" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-vc_StoreALL]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="8" destid="1" sourceattachpoint="16" destattachpoint="31" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<point x="21397" y="13299" />

<point x="20029" y="13299" />

<point x="20029" y="12962" />

<point x="18661" y="12962" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_Character" left="12161" top="44" logicalid="40" controlid="10" masterid="0" hint1="0" hint2="0" width="3281" height="3149" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000d10c00004d0c0000" />

<property name="LogicalObject" value="dbo_vc_Character" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_SaleDiscByDay" left="11589" top="8728" logicalid="41" controlid="11" masterid="0" hint1="0" hint2="0" width="3000" height="3042" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000b80b0000e20b0000" />

<property name="LogicalObject" value="dbo_vc_SaleDiscByDay" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="8134" top="8504" logicalid="42" controlid="12" masterid="0" hint1="0" hint2="0" width="3755" height="945" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_SaleDiscByDay-vc_Calendar]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="4" destid="11" sourceattachpoint="17" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="10256" top="11470" logicalid="43" controlid="13" masterid="0" hint1="0" hint2="0" width="2033" height="1500" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_SaleDiscByDay-vc_SubdivisionShop]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="3" destid="11" sourceattachpoint="10" destattachpoint="1" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<point x="10655" y="12470" />

<point x="10655" y="11962" />

<point x="11322" y="11962" />

<point x="11322" y="12170" />

<point x="11989" y="12170" />

<point x="11989" y="11770" />

<ddscontrol controlprogid="MSDDS.Polyline" left="14289" top="8030" logicalid="44" controlid="14" masterid="0" hint1="0" hint2="0" width="8965" height="1419" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_SaleDiscByDay-vc_Good]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="11" sourceattachpoint="24" destattachpoint="11" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_Moves" left="20176" top="1002" logicalid="45" controlid="15" masterid="0" hint1="0" hint2="0" width="3281" height="3572" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000d10c0000f40d0000" />

<property name="LogicalObject" value="dbo_vc_Moves" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="8134" top="4138" logicalid="46" controlid="16" masterid="0" hint1="0" hint2="0" width="12342" height="3515" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Moves-vc_Calendar]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="4" destid="15" sourceattachpoint="11" destattachpoint="22" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="22616" top="4274" logicalid="47" controlid="17" masterid="0" hint1="0" hint2="0" width="887" height="1605" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Moves-vc_Good]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="15" sourceattachpoint="0" destattachpoint="9" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="t_PriceHistory" left="6343" top="0" logicalid="48" controlid="18" masterid="0" hint1="0" hint2="0" width="3413" height="3811" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000550d0000e30e0000" />

<property name="LogicalObject" value="dbo_t_PriceHistory" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="6535" top="3511" logicalid="49" controlid="19" masterid="0" hint1="0" hint2="0" width="799" height="4114" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[t_PriceHistory-vc_Calendar]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="4" destid="18" sourceattachpoint="4" destattachpoint="1" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="9456" top="3255" logicalid="50" controlid="20" masterid="0" hint1="0" hint2="0" width="13798" height="2824" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[t_PriceHistory-vc_Good]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="18" sourceattachpoint="14" destattachpoint="23" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_PriceTypes" left="0" top="5743" logicalid="51" controlid="21" masterid="0" hint1="0" hint2="0" width="3413" height="2302" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000550d0000fe080000" />

<property name="LogicalObject" value="dbo_vc_PriceTypes" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="3113" top="3255" logicalid="52" controlid="22" masterid="0" hint1="0" hint2="0" width="3530" height="3489" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[t_PriceHistory-vc_PriceTypes]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="21" destid="18" sourceattachpoint="11" destattachpoint="22" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="Time" left="0" top="0" logicalid="53" controlid="23" masterid="0" hint1="0" hint2="0" width="4101" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="000800000510000088130000" />

<property name="LogicalObject" value="Time" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="3801" top="-99" logicalid="54" controlid="24" masterid="0" hint1="0" hint2="0" width="2842" height="1204" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Prices-Time]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="23" destid="18" sourceattachpoint="15" destattachpoint="12" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="3801" top="2101" logicalid="56" controlid="26" masterid="0" hint1="0" hint2="0" width="16675" height="2087" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Moves-Time]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="23" destid="15" sourceattachpoint="23" destattachpoint="20" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="14502" top="2694" logicalid="57" controlid="27" masterid="0" hint1="0" hint2="0" width="1859" height="4731" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-vc_Character1]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="10" destid="1" sourceattachpoint="9" destattachpoint="0" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="9456" top="-45" logicalid="58" controlid="28" masterid="0" hint1="0" hint2="0" width="3005" height="963" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Prices-vc_Character]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="10" destid="18" sourceattachpoint="10" destattachpoint="11" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="3801" top="3751" logicalid="59" controlid="29" masterid="0" hint1="0" hint2="0" width="8088" height="6248" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_SaleDiscByDay-Time]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="23" destid="11" sourceattachpoint="29" destattachpoint="12" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="15142" top="669" logicalid="60" controlid="30" masterid="0" hint1="0" hint2="0" width="5334" height="799" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_Moves-vc_Character]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="10" destid="15" sourceattachpoint="13" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="3801" top="4301" logicalid="62" controlid="32" masterid="0" hint1="0" hint2="0" width="12160" height="3461" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OTP-Time]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="23" destid="1" sourceattachpoint="31" destattachpoint="10" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.3" tooltip="vc_OST" left="7" top="9826" logicalid="63" controlid="33" masterid="0" hint1="0" hint2="0" width="3000" height="3572" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<ddsxmlobjectstreaminitwrapper binary="00080000b80b0000f40d0000" />

<property name="LogicalObject" value="dbo_vc_OST" vartype="8" />

<shape groupshapeid="0" groupnode="0" />

<ddscontrol controlprogid="MSDDS.Polyline" left="2707" top="12350" logicalid="64" controlid="34" masterid="0" hint1="0" hint2="0" width="18990" height="1212" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OST-vc_StoreALL]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="8" destid="33" sourceattachpoint="14" destattachpoint="23" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<point x="21397" y="12749" />

<point x="12202" y="12749" />

<point x="12202" y="13262" />

<ddscontrol controlprogid="MSDDS.Polyline" left="2707" top="9680" logicalid="65" controlid="35" masterid="0" hint1="0" hint2="0" width="20547" height="1132" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OST-vc_Good]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="2" destid="33" sourceattachpoint="30" destattachpoint="13" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<point x="22954" y="10079" />

<point x="12981" y="10079" />

<point x="12981" y="10512" />

<ddscontrol controlprogid="MSDDS.Polyline" left="2707" top="2319" logicalid="67" controlid="37" masterid="0" hint1="0" hint2="0" width="9754" height="7943" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OST-vc_Character]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="10" destid="33" sourceattachpoint="18" destattachpoint="11" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

<ddscontrol controlprogid="MSDDS.Polyline" left="2707" top="12297" logicalid="68" controlid="38" masterid="0" hint1="0" hint2="0" width="5084" height="799" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" />

<property name="LogicalObject" value="dataSet.Relations[vc_OST-vc_SubdivisionShop]" vartype="8" />

<property name="Virtual" value="0" vartype="11" />

<property name="VisibleAP" value="0" vartype="3" />

<connector lineroutestyle="MSDDS.Rectilinear" sourceid="3" destid="33" sourceattachpoint="14" destattachpoint="21" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0">

</DiagramLayout>

<ShowRelationshipNames>False</ShowRelationshipNames>

<UseDiagramDefaultLayout>True</UseDiagramDefaultLayout>

<DiagramViewPortLeft>-6166</DiagramViewPortLeft>

<DiagramViewPortTop>-2332</DiagramViewPortTop>

<DiagramBoundingLeft>0</DiagramBoundingLeft>

<DiagramBoundingTop>0</DiagramBoundingTop>

<DiagramZoom>100</DiagramZoom>

</Diagram>

</Layouts>

</Value>

</Annotation>

</Annotations>

<DataSourceID>DSCube</DataSourceID>

<Schema>

<xs:schema id="DSVCube" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">

<xs:element name="DSVCube" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="708d8e99-43b6-421a-b132-f0ef2e25f2f3">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="dbo_vc_OTP" msprop:design-time-name="c5f37663-20d1-4ffb-9f1c-fcffc3ee306d" msprop:FriendlyName="vc_OTP" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_OTP" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msprop:design-time-name="a7bec9c5-8542-430c-9008-66ef7ecb184a" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:long" />

<xs:element name="date" msprop:design-time-name="3105e9f3-a1fa-48c0-bcb0-2d58c85a753a" msprop:DbColumnName="date" msprop:FriendlyName="date" type="xs:dateTime" minOccurs="0" />

<xs:element name="subdivision_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="a77fc4f9-80ce-44c7-82f5-2880d49ad5f5" msprop:DbColumnName="subdivision_id" msprop:FriendlyName="subdivision_id" type="xs:string" minOccurs="0" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="f924169d-4134-4c84-b839-f98170937bb3" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="character_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="7accdf2f-bdcf-49b0-a32d-afa85b9402bc" msprop:DbColumnName="character_id" msprop:FriendlyName="character_id" type="xs:string" />

<xs:element name="qto" msprop:design-time-name="8b93745d-7977-41a0-a491-314d36ea7e70" msprop:DbColumnName="qto" msprop:FriendlyName="qto" type="xs:long" />

<xs:element name="qtt" msprop:design-time-name="8ec06c7d-a998-49ef-a1ba-6ce51f506df2" msprop:DbColumnName="qtt" msprop:FriendlyName="qtt" type="xs:int" />

<xs:element name="qtp" msprop:design-time-name="44dda37d-d766-42f2-a885-ace33f512e51" msprop:DbColumnName="qtp" msprop:FriendlyName="qtp" type="xs:int" />

<xs:element name="rur" msprop:design-time-name="6eaa4645-3b92-467b-978c-d318500322a9" msprop:DbColumnName="rur" msprop:FriendlyName="rur" type="xs:double" />

<xs:element name="seb" msprop:design-time-name="ac8eff96-dbe9-4707-b40a-24e4d9d9656a" msprop:DbColumnName="seb" msprop:FriendlyName="seb" type="xs:double" minOccurs="0" />

<xs:element name="storage_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="4a48c1ba-e83f-46ba-abee-b5cdbabf802c" msprop:DbColumnName="storage_id" type="xs:string" minOccurs="0" />

<xs:element name="qto_incanto_1" msprop:design-time-name="2e10905f-80bf-4d3e-8552-09320f775ea4" msprop:DbColumnName="qto_incanto_1" type="xs:double" minOccurs="0" />

<xs:element name="qtt_incanto_1" msprop:design-time-name="47e015cc-429b-4c89-8120-db2f95195141" msprop:DbColumnName="qtt_incanto_1" type="xs:double" minOccurs="0" />

<xs:element name="qto_seb_rub" msprop:design-time-name="83b3e713-9d71-4219-b459-ad866e044b13" msprop:DbColumnName="qto_seb_rub" type="xs:double" minOccurs="0" />

<xs:element name="qtt_seb_rub" msprop:design-time-name="00b40a7b-8232-433a-835d-38cf5d476cfc" msprop:DbColumnName="qtt_seb_rub" type="xs:double" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_Good" msprop:design-time-name="88211da6-0f62-46e0-a000-b3f4a2e5bd2a" msprop:FriendlyName="vc_Good" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_Good" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="38851d9a-57fa-47f3-b7b4-507b820e6fc3" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:string" />

<xs:element name="brand_name" msdata:ReadOnly="true" msprop:design-time-name="490a2ec9-6e69-4bb7-af00-2e7ea0170456" msprop:DbColumnName="brand_name" msprop:FriendlyName="brand_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="cat_name" msprop:design-time-name="a5a4f285-b34b-4475-9f42-b261cf1b22d7" msprop:DbColumnName="cat_name" msprop:FriendlyName="cat_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="age" msprop:design-time-name="ce8d70ae-ee19-44aa-bad2-a0dd919e5d98" msprop:DbColumnName="age" msprop:FriendlyName="age" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="gender" msprop:design-time-name="35a5a997-f6b2-4545-baf2-177cd04eabb1" msprop:DbColumnName="gender" msprop:FriendlyName="gender" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="1" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="basic_fashion" msprop:design-time-name="e2afc807-7510-4585-9050-eaab5d7180f1" msprop:DbColumnName="basic_fashion" msprop:FriendlyName="basic_fashion" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="great_grp_name" msdata:ReadOnly="true" msprop:design-time-name="c3142bea-12d0-43c4-a466-80c87bf3eab6" msprop:DbColumnName="great_grp_name" msprop:FriendlyName="great_grp_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="grp_name" msdata:ReadOnly="true" msprop:design-time-name="f1a1ec8d-9a1e-4d41-aa5d-8ebaddcdb421" msprop:DbColumnName="grp_name" msprop:FriendlyName="grp_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="season_name" msdata:ReadOnly="true" msprop:design-time-name="98009d81-3d4a-43ef-96be-24dcb0470c8b" msprop:DbColumnName="season_name" msprop:FriendlyName="season_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="collection_name" msdata:ReadOnly="true" msprop:design-time-name="72ea71c5-cdd0-462e-8bab-965b47b91ff5" msprop:DbColumnName="collection_name" msprop:FriendlyName="collection_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="view_name" msprop:design-time-name="93a215e7-a3e6-443d-a67e-c43ac8a14562" msprop:DbColumnName="view_name" msprop:FriendlyName="view_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="10" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="good_code" msprop:design-time-name="adb0bfd5-7cbf-46f7-9e25-59bc0839bfe9" msprop:DbColumnName="good_code" msprop:FriendlyName="good_code" type="xs:int" minOccurs="0" />

<xs:element name="good_name" msprop:design-time-name="33531e10-048d-411f-ab41-16e40e3c975f" msprop:DbColumnName="good_name" msprop:FriendlyName="good_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="line_name" msdata:ReadOnly="true" msprop:design-time-name="9af8a5e2-f93e-46f6-b40f-3c6172cd1272" msprop:DbColumnName="line_name" msprop:FriendlyName="line_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="line_descr" msdata:ReadOnly="true" msprop:design-time-name="ce30bcb0-fc01-448f-a51d-c7da473b23fc" msprop:DbColumnName="line_descr" msprop:FriendlyName="line_descr">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="type_name" msdata:ReadOnly="true" msprop:design-time-name="cecd486b-4e72-4b92-a87f-a7447cd60b09" msprop:DbColumnName="type_name" msprop:FriendlyName="type_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="construction_name" msdata:ReadOnly="true" msprop:design-time-name="a9543ad9-7ab5-4765-84a0-c82c4c539b0d" msprop:DbColumnName="construction_name" msprop:FriendlyName="construction_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="100" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="season_start" msprop:design-time-name="45706ab4-d6f6-4f69-a5b6-1c1ae19b9e3e" msprop:DbColumnName="season_start" msprop:FriendlyName="season_start" type="xs:dateTime" minOccurs="0" />

<xs:element name="season_end" msprop:design-time-name="e618e60a-66e7-4466-9a68-111309bae327" msprop:DbColumnName="season_end" msprop:FriendlyName="season_end" type="xs:dateTime" minOccurs="0" />

<xs:element name="content_name" msdata:ReadOnly="true" msprop:design-time-name="df6beeb8-1f88-4222-b77d-0761f00cba39" msprop:DbColumnName="content_name" msprop:FriendlyName="content_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="tnved_name" msprop:design-time-name="7535ea76-698c-4184-9f32-b96b14fc13d0" msprop:DbColumnName="tnved_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="250" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="good_cup" msprop:design-time-name="6c921852-f2e6-4cd1-aac6-49c15e2ede43" msprop:DbColumnName="good_cup" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="good_art" msprop:design-time-name="6f831f43-46eb-443a-a053-46c4e269794a" msprop:DbColumnName="good_art" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="cup" msprop:design-time-name="2b792754-103c-48b8-ab3a-fa5e28438a5a" msprop:DbColumnName="cup" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="1" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="complect" msprop:design-time-name="46988854-ff67-4582-9886-b18a7544ddbb" msprop:DbColumnName="complect" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="208" />

</xs:restriction>

</xs:simpleType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_SubdivisionShop" msprop:design-time-name="ba40322f-5745-41cc-9b96-f1943a66ff3d" msprop:FriendlyName="vc_SubdivisionShop" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_SubdivisionShop" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="34c5ffdc-0f2e-4e59-9114-25c03290d346" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:string" />

<xs:element name="subdivision_city_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="5b35cde0-8041-4600-ba80-79c7b74d8c4b" msprop:DbColumnName="subdivision_city_id" msprop:FriendlyName="subdivision_city_id" type="xs:string" minOccurs="0" />

<xs:element name="subdivision_channel_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="a514d08c-d111-45db-b083-6f6894725589" msprop:DbColumnName="subdivision_channel_id" msprop:FriendlyName="subdivision_channel_id" type="xs:string" minOccurs="0" />

<xs:element name="parent_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="6a0d68e5-ccf0-451a-b4c5-42aeb3af1c5b" msprop:DbColumnName="parent_id" msprop:FriendlyName="parent_id" type="xs:string" minOccurs="0" />

<xs:element name="marked" msprop:design-time-name="f3285fa5-8e93-481d-a67b-0d315a3379a4" msprop:DbColumnName="marked" msprop:FriendlyName="marked" type="xs:boolean" />

<xs:element name="subdivision_channel" msprop:design-time-name="a11e7736-60e1-4b69-ac5f-01a9bc8d1733" msprop:DbColumnName="subdivision_channel" msprop:FriendlyName="subdivision_channel" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="subdivision_city" msprop:design-time-name="35fdd8c4-967a-46dd-98a5-b52eb2276a3e" msprop:DbColumnName="subdivision_city" msprop:FriendlyName="subdivision_city" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="subdivision_name" msprop:design-time-name="ef4bc4ce-b2d5-4bee-b3fa-2733dfb11d83" msprop:DbColumnName="subdivision_name" msprop:FriendlyName="subdivision_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="date_open" msprop:design-time-name="55b754d2-b28c-42d9-b8c4-09f26ee682ff" msprop:DbColumnName="date_open" msprop:FriendlyName="date_open" type="xs:dateTime" minOccurs="0" />

<xs:element name="date_close" msprop:design-time-name="b0078b2b-e8af-46a1-9177-b7b59f646ff9" msprop:DbColumnName="date_close" msprop:FriendlyName="date_close" type="xs:dateTime" minOccurs="0" />

<xs:element name="discount" msprop:design-time-name="6c7d0918-526a-4ec4-a5d7-029e739d7381" msprop:DbColumnName="discount" msprop:FriendlyName="discount" type="xs:boolean" minOccurs="0" />

<xs:element name="franch" msprop:design-time-name="dfca560c-033a-4920-894b-eb2cb0531f58" msprop:DbColumnName="franch" msprop:FriendlyName="franch" type="xs:boolean" minOccurs="0" />

<xs:element name="shop_volume" msprop:design-time-name="5fe599a3-96c2-4e94-982c-258825082f3a" msprop:DbColumnName="shop_volume" msprop:FriendlyName="shop_volume" type="xs:int" minOccurs="0" />

<xs:element name="shop_mail" msprop:design-time-name="239741a4-16fb-412d-932a-2158f3b462d4" msprop:DbColumnName="shop_mail" msprop:FriendlyName="shop_mail" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="manager" msprop:design-time-name="f7309474-701a-4cc0-8d53-9329e1213975" msprop:DbColumnName="manager" msprop:FriendlyName="manager" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="100" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="shop_area" msprop:design-time-name="30a5b4e0-bf5e-4bf1-ba65-42fedf32c6e7" msprop:DbColumnName="shop_area" msprop:FriendlyName="shop_area" type="xs:double" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_Calendar" msprop:design-time-name="cb1ded64-17fa-4dab-bac1-aad49fc48c2b" msprop:FriendlyName="vc_Calendar" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_Calendar" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="date" msprop:design-time-name="8cc5d0b4-1c77-4a5f-8bcc-aeccc848147c" msprop:DbColumnName="date" msprop:FriendlyName="date" type="xs:dateTime" />

<xs:element name="yyyy" msprop:design-time-name="e347df3b-3339-411e-830f-c5556195b606" msprop:DbColumnName="yyyy" msprop:FriendlyName="yyyy" type="xs:short" minOccurs="0" />

<xs:element name="mm" msprop:design-time-name="b5a4c7f7-4868-4a15-9b8e-14de75faf2e5" msprop:DbColumnName="mm" msprop:FriendlyName="mm" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="2" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="dd" msprop:design-time-name="187c6d81-4c14-4f88-8c55-7746c9c710aa" msprop:DbColumnName="dd" msprop:FriendlyName="dd" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="2" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="dw" msprop:design-time-name="f67ce7cf-3d8c-4abe-aa3e-e034b7b32268" msprop:DbColumnName="dw" msprop:FriendlyName="dw" type="xs:unsignedByte" minOccurs="0" />

<xs:element name="dw2" msprop:design-time-name="db0f3f09-fbd1-45f6-8ded-0c5a814f947e" msprop:DbColumnName="dw2" msprop:FriendlyName="dw2" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="2" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="hy" msprop:design-time-name="060e0704-52a3-4b0f-8510-2c309d0515a9" msprop:DbColumnName="hy" type="xs:unsignedByte" minOccurs="0" />

<xs:element name="quarter" msprop:design-time-name="1869ffc8-b707-4f3a-9350-349369e65d09" msprop:DbColumnName="quarter" type="xs:unsignedByte" minOccurs="0" />

<xs:element name="woy" msprop:design-time-name="c627bb7f-b6a9-4ba1-9321-8c585962f51c" msprop:DbColumnName="woy" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="2" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="date_week" msprop:design-time-name="03ae48a3-8c3c-419a-b267-d07d1167d574" msprop:DbColumnName="date_week" type="xs:dateTime" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_StoreALL" msprop:design-time-name="dced404d-d8a0-462b-aecb-74de76a35ae3" msprop:FriendlyName="vc_StoreALL" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_StoreALL" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="storage_name_gr3" msprop:design-time-name="07c2bfc4-655a-43a0-b3a1-4e2f7908a552" msprop:DbColumnName="storage_name_gr3" msprop:FriendlyName="storage_name_gr3" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="storage_name_gr2" msprop:design-time-name="68937584-0f57-426c-8e51-41af332c5345" msprop:DbColumnName="storage_name_gr2" msprop:FriendlyName="storage_name_gr2" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="400" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="storage_name_gr1" msprop:design-time-name="e1abd3ae-5d6f-4f42-a72f-926b7ac3a928" msprop:DbColumnName="storage_name_gr1" msprop:FriendlyName="storage_name_gr1" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="8954940e-27ef-4bc4-ad33-66ce1e509c03" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:string" />

<xs:element name="storage_name" msprop:design-time-name="0186f0c1-9257-4860-9142-428d12fb7d07" msprop:DbColumnName="storage_name" msprop:FriendlyName="storage_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="days_on_the_way" msprop:design-time-name="df7959da-7bcd-4887-831e-8b3f193b68fa" msprop:DbColumnName="days_on_the_way" msprop:FriendlyName="days_on_the_way" type="xs:int" minOccurs="0" />

<xs:element name="subdivision_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="e72b2133-61af-470a-9f6b-da75acb95371" msprop:DbColumnName="subdivision_id" msprop:FriendlyName="subdivision_id" type="xs:string" minOccurs="0" />

<xs:element name="subdivision_name" msprop:design-time-name="41695208-2432-4772-b7c7-def767152743" msprop:DbColumnName="subdivision_name" msprop:FriendlyName="subdivision_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="200" />

</xs:restriction>

</xs:simpleType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_Character" msprop:design-time-name="0c412db6-db75-41aa-8db8-e36c9abf1973" msprop:FriendlyName="vc_Character" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_Character" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="ca7da628-f77c-4d04-b53c-98ec0b7a229a" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:string" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="2fd7c0e7-30b2-48eb-b6da-03fc292011ee" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="character_name" msprop:design-time-name="bdab98ca-c001-4843-9837-2aed114544cc" msprop:DbColumnName="character_name" msprop:FriendlyName="character_name">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="100" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="color_name" msprop:design-time-name="17a55651-65ad-4684-93d6-2fdd28185be5" msprop:DbColumnName="color_name" msprop:FriendlyName="color_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="100" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="size_name" msprop:design-time-name="b62c1a2e-2814-4e44-a2f4-4f28ff940ff6" msprop:DbColumnName="size_name" msprop:FriendlyName="size_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="25" />

</xs:restriction>

</xs:simpleType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_SaleDiscByDay" msprop:design-time-name="f64381e5-adcc-4dd5-acd0-c1fafc7b34cc" msprop:FriendlyName="vc_SaleDiscByDay" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_SaleDiscByDay" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="date" msprop:design-time-name="ad661352-1268-49c9-bae3-a1e4d88cfff8" msprop:DbColumnName="date" msprop:FriendlyName="date" type="xs:dateTime" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="314c36af-1660-48bb-8e51-5f468b2358cb" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="delta" msdata:ReadOnly="true" msprop:design-time-name="fd7f425e-cc53-404a-a37c-58f2b91e7f6b" msprop:DbColumnName="delta" msprop:FriendlyName="delta" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="5" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="discount" msdata:ReadOnly="true" msprop:design-time-name="959160af-d8cf-48f8-8271-4b518c641367" msprop:DbColumnName="discount" msprop:FriendlyName="discount" type="xs:boolean" />

<xs:element name="delta_value" msprop:design-time-name="749faae8-d5db-4d86-92e2-9cba31b1d7b5" msprop:DbColumnName="delta_value" type="xs:double" minOccurs="0" />

<xs:element name="id" msprop:design-time-name="d9006fb0-a91f-45e3-8852-9e47401f8c61" msprop:DbColumnName="id" type="xs:long" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_Moves" msprop:design-time-name="c9d0e3b0-d808-4e60-a1bd-daca9415d5e4" msprop:FriendlyName="vc_Moves" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_Moves" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msprop:design-time-name="f081082b-9222-459b-a783-cf07c98a31b2" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:long" />

<xs:element name="date" msprop:design-time-name="3e0f561b-df58-477f-9b9f-a014d598afe5" msprop:DbColumnName="date" msprop:FriendlyName="date" type="xs:dateTime" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="d801b1da-5fac-44c6-b876-9bb6f08b8a46" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="character_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="1d5eb7ce-18b7-468c-a93a-eec0549b5d01" msprop:DbColumnName="character_id" msprop:FriendlyName="character_id" type="xs:string" />

<xs:element name="quantity" msprop:design-time-name="bfa54b76-f2fc-4261-a072-e67215ffa0d3" msprop:DbColumnName="quantity" msprop:FriendlyName="quantity" type="xs:int" />

<xs:element name="movement_view" msprop:design-time-name="0b39b92f-9f68-4a8a-801b-e9d884a4b213" msprop:DbColumnName="movement_view" msprop:FriendlyName="movement_view">

<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_t_PriceHistory" msprop:design-time-name="53fd534d-bb7a-4153-9216-4dc2026b4405" msprop:FriendlyName="t_PriceHistory" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_Prices" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msprop:design-time-name="3643ea7a-1662-409a-9f00-b210f9f88fc1" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:long" />

<xs:element name="price_type_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="fce1deb6-6187-479c-84f1-e941f577af55" msprop:DbColumnName="price_type_id" msprop:FriendlyName="price_type_id" type="xs:string" minOccurs="0" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="c9bfd500-5a94-4cad-ad4d-5c872897f4c6" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="character_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="d056ebb9-c418-4f7f-aa52-776b3a35d85a" msprop:DbColumnName="character_id" msprop:FriendlyName="character_id" type="xs:string" />

<xs:element name="price_value" msprop:design-time-name="23f50883-361b-47bc-8b7c-9bd51d450017" msprop:DbColumnName="price_value" msprop:FriendlyName="price_value" type="xs:double" minOccurs="0" />

<xs:element name="include_nds" msprop:design-time-name="d3639ce5-88a8-4596-a095-c1adebd608a8" msprop:DbColumnName="include_nds" msprop:FriendlyName="include_nds" type="xs:boolean" minOccurs="0" />

<xs:element name="date" msprop:design-time-name="d6a616ee-bf43-49ed-a074-21c6faf56394" msprop:DbColumnName="date" msprop:FriendlyName="date" type="xs:dateTime" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="dbo_vc_PriceTypes" msprop:design-time-name="1a374f35-db50-45be-a707-a11238a58edd" msprop:FriendlyName="vc_PriceTypes" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_PriceTypes" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="3086f8da-bb5e-4598-abc2-355c5c258d8a" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:string" />

<xs:element name="price_type_name" msdata:ReadOnly="true" msprop:design-time-name="ef195768-7fe5-4ac6-b5e3-d10a98586d28" msprop:DbColumnName="price_type_name" msprop:FriendlyName="price_type_name" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="308" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="includesNDS" msprop:design-time-name="935d69e3-6b88-40c8-9a13-8f11074322dd" msprop:DbColumnName="includesNDS" msprop:FriendlyName="includesNDS" type="xs:boolean" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element name="Time" msprop:design-time-name="8192625f-bced-4d5f-afe8-b0da0c53a232" msprop:FriendlyName="Time" msprop:DbSchemaName="dbo" msprop:AllowGen="True" msprop:TableType="Table" msprop:DbTableName="Time">

<xs:complexType>

<xs:sequence>

<xs:element name="Date" msprop:design-time-name="f2919655-1071-4fa0-a027-d0310a8f6460" msprop:FriendlyName="PK_Date" msprop:DbColumnName="PK_Date" msprop:AllowGen="True" type="xs:dateTime" />

<xs:element name="Date_Name" msprop:design-time-name="8ccd8446-ad6c-40c0-8d1a-0c48d0a2f8f6" msprop:FriendlyName="Date_Name" msprop:DbColumnName="Date_Name" msprop:AllowGen="True" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Year" msprop:design-time-name="c40f070d-2615-4f7f-9e32-9a76ff12a35b" msprop:FriendlyName="Year" msprop:DbColumnName="Year" msprop:AllowGen="True" type="xs:dateTime" minOccurs="0" />

<xs:element name="Year_Name" msprop:design-time-name="17808a6b-fd9c-46fa-a7d4-10c3f569432e" msprop:FriendlyName="Year_Name" msprop:DbColumnName="Year_Name" msprop:AllowGen="True" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Month" msprop:design-time-name="a88129c8-84eb-414a-8c7b-40d7827d6767" msprop:FriendlyName="Month" msprop:DbColumnName="Month" msprop:AllowGen="True" type="xs:dateTime" minOccurs="0" />

<xs:element name="Month_Name" msprop:design-time-name="d7d48bdd-2800-4bb0-81e2-c59b0739523f" msprop:FriendlyName="Month_Name" msprop:DbColumnName="Month_Name" msprop:AllowGen="True" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Day_Of_Year" msprop:design-time-name="d306a733-3b1a-42b5-acc9-a22675ed1ca3" msprop:FriendlyName="Day_Of_Year" msprop:DbColumnName="Day_Of_Year" msprop:AllowGen="True" type="xs:int" minOccurs="0" />

<xs:element name="Day_Of_Year_Name" msprop:design-time-name="350ec3e0-8cfd-448c-9a08-cb0ba7d31b12" msprop:FriendlyName="Day_Of_Year_Name" msprop:DbColumnName="Day_Of_Year_Name" msprop:AllowGen="True" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Day_Of_Month" msprop:design-time-name="f27a43b1-387c-4ef9-8f74-bbb89d0d7735" msprop:FriendlyName="Day_Of_Month" msprop:DbColumnName="Day_Of_Month" msprop:AllowGen="True" type="xs:int" minOccurs="0" />

<xs:element name="Day_Of_Month_Name" msprop:design-time-name="42c73623-09f9-4704-a670-097db0d8e64f" msprop:FriendlyName="Day_Of_Month_Name" msprop:DbColumnName="Day_Of_Month_Name" msprop:AllowGen="True" minOccurs="0">

<xs:simpleType>

<xs:restriction base="xs:string">

<xs:maxLength value="50" />

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Month_Of_Year" msprop:design-time-name="679cb049-94a4-4b2a-b2b8-4cb948cf0877" msprop:FriendlyName="Month_Of_Year" msprop:DbColumnName="Month_Of_Year" msprop:AllowGen="True" type="xs:int" minOccurs="0" />

<xs:element name="Month_Of_Year_Name" msprop:design-time-name="d28e1d1d-b5fa-411e-8267-cf453b26abb8" msprop:FriendlyName="Month_Of_Year_Name" msprop:DbColumnName="Month_Of_Year_Name" msprop:AllowGen="True" 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_vc_OST" msprop:design-time-name="f86dea26-967c-4a5e-a3b4-0759562ecfb7" msprop:FriendlyName="vc_OST" msprop:DbSchemaName="dbo" msprop:DbTableName="vc_OST" msprop:TableType="View">

<xs:complexType>

<xs:sequence>

<xs:element name="id" msprop:design-time-name="23086275-74b1-4005-a9a0-c20a17373f72" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:long" />

<xs:element name="storage_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="8f82a488-bcd4-4128-8744-51bd67b46609" msprop:DbColumnName="storage_id" msprop:FriendlyName="storage_id" type="xs:string" />

<xs:element name="good_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="feaa4a4c-4340-4131-9233-90132b235d2a" msprop:DbColumnName="good_id" msprop:FriendlyName="good_id" type="xs:string" />

<xs:element name="character_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="081021be-d580-4f05-80b4-880e71331ac3" msprop:DbColumnName="character_id" msprop:FriendlyName="character_id" type="xs:string" />

<xs:element name="subdivision_id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:design-time-name="e6a07e01-1003-4b18-8b65-1edd1720873d" msprop:DbColumnName="subdivision_id" type="xs:string" minOccurs="0" />

<xs:element name="ost" msprop:design-time-name="3cf2c2e7-d672-4421-8926-09aa43019772" msprop:DbColumnName="ost" type="xs:long" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

<xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_OTP" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_vc_Good_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_Good" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="Constraint2" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_SubdivisionShop" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_vc_Calendar_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_Calendar" />

<xs:field xpath="date" />

</xs:unique>

<xs:unique name="dbo_vc_StoreALL_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_StoreALL" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_vc_Character_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_Character" />

<xs:field xpath="id" />

<xs:field xpath="good_id" />

</xs:unique>

<xs:unique name="dbo_vc_SaleDiscByDay_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_SaleDiscByDay" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_vc_Moves_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_Moves" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_t_PriceHistory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_t_PriceHistory" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="dbo_vc_PriceTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_PriceTypes" />

<xs:field xpath="id" />

</xs:unique>

<xs:unique name="PK_Time" msprop:AllowGen="True" msdata:PrimaryKey="true">

<xs:selector xpath=".//Time" />

<xs:field xpath="Date" />

</xs:unique>

<xs:unique name="dbo_vc_OST_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">

<xs:selector xpath=".//dbo_vc_OST" />

<xs:field xpath="id" />

</xs:unique>

</xs:element>

<xs:annotation>

<xs:appinfo>

<msdata:Relationship name="vc_OTP-vc_Calendar" msdata:parent="dbo_vc_Calendar" msdata:child="dbo_vc_OTP" msdata:parentkey="date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OTP-vc_Good" msdata:parent="dbo_vc_Good" msdata:child="dbo_vc_OTP" msdata:parentkey="id" msdata:childkey="good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OTP-vc_SubdivisionShop" msdata:parent="dbo_vc_SubdivisionShop" msdata:child="dbo_vc_OTP" msdata:parentkey="id" msdata:childkey="subdivision_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OTP-vc_StoreALL" msdata:parent="dbo_vc_StoreALL" msdata:child="dbo_vc_OTP" msdata:parentkey="id" msdata:childkey="storage_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_SaleDiscByDay-vc_Calendar" msdata:parent="dbo_vc_Calendar" msdata:child="dbo_vc_SaleDiscByDay" msdata:parentkey="date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_SaleDiscByDay-vc_SubdivisionShop" msdata:parent="dbo_vc_SubdivisionShop" msdata:child="dbo_vc_SaleDiscByDay" msdata:parentkey="discount" msdata:childkey="discount" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_SaleDiscByDay-vc_Good" msdata:parent="dbo_vc_Good" msdata:child="dbo_vc_SaleDiscByDay" msdata:parentkey="id" msdata:childkey="good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Moves-vc_Calendar" msdata:parent="dbo_vc_Calendar" msdata:child="dbo_vc_Moves" msdata:parentkey="date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Moves-vc_Good" msdata:parent="dbo_vc_Good" msdata:child="dbo_vc_Moves" msdata:parentkey="id" msdata:childkey="good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="t_PriceHistory-vc_Calendar" msdata:parent="dbo_vc_Calendar" msdata:child="dbo_t_PriceHistory" msdata:parentkey="date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="t_PriceHistory-vc_Good" msdata:parent="dbo_vc_Good" msdata:child="dbo_t_PriceHistory" msdata:parentkey="id" msdata:childkey="good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="t_PriceHistory-vc_PriceTypes" msdata:parent="dbo_vc_PriceTypes" msdata:child="dbo_t_PriceHistory" msdata:parentkey="id" msdata:childkey="price_type_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Prices-Time" msdata:parent="Time" msdata:child="dbo_t_PriceHistory" msdata:parentkey="Date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Moves-Time" msdata:parent="Time" msdata:child="dbo_vc_Moves" msdata:parentkey="Date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OTP-vc_Character1" msdata:parent="dbo_vc_Character" msdata:child="dbo_vc_OTP" msdata:parentkey="id good_id" msdata:childkey="character_id good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Prices-vc_Character" msdata:parent="dbo_vc_Character" msdata:child="dbo_t_PriceHistory" msdata:parentkey="id good_id" msdata:childkey="character_id good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_SaleDiscByDay-Time" msdata:parent="Time" msdata:child="dbo_vc_SaleDiscByDay" msdata:parentkey="Date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_Moves-vc_Character" msdata:parent="dbo_vc_Character" msdata:child="dbo_vc_Moves" msdata:parentkey="id good_id" msdata:childkey="character_id good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OTP-Time" msdata:parent="Time" msdata:child="dbo_vc_OTP" msdata:parentkey="Date" msdata:childkey="date" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OST-vc_StoreALL" msdata:parent="dbo_vc_StoreALL" msdata:child="dbo_vc_OST" msdata:parentkey="id" msdata:childkey="storage_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OST-vc_Good" msdata:parent="dbo_vc_Good" msdata:child="dbo_vc_OST" msdata:parentkey="id" msdata:childkey="good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OST-vc_Character" msdata:parent="dbo_vc_Character" msdata:child="dbo_vc_OST" msdata:parentkey="id good_id" msdata:childkey="character_id good_id" msprop:IsLogical="True" msprop:Description="" />

<msdata:Relationship name="vc_OST-vc_SubdivisionShop" msdata:parent="dbo_vc_SubdivisionShop" msdata:child="dbo_vc_OST" msdata:parentkey="id" msdata:childkey="subdivision_id" msprop:IsLogical="True" msprop:Description="" />

</xs:appinfo>

</xs:annotation>

</xs:schema>

<DSVCube xmlns="" />

</Schema>

</DataSourceView>