pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tony Wasson <ajwasson@gmail.com>
To: Medi Montaseri <montaseri@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: accounting schema
Date: Thu, 7 Feb 2008 08:52:43 -0700
Message-ID: <6d8daee30802070752g74673b79s4d5cfb3cdad25a01@mail.gmail.com> (raw)
In-Reply-To: <8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com>
References: <8078a1730802061708q17c72234xe61be822459a24a8@mail.gmail.com>

On Feb 6, 2008 6:08 PM, Medi Montaseri <montaseri@gmail.com> wrote:
> I am learning my way into Accounting and was wondering how Accounting
> applications are designed. perhaps you could point the way....

<SNIP>
> As a DBA, (and keeping it simple) I am thinking I need a table for every
> account which migh look like
>
> id, description, credit, debit, validated, created_on, created_by,
> modified_on, modified_by
>
> Is that pretty match it ?
> Please let me know if you have seen some accounting or DB book that
> addresses this problem domain.

Another codebase to look at is http://www.sql-ledger.org/. It uses postgresql.

Regards,
Tony



view thread (8+ messages)  latest in thread

Message-ID: <6d8daee30802070752g74673b79s4d5cfb3cdad25a01@mail.gmail.com>
Permalink:  ../6d8daee30802070752g74673b79s4d5cfb3cdad25a01@mail.gmail.com/
Also on:    postgresql.org/message-id/6d8daee30802070752g74673b79s4d5cfb3cdad25a01@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ajwasson@gmail.com, montaseri@gmail.com
  Subject: Re: accounting schema
  In-Reply-To: <6d8daee30802070752g74673b79s4d5cfb3cdad25a01@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox