I think ive got the schema right, finally. I hope.
just a bunch of writes and rewrites