CDM and Vocab in same schema

[davidhcar]

When CDM and Vocabularies are in the same schema what should be the daimon_type in the source_daimon table? Could someone clarify please?

[chrisknoll]

It is the normal case that vocab and cdm tables are in the same schema. The reason that we have a 'vocab' daimon separate from a 'cdm' daimon is that it is possible to set up a source that is only used for vocabulary searching.

IN your case, just put the same schema for the CDM and Vocabulary Daimon (CDM=0, Vocab=1)

[davidhcar]

Thank you @chrisknoll Which column, refers to the schema in the source_daimon table ?

[chrisknoll]

table_qualifier. We used that instead of 'shema' because in the early years of buidling the app, different DB platforms had different definitions of what a 'schema' is, so we just called it table_qualifier to avoid that.

[davidhcar]

Thank you again for the prompt response @chrisknoll. The naming convention of being generic makes sense.