|Subject||Re: [firebird-support] FB Embedded: Table Field encryption questions|
> As to whether the index should be in the database. You could,Very wrong! Of course WORD cannot be the primary key, it must
> for example, create a table for the index data and then define
> a FB index on that table such as this really basic (and
> probably wrong) example:
> CREATE TABLE SECRET_LOOKUP (
> WORD VARCHAR(30) PRIMARY KEY,
> SECRET_TABLE VARCHAR(31),
> LOOKUP_PK INTEGER );
be allowed to occur multiple times.
Hopefully you got the gist anyway. Lots of details to work
through; whether it is worth normalising, what index(es) will
work best in your particular situation and so on.