yeah the referential integrity and constraints part is usually the most complicated part and everyone does things differently which adds another layer of complexity on it