this data model (mixed with rails) is seriously killing my brain. i am about to just write the bleeper bloppin sql.