[Maypole] Status table relationship

From: Brian Glass (brian at glassbrian.com)
Date: Fri Sep 24 2004 - 02:27:10 BST


Suppose I have a table of status codes for different purposes.

It has a status_type column along with a typical id column which is the
primary key. I want to relate multiple other tables to this status_code
table but I want each relationship to be limited to a certain value of
status_type.

Example:

A car has a color. There are a list of colors in the status_code table
all with the status_type column set to color. A car has_a color. A
person can be either a driver or a passenger. There are a list of person
roles in the status_code table all with the status_type column set to
person_role. A person has_a person_role.

How can a make such a relation ship in Maypole/Class::DBI?

_______________________________________________
maypole mailing list
maypole at lists.netthink.co.uk
http://lists.netthink.co.uk/listinfo/maypole



This archive was generated by hypermail 2.1.3 : Thu Feb 24 2005 - 22:25:56 GMT