In response to Ognjen Blagojevic <ogn...@etf.bg.ac.rs>: > Hi, > > How do you name a table which sole purpose is to store a list of values? > E.g. > > Table: sex > id name > ------- > 1 male > 2 female > > Table: day > id name > ------- > 1 Sunday > 2 Monday > 3 Tuesday > 4 Wednesday > 5 Thursday > 6 Friday > 7 Saturday > > Is this: > a. Lookup table > b. Classifier > c. Cypher(er)? > > I'm looking for the appropriate term in English.
I try to make it an ENUM when it's very unlikely to change, i.e. day of the week is a good candidate for an enum ... when's the last time that changed? For lookup tables that aren't static enough to be an enum, it usually ends up appended with _list (i.e. gender_list, county_list, etc) -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
