Results 1 to 2 of 2

Thread: Table

  1. #1
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Question Unanswered: Table

    Hi All,

    I got a table for a debit card System,

    which consists following:

    Ledger:
    Trans_id;(Transaction ID)
    Card_id;(Customer ID)
    Date;(DATE)
    Description;(What Has been Done purchase or Account balance added)
    amount;(Amount)
    trans_Type;(DR/CR)
    location;(Transaction location)

    the column trans_type contains information of type i.e DR(Debit) or CR(Credit) I need to ask is this structure ok?? or do I make sepearate columsn for DR or CR i am a bit confused in this os should I take a Bit in it one for DR and zero for Credit Please mention which is more suitable. Or if you feel their is any other way I can do this.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I definately would use one column and I would name it as you have. The data type is up to you, some would use a bit but the problem there is what if you are required to add a third type?
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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