Results 1 to 5 of 5

Thread: accounting Database design

Threaded View

  1. Mar 4th, 2003, 12:19 PM #1
    nemaroller
    nemaroller is offline

    Thread Starter
    I wonder how many charact
    Join Date
    Feb 2001
    Location
    Savage, MN, USA
    Posts
    3,704

    accounting Database design

    If anyone has a relationship entity diagram for an accounting database they have made or administer, I would appreciate an email of a WORD or JPEG or whatever of the relationship diagram.

    Thanks...

    I'm beginning the preliminary steps of the accounting part of our database system...


    As far as tables... this is what I have so far...


    Account
    AccountID - primary key
    AccountTitle - name of account
    AccountType - income or expense
    AccountBalance - balance of the account
    AccountCreationDate



    AccountTypes - a lookup table for assigning an account type
    AccountNumberID - primary key
    AccountTypeName - Accounts recievable, accts payable, etc


    Transactions
    TransactionID - primary key
    AccountID - (foreign key)account transaction belongs to or posts to
    Amount
    DebitCredit - true or false
    DateOfTransaction
    EnteredBy - employeeID
    Last edited by nemaroller; Mar 4th, 2003 at 12:22 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width