| Subject | RE: [firebird-support] Design Question: Storing and using generic text "tags" |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-06-26T14:02:33Z |
At 11:09 PM 26/06/2009, you wrote:
./heLen
>Hi Daniel,Ummm, fail? The tag only has to be entered once. If it's there already, it doesn't need to be added: an exception will take care of it.
>
>> I'd imagine a design like this:
>
>Thank you for your input on this.
>
>> create table tags
>> (
>> constraint un_tags_name unique(name)
>
>In a multi-user environment I'll have to be prepared for this to fail (two users added the same new tag at the same time).
./heLen