Toad Modeler for modelling. Handles defered constraints, inheritance, keys etc. Very scriptable tho the scripting IDE isn't great.