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

[..hidden..]

Revision: 3352
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3352&view=rev
Author:   einhverfr
Date:     2011-06-27 05:47:10 +0000 (Mon, 27 Jun 2011)

Log Message:
-----------
Comment on statements up through relation voucher

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-27 03:32:12 UTC (rev 3351)
+++ trunk/sql/Pg-database.sql	2011-06-27 05:47:10 UTC (rev 3352)
@@ -901,17 +901,34 @@
   approved bool default true,
   department_id int default 0
 );
+
+COMMENT ON TABLE gl IS
+$$ This table holds summary information for entries in the general journal.
+Does not hold summary information in 1.3 for AR or AP entries.$$;
+
+COMMENT ON COLUMN gl.person_id is $$ the person_id of the employee who created
+the entry.$$;
 --
 CREATE TABLE gifi (
   accno text PRIMARY KEY,
   description text
 );
+
+COMMENT ON TABLE gifi IS 
+$$ GIFI labels for accounts, used in Canada and some EU countries for tax 
+reporting$$;
 --
 CREATE TABLE defaults (
   setting_key text primary key,
   value text
 );
 
+COMMENT ON TABLE defaults IS 
+$$  This is a free-form table for managing application settings per company
+database.  We use key-value modelling here because this most accurately maps 
+the actual semantics of the data.
+$$ ;
+
 \COPY defaults FROM stdin WITH DELIMITER '|'
 timeout|90 minutes
 sinumber|1
@@ -942,11 +959,6 @@
 check_prefix|CK
 \.
 
-COMMENT ON TABLE defaults IS $$
-Note that poll_frequency is in seconds.  poll_frequency and queue_payments 
-are not exposed via the admin interface as they are advanced features best
-handled via DBAs.  Also, separate_duties is not yet included in the admin 
-interface.$$;
 -- */
 -- batch stuff
 
@@ -955,6 +967,10 @@
   class varchar primary key
 );
 
+COMMENT ON TABLE batch_class IS 
+$$ These values are hard-coded.  Please coordinate before adding standard
+values.$$;
+
 insert into batch_class (id,class) values (1,'ap');
 insert into batch_class (id,class) values (2,'ar');
 insert into batch_class (id,class) values (3,'payment');
@@ -978,6 +994,10 @@
   CHECK (length(control_code) > 0)
 );
 
+COMMENT ON TABLE batch IS
+$$ Stores batch header info.  Batches are groups of vouchers that are posted
+together.$$;
+
 COMMENT ON COLUMN batch.batch_class_id IS
 $$ Note that this field is largely used for sorting the vouchers.  A given batch is NOT restricted to this type.$$;
 
@@ -991,6 +1011,9 @@
   batch_class int references batch_class(id) not null
 );
 
+COMMENT ON TABLE voucher IS 
+$$Mapping transactions to batches for batch approval.$$;
+
 COMMENT ON COLUMN voucher.batch_class IS $$ This is the authoritative class of the 
 voucher. $$;
 


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