Without more information, I would say in both cases you are looking at a table(, or perhaps a user defined datatype, but a table is simpler). If you are looking for something generic, you could possibly use XML or a table with a row per property, but SQL is not generally generic friendly. It is centered around building known structures...