CustomerCustomerDemo
Fields
Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
Is PK |
Is FK |
Is Identity |
Is Computed |
Default value |
Default sequence |
CustomerID |
1 |
nchar |
5 |
0 |
0 |
|
Yes |
Yes |
|
|
|
|
CustomerTypeID |
2 |
nchar |
10 |
0 |
0 |
|
Yes |
Yes |
|
|
|
|
Foreign key constraints
FK_CustomerCustomerDemo
Foreign key field |
Primary key field |
CustomerTypeID |
dbo.CustomerDemographics.CustomerTypeID |
FK_CustomerCustomerDemo_Customers
Aspect |
Value |
Primary key table |
dbo.Customers |
Delete rule |
NoAction |
Update rule |
NoAction |
Foreign key field |
Primary key field |
CustomerID |
dbo.Customers.CustomerID |
Model elements mapped on this table