RdsDiagram
Country
id: INTEGER
name: VARCHAR(255)
company
id: INTEGER
name: VARCHAR(255)
address1: VARCHAR(255)
address2: VARCHAR(255)
city: VARCHAR(255)
countryID: INTEGER
email: VARCHAR(255)
phone: VARCHAR(255)
contactname: VARCHAR(255)
passwordx: VARCHAR(255)
last_logged: datetime
lastupdated: datetime
active: bit
ipaddress: VARCHAR(250)
logo_image_location: VARCHAR(250)
company_number: VARCHAR(255)
tax_number: VARCHAR(255)
subscribe: bit
blocked: bit
whenx: datetime
activity
id: INTEGER
descx: VARCHAR(255)
dateadded: VARCHAR(255)
company_id: INTEGER
campaign_game
id: INTEGER
campaign_id: INTEGER
image_id: INTEGER
judge_x: DECIMAL(18,0)
judge_y: DECIMAL(18,1)
company_id: INTEGER
checkbox_text: TEXT
Icon_master_id: INTEGER
whenx: datetime
campaign_game_types_id: INTEGER
animation_name: VARCHAR(255)
isPrivate: bit
Campaign_Master
CID: INTEGER
Camp_name: VARCHAR(255)
Camp_Desc: VARCHAR(500)
CompanyID: INTEGER
End_Date: DATE
isActive: bit
Start_Date: DATE
isPaid: bit
iscomplete: INTEGER
isTrial: bit
TimeZone_Id: INTEGER
prize_details: VARCHAR(255)
whenx: datetime
campaign_costs_id : INTEGER
campaign_cost_currency: INTEGER
number_of_days: INTEGER
welcome_text: VARCHAR(255)
campaign_cost_charge: DECIMAL(18,2)
campaign_type_id: INTEGER
bitly: VARCHAR(255)
2dbarcode_loc: VARCHAR(255)
campaign_boost_id: INTEGER
campaign_mood: INTEGER
isPaid_whenx: datetime
Client
Client_Id: INTEGER
namex: VARCHAR(255)
whenx_added: datetime
verifiedx: VARCHAR(255)
campaign_id: INTEGER
emailx: VARCHAR(255)
phonex: VARCHAR(255)
company_id: INTEGER
posx: DECIMAL(18,1)
posy: DECIMAL(18,1)
distx: DECIMAL(18,1)
wonx: INTEGER
device_details: TEXT
timex: TIME
company_logs
id: INTEGER
staff_id: INTEGER
notesx: TEXT
whenx: datetime
company_id: INTEGER
Device_Details: TEXT
Campaign_question_controls
Control_Id: INTEGER
Control_Name: VARCHAR(255)
whenx: datetime
When Launching we will just
use TEXTBOX......textbox,
dropdown, checkbox etc.
Campaign_questions
campaign_questions_id: INTEGER
campaign_ id: INTEGER
order_id: INTEGER
whenx: DATE
control_id: INTEGER
ques_desc: VARCHAR(255)
mandatory: INTEGER
isActive: INTEGER
textbox_type: INTEGER
prev_archivex: bit
Campaign_answers
campaign_answers_id: INTEGER
campaign_id: INTEGER
campaign_questions_id: INTEGER
Ans_desc: VARCHAR(255)
client_id: INTEGER
Whenx: datetime
User_Wrong_Log
Id: INTEGER
CID: INTEGER
Password: BOOLEAN
whenX: datetime
password_typed: VARCHAR(255)
email: VARCHAR(255)
Payment_Methods
ID: INTEGER
Name: VARCHAR(255)
Company_Id: INTEGER
whenx: datetime
Campaign_Credit_History_temp
ID: INTEGER
UID: INTEGER
Payment_Method_ID: INTEGER
amount_taken: NUMERIC(18,2)
ref: VARCHAR(255)
history: TEXT
authorised: INTEGER
emailx: VARCHAR(255)
reward_amt: NUMERIC(18,2)
currency: VARCHAR(50)
mobilex: VARCHAR(255)
CID: INTEGER
whenX: datetime
game_images
id: INTEGER
descx_small: VARCHAR(255)
dateadded: VARCHAR(255)
image_location: VARCHAR(255)
judge_x: DECIMAL(18,1)
judge_y: DECIMAL(18,1)
descx_large: TEXT
games_category
id: INTEGER
descx: VARCHAR(255)
dateadded: VARCHAR(255)
ADHIR - this may need
more work - however not
needed for App Dev
Exception
Ex_Id: INTEGER
whenx: Datetime
Error: VARCHAR(500)
Error_Details: Text
Source_page: VARCHAR(500)
source_Event: VARCHAR(255)
company_id: INTEGER
UserId: INTEGER
company_app_login
id: INTEGER
company_id: INTEGER
device_id: VARCHAR(500)
whenx: datetime
games_tag_master
id: INTEGER
descx: VARCHAR(255)
TimeZone_Master
id: INTEGER
timeZone_Name: VARCHAR(255)
timeZone_desc: VARCHAR(255)
whenx_added: datetime
New York+7GMT
New York +10GMT
London +3GMT
London +12GMT
game_images_tags
id: INTEGER
games_images_id: INTEGER
games_tag_master_id: INTEGER
whenx: datetime
games_images_cat
id: INTEGER
games_images_id: INTEGER
games_cat_master_id: INTEGER
whenx: datetime
games_icon_master
id: INTEGER
whenx_added: datetime
icon_img_location: VARCHAR(255)
orderx: INTEGER
game_tags_popular
id: INTEGER
descx: VARCHAR(500)
whenx: datetime
game_images_popular
id: INTEGER
game_images_id: INTEGER
whenx: datetime
campaign_costs
id: INTEGER
descx: VARCHAR(255)
no_days: INTEGER
cost_gbp: DECIMAL(18,2)
cost_usd: DECIMAL(18,2)
cost_eur: DECIMAL(18,2)
whenx: datetime
user_searches
Id: INTEGER
user_id: INTEGER
descx: TEXT
whenx: datetime
company_email_settings
id: INTEGER
company_id: INTEGER
smtp_username: VARCHAR(255)
smtp_from_email: VARCHAR(255)
smtp_password: nvarchar
smtp_host: VARCHAR(255)
smtp_port: INTEGER
smtp_encryption: INTEGER
whenx: DATE
help_main
id: INTEGER
whenx: datetime
image_loc: VARCHAR(255)
descx: VARCHAR(255)
help_sub
id: INTEGER
help_main_id: INTEGER
whenx: datetime
isActive: bit
whenx_updated: datetime
order_no: INTEGER
questionx: VARCHAR(255)
answerx: TEXT
tagx: TEXT
company_image_library
id: INTEGER
company_id: INTEGER
image_loc: VARCHAR(255)
isDeleted: bit
judge_x: NUMERIC(18,1)
judge_y: NUMERIC(18,1)
whenx: datetime
campaign_questions_possible_answers
id: INTEGER
decsx: VARCHAR(255)
whenx: datetime
campaign_questions_id: INTEGER
Campaign_answers_possible_answers
id: INTEGER
campaign_answers_id: INTEGER
campaign_questions_possible_answers_id: INTEGER
whenx: datetime
campaign_game_types
id: INTEGER
descx: VARCHAR(255)
whenX: datetime
Textbox_type: 1=normal,
2=calender, 3=numeric
qanda_cats
id: INTEGER
descx: VARCHAR(500)
whenx: datetime
1 Spot the Ball
2 Odd One Out
3 Q and A
4 No Game
qanda_questions
id: INTEGER
whenx: datetime
q: VARCHAR(255)
a1: VARCHAR(255)
a2: VARCHAR(255)
a3: VARCHAR(255)
qanda_cats_id: INTEGER
campaign_game_qanda
id: INTEGER
campaign_id: INTEGER
qanda_questions_id: INTEGER
whenx: datetime
customx: bit
campaign_game_qanda_answers
id: INTEGER
campaign_id: INTEGER
campaign_game_qanda_id: INTEGER
Ans_desc: VARCHAR(255)
client_id: INTEGER
Whenx: datetime
time_taken: INTEGER
oddoneout_cats
id: INTEGER
descx: VARCHAR(500)
whenx: datetime
oddoneout_questions
id: INTEGER
whenx: datetime
filename1: VARCHAR(255)
filename2: VARCHAR(255)
filename3: VARCHAR(255)
filename4: VARCHAR(255)
oddoneout_cats_id: INTEGER
tags: TEXT
campaign_game_oddoneout
id: INTEGER
campaign_id: INTEGER
oddoneout_questions_id: INTEGER
whenx: datetime
customx: bit
campaign_game_oddoneout_answers
id: INTEGER
campaign_id: INTEGER
campaign_game_oddoneout_id: INTEGER
ans_no: INTEGER
client_id: INTEGER
whenx: datetime
time_taken: INTEGER
qanda_questions_custom
id: INTEGER
whenx: datetime
q: VARCHAR(255)
a1: VARCHAR(255)
a2: VARCHAR(255)
a3: VARCHAR(255)
company_id: INTEGER
archivex: bit
campaign_type
id: INTEGER
descx: VARCHAR(255)
cost_gbp: DECIMAL(18,2)
cost_usd: DECIMAL(18,2)
cost_eur: DECIMAL(18,2)
max_days: INTEGER
help_main_international
id: INTEGER
help_main_id: INTEGER
descx: VARCHAR(255)
whenx: datetime
help_main_language_id: INTEGER
help_main_language
id: INTEGER
whenx: datetime
descx: VARCHAR(255)
help_sub_international
id: INTEGER
help_main_id: INTEGER
questionx: VARCHAR(255)
whenx: datetime
help_main_language_id: INTEGER
answerx: TEXT
tagx: TEXT
gamification_levelx
id: INTEGER
descx: VARCHAR(250)
min_points: INTEGER
validx: INTEGER
discountx: INTEGER
whenx: datetime
gamification_logx
id: INTEGER
client_id: INTEGER
no_points: INTEGER
descx: TEXT
whenx: datetime
credit_history_temp_id: INTEGER
gamification_clients
id: INTEGER
client_id: INTEGER
lifetime_points: INTEGER
current_no_points: INTEGER
whenx: datetime
gamification_levelx_id: INTEGER
expiry_date: datetime
current_discount_balance: INTEGER
gamification_levelx_logx
id: INTEGER
client_id: INTEGER
whenx: datetime
gamification_levelx_id: INTEGER
oddoneout_questions_custom
id: INTEGER
whenx: datetime
filename1: VARCHAR(255)
filename2: VARCHAR(255)
filename3: VARCHAR(255)
filename4: VARCHAR(255)
company_id: INTEGER
archivex: bit
campaign_lost_clicks
id: INTEGER
campaign_ id: INTEGER
device_details: TEXT
whenx: datetime
emailx: VARCHAR(255)
namex: VARCHAR(255)
whyx: bit
campaign_boost
id: INTEGER
descx: VARCHAR(255)
orderid: INTEGER
cost_gbp: DECIMAL(18,2)
cost_usd: DECIMAL(18,2)
cost_eur: DECIMAL(18,2)
whyx 0 = before
i.e. not started yet,
1 = after i.e.
expired
campaign_currencies
id: INTEGER
descx: VARCHAR(255)
symbolx: VARCHAR(10)
company_team
id: INTEGER
company_id: INTEGER
emailx: VARCHAR(250)
passwordx: VARCHAR(250)
whenx: datetime
whenx_emailed: datetime
company_team_campaign
id: INTEGER
company_team_id: INTEGER
campaign_id: INTEGER
company_team_status_id: INTEGER
whenx: datetime
stopx: bit
whenx_stopx: datetime
company_team_status
id: INTEGER
decsx: VARCHAR(255)
web_url_main
id: INTEGER
campaign_id: INTEGER
messagex_before: TEXT
messagex_after: TEXT
link_fb: VARCHAR(250)
link_twitter: VARCHAR(250)
link_linkedin: VARCHAR(250)
link_ig: VARCHAR(250)
link_tiktok: VARCHAR(250)
link_yt: VARCHAR(250)
google_a: VARCHAR(250)
main_bg_color: VARCHAR(10)
main_bg_image: VARCHAR(250)
side_main_image: VARCHAR(250)
side_shadow_color: VARCHAR(10)
side_main_color1: VARCHAR(10)
side_main_color2: VARCHAR(10)
main_panel_bg_color: VARCHAR(10)
main_panel_icon: VARCHAR(250)
text_1: TEXT
text_2: TEXT
text_3: TEXT
text_4: TEXT
whenx_changed: datetime
web_url_icons
id: INTEGER
locx: VARCHAR(250)
whenx: datetime