Pathfinder Wiki:API/Database/Layout - Honor Variants

This table will holds all the information about honor variants

Template to save the data

The template that saves all of the information about variants into the database, is the HonorLanding template. This template is being used on each landing page of the honor to display the information and to enable the navigation to the subpages and all the variants.

Column description

In this part the columns of the honor variants table are described in detail.

landingID (Integer - mandatory)

The ID of the honor the variant belongs to.

type (String - allowed values)

Defines if the variant is an answer- or a requirement-variant.

Allowed values:

• answer_variants
• requirement_variants

authority (String)

The short name of the authority that released the requirements that are being used by the answer-variant or being defined by the requirement-variant.

countries (String)

Semicolon separated list of the countries that the answer-variant is relevant too.

srcLanguage (String)

ONLY USED BY ANSWER-VARIANTS Some answers are only relevant to some countries. For example in the Postcards honor the answers will differ from country to country. Those answers are also mostly only relevant for those countries, that is why it is possible to define a source language for answer variants. That way the answers don't need to be written in english and then be translated back to the needed language. Requirements should always be available in English. That is why we decided to not implement the source language for them.

The value in this cell has to be a language code defined on this list.