LIJA_character_analysis.md

nuxeo=> select * from ucldc_schema_alternativetitle where id='04efcf49-a328-41e1-8641-fe74dfbaec73';
                  id                  | pos | item 
--------------------------------------+-----+------
 04efcf49-a328-41e1-8641-fe74dfbaec73 |   0 | 梅花
(1 row)

--> rest API json returns ��

nuxeo=> select id from hierarchy where parentid='fbca8e2d-cc1a-490c-9615-696e3fa7ad12' and name='ucldc_schema:creator';
                  id                  
--------------------------------------
 8198a68f-86c4-45a4-ad9b-93c85ff33918
(1 row)

nuxeo=> select * from ucldc_schema_creatortype where id='8198a68f-86c4-45a4-ad9b-93c85ff33918';
                  id                  | nametype | source |         name         |     role     | authorityid 
--------------------------------------+----------+--------+----------------------+--------------+-------------
 8198a68f-86c4-45a4-ad9b-93c85ff33918 | persname | naf    | Doi, Gōga, 1817-1880 | Calligrapher | 
(1 row)

nuxeo=> select md5(name) from ucldc_schema_creatortype where id='8198a68f-86c4-45a4-ad9b-93c85ff33918';
               md5                
----------------------------------
 c46704379c1cd8fbd4ccec3c66852960
(1 row)

--> rest API JSON returns Doi, G�ga, 1817-1880

nuxeo=> select id from hierarchy where parentid='ef0db0f1-7ea5-4eab-a8b9-1c13a4eacb28' and name='ucldc_schema:creator';
                  id                  
--------------------------------------
 690735e4-cf3a-4de9-a469-839e4bfd5c65
(1 row)

nuxeo=> select * from ucldc_schema_creatortype where id='690735e4-cf3a-4de9-a469-839e4bfd5c65';
                  id                  | nametype | source |         name         |  role  | authorityid 
--------------------------------------+----------+--------+----------------------+--------+-------------
 690735e4-cf3a-4de9-a469-839e4bfd5c65 | persname | naf    | Doi, Gōga, 1817-1880 | Artist | 
(1 row)

nuxeo=> select md5(name) from ucldc_schema_creatortype where id='690735e4-cf3a-4de9-a469-839e4bfd5c65';
               md5                
----------------------------------
 c46704379c1cd8fbd4ccec3c66852960
(1 row)

--> rest API returns Doi, Gōga, 1817-1880