w == wmoran(at)potentialtech(dot)com writes:
...
w> Your primary key can span multiple columns, i.e.
w> PRIMARY KEY(jobclock_id, employee_id, machine_id)
w> Could be more columns.
w> Keep in mind that this ensures that the combination of all those
w> columns is unique, which may or may not be what you want.
Sure. I realize that a primary key can be made up of multiple
columns, but a unique constraint across the columns I need as
suggested by Matthew is what I was looking for.
Thanks.
--
Brandon