Schema ``directory`` ==================== Tables ------ data_source ^^^^^^^^^^^ Describes data_sources. A data_source is used to indicate where data came from. Datasources are also used to prevent collisions between sets of data from different sources, where names can be the same, but the meaning of the data differs. +-------------+---------+----------+-------------+ | Column | Type | Nullable | Description | +=============+=========+==========+=============+ | id | integer | ✘ | | +-------------+---------+----------+-------------+ | name | varchar | ✘ | | +-------------+---------+----------+-------------+ | description | varchar | ✘ | | +-------------+---------+----------+-------------+ entity_type ^^^^^^^^^^^ Stores the entity types that exist in the entity table. Entity types are also used to give context to data that is stored for entities. +-------------+---------+----------+-------------+ | Column | Type | Nullable | Description | +=============+=========+==========+=============+ | id | integer | ✘ | | +-------------+---------+----------+-------------+ | name | varchar | ✘ | | +-------------+---------+----------+-------------+ | description | varchar | ✘ | | +-------------+---------+----------+-------------+ tag_group ^^^^^^^^^ Stores groups that can be related to by tags. +---------------+---------+----------+-------------+ | Column | Type | Nullable | Description | +===============+=========+==========+=============+ | id | integer | ✘ | | +---------------+---------+----------+-------------+ | name | varchar | ✘ | | +---------------+---------+----------+-------------+ | complementary | bool | ✘ | | +---------------+---------+----------+-------------+ tag ^^^ Stores all tags. A tag is a simple label that can be attached to a number of object types in the database, such as entities and trends. +--------------+---------+----------+-------------+ | Column | Type | Nullable | Description | +==============+=========+==========+=============+ | id | integer | ✘ | | +--------------+---------+----------+-------------+ | name | varchar | ✘ | | +--------------+---------+----------+-------------+ | tag_group_id | integer | ✘ | | +--------------+---------+----------+-------------+ | description | varchar | ✔ | | +--------------+---------+----------+-------------+ Functions --------- get_entity_type_name(integer) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ get_entity_type(text) ^^^^^^^^^^^^^^^^^^^^^ get_data_source(text) ^^^^^^^^^^^^^^^^^^^^^ create_data_source(text) ^^^^^^^^^^^^^^^^^^^^^^^^ delete_data_source(text) ^^^^^^^^^^^^^^^^^^^^^^^^ define_entity_type(text) ^^^^^^^^^^^^^^^^^^^^^^^^ init_entity_type(directory.entity_type) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ create_entity_type(text) ^^^^^^^^^^^^^^^^^^^^^^^^ name_to_entity_type(text) ^^^^^^^^^^^^^^^^^^^^^^^^^ name_to_data_source(text) ^^^^^^^^^^^^^^^^^^^^^^^^^