Locale: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
==Tables==
<source lang="sql">
SELECT
    table_code,
    table_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00
</source>
==Fields==
<source lang="sql">
SELECT
    field_code,
    table_code,
    field_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00
</source>
==Languages==
==Languages==
<source lang="sql">
<source lang="sql">
Line 9: Line 36:
     amender
     amender
FROM
FROM
     T00M00X00
     T00M02X00
</source>
</source>


Line 22: Line 49:
     amender
     amender
FROM
FROM
     T00M01X00
     T00M03X00
</source>
</source>


Line 40: Line 67:
     amender
     amender
FROM
FROM
     T00M02X00
     T00M04X00
</source>
</source>

Revision as of 19:51, 11 September 2019

Tables

SELECT
    table_code,
    table_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M00X00

Fields

SELECT
    field_code,
    table_code,
    field_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M01X00

Languages

SELECT
    iso_alpha2_lingo_code,
    iso_alpha2_lingo_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M02X00

Countries

SELECT
    iso_alpha2_state_code,
    iso_alpha2_state_name,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M03X00

Translations

SELECT
    translated_code,
    translated_table_code,
    translated_field_code,
    translated_field_value,
    iso_alpha2_lingo_code,
    iso_alpha2_state_code,
    translated,
    entered,
    enterer,
    amended,
    amender
FROM
    T00M04X00