Database Schema

The notifications uses the following tables.

#__tj_notification_templates This table contains 3 sets of columns per provider. When we add support for more providers, we will need to add 3 columns for each. the _status column indicates if that provider is enabled. The _body column stores the default body for the template. The _subject column is for providers that need a subject / title (eg: email, notifications).

Column Name	Data Type	Description
id	INT	NOT NULL AUTO_INCREMENT PRIMARY KEY
client	VARCHAR	NOT NULL
key	VARCHAR	NOT NULL
email_status	INT	NOT NULL
sms_status	INT	NOT NULL
push_status	INT	NOT NULL
web_status	INT	NOT NULL
email_body	TEXT	NOT NULL
sms_body	TEXT	NOT NULL
push_body	TEXT	NOT NULL
web_body	TEXT	NOT NULL
email_subject	TEXT	NOT NULL
sms_subject	TEXT	NOT NULL
push_subject	TEXT	NOT NULL
web_subject	TEXT	NOT NULL
state	INT	NOT NULL
created_on	DATE	NOT NULL
updated_on	DATE	NOT NULL
is_override	INT	NOT NULL

#__tj_notification_providers Master table for the providers

Column Name	Data Type	Description
provider	VARCHAR	NOT NULL PRIMARY KEY
state	INT	NOT NULL

#__tj_notification_user_exclusions This table stores the user level settings. If a user disables some emails for some providers, then that exclusion is added to this table.

Column Name	Data Type	Description
user_id	INT	NOT NULL
client	VARCHAR	NOT NULL
key	VARCHAR	NOT NULL
provider	VARCHAR	NOT NULL