Sql – find SQL statements to create EAV model?


Alternatively, anyone know of where I can get the EAV model for Erwin?

Best Solution

Why would anybody want to build an EAV system using a SQL database? It's a square peg in a round hole.

If you are really convinced that EAV is the appropriate solution for your problem domain why not choose a database product which supports it? Cassandra or Voldemort or Dynomite?