|
-
I would suggest 3 tables:
employees, bonuses and employee_bonuses:
table employees:
emplooyee_id primary key,
name,
etc.
table bonuses:
bonus_id primary key,
amount,
etc.
table employee_bonuses:
employee_id foreign key referencing employees,
bonus_id foreign key referencing bonuses
Performance is not really a problem.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|