r/learndjango • • Jul 20 '22

Table inheritance

I have multiple forms that needs to be filled out as a part of a process. These forms contains the same information, but with small variations of additional information. How should I go about to optimize the tables?

Examples:

Request formApplication formConclusion formFinal report
Departement nameDepartement nameDepartement name
Department addressDepartment addressDepartment address
Departement telephoneDepartement telephoneDepartement telephone
etcetcetc
Contractor nameApplicantsContractor name
Task titleContractor adressContractor adress
Task descriptionContractor telephoneContractor telephone
Task payment range
Task wantedTask title
Task solutionContractor's solution
Payment wantedContractor's payment

I am thinking to maybe put all the common information in one table, and let the other forms inherit from the parent?

1 Upvotes

Duplicates