Difference between revisions of "Software Design:Categories"

(New page: Software Design issues for the part categories system: database tables in bbdb: '''categories''' Each category has a name and a description. '''part_categories''' Contains a part - cat...)
 
Line 11: Line 11:
 
*''issue'': Is the category a number indexed into bbdb.categories of the text name of the category?
 
*''issue'': Is the category a number indexed into bbdb.categories of the text name of the category?
 
*''issue'': Would this design be better if the categories were in a u_list?
 
*''issue'': Would this design be better if the categories were in a u_list?
−
*''issue'': What is the mysql 'set' type?
+
** ''answer'': Perhaps if we were using the category numbers above.
 +
 
 +
*''issue'': Why not use the mysql 'set' type?
 +
** ''answer'': The set datatype requires that all the possible values be defined at table creation.

Revision as of 18:01, 13 April 2009

Software Design issues for the part categories system:

database tables in bbdb:

categories Each category has a name and a description.

part_categories Contains a part - category binding.

  • issue: Is the category a number indexed into bbdb.categories of the text name of the category?
  • issue: Would this design be better if the categories were in a u_list?
    • answer: Perhaps if we were using the category numbers above.
  • issue: Why not use the mysql 'set' type?
    • answer: The set datatype requires that all the possible values be defined at table creation.