SalesOrderDetail table AdventureWorks2008R2 Primary Keys

When the table has multiple primary keys it is called as a Composite Primary Key and it is valid, hence it is a gold color key. The gray keys are not primary key but a foreign key only.