| name | value |
|---|---|
| name | DimProduct |
| data source view | AdventureWorksDW |
| case sensitive | False |
| display expression | |
| friendly name | DimProduct |
| db schema name | dbo |
| db table name | DimProduct |
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ProductKey | False | ProductKey | Int32 | 0 | True | True | 0 | 1 | |||||
| ProductAlternateKey | True | ProductAlternateKey | String | 1 | False | 25 | |||||||
| ProductSubcategoryKey | True | ProductSubcategoryKey | Int32 | 2 | False | ||||||||
| WeightUnitMeasureCode | True | WeightUnitMeasureCode | String | 3 | False | 3 | |||||||
| SizeUnitMeasureCode | True | SizeUnitMeasureCode | String | 4 | False | 3 | |||||||
| EnglishProductName | False | EnglishProductName | String | 5 | False | 50 | |||||||
| SpanishProductName | False | SpanishProductName | String | 6 | False | 50 | |||||||
| FrenchProductName | False | FrenchProductName | String | 7 | False | 50 | |||||||
| StandardCost | True | StandardCost | Decimal | 8 | False | ||||||||
| FinishedGoodsFlag | False | FinishedGoodsFlag | Boolean | 9 | False | ||||||||
| Color | False | Color | String | 10 | False | 15 | |||||||
| SafetyStockLevel | True | SafetyStockLevel | Int16 | 11 | False | ||||||||
| ReorderPoint | True | ReorderPoint | Int16 | 12 | False | ||||||||
| ListPrice | True | ListPrice | Decimal | 13 | False | ||||||||
| Size | True | Size | String | 14 | False | 50 | |||||||
| SizeRange | True | SizeRange | String | 15 | False | 50 | |||||||
| Weight | True | Weight | Double | 16 | False | ||||||||
| DaysToManufacture | True | DaysToManufacture | Int32 | 17 | False | ||||||||
| ProductLine | True | ProductLine | String | 18 | False | 2 | |||||||
| DealerPrice | True | DealerPrice | Decimal | 19 | False | ||||||||
| Class | True | Class | String | 20 | False | 2 | |||||||
| Style | True | Style | String | 21 | False | 2 | |||||||
| ModelName | True | ModelName | String | 22 | False | 50 | |||||||
| LargePhoto | True | LargePhoto | Byte[] | 23 | False | ||||||||
| EnglishDescription | True | EnglishDescription | String | 24 | False | 400 | |||||||
| FrenchDescription | True | FrenchDescription | String | 25 | False | 400 | |||||||
| ChineseDescription | True | ChineseDescription | String | 26 | False | 400 | |||||||
| ArabicDescription | True | ArabicDescription | String | 27 | False | 400 | |||||||
| HebrewDescription | True | HebrewDescription | String | 28 | False | 400 | |||||||
| ThaiDescription | True | ThaiDescription | String | 29 | False | 400 | |||||||
| StartDate | True | StartDate | DateTime | 30 | False | UnspecifiedLocal | |||||||
| EndDate | True | EndDate | DateTime | 31 | False | UnspecifiedLocal | |||||||
| Status | True | Status | String | 32 | False | 7 | |||||||
| ProductLineName | True | ProductLineName | String | 33 | False | 10 | True | ProductLineName | show/hide |
| parent column | child column | relation name | nested |
|---|---|---|---|
| DimProductSubcategory. | DimProduct. | FK_DimProduct_ProductSubcategoryKey | False |
| parent column | child column | relation name | nested |
|---|---|---|---|
| DimProductSubcategory. | DimProduct. | FK_DimProduct_ProductSubcategoryKey | False |
| name | object type | level |
|---|---|---|
| AdventureWorksDW | DataSourceView | 1 |
| AmoAdventureWorks | Database | 2 |