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);
}

---

Index	Binary	Char		Index	Binary	Char		Index	Binary	Char		Index	Binary	Char
0	000000	0		16	010000	G		32	100000	W		48	110000	m
1	000001	1		17	010001	H		33	100001	X		49	110001	n
2	000010	2		18	010010	I		34	100010	Y		50	110010	o
3	000011	3		19	010011	J		35	100011	Z		51	110011	p
4	000100	4		20	010100	K		36	100100	a		52	110100	q
5	000101	5		21	010101	L		37	100101	b		53	110101	r
6	000110	6		22	010110	M		38	100110	c		54	110110	s
7	000111	7		23	010111	N		39	100111	d		55	110111	t
8	001000	8		24	011000	O		40	101000	e		56	111000	u
9	001001	9		25	011001	P		41	101001	f		57	111001	v
10	001010	A		26	011010	Q		42	101010	g		58	111010	w
11	001011	B		27	011011	R		43	101011	h		59	111011	x
12	001100	C		28	011100	S		44	101100	i		60	111100	y
13	001101	D		29	011101	T		45	101101	j		61	111101	z
14	001110	E		30	011110	U		46	101110	k		62	111110	_
15	001111	F		31	011111	V		47	101111	l		63	111111	.

Types

Data SELECT created_at, created_by, updated_at, updated_by, version_no, id, data_type_code, data_type_name FROM M00TM00X00

Error SELECT created_at, created_by, updated_at, updated_by, version_no, id, error_type_code, error_type_name FROM M00TM01X00

Mime SELECT created_at, created_by, updated_at, updated_by, version_no, id, mime_type_code, mime_type_name FROM M00TM##X00

Objects

Tables SELECT created_at, created_by, updated_at, updated_by, version_no, id, table_code, table_nome, data_type_code, FROM M00TM02X00

Forms SELECT created_at, created_by, updated_at, updated_by, version_no, id, form_code, form_name, data_type_code, apps_type, base_flag, base_form FROM M00TM03X00

Reports SELECT created_at, created_by, updated_at, updated_by, version_no, id, report_code, report_name, data_type_code, FROM M00TM04X00

Errors SELECT created_at, created_by, updated_at, updated_by, version_no, id, error_code, error_name, error_type_code, FROM M00TM05X00

Labels

Fields SELECT created_at, created_by, updated_at, updated_by, version_no, id, field_code, table_code, field_order, field_name FROM M00TM06X00

Forms SELECT created_at, created_by, updated_at, updated_by, version_no, id, label_code, form_code, label_name, label_value FROM M00TM07X00

Reports SELECT created_at, created_by, updated_at, updated_by, version_no, id, label_code, report_code, label_name, label_value FROM M00TM08X00

Localizations

Languages SELECT created_at, created_by, updated_at, updated_by, version_no, id, lingo_code, iso_alpha2_lingo_code, iso_alpha3_lingo_code, lingo_name FROM M00TL00X00

Countries SELECT created_at, created_by, updated_at, updated_by, version_no, id, country_code, iso_alpha2_country_code, iso_alpha3_country_code, longitude, latitude, altitude, country_name FROM M00TL01X00

Currencies SELECT created_at, created_by, updated_at, updated_by, version_no, id, notes_code, iso_alpha3_notes_code, iso_alpha3_state_code, iso_numeric_code, official_flag, decimal_point, notes_symbol, crypto_flag, notes_name FROM M00TL02X00

Translations

Tables SELECT created_at, created_by, updated_at, updated_by, version_no, id, translated_code, table_code, field_code, field_value, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value FROM M00TL03X00

Forms SELECT created_at, created_by, updated_at, updated_by, version_no, id, translated_code, form_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value FROM M00TL04X00

Reports SELECT created_at, created_by, updated_at, updated_by, version_no, id, translated_code, report_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value FROM M00TL05X00

Errors SELECT enter_at, enter_by, amend_at, amend_by, revision, id, translated_code, error_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value FROM M00TL06X00

Proposed

sense of old user ────────────────────────── id  : Base36Id revision: Number enter_at: DateTime enter_by: Base36Id enter_on: Base36Id amend_at: DateTime amend_by: Base36Id amend_on: Base36Id trash_at: DateTime code  : Base36Code

sense of gui user ────────────────────────── id  : Base36Id revision : Number create_at: DateTime create_by: Base36Id create_on: Base36Id update_at: DateTime update_by: Base36Id update_on: Base36Id delete_at: DateTime code  : Base36Code

sense of sql user ────────────────────────── id  : Base36Id revision  : Number inserted_at: DateTime inserted_by: Base36Id inserted_on: Base36Id updated_at : DateTime updated_by : Base36Id updated_on : Base36Id deleted_at : DateTime code  : Base36Code

√ sense of any user ────────────────────────── id  : Base36Id version_no: Number created_at: DateTime created_by: Base36Id created_on: Base36Id updated_at: DateTime updated_by: Base36Id updated_on: Base36Id deleted_at: DateTime code  : Base36Code

References

Using MySQL table to simulate Oracle Sequence @SequenceGenerator for MySql Database Create Sequence Supported Database Difference Between a URI and a URL Prepositions of Time - at, in, on JPA Inheritance Base64 Base36 Base32 DBUnit

PostgreSQL MapStruct Liquibase Lombok JPA