Thomas (and anyone else), Here's my proposal for changes to the actor database schema for the patron statistical category enhancements:
1. Mark a required category table actor.stat_cat: new column "required": boolean -- NOT NULL, DEFAULT false 2. Allow/disallow user-entered text for a category table actor.stat_cat: new_column "allow_freetext": boolean -- NOT NULL, DEFAULT true 3. Set a default entry new table "actor.stat_cat_entry_default" Columns: id : serial -- PRIMARY KEY, stat_cat_entry : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.stat_cat_entry stat_cat : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.stat_cat By including both stat_cat_entry and stat_cat in this last table and declaring each one as UNIQUE, we can ensure that for a given statistical category only one entry is ever marked the default. Would it make sense to create a stored procedure that returned either -1 (no default entry) or the ID of the default entry for a given stat_cat? How does this sound? Am I missing anything? Do other schemas come into play? thanks, -- Scott
