Solution

• When using the Web Developer Console, we can see that the website is powered by WordPress and spreadsimple.com is used for data persistence.

Schema

Table category {
  id integer [primary key, not null, unique]
  // e.g. "Facebook Ads"
  name char(128) [not null]
}

// A resource type is a tool, a guide, a generic resource or anything else
Table resource_type {
  id integer [primary key, not null, unique]
  // e.g. "Resource", "Guide", "Article"
  name char(128) [not null]
  // corresponding Twitter Bootstrap Badge
  badge char(128) [not null]
}

Table resource {
  id integer [primary key, not null, unique]
  // e.g. FB Growth Hack #1
  title char(255) [not null]
  // image is required. This would only contain the sub path below WordPress' upload directory, e.g  "2020/09/appsumo-logo-meta.png". This makes it easy to migrate to a new domain later in time
  image char(255) [not null]
  // target URL of the resource
  url char(255) [not null]
  // description of the resource
  description text [not null]
  // each resource belongs to exactly one category
  category_id int [not null, ref: > category.id]
  // resource type *might* be optional?
  resource_type_id int [null, ref: > resource_type.id]
}