[katello-devel] key-value pairs for objects in katello db

[Miroslav Suchý]

On 08/15/2012 03:32 PM, Ohad Levy wrote:
> in foreman, we have 3 tables
>
> hosts
> fact name
> fact value
>
> and fact value is basically the join
>
> fact_value
> id, host_id, fact_name_id, value
>
> you could easily turn this into a polymorphic relationship (so instead
> of host_id you have obj_id and obj_type)
>
> however, I think that fact_name table might have created a performance
> degradation and if I'll do it again, i might just put the key next to
> the value.

+1

-- 
Miroslav Suchy
Red Hat Systems Management Engineering