From: | Nikola Milutinovic <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Classes (Object Oriented) in PostgreSQL question |
Date: | 2001-11-23 12:54:39 |
Message-ID: | 3BFE470F.5090009@ev.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all.
I'm in the process of redesigning my database. I have seen some space
for object design in my data schema. Namely, I'm modeling my company and
it has organizational units: "parts", "sectors", "divisions" and
"subdivisions". Each of these look alike and form a tree.
So I thought to create a table "org_unit" containing common fields and
just inferit them for a particular unit type. Something like:
CREATE TABLE org_unit (
id int4
PRIMARY KEY,
name text,
manager_id int4,
ordering int2,
print boolean
);
CREATE TABLE ou_part (
) INFERITS (org_unit);
CREATE TABLE ou_sector (
part_id int4,
FOREIGN KEY( part_id ) REFERENCES ou_part
) INHERITS (org_unit);
...
CREATE TABLE official_mail (
id int4 PRIMARY KEY,
e_mail text,
org_unit_id int4,
FOREIGN KEY( org_unit_id ) REFERENCES org_unit
);
Will this work? Both the foreign key in ou_* and in official_mail?
Nix.
From | Date | Subject | |
---|---|---|---|
Next Message | Einar Karttunen | 2001-11-23 13:33:09 | Re: TEXT datatype: compared to CHAR and VARCHAR |
Previous Message | Hegyvari Krisztian | 2001-11-23 12:49:26 | rollback question |