Thursday, April 14, 2011

Yibing Comercial Bank - Sells Management System -Database Model Draft

Tables:
Account
id(pk)   client_id(foreignkey to Client)   balance   created_date   enabled

Client
id(pk)   name   gender   birthday

TradeRecord
id(pk)   account_id(foreignkey to Account)   sales_man(foreignkey to Employee)   amount   date

Employee
id(pk)   employee_id   name   gender   joined_date

No comments: