[support] Help with database table and taxonomy design

[Roger]

<snip>
I'm a bit stuck on how to design an event system for our needs. The 
current offerings are overly complex for our needs and do not take 
kindly to some of the variations we need.
I would like to discuss with a Drupal 7 expert who can advice on 
taxonomy design and implementation.
Thank you in advance
Roger


  There are several on line event web applications. Why do you want to 
create one yourselves? Now I once created a system that allowed an 
administrator to manage contracted cooking instructors. These 
instruction sessions were events. Events with a venue, a schedule, 
various players who had to be contacted, supply ordering and fulfillment 
that needed to be done, verifying that the contract was actually being 
fulfilled, and paying the contracted instructors through an invoice 
system. All this was accomplished without using a Content Management 
System. What are you trying to do? Sometimes defining the problem is 
nine tenths of the solution. -
George
</snip>

Thanks George
The key issue for us in using one of the event systems already available 
is that most of what they provide is overly complex, much is of no use 
or just clutter. I have explored 3 or 4 to date.

This Drupal 7 system is at this time for Australia only.


Our events needs are fairly simple, I'm well into the process on our 
test site.

We have about 20 slightly differing event Content Types, these include 
general meetings, member's  meetings, Book Readings, Classes, Services, 
Itemised Discussions, each for public, for members only, for teams only 
and for specialised teams.

We have other specialised meeting types for public and members which do 
not fit into the above categories.

Then there are team member meetings anywhere across Australia called 
without notice.

My observations:
All events have a venue, a location, a state, a convener, a title, a date.
The date for some event types repeats weekly or monthly for 3, 6,or 12  
months, infrequently 18 months.
Other events have a single date or repeat for 2 days.
Some events have the same convener for the full repetitive cycle, other 
events may have up to 3 conveners at each meeting and these may be 
different for each monthly meeting.
Other may have 2 conveners who swap each month.

Some events have literature requirements where a book or document is a 
reading prerequisite.

I have the data entry form Title field set to automatically predefine 
prescribed titles which makes views far easier to work on (Thanks to Nancy).

I have taxonomy vocabularies for:
Book references
Venues
Location
State
Event types
Event titles
Authors
Contacts
And several more.

There are 8 States, 70 Locations and 100 venues and over 2000 events per 
year across Australia.

Venue Terms are the local names of venues like "433 On Logan" or 
Melbourne Exhibition Centre"
Location Terms are say Canberra, Newcastle, Tongala, Bentleigh, Moe.
State Terms are QLD, VIC, SA, TAS - Australian states.

My question was to be more along the lines of, say with State, Venue, 
Location.
A state can have more than one location
A location can have more than 1 venue.
A Venue has a Location and State.

I am currently providing Venue, Location, State Term References for each 
event content type. This is doubling up information as each table over 
the course of time will contain very similar information.

I have tried putting a Location and State field in each Venue term but 
find that these do not display and do not know how to get them to do so 
after an event data entry is displayed.

I have tried adding Location and Venue to the State Terms

I do not know which is the most appropriate way to provide the 3 lots of 
data from one Term Reference field in each event Content Type.


I'm thinking of just providing the Venue then the location and State are 
automatically linked.
This way the coordinator has only to select  the venue from the Term 
Reference field.
Only the Venue has a link to address information and a map.

I have tried a number of ways but am more confused now.

I greatly appreciate any help I can get
Thanks in advance
Roger