Content Modules
The main modules that you can find in Alfred CMS are the Homepage and Pages. You can also use other ones such as Blog, News, Resources, Events and so on (all depends on the project needs). However all of them are based on the Pages though! As you have read before, all the pages are based on the pages database table. All the modules have their own controllers, sometimes their own services, however all of them call or extend the Pages Service, use one Pages model etc.
Feel free to create your own modules, based on one of the ready ones and adjust to project needs!