accounting schema

Hi,<br /><br />I am learning my way into Accounting and was wondering how Accounting applications are designed. perhaps
youcould point the way....<br /><br />On one hand, accountants talk about a sacret equation A = L + OE (Asset =
Libility+ Owner Equity) and then under each categories there are one or many account. On the other hand a DBA thinks in
termsof tables and relations. Instead of getting theoritical, allow me to setup an example<br /><br />Say you have have
constructionproject (like a room addition) or one of those flip this house deals<br /><br />Owner brings the land
(equity)of say worth $100K<br />Expenses begin to mount ( that is a minus against OE)<br /> Account Payble begins to
mount(that is a liability)<br />And one day you experience a sale <br /><br />As a DBA, (and keeping it simple) I am
thinkingI need a table for every account which migh look like<br /><br />id, description, credit, debit, validated,
created_on,created_by, modified_on, modified_by<br /><br />Is that pretty match it ?<br />Please let me know if you
haveseen some accounting or DB book that addresses this problem domain.<br /><br />Thanks<br />Medi<br /><br />