Now set up your ‘articles’ table, with the following columns:

  • title (Text column)
  • content (Text column)
  • image (Media column)
  • created (Date and Time column)
  • updated (Date and Time column)

Here’s how to do that:

  1. Click ‘Add a table’ in the light blue box at the top, then ‘Create new table…’. You’ll be prompted to give your table a name - let’s call it ‘articles’.

  2. Next, add a column for the article title, by clicking ‘+ New Column’ and choosing ‘Add text column…’. Call this column ‘title’.

  3. Keep adding columns until your Data Table has the structure we described above. Column titles are case sensitive, so let’s stick to lower case.

Creating the 'Articles' data table

Your Data Table should look something like this:

Database schema