Locale

static char *base36enc(long unsigned int value) {
    char base36[36] = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    /* log(2**64) / log(36) = 12.38 => max 13 char + '\0' */
    char buffer[14];
    unsigned int offset = sizeof(buffer);

    buffer[--offset] = '\0';
    do {
        buffer[--offset] = base36[value % 36];
    } while (value /= 36);

    return strdup(&buffer[offset]); // warning: this must be free-d by the user
}

static long unsigned int base36dec(const char *text) {
    return strtoul(text, NULL, 36);
}

Types

Data SELECT id, data_type_id, data_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM00X00

Error SELECT id, error_type_id, error_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM01X00

Mime SELECT id, mime_type_id, mime_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM##X00

Objects

Tables SELECT id, table_id, table_name, data_type_id, enter_at, enter_by, amend_at, amend_by FROM M00TM02X00

Forms SELECT id, form_id, form_name, data_type_id, apps_type, base_flag, base_form, enter_at, enter_by, amend_at, amend_by FROM M00TM03X00

Reports SELECT id, report_id, report_name, data_type_id, enter_at, enter_by, amend_at, amend_by FROM M00TM04X00

Errors SELECT id, error_id, error_name, error_type_id, enter_at, enter_by, amend_at, amend_by FROM M00TM05X00

Labels

Fields SELECT id, field_id, table_id, field_order, field_name, enter_at, enter_by, amend_at, amend_by FROM M00TM06X00

Forms SELECT id, label_id, form_id, label_name, label_value, enter_at, enter_by, amend_at, amend_by FROM M00TM07X00

Reports SELECT id, label_id, report_id, label_name, label_value, enter_at, enter_by, amend_at, amend_by FROM M00TM08X00

Localizations

Languages SELECT id, lingo_id, iso_alpha2_lingo_id, iso_alpha3_lingo_id, lingo_name, enter_at, enter_by, amend_at, amend_by FROM M00TL00X00

Countries SELECT id, country_id, iso_alpha2_country_id, iso_alpha3_country_id, longitude, latitude, altitude, country_name, enter_at, enter_by, amend_at, amend_by FROM M00TL01X00

Currencies SELECT id, notes_id, iso_alpha3_notes_id, iso_alpha3_state_id, iso_numeric_id, official_flag, decimal_point, notes_symbol, crypto_flag, notes_name, enter_at, enter_by, amend_at, amend_by FROM M00TL02X00

Translations

Tables SELECT id, translated_id, table_id, field_id, field_value, iso_alpha2_lingo_id, iso_alpha2_state_id, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL03X00

Forms SELECT id, translated_id, form_id, label_id, iso_alpha2_lingo_id, iso_alpha2_state_id, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL04X00

Reports SELECT id, translated_id, report_id, label_id, iso_alpha2_lingo_id, iso_alpha2_state_id, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL05X00

Errors SELECT id, translated_id, error_id, iso_alpha2_lingo_id, iso_alpha2_state_id, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL06X00

References

• Prepositions of Time - at, in, on
• JPA Inheritance
• Base64
• Base36
• Base32
• DBUnit