I have a company auditing system, which is a bit difficult to explain but i will try to keep it simple. Here are the main parts
1) Comapny
2) Audits (certifications)
3) Clauses (These are questions specific to a certification and they all need to be answered in order for the audit to complete. The user can then add comments, status, mark it as complete etc )
There are lots of audits that a company can be tested for. So a company can have multiple audits. Each audit have some clauses, that needs to be executed in order to complete the audit. A user can also add some data to these clauses, for eg progress of the clause, status, comments etc.
Right now i have these database tables
1) Companies
2) Audits
3) Clauses
4) Companies - Audits (Pivot table)
5) Clauses - Audit (Pivot table)
6) Companies - Audits - Clauses (pivot of pivot table)
Now the first 5 are preety standard, but i am not sure how to impliment the last one. Right now in companies-audits pivot table i have an auto increment field called companies_audits_id, And i then use this id inside Companies_Audits_Clauses table. In Companies_Audits_Clauses table i also have the fields like status, progress, comments etc.
I am not sure if this is a good idea. So i need your thoughts on it. Every help is appreciated.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire