SirJakesalot / TutorialManager

A web application for managing a tutorial website
0 stars 0 forks source link

Add a category field to the tutorials table #7

Closed SirJakesalot closed 8 years ago

SirJakesalot commented 8 years ago

Add a categories table and incorporate a category for each tutorial.

SirJakesalot commented 8 years ago

Using a schema of id, name

SirJakesalot commented 8 years ago

Updated the createtable.sql/data.sql scripts to include the added table/column.

SirJakesalot commented 8 years ago

Need to incorporate another table, tutorial_categories. The schema will consist of two foreign keys referencing a tutorial object to a category object. This will enable a tutorial falling under mutiliple categories and lead to a nice query convention in the DataModel.