that wouldn't be especially bad, but our application language sucks balls, so it's not easy to seperate log like that out from the application itself, and this is something that needs to be interacted with from multiple places
or, maybe not, I guess it only has to be veiwed from multiple places
maybe someone can recommend some reading or examples? I'm not a total newb but this is something that's got me stumped, but I'm sure someone else has solved it already,
one sec while I type
I need to track the structure of a team as it changes over time, There are multiple Agents who report to one of several team leaders in different departments, who each report to the single director of that dept.
my current solution is a position table, that stores the name of the dept, the type of position, and a recursive FK indicating reporting structure, then a seperate 'history' table that uses a composite key to relate a 'person' to a position, and the dates they started/ended in that position