kraada wrote:I don't think that will cause any problems, but you will need to keep that new table updated if you play in new tournament types.
The manual work for keeping the table updated can be avoided by replacing the proposed static table with a dynamic view:
CREATE VIEW lookup_tourney_table_type AS SELECT id_table_type AS id_type, description FROM tourney_table_type