Skip to Content
avatar image
Former Member

Need help in designing custom tables

time-sheet-project.jpegHi friends,

I am designing a complex timesheet which consists of editable WD ALV. there are seven fields emp id, emp name, date, time type, from time, to time and total time respectively. My doubt is that how many custom tables do i need to design and what all fields do i need to include. I am getting stuck in the DB design. Please check the attachment for the complete details.


Saurav Lahiry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2017 at 07:13 AM

    It is hard to help with this without knowing the full picture of the requirements, your development process and the current system. But here are some basics:

    So for transactional data, the fields that the user is entering need to be in the tables while the fields that are fetched from other related tables or calculated need not. In your example, I guess the name will be in HR tables already, and the total time is something that you calculate? If that is the case, you won't need them as fields in you db table.

    For customizing, you would need a table for your possible values of the Time Type, if you are not using standard. (The alternative is to hardcode them into the programs, but I would not recommend that from a maintainability and customization perspective. Though I do not know your requirements and system). You can choose to include the rules also in that table, i.e. "number of years as employee" and "managers", or use the authorization concept or (again) hardcode in the program.

    Well, that were som basics. Then there is something about "Quota" you need to handle as well. And you might need some flag for approval?

    Good luck!

    Add comment
    10|10000 characters needed characters exceeded