Re: Research and EAV models - Mailing list pgsql-general

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