I am using the following SQL to create a unique index with 2 fields:

CREATE UNIQUE INDEX IDXPERSON_ID ON PAYCHECKINFO (PERSON_ID,
SEQUENCE);

Yet after creating the DB, when I view the unique constraint in IB
Expert I see that only PERSON_ID field is in the unique index.

Note that PERSON_ID is defined

AS INTEGER NOT NULL

and SEQUENCE is defined as

AS SMALLINT NOT NULL CHECK(VALUE IN (1, 2))

What's wrong with my SQL command?

Thanks
Ed Dressel