Anvil: Web Apps with Nothing but Python Transcripts
Chapter: Databases: Storing and querying data
Lecture: Add the averages table
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
We're going to need one more table for our web app to work. When we get to the compare yourself against the average person of your age
0:09
and height and things like that we need to have that data so that we can then compare you to it. So, let's add one more table.
0:17
Now, create a new table, averages and in here we're going to have just a couple of things. We're going to have a text column.
0:24
This will be gender and it'll be like male or female. We're going to have a number and this is going to be your height, the average height.
0:35
And have a weight. And we're going to have a rate as in heart rate. And that's it. We're going to write a little app to populate this later
0:45
but for now, we're going to have this table just around 'cause that's going to round out all the tables we got to create, might as well do it here.