Schemas List

Schemas List

Top Previous Next

Every SQL Table in the system has an associated "Schema" or definition. Hyperseek uses these schemas to determine how to draw input forms, as well as how to save the data once you submit a form. Below is a chart which lists every table and schema in the system as well as it's intended use and some information about it, where relevant. (You'll note that some tables have multiple schemas as they're used by different parts of the system for drawing forms and such).

Note that some of the tables/schemas are used internally by the system, and are not to be edited. We have noted these tables in RED in the chart.

User Tables & Schemas (Ones you can/should edit)
Schema Name	Associated Table	Use / Purpose in Hyperseek

accounts	accounts	Used in the admin center's account edit screen
accounts_create	accounts	Used only when an advertiser signs up for a new account
accounts_user	accounts	Used only when an advertiser hits the "Edit Account" link. Note, on this form, you MUST have acct_id in there as "Hide and Show" field type, or else either the record will not save, or the user can change (and create) a new account id.
affiliate_info	affiliate_info	Used on the affiliate approval, and affiliate edit screens in the admin center.
hs_categories	hs_categories	Used to store/edit your category structure.
hyperseek_links	hyperseek_links	Used on the edit listing form in the admin center only.
hyperseek_links_user	hyperseek_links	Used as the form the user uses when they change or edit a link from their account manager program
hyperseek_temp	hyperseek_temp	Used only in the admin center to store new submissions.
hyperseek_temp_addurl	hyperseek_temp	Used as the form the user uses when they add a link
promotions	promotions	Used to define "Promotions" and "Promo Codes" in the admin center.
support_tickets	support_tickets	Used to let the user enter a new support request
support_ticket_replies	support_ticket_replies	Used to let the user reply to a support request
support_ticket_replies_admin	support_ticket_replies	Used to let the administrator reply to a support request
xml_feeds	xml_feeds	Used to edit/define backfill XML Feeds.

The following tables are "Logging and Temp" tables
Schema Name	Associated Table	Use / Purpose in Hyperseek

acct_deposits	acct_deposits	Temporarily stores deposit amounts for users.
acct_withdrawals	acct_withdrawals	Temporarily stores withdrawal requests
acct_summary	acct_summary	Summarizes click stats for users, used in reports
acct_transactions	acct_transactions	Stores every transaction (deposit, withdrawal) for accounts
affiliate_searches	affiliate_searches	Temporarily stores searches performed to be credited towards an affiliate (Cleaned out daily)
affiliate_payments	affiliate_payments	Stores a history of every payment made to affiliates
hyperseek_log	hyperseek_log	Stores details about every search run in Hyperseek
hyperseek_log_summary	hyperseek_log_summary	Summarized version of hyperseek_log (grouped by keyword)
hyperseek_results	hyperseek_results	Temporarily stores result sets for visitors (used in the "Search within results" search function)
jackhammer_debug	jackhammer_debug	Stores very detailed information about every PPC Click made (both valid and fraudulent)
jh_click_fraud	jh_click_fraud	Stores details about every fraudulent click (PPC)
jh_click_log	jh_click_log	Stores details about every good click (PPC)
jh_affiliate_summary	jh_affiliate_summary	Summarized affiliate earnings information
jh_click_summary	jh_click_summary	Summarized click through data
jh_daily_summary	jh_daily_summary	Summarized account information by account
jh_source_summary	jh_source_summary	Summarized click data for XML Inbound feeds
jh_clicked	jh_clicked	Temporarily stores the link id of PPC Clicks by IP for fraud checks.
affiliate_access	affiliate_access	Temporarily stores the search information for affiliates to avoid fraudulent clicks.

The following tables are "System" Tables, and should never be edited
Schema Name	Associated Table	Use / Purpose in Hyperseek

affiliate_html	affiliate_html	Stores header and footer for affiliate cobrands
dsx_glossary	dsx_glossary	Stores word meanings (depricated)
dsx_internal_templates	dsx_internal_templates	Stores the html for your internal templates
dsx_lexical	dsx_lexical	Stores the word relationships (Synonyms) for lexical searching option
group_assignments	group_assignments	Which user is assigned to which user group (used to track affiliates)
hs_category_tree	hs_category_tree	Mapping table for the categories. Used to draw some of the screens more quickly.
hs_featured	hs_featured	Stores the ID and Category/Term of featured sites
hs_optin	hs_optin	Deprecated -- stores the email address and category option for users that opt-in to alert emails
hs_related	hs_related	Deprecated -- stores related category information
hs_reviews	hs_reviews	Stores the HTML Review for links that the admin chooses to review
hs_subscribers	hs_subscribers	Depricated -- old version of the optin
hs_validate	hs_validate	Stores a running status on the availability of listings (used by the dead links report)
html_replacements	html_replacements	Used to dynamically replace text with other text (a remnant from an older app -- deprecated)
hyperseek_cats	hyperseek_cats	Stores the mapping of link-category assignments
hyperseek_forbid	hyperseek_forbid	Keeps track of search terms/phrases that you have forbidden certain advertisers from bidding on
hyperseek_keys	hyperseek_keys	Stores information about every keyword bid
iweb_language	iweb_language	Holds the language variables
jh_autobill	jh_autobill	Used to store the credit card information and preferences for users of the auto-billing system.
jh_autobill_log	jh_autobill_log	Log table for daily autobilling
jh_bids_pending	jh_bids_pending	Temporarily stores pending bids for advertisers
keyword_minimums	keyword_minimums	Stores the keyword and minimum bids for those keywords that you elect to have separate minimums from the system default.
related_keywords	related_keywords	Stores related keywords for the Bidding Advice advertiser tool.
sponsor_boxes	sponsor_boxes	Stores the keywords, link ids, expiration dates for advertisers that are purchasing sponsor box ads
table_def	table_def	Stores all of the schema information for these tales. DO NOT EDIT THIS SCHEMA.
user_groups	user_groups	A list of groups that users can be assigned to.