# DB Schema: Which table contains the localized mapping?

**URL:** <https://speciforum.org/t/db-schema-which-table-contains-the-localized-mapping/409>\
**Category:** Get Help\
**Tags:** Specify-7\
**Created:** [April 15, 2022, 11:24pm UTC](https://speciforum.org/t/db-schema-which-table-contains-the-localized-mapping/409 "2022-04-15T23:24:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcruz](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/mcruz/32/451_2.png) [@mcruz](https://speciforum.org/u/mcruz)\
**Post date:** [April 15, 2022, 11:24pm UTC](https://speciforum.org/t/db-schema-which-table-contains-the-localized-mapping/409/1 "2022-04-15T23:24:55Z")

</div>

Which table in the database contains the information on the label and if the field is shown?

Example to see all of the following:

1. How “collectionOjbectAttribute.number5” is labeled and shown.
2. How “collectionObjectProperties.text16” is labeled and shown.

It was suggested to me that peeking at this table in MySQL workbench might be a faster way to see this information vs opening up the schema and looking around there.

---

<div class="post-metadata">

**Author:** ![maxpatiiuk](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/maxpatiiuk/32/563_2.png) [@maxpatiiuk](https://speciforum.org/u/maxpatiiuk)\
**Post date:** [April 18, 2022, 6:11pm UTC](https://speciforum.org/t/db-schema-which-table-contains-the-localized-mapping/409/2 "2022-04-18T18:11:44Z")

</div>

Information is stored in tree tables: splocalecontainer (for tables), splocalecontaineritem (for fields) and splocaleitemstr (stores strings for tables and fields).

Next Specify 7 release would have a Schema Editor, so you won’t have to make these changes though the database