-
Notifications
You must be signed in to change notification settings - Fork 6
Database Schema
Samadhan Salunkhe edited this page Mar 18, 2017
·
16 revisions
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)'. 'Content' field stores all T & C in text format. The 'global' field is used for showing T & C for all pages. The 'groups' field stores selected user types for accepting T & C.
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
This table is used for storing client, option, view & params of URL
Column Name | Data Type |
---|---|
tc_id | INT |
client | VARCHAR |
option | VARCHAR |
view | VARCHAR |
params | VARCHAR |
#__tc_acceptance
This table stores the accepted users T & C entries.
Column Name | Data Type |
---|---|
user_id | INT |
tc_id | INT |
client | VARCHAR |
accepted_on | DATE |
params | VARCHAR |