The plugin uses certain terms and concepts and it’s a lot easier to use once you understand what they mean.
- Database – WordPress stores all your data in a MySQL database. This database consists of a number of tables.
- Table – A database table stores information in a specific format. For example, WordPress stores posts in the posts table. A table consists a series of rows, in much the same way as a spreadsheet.
- Row – A database row is a single entry in a database table. For example, a post will have a row in the posts table. It contains a sequence of columns that specifies all the data for a particular entry. This matches a row in a spreadsheet.
- Column – A column contains data of a specific type. For example, a post has many columns including date, status, content etc.
These concepts are used throughout the plugin. For example, you can add filters to find specific rows from the posts table. These filters are performed on the columns such as post type.