Thread

1. Inherited Table

   Peter Harvey <pharvey@codebydesign.com> — 2001-09-06T06:49:21Z

   Anyone know how inherited tables are shown on an ERD... both the table
   and the connector (if any)?
   
   What I am looking for is how to draw this in the diagram.
   
   Peter
   
   -- 
   +---------------------------
   | Data Architect
   | your data; how you want it
   | http://www.codebydesign.com
   +---------------------------
   
   

2. Re: Inherited Table

   Hannu Krosing <hannu@tm.ee> — 2001-09-06T10:28:43Z

   Peter Harvey wrote:
   > 
   > Anyone know how inherited tables are shown on an ERD... both the table
   > and the connector (if any)?
   > 
   > What I am looking for is how to draw this in the diagram.
   
   An old S-Designor does it so:

3. Re: Inherited Table

   Peter Harvey <pharvey@codebydesign.com> — 2001-09-06T16:08:47Z

   Hannu Krosing wrote:
   > 
   > Peter Harvey wrote:
   > >
   > > Anyone know how inherited tables are shown on an ERD... both the table
   > > and the connector (if any)?
   > >
   > > What I am looking for is how to draw this in the diagram.
   > 
   > An old S-Designor does it so:
   > 
   
   Yes. But pgsql does not support multiple inheritance (from what I can
   tell) so the extra symbol along the ref line ("can be"/"must be") seems
   silly. I am thinking that I should draw the new table slightly diff in
   some way just as is done with Views. However; some purests would freak.
   <Hmmm>
   
   Thanks
   
   Peter