Multiple reference in SQL

Posted by AGarofoli on Stack Overflow See other posts from Stack Overflow or by AGarofoli
Published on 2010-05-17T15:09:14Z Indexed on 2010/05/17 15:20 UTC
Read the original article Hit count: 101

Filed under:

Hi! I'm working on a db but i'm kinda new to this so i've bumped into a problem today. I've got some tables: OFFICE, ROOM, EMPLOYEE and DOCUMENT. Document must specify the sender, which can be a single employee, an entire room or an entire office so it must have a reference to the primary keys of those tables. Should I do a "parallel" table for handle it (for example i've done one for handle the multiple recipients documents) or there is another way? Thank you

© Stack Overflow or respective owner

Related posts about sql