Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Polymorphic database tables? More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Which database engine are you using? (Score:1)

by mattk (7945) on 2008.06.14 2:54 (#63395) Homepage Journal

You could use Postgres schemas to achieve this - keep your survey table in one schema, and your faculty/department tables, identically structured, in seperate schemas. When you want to work with the faculty stuff, set your search path to survey + faculty. If the survey schema holds unique keys, the same join queries should return different results based on which schema is active.

Reply to This
- Here's what I'd try first (Score:1)
  
  by Ron Savage (5224)
  
  o The survey table has a context_id
  
  o The context table has:
  - the id pointed to by context_id
  - the owner_id
  - the owner_type_id
  
  o The owner_type table has:
  - the id pointed to by owner_type_id
  - the name of the owner type
  
  o The owner_id points to either the faculty
  table's id or the dept table's id (if you
  insist on having these in separate tables,
  an assumption which needs questioning)
  
  (o Alternately, the faculty and dept tables
  can have owner_type_id, of course)
  
  o The owner_type's name tells you what type
  of thing, fa

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.