@startuml
hide empty members
hide circle
skinparam classAttributeIconSize 0
class _object_ObjectID_ as "<object/(ObjectID)>"
_object_ObjectID_ : {field} a crm:E22_Man-Made_Object
class _object_ObjectIDclean_title_TitleIDclean_ as "<object/(ObjectIDclean)/title/(TitleIDclean)>"
_object_ObjectID_ -down-> _object_ObjectIDclean_title_TitleIDclean_ : crm:P102_has_title
_object_ObjectID_ : {field}  <color:red>"\nselect *, \n  replace(',','',ObjectID) as ObjectIDclean\n  replace(',','',TitleID) as TitleIDclean\n  (case TitleType of 'Primary Title' then Title else null end) as TitlePrimary\nfrom titles.csv\n"</color>
_object_ObjectID_ : {field} rdfs:label "(TitlePrimary)"
_object_ObjectIDclean_title_TitleIDclean_ : {field} a crm:E35_Title
class _object_ObjectIDclean_title_TitleIDclean_id_ as "<object/(ObjectIDclean)/title/(TitleIDclean)/id>"
_object_ObjectIDclean_title_TitleIDclean_ -down-> _object_ObjectIDclean_title_TitleIDclean_id_ : crm:P1_is_identified_by
class _thesaurus_title_TitleTypeIDclean_ as "<thesaurus/title/(TitleTypeIDclean)>"
_object_ObjectIDclean_title_TitleIDclean_ -down-> _thesaurus_title_TitleTypeIDclean_ : crm:P2_has_type
_object_ObjectIDclean_title_TitleIDclean_ : {field} crmx:display_order "(DisplayOrder)"^^xsd:integer
_object_ObjectIDclean_title_TitleIDclean_ : {field} rdf:value "(Title)"
_object_ObjectIDclean_title_TitleIDclean_id_ : {field} a crm:E42_Identifier
_object_ObjectIDclean_title_TitleIDclean_id_ : {field} rdf:value "(TitleIDclean)"
_thesaurus_title_TitleTypeIDclean_ : {field} a skos:Concept
_thesaurus_title_TitleTypeIDclean_ : {field} rdfs:label "(TitleType)"
_thesaurus_title_TitleTypeIDclean_ : {field} skos:exactMatch aat:SOMETHING
@enduml
