Subject | Re: [firebird-support] DB design best practices - which solutionisfaster? |
---|---|
Author | Woody |
Post date | 2010-11-19T15:23:08Z |
From: "Peter Faulks" <faulksp@...>
sending thank you notes, reminding you to check the status of something
after a seminar, follow ups, deadlines for filing reimbursement requests,
etc..
Woody (TMW)
> I'm still not 100% sure what it is you are doing....Excuse me for jumping in here but there might be many reasons such as
>
> Sounds like you need a separate table then. Join the two on a integer
> primary key - use create generator and select gen_id() to create a
> sequence. (it is always generally a good thing to make primary keys
> meaningless)
>
> When does a reminder expire? would you then delete it from the table?
>
> Why would a reminder be set for after the event?
>
sending thank you notes, reminding you to check the status of something
after a seminar, follow ups, deadlines for filing reimbursement requests,
etc..
Woody (TMW)