The only thing we miss is how to get there. Now we know where we are and where we want to be. Basically, they give the purpose to the whole data model. While everything in databases is closely related to our business, these 4 new tables are much more specific than theĢ ones we already had. These 4 tables are much more than just a place to store the data in the way we did that with counties and cities. Table employees, customers and call outcomes are related call – Contains details about calls employees had with customers.For example, call outcome could be “Call successful – They are specific because values stored here almost never change and business logic is often directly related to these values. call_outcome – Is a list of all possible ways any call could finish.customer – Contains a list of all customers we’ve worked with.employee – Contains a list of all employees in our company.Now we have the data model with 6 tables. Such tables are the country, city, employee/user/account, customer/client, task, contact. The ones storing data that are used often and are being part of almost any business process.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |