Hi all,

I need some advice regarding the database layout of the following problem:

I have a list P of PCs. I have a list S of Software. Both have different 
fields and are two models.Model subclasses.
Now, I want to store for each PC in P, which software from S is installed 
on it and with which version.

So, P has like a ManyToMany relation to S, however for each "link" the 
extra-field Version would be required.

In a table layout, this could look like this:

Table PC, with columns: 
Name,   IP ...

Table Software with columns:   
Name, Description, ...

Table InstalledSoftware with Columns;
PC (links to PC.Name),   Software (links to Software.Name),   Version

With this layout, the problem could be layd out. The questions are:
- Is this the correct layout for this problem? Would you suggest something 
else?
- can Django support this? How would the code then look like, including 
relevant queries?

Thanks for your help!
Max

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/af010632-d799-413d-8980-9de5e9ade8d3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to