I have multi-company database.
Each company has its own chart of accounts table which are stored in each
company schema.
Some account numbers are used in a common table which is stored in public
schema.
So I need to create duplicate foreign keys like
create temp table company1.chartoffaccounts ( accountnumber int primary
key);
create temp table company2.chartoffaccounts ( accountnumber int primary
key);
create temp table public.commontable ( accountnumber int,
FOREIGN KEY (accountnumber) REFERENCES c1hartoffaccounts
(accountnumber)
FOREIGN KEY (accountnumber) REFERENCES c2hartoffaccounts
(accountnumber) );
Is it OK to use duplicate foreign keys ? What issues will they cause ?
Andrus.