From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "GH" <grasshacker(at)over-yonder(dot)net> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Accounting Schema |
Date: | 2001-05-06 00:05:56 |
Message-ID: | 05e101c0d5c0$53247830$0401a8c0@INSPIRON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ya, thought of that. I generally prefer to keep my data model consistent. It
has some merit though, thanks
--dc--
----- Original Message -----
From: "GH" <grasshacker(at)over-yonder(dot)net>
To: "Dave Cramer" <Dave(at)micro-automation(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, May 05, 2001 7:48 PM
Subject: Re: [GENERAL] Accounting Schema
> On Sat, May 05, 2001 at 07:09:13PM -0400, some SMTP stream spewed forth:
> > Hi all,
> >
> > Can anyone out there with more experience than me give me some hints as
to
> > how to do accounting tables in a db. The problem I am wrestling with is
how
> > to represent credits, and debits.
> > One way is to identify credits and debits with a transactiontype, and
keep
> > all of the numbers positive which models the way accountants do it. This
> > makes things liking calculating the balance difficult with a sql
statement.
> >
>
> Keep in mind that what is in the database and what the user sees do not
> have to be the same...
> You could store the values in the database as positive or negative
> convert them to all positives (with a determined "transaction type")
> accordingly for display.
>
> gh
>
> > Any hints would be appreciated.
> >
> > Dave
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Harr | 2001-05-06 00:38:49 | Re: Problems w. SERIAL |
Previous Message | Muhammad Rusydi | 2001-05-05 23:51:49 | nested if , and how to trigger.... |