Hello, I'm new to Django, but learning as fast as I can. I would
appreciate some technical help and some database design advice...

**
1) Admin pluralizing question

So I have three models: samurai, item, inventory

When I login to the admin screen it has chosen to pluralize them as:
samurais, items, inventorys

I'm a little bit anal, so this bothers me. Where can I change it to:
samurai, items, inventories ?

**
2) Model relationships question

Can someone validate that I am using the right relations for these?
Users will login with a unique id and instantiate a samurai, each
possessing various attributes (not shown below). Items have unique IDs
but many samurai can have many of the same items (including
duplicates)- also the items have a status as to the condition of the
item. There is one inventory for each samurai which links his items to
him. Based on this system, I believe I should do the following...

Samurai model: AutoField ID (primary key, unique)
Item model: AutoField ID (primary key, unique), ManyToMany(Samurai)
Inventory: Foreignkey(Samurai), ManyToMany(Item)

Did I do this right?

**

And two design questions:

3) How should I implement duplicates of items for a single inventory?
For example, one samurai may have two identical fish. Should I store
this as an additional field in the inventory? If so, how do I link it
to the item id? Is it cleaner/faster/better to use a dictionary?
Actually, I've never heard of a dict in SQL.

4) How should I implement the status/condition of the items? For
example, I want them to be "New", "Used", or "Broken/Unusable". Should
I store this in the inventory or in a separate model called Status? If
the latter, should I use a foreignkey(item) and OneToOne(Inventory) or
something else?

Thank you very much for your help. If you are aware of any tutorials
or available source code for coding RPGs, browser games, or
inventories, I will be happy to follow links and try to learn on my
own.

-Tim

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to