Schema notification_directory

Tables

notification_store

Describes notification_stores. Each notification_store maps to a set of tables and functions that can store and manage notifications of a certain type. These corresponding tables and functions are created automatically for each notification_store. Because each notification_store maps one-on-one to a data_source, the name of the notification_store is the same as that of the data_source. Use the create_notification_store function to create new notification_stores.

Column	Type	Nullable	Description
id	integer	✘
data_source_id	integer	✔

attribute

Describes attributes of notification stores. An attribute of a notification store is an attribute that each notification stored in that notification store has. An attribute corresponds directly to a column in the main notification store table

Column	Type	Nullable	Description
id	integer	✘
notification_store_id	integer	✔
name	name	✘
data_type	name	✘
description	varchar	✘

notification_set_store

Describes notification_set_stores. A notification_set_store can hold information over sets of notifications that are related to each other.

Column	Type	Nullable	Description
id	integer	✘
name	name	✘
notification_store_id	integer	✔

set_attribute

Describes attributes of notification_set_stores. A set_attribute of a notification_set_store is an attribute that each notification set has. A set_attribute corresponds directly to a column in the main notification_set_store table.

Column	Type	Nullable	Description
id	integer	✘
notification_set_store_id	integer	✔
name	name	✘
data_type	name	✘
description	varchar	✘

Functions

notification_store_schema()

to_char(notification_directory.notification_store)

table_name(notification_directory.notification_store)

staging_table_name(notification_directory.notification_store)

create_table_sql(notification_directory.notification_store)

create_table(notification_directory.notification_store)

create_staging_table_sql(notification_directory.notification_store)

create_staging_table(notification_directory.notification_store)

drop_staging_table_sql(notification_directory.notification_store)

drop_staging_table(notification_directory.notification_store)

initialize_notification_store(notification_directory.notification_store)

define_attribute(notification_directory.notification_store, name, name, text)

define_attributes(notification_directory.notification_store, notification_directory.attr_def[])

define_notification_set_store(name name, notification_store_id integer)

notification_store(notification_directory.notification_set_store)

get_notification_store(data_source_name name)

define_notification_store(data_source_id integer)

define_notification_store(data_source_id integer, notification_directory.attr_def[])

create_notification_store(data_source_id integer, notification_directory.attr_def[])

create_notification_store(data_source_name text, notification_directory.attr_def[])

create_notification_store(data_source_id integer)

create_notification_store(data_source_name text)

init_notification_set_store(notification_directory.notification_set_store)

create_notification_set_store(name name, notification_store_id integer)

create_notification_set_store(name name, notification_directory.notification_store)

get_column_type_name(namespace_name name, table_name name, column_name name)

get_column_type_name(notification_directory.notification_store, name)

add_attribute_column_sql(name, notification_directory.attribute)

add_staging_attribute_column_sql(notification_directory.attribute)

create_attribute_column(notification_directory.attribute)

get_attr_defs(notification_directory.notification_store)

drop_table_on_delete()

drop_notification_set_store_table_on_delete()

cleanup_on_data_source_delete()

Sequences

notification_store_id_seq(integer)