All right, welcome back to Module five. Siegel Development. This is less than one skimmer development, and we're currently in sub lesson 1.5 Implement the categories model and this lesson we're going to implement the categories model. It's the next easiest, modeled implement after the Tags model. And just as a note,
we're going to implement just the table slash models we need.
And then after that, we're gonna implement the constraints and the foreign keys that we need. So we're gonna break apart our work, create the models first, then add in the constraints that we need after we've created all our models with that said, let's get started.
left click on the tables within our CMA said base and select create new table,
go ahead and add a categories for the name
going to right click create new column
bigness t i d column. We're gonna make that a big ends on signed
or say that cannot be no.
gonna add in a new column?
We call this the main column. I think marsh are 100 is just fine for that.
We're gonna say that it can't be No. So they must provide a name when it's added.
We're gonna create a new column,
and this is going to be a description column.
Bar char might not be enough. So we're gonna go ahead and
make that the text. Which means that can be a very, very large amount of text in this column.
I'm gonna say that can be null so they don't have to add a description, which is a common design pattern you see out there, you you often see applications where this description is not a required field.
We didn't click. Okay,
we're gonna go ahead and add in the constraint of the primary key.
select I d hit. Okay,
let's go ahead and save this
So we created our category tables.
so we created our categories table that completes this lesson. And the next lesson we will create the articles table. I hope to see you there. Thank you.