acc_trans
     Column     |  Type   |         Modifiers
----------------+---------+----------------------------
 trans_id       | integer |
 chart_id       | integer | not null
 project_id     | integer |
 amount         | numeric |
 transdate      | date    | default ('now'::text)::date

chart:
   Column    |     Type     |                Modifiers
-------------+--------------+------------------------------------------
 id          | integer      | not null default nextval('id'::regclass)
 accno       | text         | not null
 description | text         |
 category    | character(1) |

project:
    Column     |  Type   |                Modifiers
---------------+---------+------------------------------------------
 id            | integer | not null default nextval('id'::regclass)
 projectnumber | text    |