 So we just spent some time creating our first table the visit table But I want to go ahead and start to expand on this the idea of a database is being able to have all of these different kind of Things of data that somehow interweave together So the first thing I kind of want to think about is well if we look at a visit for example Well a visit typically has a bill to it as well so I want to go ahead and create that bill and so You notice okay. Well, how do I do that? Especially since I don't get that luxury of having the same kind of Table popping up like we did with the visit table when I started my database to do this We go to our create tab and you see that we get a few different options The one I want to actually click on this time is table design Now table design table design if you notice looks a little different. It's not the luxury that we see With visit which is more the traditional Microsoft Excel style with my records going down my Columns going up top. Well now called fields now things are a little different now There's no data Now I'm literally making each one of my fields first I'm making all of my columns because there are none currently in my database So the first one I'm going to go ahead and name is a invoice No, again, we're talking about billing. So it makes perfect sense to be having a billing number to that and Again, all right. Well, we're gonna go ahead and hit tab You see that we get our data type and we can select from all the same data types We've worked with in the past. I'm going to go ahead and just keep it as short text Now you notice over here. We have this section called description Optional well, that's because if we kind of look at it notice. I said invoice numb. No space Okay, well, what does that mean? Okay, we can infer invoice number, but You know, that doesn't always happen. That's not always naturally the case so the description gives us a way as people as You know not computers To understand what we're doing one of the other things I can do here is I can also add in something known as a Little comment saying this is called my primary key now my primary key It technically has not done anything just yet again The description is just like a comment talking about what we're dealing with But over here in my design tab You might notice that I have over on the far left Something that says primary key right there and if I click on it You notice I get a little key right here that appears by invoice. No, the primary key now specifies that this Field is this part of my record is going to be Unique and never No, never blank What that allows for me to do is now have this unique identifier for every one of my invoices that way I don't at any point in time accidentally have to invoices of different amounts with the same number You can think of this like your social security number You wouldn't want someone else to have your social security number and then then go to a bank and take out You know a hundred thousand dollars in loans because well You both now owe a hundred thousand dollars in loans So we don't want those kind of things this primary key what it does is it explicitly is now saying that can't happen You