Order Details
Fields
Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
Is PK |
Is FK |
Is Identity |
Is Computed |
Default value |
Default sequence |
OrderID |
1 |
int |
0 |
10 |
0 |
|
Yes |
Yes |
|
|
|
|
ProductID |
2 |
int |
0 |
10 |
0 |
|
Yes |
Yes |
|
|
|
|
UnitPrice |
3 |
money |
0 |
19 |
4 |
|
|
|
|
|
0 |
|
Quantity |
4 |
smallint |
0 |
5 |
0 |
|
|
|
|
|
1 |
|
Discount |
5 |
real |
0 |
24 |
0 |
|
|
|
|
|
0 |
|
Foreign key constraints
FK_Order_Details_Orders
Aspect |
Value |
Primary key table |
dbo.Orders |
Delete rule |
Cascade |
Update rule |
NoAction |
Foreign key field |
Primary key field |
OrderID |
dbo.Orders.OrderID |
FK_Order_Details_Products
Aspect |
Value |
Primary key table |
dbo.Products |
Delete rule |
NoAction |
Update rule |
NoAction |
Foreign key field |
Primary key field |
ProductID |
dbo.Products.ProductID |
Model elements mapped on this table