📄 data mining tables.dsv
字号:
</xs:simpleType>
</xs:element>
<xs:element name="EnglishOccupation" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="82e54b74-4ca5-4b38-808e-7bc08113c5bf" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="HouseOwnerFlag" msprop:FriendlyName="HouseOwnerFlag" msprop:DbColumnName="HouseOwnerFlag" msprop:design-time-name="e5cbcd0e-8793-4ca7-be47-e1696ee1423c" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NumberCarsOwned" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="18a70eee-ddb0-428a-84c9-95d7b7835725" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="DateFirstPurchase" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="13011206-c029-4e6d-9144-1201af9b06b1" type="xs:dateTime" minOccurs="0" />
<xs:element name="CommuteDistance" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="aa7013d8-6bac-4b4e-b212-e8a6149a1152" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StateProvinceName" msprop:FriendlyName="StateProvinceName" msprop:DbColumnName="StateProvinceName" msprop:design-time-name="5ed94aae-e6a2-4c4e-a976-b6acf5839e09" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EnglishCountryRegionName" msprop:FriendlyName="EnglishCountryRegionName" msprop:DbColumnName="EnglishCountryRegionName" msprop:design-time-name="7aedb498-0cc3-4bbf-9699-e22b5e914310" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PostalCode" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="7f88634f-2a11-4a0f-b46c-e38579cc834e" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="City" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="a013827e-7cc9-47cc-9524-29305687f3c3" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DMDemoCustAll" msprop:QueryDefinition="SELECT CustomerKey, FirstName, MiddleName, LastName, NameStyle, BirthDate, MaritalStatus, Gender, YearlyIncome, TotalChildren, NumberChildrenAtHome, EnglishEducation, EnglishOccupation, HouseOwnerFlag, NumberCarsOwned, DateFirstPurchase, CommuteDistance, 
 StateProvinceName, EnglishCountryRegionName, PostalCode, City
FROM DMDemoCustTest
UNION
SELECT CustomerKey, FirstName, MiddleName, LastName, NameStyle, BirthDate, MaritalStatus, Gender, YearlyIncome, TotalChildren, NumberChildrenAtHome, EnglishEducation, EnglishOccupation, HouseOwnerFlag, NumberCarsOwned, DateFirstPurchase, CommuteDistance, 
 StateProvinceName, EnglishCountryRegionName, PostalCode, City
