why do you need : -- iid integer not_null auto_increment
???
wouldnt a composite primary be the way to do it?