how is this schema/model called
From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Mon, 23 Jun 2003 11:57:21 -0700
Message-ID: <dbIJa.8$aO2.69_at_news.oracle.com>
From time to time people reinvent the following schema
NAME PHONE
REL_NAME ID TYPE VALUE
-------- -- ---- -----
Date: Mon, 23 Jun 2003 11:57:21 -0700
Message-ID: <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 - 20:57:21 CEST