I am looking for some help in the clarification of the UNIQUE key. For example, say I created a table and appended UNIQUE (email, activation, code) to the end of the CREATE statement. When inserting data, does the unique fields create a combined unique key or are they separate? In other words does an insert look for a row with all three unique fields to be the same or will it be unsuccessful if just one of the fields is a duplicate?