Back-on-track

Ok

So after we did all that stuff about the users, we got to a new dilemma (thank you django!).

How are we going to store the stands in our database?

Our first choice was to create tables "on the fly" which we were going to use as matrix, so every position in our table would be a stand. Yes, that didn't work. So after more than a week investigating how to make that happen, we actually decided not to, its too difficult to implement it that way.

Current solution:

Now we are going to store all the stands in one table (yes, at large scale its going to be huge but we couldn't figure out any better way to do it).

Instead of giving you a big messy explanation I'm just going to paste what would be our design for the expo and the stand models:

=Exposiciones=

nombre -> String
creador -> Usuario
entrada -> norte, sur, este, oeste -> 0,1,2,3
salida -> norte, sur, este, oeste -> 0,1,2,3
columnas -> #
filas -> #
pasillos -> horizontal, vertical -> 0,1

=Stands=

exposicion -> Exposiciones
x -> columnas -> #
y -> filas -> #
usuario -> Usuario

Cheers

-Deco