Database question

[Paul Lussier]

Dan,

Is this what you meant:

    class_types:

    id   | integer | nextval
    name | text    | not null

    primary key: id

    classes:

    id   | integer | nextval
    name | text    | not null
    type | integer | not null

    primary key: id
    foreign key: type references class_types(id)

    members:
    id    | integer | not null
    class | integer | not null
    type  | integer | not null

    primary key: name
    foreign key: class references class(id)
    foreign key: type references class_types(id)


Then, based on the value of members.type, I could figure out which
table to look up the member(id) in.  If it were of type 'class', then
the id would map into that table, if of type 'machines', the id would
map into the machines table, etc.///

Thanks!
-- 

Seeya,
Paul