var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Design Many to many
I am wanting to design a simple software to manage checklists.
I have a following tables in mind
checklist task_types applicable_checklist tasks task_checklist
ID ID ID ID
CL_NAME TT_NAME FK_CHECKLIST FK_TASK_TYPES
Checklist will be applicable to a particular tasktype.
For all tasks of a particular task type, the checklists will have to be fulfilled.
Should the table task checklist have foreign key of checklist or applicable checklist?
I would use a foreign key of checklist because the tasks relate to checklists.
If you want to ensure at the database-level that a task is not assigned a checklist which it should not have you could use a trigger to validate new relations.
Tags for this Thread