Re: Research and EAV models

Karsten Hilbert <Karsten.Hilbert@xxxxxxx> · Sat, 24 Oct 2009 00:29:11 +0200

On Fri, Oct 23, 2009 at 11:53:26PM +0200, Leif B. Kristensen wrote:

> I'm a researcher type, and I've made an EAV model that suits me well in 
> my genealogy research. How can you associate an essentially unknown 
> number of sundry "events" to a "person" without an EAV model?

create table person (
	pk serial primary key,
	who_is_it text
);

create table event (
	pk serial primary key,
	fk_person integer references person(pk),
	what_happened text
);

I'm sure you meant something else, no ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general