Inheritance - Multiple membership

Поиск
Список
Период
Сортировка
От Jimmie Fulton
Тема Inheritance - Multiple membership
Дата
Msg-id FB93404FB67ED311ABF9009027991188417E66@www.ehso.emory.edu
обсуждение исходный текст
Ответы Re: Inheritance - Multiple membership  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
This question was asked in 1998 on this list by someone else, but did not
appear to be answered...

Say I have a tbl_person.  tbl_teacher and tbl_student both inherit from
tbl_person and each have their own extended attributes.  Is it possible for
a person in tbl_person to be both a teacher at the school, and also a
student (say night school or something).  Also, the student may be a
part-time employee, like a graduate student.  If it is possible, what would
an insert look like.  Given the possibility that someone can exist in both
tbl_teacher and tbl_student, what happens if you delete their student
record.  I'm guessing that it should leave the other records in tact.

Any ideas?



В списке pgsql-sql по дате отправления:

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: [GENERAL] tables, permissions, sequences
Следующее
От: Christophe Labouisse
Дата:
Сообщение: Re: Integrity reference and inheritance