FROM DMDemoCustTrain" msprop:DbTableName="DMDemoCustAll" msprop:QueryBuilder="SpecificQueryBuilder" msprop:IsLogical="True" msprop:FriendlyName="DMDemoCustAll" msprop:design-time-name="2c035280-8b17-49bf-8537-7331c1edb394" msprop:TableType="View" msprop:Description="">
<xs:complexType>
<xs:sequence>
<xs:element name="CustomerKey" msdata:ReadOnly="true" msprop:FriendlyName="CustomerKey" msprop:DbColumnName="CustomerKey" msprop:design-time-name="b244528c-9c0d-426a-a9ad-8b634c9d77d6" type="xs:int" />
<xs:element name="FirstName" msdata:ReadOnly="true" msprop:FriendlyName="FirstName" msprop:DbColumnName="FirstName" msprop:design-time-name="fa1893a8-91ab-4ea1-b052-9065e3918b5c" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MiddleName" msdata:ReadOnly="true" msprop:FriendlyName="MiddleName" msprop:DbColumnName="MiddleName" msprop:design-time-name="12c22465-6039-4041-b9ef-1459b10652d9" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="LastName" msdata:ReadOnly="true" msprop:FriendlyName="LastName" msprop:DbColumnName="LastName" msprop:design-time-name="37d4eeef-8422-43af-af92-6a460aaca572" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NameStyle" msdata:ReadOnly="true" msprop:FriendlyName="NameStyle" msprop:DbColumnName="NameStyle" msprop:design-time-name="dca4ee2d-6a5c-4803-a2ae-6c50fa9f2f3a" type="xs:boolean" minOccurs="0" />
<xs:element name="BirthDate" msdata:ReadOnly="true" msprop:FriendlyName="BirthDate" msprop:DbColumnName="BirthDate" msprop:design-time-name="f4a7ff3c-b41f-4685-b48c-f39053b6211b" type="xs:dateTime" minOccurs="0" />
<xs:element name="MaritalStatus" msdata:ReadOnly="true" msprop:FriendlyName="MaritalStatus" msprop:DbColumnName="MaritalStatus" msprop:design-time-name="35fcfe4e-267b-4faa-b728-2828d98b3cb1" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Gender" msdata:ReadOnly="true" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="363c5975-28d3-4c54-b8f6-916d135569ad" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="YearlyIncome" msdata:ReadOnly="true" msprop:FriendlyName="YearlyIncome" msprop:DbColumnName="YearlyIncome" msprop:design-time-name="72aacaf2-fdc9-472e-830a-4788bd2768b2" type="xs:decimal" minOccurs="0" />
<xs:element name="TotalChildren" msdata:ReadOnly="true" msprop:FriendlyName="TotalChildren" msprop:DbColumnName="TotalChildren" msprop:design-time-name="e1a391a7-10b5-4f99-9d28-13f81a9717bc" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="NumberChildrenAtHome" msdata:ReadOnly="true" msprop:FriendlyName="NumberChildrenAtHome" msprop:DbColumnName="NumberChildrenAtHome" msprop:design-time-name="5236ab17-053d-4c64-9b57-3e1f0708db87" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="EnglishEducation" msdata:ReadOnly="true" msprop:FriendlyName="EnglishEducation" msprop:DbColumnName="EnglishEducation" msprop:design-time-name="59df3b66-d44b-4650-9bc2-7fe8ce76db92" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="40" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EnglishOccupation" msdata:ReadOnly="true" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="f330e677-aa51-4ba5-acd4-3f7c54fba0ae" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="HouseOwnerFlag" msdata:ReadOnly="true" msprop:FriendlyName="HouseOwnerFlag" msprop:DbColumnName="HouseOwnerFlag" msprop:design-time-name="e405501d-7062-46fb-9fb5-8b5df64a2dbc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NumberCarsOwned" msdata:ReadOnly="true" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="30ab4c07-2d46-47d5-a522-7a6bf4452065" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="DateFirstPurchase" msdata:ReadOnly="true" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="fce154b7-d762-438c-b3f7-04055a163ff4" type="xs:dateTime" minOccurs="0" />
<xs:element name="CommuteDistance" msdata:ReadOnly="true" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="e7a665fe-8c20-4134-88a4-cdd505f4e531" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StateProvinceName" msdata:ReadOnly="true" msprop:FriendlyName="StateProvinceName" msprop:DbColumnName="StateProvinceName" msprop:design-time-name="5a874fcf-f36b-41dc-9475-c767e13789c5" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EnglishCountryRegionName" msdata:ReadOnly="true" msprop:FriendlyName="EnglishCountryRegionName" msprop:DbColumnName="EnglishCountryRegionName" msprop:design-time-name="e5486867-39e7-4ac8-be23-151497e4c010" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PostalCode" msdata:ReadOnly="true" msprop:FriendlyName="PostalCode" msprop:DbColumnName="PostalCode" msprop:design-time-name="3e67bc0a-8e51-497e-99ce-9ecaf38e57b5" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="City" msdata:ReadOnly="true" msprop:FriendlyName="City" msprop:DbColumnName="City" msprop:design-time-name="19287f6c-7c02-4130-8ab0-0acaf3886733" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
<xs:selector xpath=".//dbo_DMDemoCustTest" />
<xs:field xpath="CustomerKey" />
</xs:unique>
<xs:unique name="dbo_DMDemoCustTrain_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
<xs:selector xpath=".//dbo_DMDemoCustTrain" />
<xs:field xpath="CustomerKey" />
</xs:unique>
<xs:unique name="DMDemoCustAll_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
<xs:selector xpath=".//DMDemoCustAll" />
<xs:field xpath="CustomerKey" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="DMDemoCustPurch-DMDemoCustTest" msdata:parent="dbo_DMDemoCustTest" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
<msdata:Relationship name="DMDemoCustPurch-DMDemoCustTrain" msdata:parent="dbo_DMDemoCustTrain" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
<msdata:Relationship name="DMDemoCustPurch-DMDemoCustAll" msdata:parent="DMDemoCustAll" msdata:child="dbo_DMDemoCustPurch" msdata:parentkey="CustomerKey" msdata:childkey="CustomerKey" msprop:Description="" msprop:IsLogical="True" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
</Schema>
</DataSourceView>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -