I'm looking for finding the Title of the Out-Of-Box and Custom Document types in Alfresco database schema. The ALF_QNAME table does contain the QName definition of the document types but does not have any other information about the document type.
Going through the Alfresco Core implementation I cold not find any location where this information is persisted in DB or Content Store. It seems the compiled models are just maintained in the Cache as objects.This sounded a bit odd implementation.
In case someone can point me where in DB can I find the Title of document types it will be really useful.