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

[..hidden..]

Revision: 3346
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3346&view=rev
Author:   einhverfr
Date:     2011-06-26 17:23:28 +0000 (Sun, 26 Jun 2011)

Log Message:
-----------
Commeents through about line 650

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-26 16:21:43 UTC (rev 3345)
+++ trunk/sql/Pg-database.sql	2011-06-26 17:23:28 UTC (rev 3346)
@@ -540,7 +540,11 @@
   class text check (class ~ '[[:alnum:]_]') not null,
   authoritative boolean not null,
   PRIMARY KEY (class,authoritative));
-  
+
+COMMENT ON TABLE location_class is $$
+Individuals seeking to add new location classes should coordinate with others.
+$$;
+
 CREATE UNIQUE INDEX lower_class_unique ON location_class(lower(class));
 
 INSERT INTO location_class(id,class,authoritative) VALUES ('1','Billing',TRUE);
@@ -562,6 +566,10 @@
   inactive_date timestamp default null,
   active boolean not null default TRUE
 );
+
+COMMENT ON TABLE location IS $$
+This table stores addresses, such as shipto and bill to addresses.
+$$;
   
 CREATE TABLE company (
   id serial UNIQUE,
@@ -623,6 +631,9 @@
     PRIMARY KEY (entity_id)
 );
 
+COMMENT ON TABLE entity_employee IS 
+$$ This contains employee-specific extensions to person/entity. $$;
+
 CREATE TABLE person_to_location (
   location_id integer not null references location(id),
   location_class integer not null references location_class(id),
@@ -635,6 +646,10 @@
   company_id integer not null references company(id) ON DELETE CASCADE,
   PRIMARY KEY (location_id,person_id)); 
 
+COMMENT ON TABLE person_to_company IS
+$$ currently unused in the front-end, but can be used to map persons
+to companies.$$;
+
 CREATE TABLE entity_other_name (
  entity_id integer not null references entity(id) ON DELETE CASCADE,
  other_name text check (other_name ~ '[[:alnum:]_]'),


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