[Pdx-pm] Eliminating circular table relations.

David E. Wheeler david at kineticode.com
Wed Jan 31 14:45:32 PST 2007


On Jan 31, 2007, at 1:33 PM, David E. Wheeler wrote:

> # sub-type
> CREATE TABLE _meat_account (
>      id                  INTEGER PRIMARY KEY REFERENCES account(id),
>      drippings           BOOLEAN,
>      gravy               TEXT
> );

Oh, and check out EnumKit for building enums for PostgreSQL.

   http://www.oreillynet.com/pub/a/databases/2006/01/06/enumerated- 
fields-in-postgresql.html

Best,

David


More information about the Pdx-pm-list mailing list