Activity overview
Latest activity by rlasker3
This is very disappointing. We have a very large database so there is likely to be many of these kinds of scenarios not to mention this currently fails due to check constraints. Having to store a large list of scripts that need to run at the end obscures the logic compared to each column doing the right approach. / comments
This is very disappointing. We have a very large database so there is likely to be many of these kinds of scenarios not to mention this currently fails due to check constraints. Having to store a l...
way0utwest wrote: »
If I understand this, you want to populate the Equipment.Operator column with data. This data is a reference to another table, correct? Some Operators table?
Then, you want a NULL in this column if Operator.OwnershipType = Subcontracted, otherwise some valid FK. Is that correct?
Yes, this is correct. If the the equipment is subcontracted you do not assign an operator to it so it needs to be null. Otherwise, an operator can be assigned. / comments
way0utwest wrote: »
If I understand this, you want to populate the Equipment.Operator column with data. This data is a reference to another table, correct? Some Operators table?
Then, you want ...
Conditional Foreign Keys
Short: Does anyone know of how I would fill in a foreign key value only if the value of a different column is a certain value?Long: I have an Equipment table. It has an Operator column that is a ke...