the database

Read-only access to the database functions and tables.

full schema dump

tables

tadvisorygroup (
- advisorygroupid
)
tadvisorygroup_user (
- advisorygroupid,
- userid
)
tarticle (
- articleid,
- body,
- createdate,
- externalsourceid,
- feederid,
- md5,
- origonal,
- title,
- url,
- version
)
tarticle_forum (
- articleid,
- forumid
)
tarticle_quote (
- articleid,
- quote,
- quoteid
)
tarticle_tag (
- articleid,
- feederid,
- position,
- tagid
)
tarticle_word (
- articleid,
- position,
- wordid
)
tbigram (
- bigramid,
- word1,
- word2
)
tblogcategory (
- blogcategoryid,
- description,
- name
)
tblogpost (
- blogcategoryid,
- blogpostid,
- body,
- createdate,
- description,
- tags,
- title,
- userid
)
tcarrotmob (
- area,
- businesstype,
- carrotmobid,
- createdate,
- description,
- image,
- latitude,
- location,
- longitude,
- mobdate,
- mobtype,
- name,
- opendate,
- overallcompanyreview,
- private,
- userid,
- zoom
)
tcarrotmob_entity (
- agreement,
- blog,
- carrotmobid,
- entityid,
- image,
- interview,
- perc_revenue
)
tcarrotmob_user (
- carrotmobid,
- shout,
- userid
)
tcarrotmob_vote (
- carrotmobid,
- createdate,
- entityid,
- reason,
- userid
)
tcategory (
- categoryid,
- description,
- name,
- parentcategoryid
)
tcategory_taggroup (
- categoryid,
- taggroupid
)
tcms (
- cmsid,
- cmskey,
- domainid,
- parentpage,
- proc,
- template
)
tcmsvalue (
- cmsid,
- createdate,
- reason,
- userid,
- value,
- version
)
tcommitment (
- commitmentid,
- companyid,
- createdate,
- enddate,
- initial,
- percentage,
- specific,
- startdate,
- target
)
tcompany_product (
- companyid,
- productid,
- relationship
)
tcompany_producttype (
- companyid,
- createdate,
- order,
- producttypeid
)
tcompanywow (
- companyid,
- interestpercentage,
- interesttype,
- subsiduaryid
)
tdomain (
- code,
- description,
- domainid,
- name,
- siteroot
)
temaillist (
- area,
- bounce,
- createdate,
- emailaddress,
- listid,
- name,
- networking,
- notes,
- source
)
tentity (
- createdate,
- entityid,
- feederid,
- feedernotes,
- latitude,
- location,
- longitude,
- markuppolicyid,
- moderation,
- namequalifiersetid,
- subtype,
- system
)
tentity_article (
- articleid,
- entityid
)
tentity_forum (
- entityid,
- forumid
)
tentity_qualifierset (
- entityid,
- qualifiersetid
)
texternalsource (
- area,
- domain,
- enabled,
- externalsourceid,
- externalsourcetypeid,
- notes,
- rootpagetitle,
- startpage
)
texternalsourcetype (
- description,
- externalsourcetypeid,
- name
)
tfeederprogram (
- buildid,
- enabled,
- feederid,
- majorversion,
- minorversion,
- name,
- versionname
)
tforum (
- createdate,
- description,
- forumid,
- name,
- userid
)
tinvestment (
- amount,
- commitmentid,
- companyid,
- createdate,
- description,
- investmentid
)
tknowledge_article (
- articleid,
- createdate,
- entityid,
- finish,
- readingid,
- sessionid,
- userid
)
tlcompany (
- businesstypequalifier,
- companyid,
- entityid,
- icon,
- notes,
- voucherbookid,
- website
)
tlcountry (
- countryid,
- entityid
)
tlperson (
- entityid,
- personid
)
tlproduct (
- entityid,
- maincompanyid,
- productid
)
tlproducttype (
- entityid,
- icon,
- producttypeid,
- relevance9c
)
tlproducttype_category (
- colour,
- description,
- icon,
- name,
- parentcategoryid,
- producttype_categoryid,
- relevance9c
)
tpost (
- body,
- createdate,
- forumid,
- postid,
- summary,
- title,
- userid
)
tpost_article (
- articleid,
- postid
)
tpost_entity (
- entityid,
- postid
)
tpost_post (
- childpostid,
- postid
)
tproducttype_product (
- productid,
- producttypeid
)
tproducttype_producttype_category (
- producttype_categoryid,
- producttypeid
)
tqualifierset (
- phrase,
- qualifiersetid
)
tqualifierword (
- position,
- qualifiersetid,
- wordid
)
tsearches (
- amount,
- lastused,
- term
)
tsession (
- autosavearticles,
- autosaveentities,
- createdate,
- domainid,
- iframe,
- javascript,
- lastactiondate,
- sessionid,
- sessionstring,
- useragent,
- userid
)
tsession_briefcase (
- addsource,
- articleid,
- sessionid
)
tsession_entity (
- addsource,
- entityid,
- rank,
- sessionid,
- touched
)
tstatus (
- createdate,
- entityid,
- status,
- statusid,
- statustypeid,
- userid
)
tstatustype (
- createdate,
- description,
- name,
- statustypeid
)
tsummary (
- addsource,
- articleid,
- body,
- createdate,
- feederid,
- md5,
- summaryid,
- title,
- userid,
- version
)
ttag (
- criteria,
- taggroupid,
- tagid,
- tagqualifiersetid,
- tagtype
)
ttaggroup (
- tag,
- taggroupid
)
ttaggroup_bigram (
- bigramid,
- count,
- taggroupid
)
ttaggroup_taggroup (
- associatedtaggroupid,
- count,
- taggroupid
)
ttaggroup_unigram (
- count,
- taggroupid,
- wordid
)
ttransaction (
- createdate,
- transactiondate,
- transactionid
)
ttransaction_voucher (
- transactionid,
- voucherid
)
tuser (
- about_you_cyclist,
- about_you_dont_use_airplanes,
- about_you_fairtrade,
- about_you_freerange,
- about_you_local_produce,
- about_you_not_stated,
- about_you_organic,
- about_you_other,
- about_you_vegetairian_vegan,
- active,
- affiliations,
- age_group,
- area,
- avatar,
- blackballed,
- businessownerid,
- buy_online_clothes,
- buy_online_electronics,
- buy_online_financial_products,
- buy_online_flights,
- buy_online_groceries,
- buy_online_holiday_accomodation,
- buy_online_insurance,
- buy_online_media,
- buy_online_not_stated,
- buy_online_other,
- createdate,
- disactivatedate,
- emailaddress,
- encryptedpassword,
- ethnic_group,
- firstname,
- flickr_name,
- flickr_password,
- flickr_photoid,
- flickr_set,
- gender,
- income_group,
- lastlogin,
- lastname,
- latitude,
- location,
- longitude,
- message_long,
- message_medium,
- message_short,
- middlename,
- mobilenumber,
- nickname,
- profession,
- purchase_research,
- purchase_research_other,
- subscribe_events,
- subscribe_news,
- system,
- type9c,
- userid,
- username,
- verificationid,
- verified,
- what_ideas,
- what_skills,
- what_tools,
- why_do_you_ethically_consume,
- youtube_name,
- youtube_password,
- youtube_playlist,
- youtube_videoid
)
tuser_producttype (
- producttypeid,
- userid
)
tusergroup (
- createdate,
- description,
- name,
- usergroupid,
- userid
)
tusergroup_user (
- createdate,
- inviteuserid,
- usergroupid,
- userid
)
tvoucher (
- code,
- value,
- voucherbookid,
- voucherid
)
tvoucherbook (
- createdate,
- notes,
- voucherbookid
)
tword (
- feederid,
- markuppolicyid,
- stopword,
- word,
- wordid
)
twordnet (
- commonality,
- definition,
- feederid,
- senseid,
- special,
- wordcount,
- wordid
)
twordnetsense (
- description,
- name,
- senseid
)
twordnetspecial (
- description,
- name,
- special
)
txobjectparsersetting (
- pagegroupid,
- propertyid,
- regex,
- required,
- type
)
txpagegroup (
- cleanerfilter_footer,
- cleanerfilter_header,
- cleanerfilter_other,
- description,
- enable,
- exceptionsregxx,
- externalsourceid,
- headingfilter_level1,
- headingfilter_level2,
- outputfilter,
- pagegroupfilter,
- pagegroupid,
- parsertype,
- sectionfilter,
- typeid
)
txsummary (
- body,
- createdate,
- md5,
- summaryid,
- title,
- url
)
txtagfilter (
- enable,
- exceptions,
- filter,
- filterid,
- negativity,
- relevancyid,
- tagid
)

ppp - public xml - xsl - website system procedures

These procs generate the XML for their related XSL webpages with the same path

the database

tables

ppp - public xml - xsl - website system procedures

padd - public and private procs that allow external apps to add content into the system

uxml - private procs that assemble XML for an object in the system

uexists - internal checking to see if an item already exists

unormalise - normalisation of strings

usession - session handling

other - misc