Re: how is this schema/model called
Date: Mon, 23 Jun 2003 12:29:53 -0700
Message-ID: <JFIJa.9$aO2.200_at_news.oracle.com>
Found a recent thread about EAV, so never mind. Unless there are other names too.
"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
news:dbIJa.8$aO2.69_at_news.oracle.com...
> From time to time people reinvent the following schema
>
> table Everything (
> relation_name String,
> id Integer,
> type String,
> value String
> )
>
> For example
>
> Phones
> ======
> NAME PHONE
> ---- -----
> Paul 011-3
> Mike 650-1
>
> becomes
>
> Everything
> ==========
> REL_NAME ID TYPE VALUE
> -------- -- ---- -----
> Phones 1 NAME Paul
> Phones 1 PHONE 011-3
> Phones 2 NAME Mike
> Phones 2 PHONE 650-1
>
> Does this design has a name to refer to?
>
>
Received on Mon Jun 23 2003 - 21:29:53 CEST