Database Reference
In-Depth Information
FOREIGN KEY (OrderID)
REFERENCES ORDERS (OrderID),
CONSTRAINT OInventory_InventoryID_fk
FOREIGN KEY (InventoryID)
REFERENCES INVENTORY (InventoryID),
CONSTRAINT OrderID_InventoryID_pk
PRIMARY KEY (OrderID, InventoryID)
)
GO
CREATE TABLE CUSTOMER_PAYMENT
(
CustomerID INT,
PaymentID INT,
PaymentDate DATETIME NOT NULL,
CONSTRAINT CustPayment_CustomerID_fk
FOREIGN KEY (CustomerID)
REFERENCES CUSTOMER (CustomerID),
CONSTRAINT CustPaymant_PaymentID_fk
FOREIGN KEY (PaymentID)
REFERENCES PAYMENT (PaymentID),
CONSTRAINT CustomerID_PaymentID_pk
PRIMARY KEY (CustomerID, PaymentID)
)
9. As shown in Figure 4.5. If everything works properly, you should get the message
“Command(s) completed successfully.”
Figure 4.5
Create tables.
