Localization and workspace related TYPO3 database fields

l10n_ws_fields.md

Localization and Workspaces SQL fields Cheat Sheet

Localization

sys_language_uid

Contains a uid pointing to the sys_language table and indicates which language the record is in. 0 means default language. -1 means this record should be used for all languages.

l10n_parent

Contains a uid pointing to the same table and to the record in the default language. Normally only translated records (sys_language_uid > 1) should have this field filled.

l10n_source

Contains a uid pointing to the same table and to the record that this record was translated from. A translation is not necessarily created from the default language record, but can be derived from another translated record.

l10n_state

Contains a json string that stores configuration on how the fields of the record behave regarding the synchronisation of values betweet the source record and the translated record.

l10n_diffsource

Contains a serialized array of field values of the original records, that is used to show changes to the original record in the backend that may not be reflected in the translated recird yet.

Workspaces

t3_origuid

Contains the uid of the original record of this record version.

t3ver_oid

Contains the uid of the version that this record version is created from (which might not equal t3_origuid if you have nested workspaces).

t3ver_state

Contains information about wether the orignial record was created, moved, deleted in the workspace. See \TYPO3\CMS\Core\Versioning\VersionState for more documentation.

t3ver_stage

If you have a multi stage workflow this column contains the uid of the sys_workspace_stage the version is currently in.

t3ver_count

Holds a count of available versions for a given record.

t3ver_tstamp

Timestamp of the version

t3ver_move_id

If this field is set the current record acts as a placeholder for a record that is to be moved, which has this uid.