That seems to be going in the right direction. It would be nice to have comments on the columns, but the usage of most can be guessed by good naming.
Two questions: 1. Column "entity_class (not null)" in TABLE "entity": is it something like "current_default/primary_class", whatever that might be? 2. The term and term fragment "class" (assuming it means "our way of classifying the entities") might be better understood using the term and term fragment "role". Term fragments class/group/type are all shallow terms in entity/logical modelling. What we want to know is WHY we are classifying/grouping/typifying an entity. The reason for making the classification/grouping/typification is usually the best term to use. In this case we are classifying based on the role the entity has. Therefore "role" is a better choice than "class" in this model. Before you go further I would rename "class" to "role" everywhere that it occurs in this physical model. Later you might also classify entities in another way, eg based on whether they are current or not, alive or dead perhaps. (Rules for classification can be implicit in events/transactions that change the state of an entity(in logical modelling) from oe state to another, and be explicitly or redundantly recorded in both the logical and physical models as classifications.) On 5/30/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Here is the current model: > http://ledger-smb.svn.sourceforge.net/viewvc/ledger-smb/trunk/sql/Pg-database.sql?view=markup&pathrev=1244 > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Ledger-smb-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel > -- The Last Great Frontier is in Your Mind ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
