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

Aspect Value
Primary key table dbo.CustomerDemographics
Delete rule NoAction
Update rule NoAction
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

Model Element Element type
CustomerCustomerDemo Entity