Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-11-09 : 17:46:20
|
| I've been assigned a project, and it's a bit of new territory to me.Here's what I have to do:1. Design a project that allows users to select documents to have mailed to them on a regular basisWhat I was thinking was a three table design:Parent table:1. PK integer2. string column with e-mail addressChild table [Document]:1. PK integer2. Document stored in this columnChild table [DocSelected]...or something like this:1. PK integer / FK for linking to parent table PK2. PK integer / FK for linking to chilc table [Document]I'm thinking this way if there are more documents added, I only have to udpate the [Document] tableShould I use [DocSelected] as a join table?Thanks....any suggestions are welcome! |
|
|
|
|
|
E-mail documents schema design