Subject Re: [firebird-support] DB design best practices - which solutionisfaster?
Author Woody
From: "Peter Faulks" <faulksp@...>
> I'm still not 100% sure what it is you are doing....
>
> 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?
>

Excuse me for jumping in here but there might be many reasons such as
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)