Re: enforcing uniqueness across tables
> Can I have a location column in "stock" that references two different location tables
Sorry, I don't see why that's needed. As you say, a given machine is in one place at one time. If it's rented to a customer, the location table says so---perhaps involving child tables documenting all the details, dates and so on. If said rented machine generates data in some other table, that table has a column indicating where the data came from, and that column could refer either directly or via a chain of references back to the location table.
Subject
Written By
Posted
Re: enforcing uniqueness across tables
July 18, 2015 09:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.