Taxonomies

In CodeMash, Taxonomy is a type of collection where you store simple structural data; usually, you refer to that data in database collections (a.k.a tables). When you want to classify and group simple structure data, it would be best to choose taxonomy.

Good examples of taxonomy would be:

• Countries

• Cities

• Order Statuses (Pending, In Progress, Paid, Completed, ...)

• Event Types (Course, Webinar, Conference, ...)

• Work Item Types (Polishing, Service, Replacement of parts, Assembling, Dissasembling, ...)

Use the Taxonomy rule of thumb

Selected list items below are the perfect match to make data as a taxonomy:

• You want to have a dynamic list and include that in collections as a classification

• You want to have hierarchical data in your application. Such structures are the perfect fit for Taxonomy:

  • Country

    • -> State

      • -> City

  • Computers

    • Desktop

    • Laptop

    • Single-board computers

• You have uncertainty about the data changes in the feature. E.g., you classify working hours commitment between your company and employee as an "Employment status" with such structure:

  • Full time

  • 0.75 FTE (FTE - Full-time employee)

  • 0.5 FTE

  • 0.25 FTE

  • Per hour

• The data structure is simple and can be used from project to project

  • Countries

  • VAT percentages for each country

  • E-Shop categories and subcategories

  • Order statuses

When not to use Taxonomy

Please consider if it makes sense to have your data as taxonomy when:

1. The data list is short and with well-known and finished scope. E.g., Imperial units of measurement is a perfect match for the Enum database field rather than Taxonomy

   • Foot (feet)

   • Inches (inch)

   • Mile

   • Yard

2. Data is complex, with many additional fields. Taxonomy doesn't support all the fields the database collection schema does. You can extend taxonomy with custom fields, but those fields are stored under _meta property, so querying data is a bit more complicated.

Creating taxonomies

You can see and create a new taxonomy on our dashboard page:

• Go to Database

• Choose Taxonomies

• Here you can see all your project taxonomies, and you can create a new one by pressing the "Add New" button

1:N relationship

Let's say you want a country's list of corresponding states and cities. Such structure is explained below:

So we have three taxonomies here - Countries, States, and Cities. The parent of the taxonomy States is taxonomy Countries, and the parent of the taxonomy Cities is, of course, States' taxonomy. Le's follow the instructions defined below to achieve such functionality:

1. Add new taxonomy (Database -> Taxonomies -> Add New) called "Countries."

2. Add new taxonomy called "States."

3. Add new taxonomy called "Cities."

4. Go to States' taxonomy and press the taxonomy settings page.

   1. From the list of all taxonomies...

      
   2. ....or from the Taxonomy terms page

   
5. Point the parent property of the taxonomy of States to the taxonomy of Countries.

   
6. Point the parent property of the taxonomy of Cities to the taxonomy of States. The same as you did in the 5th step.

7. Fill in Countries. Go to Database -> Taxonomies -> Countries and add countries.

8. Fill in states. Now for each state, you can refer country accordingly.

9. Repeat it with cities.

Extending Taxonomy schema

Sometimes having an id and value data type is not enough. You often want to extend it a bit, add one extra digital number representing the country's population, or add some flag of the country that you can fetch from your mobile app. Are you forced for such a change to use Collection rather than taxonomy? Well, if the extension is simple, we have you covered. Please follow this page to see capabilities.

Terms

Taxonomy records are called terms.

API reference

Get Terms