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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
