Database Schema

The Terms & Conditions Manager uses the following tables.

#__tc_content

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
id	INT
client	VARCHAR
key	VARCHAR
email_status	INT
sms_status	INT
push_status	INT
web_status	INT
email_body	TEXT
sms_body	TEXT
push_body	TEXT
web_body	TEXT
email_subject	TEXT
sms_subject	TEXT
push_subject	TEXT
web_subject	TEXT
state	INT
created_on	DATE
updated_on	DATE
is_override	INT

#__tj_notification_providers

Master table for the providers

Column Name	Data Type
provider	VARCHAR
state	INT

#__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
user_id	INT
client	VARCHAR
key	VARCHAR
provider	VARCHAR