| name | value |
|---|---|
| name | DimCustomer |
| data source view | AdventureWorksDW |
| case sensitive | False |
| display expression | |
| friendly name | DimCustomer |
| db schema name | dbo |
| db table name | DimCustomer |
| type | Table |
| name | nulls | caption | data type | ordinal | unique | auto increment | auto increment seed | auto increment step | datetime mode | max length | is logical | db column name | computed column expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CustomerKey | False | CustomerKey | Int32 | 0 | True | True | 0 | 1 | |||||
| GeographyKey | True | GeographyKey | Int32 | 1 | False | ||||||||
| CustomerAlternateKey | False | CustomerAlternateKey | String | 2 | False | 15 | |||||||
| Title | True | Title | String | 3 | False | 8 | |||||||
| FirstName | True | FirstName | String | 4 | False | 50 | |||||||
| MiddleName | True | MiddleName | String | 5 | False | 50 | |||||||
| LastName | True | LastName | String | 6 | False | 50 | |||||||
| NameStyle | True | NameStyle | Boolean | 7 | False | ||||||||
| BirthDate | True | BirthDate | DateTime | 8 | False | UnspecifiedLocal | |||||||
| MaritalStatus | True | MaritalStatus | String | 9 | False | 1 | |||||||
| Suffix | True | Suffix | String | 10 | False | 10 | |||||||
| Gender | True | Gender | String | 11 | False | 1 | |||||||
| EmailAddress | True | EmailAddress | String | 12 | False | 50 | |||||||
| YearlyIncome | True | YearlyIncome | Decimal | 13 | False | ||||||||
| TotalChildren | True | TotalChildren | Byte | 14 | False | ||||||||
| NumberChildrenAtHome | True | NumberChildrenAtHome | Byte | 15 | False | ||||||||
| EnglishEducation | True | EnglishEducation | String | 16 | False | 40 | |||||||
| SpanishEducation | True | SpanishEducation | String | 17 | False | 40 | |||||||
| FrenchEducation | True | FrenchEducation | String | 18 | False | 40 | |||||||
| EnglishOccupation | True | EnglishOccupation | String | 19 | False | 100 | |||||||
| SpanishOccupation | True | SpanishOccupation | String | 20 | False | 100 | |||||||
| FrenchOccupation | True | FrenchOccupation | String | 21 | False | 100 | |||||||
| HouseOwnerFlag | True | HouseOwnerFlag | String | 22 | False | 1 | |||||||
| NumberCarsOwned | True | NumberCarsOwned | Byte | 23 | False | ||||||||
| AddressLine1 | True | AddressLine1 | String | 24 | False | 120 | |||||||
| AddressLine2 | True | AddressLine2 | String | 25 | False | 120 | |||||||
| Phone | True | Phone | String | 26 | False | 20 | |||||||
| DateFirstPurchase | True | DateFirstPurchase | DateTime | 27 | False | UnspecifiedLocal | |||||||
| CommuteDistance | True | CommuteDistance | String | 28 | False | 15 | |||||||
| FullName | True | FullName | String | 29 | False | 152 | True | FullName | show/hide | ||||
| GenderDesc | True | GenderDesc | String | 30 | False | 6 | True | GenderDesc | show/hide | ||||
| MaritalStatusDesc | True | MaritalStatusDesc | String | 31 | False | 7 | True | MaritalStatusDesc | show/hide |
| parent column | child column | relation name | nested |
|---|---|---|---|
| DimGeography. | DimCustomer. | FK_DimCustomer_GeographyKey | False |
| parent column | child column | relation name | nested |
|---|---|---|---|
| DimGeography. | DimCustomer. | FK_DimCustomer_GeographyKey | False |
| name | object type | level |
|---|---|---|
| AdventureWorksDW | DataSourceView | 1 |
| AmoAdventureWorks | Database | 2 |