Henry Banking System
Automatic Teller Machine (ATM)
Datbase Structure

See also -   Business Functions   System Structure Interface Facade   Database Structure  

  • System

    • ID Field Name Introduction Note
    1 aCardNo To automaticly generate card number.  
    2 aDealingID To automaticly generate Dealing ID.  

  • Account

    • ID Filed Name Introduction Note
    1 CardNo Refer to card number. Must be 6 digits.
    2 Name Account name. Can not be more than 10 bytes.
    3 Password User password. Can not be more than 6 digits
    4 Amount The sum of money.  
    5 Time Register Time.  

  • Dealing

    • ID Field Name Introduction Note
    1 DealingID Each Dealing has a unique ID.  
    2 CardNo Refer to an unique card holder.  
    3 Amount Dealing amount. A plus or negative.
    4 Type The type of dealing. Open Account, Deposit, Draw, Change Password.
    5 Time Dealing Time.