Two tables called
Dale have m2n-relations to each other. I am used to build a link table called
id NUMBER UNIQUE NOT NULL chip_id NUMBER NOT NULL dale_id NUMBER NOT NULL
UNIQUE INDEX CHIP2DALE_UQ ON (chip_id, dale_id), because multiple relations don't make sense.
My question is: Do I still need the
ID-column here? Is there any good reason for having this column? My rows are ultimatly identified by the combination of chip_id and chap_id GIVEN THAT I have absolutly no other columns here but the two.