|Subject||Re: [firebird-support] Re: MySQL Enum type?|
> > I'll ask again: what are you trying to accomplish?Right, let me try to see if I get this straight:
> I have a one-to-one relationship. In the "mastertable" I want to store
> a type about which other table to look up the additional fields. I
> want to store this type as one of the values from a text set.
> Hope you understand what I mean, but I think the workaround was
> already posted.
Type (Enum ( type1, type2, type3 ) )
Would this be some kind of class hierarchy, btw?
Either way, what point is using ENUM here? Why not make a Types table and
do a FK to that? Or indeed, use the DOMAIN instead?
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!