We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we use LOGICAL ONLY UDT but translate them to standard data types in the physical model. We use ERwin. It is a little pricey but I think there are others out there for less.