Database Schema

The Terms & Conditions Manager uses the following tables.

#__tc_content This table is used for storing the Terms & Conditions with the combination of unique 'version no' & 'client(Ex. com_tjlms,com_subusers)'.

Column Name	Data Type
id	INT
version	INT
client	VARCHAR
content	VARCHAR
start_date	DATE
global	INT
groups	INT
is_blacklist	INT
enforce_delay	INT
created_on	DATE
modified_on	DATE

#__tc_pattern

Master table for the providers

Column Name	Data Type
tc_id	INT
client	VARCHAR
option	VARCHAR
view	VARCHAR
params	VARCHAR

#__tc_acceptance

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
tc_id	INT
client	VARCHAR
accepted_on	DATE
params	VARCHAR