如何基于真实数据自动创建模式？

I have many vendors in database, they all differ in some aspect of their data. I'd like to make data validation rule which is based on previous data. I have many vendors in database, they all diffe