Foreign key malformed

1 posts
[expired user #8931]'s profile image [expired user #8931] posted 9 years ago in General Permalink
Working

CONSTRAINT `FK_users_orders` FOREIGN KEY (`cus_id`, `ord_id`) REFERENCES `orders` (`cus_id`, `ord_id`)

is always formed like

CONSTRAINT `FK_users_orders` FOREIGN KEY (`cus_id`, `ord_id`) REFERENCES `orders` (`ord_id`, `cus_id`)

(reversed order because of the sequence fields appear in the corresponding tables - e.g. order is the field "number")

... which is incorrect I believe.

Regards.
smooker.

Please login to leave a reply, or register at first.