Ah, I think that makes sense. Sorry if I wasn't clear earlier on but yes, I am looking for instructors who are certified to teach a certain course. So basically a user could sign up and select some or none of the types of courses they are certified to teach this way other users who want to learn can find them easily. As far as the difference between NRA and CCL, there are several different types of NRA courses one could take however a Concealed Carry course is dependent on which state your certified to teach in. This is what was getting me all confused as I was trying to abstract the type of course from the actual courses provided since there are a number of organizations and individuals (not attached to an organization) that can provide not only courses but services, such as a state certified hunting guide (for instance in Alaska you need one to hunt large game).
I guess though from your example data structure I could put any type of organization, state, etc into the IssuingAuthority and when it comes time to create the profile forms I could just create a drop down list of all issuing authorities for a person to choose from and then populate a select box with all classes that belong to that issuing authority. I would like for people to be able to multi-select and have fields auto-populate all on one page at one time but I'll jump that hurdle when I get there I suppose. Probably need to dive into Javascript/Ajax to make that work. Thanks much for your help. On Wed, Jun 27, 2012 at 3:31 PM, Dennis Lee Bieber <wlfr...@ix.netcom.com>wrote: > On Wed, 27 Jun 2012 11:48:22 -0700, David Wagner <cptnwi...@gmail.com> > declaimed the following in gmane.comp.python.django.user: > > > Looking at that I think I may need to add a foreignkey to cert_types > > relating to person since a person can have multiple certification types > > (NRA Instructor, CCL Instructor, etc). > > Well, this has just added a different aspect... That of INSTRUCTOR > (my memory of the first messages came across more as a certificate that > one had attended a course <G>, not that it meant they could teach the > course). > > In the case of instructors -- what is the difference between "NRA" > and "CCL" instructor? "NRA" specifies an organization that provides the > certification in /something/, but "CCL" is a /something/ but who issues > it? > > Okay, looking at these as teaching certificates... > > Certificates > ID #primary key > Name #text string for the common name of the class > IssuingAuthority #NRA or government entity > DateFirstAuthorized #not date of issuance, but a double check > that > #an issued > certificate date does not come > #before the "class" > was created > RenewalPeriod #how often the certificate needs to be > renewed > > Persons > ID > Name > Address > whatever > > Issued #or PersonsCertificates if you want to name the > sources > ID > pID foreign key (Persons.ID) #who this certificate > was issued to > cID foreign key (Certificates.ID) #what type of > certificate > DateIssued #constraint DateIssued > DateFirstAuthorized > CertificateNumber #document number > DateExpires #for things that need to be renewed > periodically > #= DateIssued + > RenewalPeriod > UniqueKey (pID, cID, CertificateNumber) > #including certificate number means you can track renewals > #as a renewal would have a different serial number > > This is a many-to-many between Persons and Certificates, in which > the intersection table (Issued) contains additional information. > > > -- > Wulfraed Dennis Lee Bieber AF6VN > wlfr...@ix.netcom.com HTTP://wlfraed.home.netcom.com/ > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@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. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@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.
