[D3d-Sec] [Tables] Facebook

  ____    _____       _           ____                    _  _
 |  _ \  |___ /    __| |         / ___|    ___    ___   _| || |_
 | | | |   |_ \   / _` |  _____  \___ \   / _ \  / __| |_  ..  _|
 | |_| |  ___) | | (_| | |_____|  ___) | |  __/ | (__  |_      _|
 |____/  |____/   \__,_|         |____/   \___|  \___|   |_||_|


               -----------------------XIII; Downi; Sw3 ----------------------
               -------------- @xIII_Ms ; @MsDowni ; @IMSW3_--------------

Database : information_schema
-----------------------------
Table COLLATIONS ( Rows)
-----------------------------
Database :  bge
-----------------------------
Table : Allowed_users ( Rows)
-----------------------------
facebook_name
facebook_id
-----------------------------
Table [Email_signup ( Rows)]
-----------------------------
address
time
key
-----------------------------
Table [ad ( Rows)]
-----------------------------
id
ad_type_id
full_link_text
submitter
-----------------------------
Table [ad_assigned_to_idea ( Rows)]
-----------------------------
id
idea_id
ad_id
-----------------------------
Table [ad_type ( Rows)]
-----------------------------
ID
Company
Campaign type
-----------------------------
Table [basic_ideas ( Rows)]
-----------------------------
id
short_title
poem
prose
long_title
ad_line
-----------------------------
Table [calc_param_values ( Rows)]
-----------------------------
param_value_id
idea_id
option_name
initial_cost_fixed
initial_cost
old_watts
new_watts
-----------------------------
Table [category ( Rows)]
-----------------------------
name
category_id
-----------------------------
Table [idea ( Rows)]
-----------------------------
idea_id
summary
description
savings
initcost
difficulty
status
name_option
hoursPerWeek_name
nInstances_name
hoursPerWeek_defaultVal
nInstances_defaultVal
calc_explanation
calc_option_name
heating_conserved_percentage
driving_conserved_percentage
date _created
adPic1
adText1
adText2
adPic2
Own
Rent
Apartment
Dorm
Condo
House
-----------------------------
Table [idea_given_to ( Rows)]
-----------------------------
ID
idea_id
fbuser_owner
fbuser_giver
time given
type
-----------------------------
Table [idea_invented_by ( Rows)]
-----------------------------
invented_by_id
idea_id
inventor_id
-----------------------------
Table [idea_rating ( Rows)]
-----------------------------
id
idea_fk
rater_fbid
rating
-----------------------------
Table [image_assigned_to ( Rows)]
-----------------------------
ID
image_id
user_id
user_id_giver
date
image_status
gift_type
-----------------------------
Table [images ( Rows)]
-----------------------------
image_id
type
width
height
category
location
-----------------------------
Table [is_tagged_by ( Rows)]
-----------------------------
id
category_fk
idea_fk
-----------------------------
Table [page_viewed_by ( Rows)]
-----------------------------
id
time_viewed
page
viewer_fbid
-----------------------------
Table [pledge ( Rows)]
-----------------------------
pledge_id
user_id
idea_id
param_value_id
pledge_status
pledge_type
timestamp
InitialCost
savings_kwh
savings_natgas
savings_heatingoil
savings_gasoline
summary
nInstances
hoursPerWeek
-----------------------------
Table [unit ( Rows)]
-----------------------------
id
name
multiplier
explanation
added_by
type
-----------------------------
Table [user ( Rows)]
-----------------------------
user_id
fb_name
permissions_level
fb_id
Electricity_cost
co2PerKwh
date_joined
own
house_type
annual_heating_cost
heat_with
cost_per_therm
cost_per_gallon
cost_per_gallon_gasoline
car_mpg
miles_per_year
unit_fk
-----------------------------
Database [f2c]
-----------------------------
Table [campaigns ( Rows)]
-----------------------------
short_cause
short_bill
instructions
primary_key
current
hometown
email_subject
display_name
owner_displayName
owner_displayEmail
owner_uid
senate
house
action
report_url
-----------------------------
Table [caucus ( Rows)]
-----------------------------
ID
Name
-----------------------------
Table [districts ( Rows)]
-----------------------------
Zip
CD
State
-----------------------------
Table [legislator_in_campaign ( Rows)]
-----------------------------
ID
fk_legislator
fk_campaign
priority
-----------------------------
Table [legislator_in_caucus ( Rows)]
-----------------------------
id
fk_legislator
fk_caucus
-----------------------------
Table [legislators ( Rows)]
-----------------------------
ID
State
District
Name
Last_name
Party
state_code
dc_office
dc_phone
district_phone
online_contact
web
-----------------------------
Table [tracking ( Rows)]
-----------------------------
from_id
to_id
legislator_fk
campaign_fk
status
Primary_key
Comments
timestamp
-----------------------------
Table [zips ( Rows)]
-----------------------------
zip
city
code
state
citystate
-----------------------------
Database [norman]
-----------------------------
Table [mailinglist_blacklist ( Rows)]
-----------------------------
rule
-----------------------------
Table [mailinglist_drafts ( Rows)]
-----------------------------
id
subject
message
texthtml
lastsaved
-----------------------------
Table [mailinglist_messages ( Rows)]
-----------------------------
id
subject
message
created
queued
count
format
-----------------------------
Table [mailinglist_queue ( Rows)]
-----------------------------
message_id
address
send_after
-----------------------------
Table [mailinglist_subscribers ( Rows)]
-----------------------------
address
userkey
confirmed
last_sub_req_date
bounce_count
-----------------------------
Database [ywc_dev]
-----------------------------
Table [Allowed_users ( Rows)]
-----------------------------
facebook_name
facebook_id
-----------------------------
Table [ad ( Rows)]
-----------------------------
id
ad_type_id
full_link_text
submitter
-----------------------------
Table [basic_ideas ( Rows)]
-----------------------------
id
short_title
poem
prose
long_title
ad_line
-----------------------------
Table [calc_param_values ( Rows)]
-----------------------------
param_value_id
idea_id
option_name
initial_cost_fixed
initial_cost
old_watts
new_watts
-----------------------------
Table [category ( Rows)]
-----------------------------
name
category_id
-----------------------------
Table [idea ( Rows)]
-----------------------------
idea_id
summary
description
savings
initcost
difficulty
status
name_option
hoursPerWeek_name
nInstances_name
hoursPerWeek_defaultVal
nInstances_defaultVal
calc_explanation
calc_option_name
heating_conserved_percentage
driving_conserved_percentage
date _created
adPic1
adText1
adText2
adPic2
Own
Rent
Apartment
Dorm
Condo
House
-----------------------------
Table [idea_given_to ( Rows)]
-----------------------------
ID
idea_id
fbuser_owner
fbuser_giver
time given
type
-----------------------------
Table [idea_invented_by ( Rows)]
-----------------------------
invented_by_id
idea_id
inventor_id
-----------------------------
Table [idea_rating ( Rows)]
-----------------------------
id
idea_fk
rater_fbid
rating
-----------------------------
Table [image_assigned_to ( Rows)]
-----------------------------
ID
image_id
user_id
user_id_giver
date
image_status
gift_type
-----------------------------
Table [images ( Rows)]
-----------------------------
image_id
type
width
height
category
location
-----------------------------
Table [is_tagged_by ( Rows)]
-----------------------------
id
category_fk
idea_fk
-----------------------------
Table [page_viewed_by ( Rows)]
-----------------------------
id
time_viewed
page
viewer_fbid
-----------------------------
Table [pledge ( Rows)]
-----------------------------
pledge_id
user_id
idea_id
param_value_id
pledge_status
pledge_type
timestamp
InitialCost
savings_kwh
savings_natgas
savings_heatingoil
savings_gasoline
summary
nInstances
hoursPerWeek
-----------------------------
Table [unit ( Rows)]
-----------------------------
id
name
multiplier
explanation
added_by
type
-----------------------------
Table [user ( Rows)]
-----------------------------
user_id
fb_name
permissions_level
fb_id
Electricity_cost
co2PerKwh
date_joined
own
house_type
annual_heating_cost
heat_with
cost_per_therm
cost_per_gallon
cost_per_gallon_gasoline
car_mpg
miles_per_year
unit_fk