please help with simple relational db

For HanDBase related topics that are not specific to one platform.

please help with simple relational db

Postby NikNik » Wed Apr 30, 2014 4:50 pm

Hello dear HanDBase folks,

I'm trying to create the following:
1 jobs tracking app with
3 databases:

- JOBS (1-many to PAYCHECKS)
- PAYCHECKS (1-many to WORK_DAYS)
- WORK_DAYS

JOBS can have only one or umpteen WORK_DAYS. They can have as many PAYCHECKS as there are weeks during which i worked on said jobs.
JOBS should hold general info like name, employer, rate of pay, etc.
HanDBase functionality i'd like:
- the total number of WORK_DAYS (limited to current calendar year)
- a list of all WORK_DAYS (again within calendar year)
- the total number of PAYCHECKS (limited to current calendar year)
- a list of all PAYCHECKS (again within calendar year)

PAYCHECKS can have only one or up to 7 WORK_DAYS, limited by the current week (ending saturday).
PAYCHECKS should hold job name (pulled from JOBS), a "paid" checkbox, etc.
HanDBase functionality i'd like:
- a designation for the week, either week number or week ending date
- the total number of WORK_DAYS (limited to current PAYCHECK / week)
- a list of all WORK_DAYS (again within PAYCHECK / week)
- a list of the worked weekdays ("Monday, Thursday" for example) (again within PAYCHECK / week)

WORK_DAYS should have again job name (pulled from JOBS), date, some time calculations, various info I want to keep track of, etc.

That's it.
Once these databases are all linked up I'd also like to be able to find unpaid checks and check off paid ones. I'd like a tally of total days worked for a given calendar year; as well as some form of control to make sure the "app" is accounting for everything and not dropping days or checks.
Most of all I despise double-entering data, which is in part what I'm trying to solve with HanDBase.

I'm giving you just the most basic version here as I'm already running into lots of trouble accomplishing just the above. Any tips are much appreciated.
NikNik
 
Posts: 2
Joined: Wed Apr 30, 2014 3:34 pm

Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest