Book a Demo

Author Topic: Can all database tables inherit common fields?  (Read 2062 times)

spfiore

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Can all database tables inherit common fields?
« on: October 13, 2004, 09:58:46 am »
I’m using EA to create a data model (and eventually a database) for a large system that has four or five fields that are common to ALL tables in the system - things like last modified date/time, last modified ID, source system ID, etc.

Is there a way to have all the tables “inherit” these from a common ancestor? Databases like Postgres have an Inherits clause in the Create Table DDL, is there a way to do this within EA?

I could create a little script that parses the DDL created by EA and inserts the inherits clause to the bottom of every create table statement, but I was hoping there was an automated way to do this within EA?

Thanks in advance for any help or suggestions.