I just looked at the admin demo. Things are not as I would have assumed.
To add a category to a link you have to type the whole name of the category, e.g. /i/cant/belive/this. Why don't have a drop down menu that lists the available categories. Why all the typing? What if you make a data entry error? Is there a separate table for categories? Do the categories join to the link based on a unique key? Can someone provide a schema for the database?
Also, why is the design for the categories flat? I would think the best way to go is to use a design like:
unique_id int
cat_name char
subcategory_of int (pointer to unique_id of record who is the parent for this category)
So, to have /microsoft/software/ and /microsoft/mice/ you would have 3 records:
1 microsoft NULL
2 software 1
3 mice 1
To add a category to a link you have to type the whole name of the category, e.g. /i/cant/belive/this. Why don't have a drop down menu that lists the available categories. Why all the typing? What if you make a data entry error? Is there a separate table for categories? Do the categories join to the link based on a unique key? Can someone provide a schema for the database?
Also, why is the design for the categories flat? I would think the best way to go is to use a design like:
unique_id int
cat_name char
subcategory_of int (pointer to unique_id of record who is the parent for this category)
So, to have /microsoft/software/ and /microsoft/mice/ you would have 3 records:
1 microsoft NULL
2 software 1
3 mice 1
