SF.net SVN: ledger-smb: [1238] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1238
          http://svn.sourceforge.net/ledger-smb/?rev=1238&view=rev
Author:   linuxpoet
Date:     2007-05-23 14:38:32 -0700 (Wed, 23 May 2007)

Log Message:
-----------
build out person->entity relationship

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-23 19:44:05 UTC (rev 1237)
+++ trunk/sql/Pg-database.sql	2007-05-23 21:38:32 UTC (rev 1238)
@@ -84,15 +84,15 @@
 
 CREATE TABLE person (
  id serial PRIMARY KEY,
+ entity_id integer references entity(id) not null,
  salutation_id integer references salutation(id),
- entity_class_id integer references entity_class(id),
  first_name text check (first_name ~ '[[:alnum:]_]') NOT NULL,
  middle_name text,
  last_name text check (last_name ~ '[[:alnum:]_]') NOT NULL,
  primary_location_id integer references location(id));
  
+COMMENT ON TABLE person IS $$ Every person, must have an entity to derive a common or display name. The correct way to get class information on a person would be person.entity_id->entity_class_to_entity.entity_id. $$;
 
-
 -- END entity   
 
 --


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.