You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
354 lines
39 KiB
354 lines
39 KiB
##################################################################################################################################
|
|
# #
|
|
# Table: DbParameters #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# Name # Text # # Name of the parameter. #
|
|
# Value # LongText # Null # Its value. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#----------#---------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#----------#---------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByName # +Name # Primary & Unique # Used to look up a parameter. #
|
|
#----------#---------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: ContentOwners #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# DN # Text # # Qualified name of the owner, constructed from the Digital Certificate. #
|
|
# ID_owner # AutoNumber # # ID associated with the owner. #
|
|
# IsOEM # Bool # # This is an OEM, so it can create nodes. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#------------#-------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#------------#-------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByVendorID # +DN # Primary & Unique # Used to look up an owner. #
|
|
# Owner # +ID_owner # Unique # #
|
|
#------------#-------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: SynSets #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# Name # Text # # SynSet name. #
|
|
# ID_owner # Number # # Owner of the SynSet. #
|
|
# ID_synset # Number # Autoincrement # SynSet number. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByPair # +Name+ID_owner # Primary & Unique # Used during add/remove. #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: HelpImage #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_owner # Number # # Owner of the Help Image. #
|
|
# File # Text # # Name of the file that is part of the Help Image. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByFile # +File # Primary & Unique # Used during add/remove. #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Scope #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_owner # Number # # Owner of the scope. #
|
|
# ID_scope # Number # Autoincrement # Identifier for the scope. #
|
|
# Name # Text # # Name of the application. #
|
|
# Category # LongText # # Position in the taxomony. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
# ByName # +Name # Primary & Unique # Used to locate a scope. #
|
|
# ByScope # +ID_scope # Unique # #
|
|
# OwnedScopes # +ID_owner # External to ContentOwners # Used to look up all the scopes of an owner. #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: IndexFiles #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_owner # Number # # Owner of the HHK. #
|
|
# ID_scope # Number # # Scope of the HHK. #
|
|
# Storage # LongText # Null # Location and name of the CHM. #
|
|
# File # LongText # Null # Name of the HHK file inside the CHM. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByScope # +ID_scope # # Used during add/remove. #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: FullTextSearch #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_owner # Number # # Owner of the CHM. #
|
|
# ID_scope # Number # # Scope of the CHM. #
|
|
# CHM # LongText # Null # Location and name of the associated CHM. #
|
|
# CHQ # LongText # Null # Location and name of the CHQ. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByScope # +ID_scope # # Used during add/remove. #
|
|
#-----------#--------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Taxonomy #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_node # Number # Autoincrement # Identifier for the node. #
|
|
# Pos # Number # # Order in which to display the node. #
|
|
# ID_parent # Number # Null # Parent of the current node. #
|
|
# ID_owner # Number # # Owner of the node. #
|
|
# Entry # Text # # Single component in the taxonomy path. #
|
|
# Title # LongText # Null # Display string. #
|
|
# Description # LongText # Null # Description of the node. #
|
|
# DescriptionURI # LongText # Null # Alternative description of the node, as an HTML page to display. #
|
|
# IconURI # LongText # Null # Optional icon for the node. #
|
|
# Visible # Bool # # Boolean value to determine whether it should be visible under XMLTOC. #
|
|
# Subsite # Bool # # Boolean value to determine whether this is a data island or not. #
|
|
# NavModel # Long # # Type of the navigation model. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
# SubNode # +ID_parent +Entry # Primary & Unique # Used to locate a node under a certain parent. #
|
|
# Children # +ID_parent # External to Taxonomy # Used to find all the subnodes of a specified node. #
|
|
# Node # +ID_node # Unique # Used to locate a specific node. #
|
|
#----------------#---------------------#-----------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Topics #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_topic # Number # Autoincrement # Unique Identified for the topic. #
|
|
# ID_node # Number # # Position on the taxonomy. #
|
|
# ID_owner # Number # # Owner of the topic. #
|
|
# Pos # Number # # Order in which to display the topic. #
|
|
# Title # LongText # Null # Display string. #
|
|
# URI # LongText # Null # Hyperlink for the contents. #
|
|
# Description # LongText # Null # Long description of the topic. #
|
|
# IconURI # LongText # Null # Optional icon for the node. #
|
|
# Type # Number # # The type of topic. #
|
|
# Visible # Bool # # Boolean value to determine whether it should be visible under XMLTOC. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------------#---------------#----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------------#---------------#----------------------------------------#-----------------------------------------------------#
|
|
# SingleTopic # +ID_topic # Primary & Unique # Used during search, to find a topic. #
|
|
# TopicsUnderNode # +ID_node # External to Taxonomy # Used to located all the topics under a certain node.#
|
|
# ByURI # +URI # # Used to locate the topics for an URL. #
|
|
#-----------------#---------------#----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Synonyms #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# Keyword # Text # # Keyword name. #
|
|
# ID_synset # Number # # Synset number. #
|
|
# ID_owner # Number # # Owner of the synset. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByPair # +Keyword+ID_synset # Primary & Unique # Used to look up the owner of a synset. #
|
|
# ByName # +Keyword # # Used to look up the ID of a synset. #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Keywords #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# Keyword # Text # # Keyword name. #
|
|
# ID_keyword # Number # Autoincrement # Keyword number. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
# ByName # +Keyword # Primary & Unique # Used to look up the ID of a keyword. #
|
|
#--------#-----------------------#-----------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
##################################################################################################################################
|
|
# #
|
|
# Table: Matches #
|
|
# #
|
|
# Columns #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# # # # #
|
|
# Name # Type # Flags # Description #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# ID_topic # Number # # External Key into "Topics" table. #
|
|
# ID_keyword # Number # # External Key into "Keywords" table. #
|
|
# Priority # Number # # To sort results. #
|
|
# HHK # Bool # # Boolean value to determine whether it should make it to the Merged HHK. #
|
|
#-------------------#------------#-------------------#---------------------------------------------------------------------------#
|
|
# #
|
|
# Indexes #
|
|
#-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
|
|
# # # # #
|
|
# Name # Definition # Kind # Description #
|
|
#-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
|
|
# Pair # +ID_keyword +ID_topic # Primary & Unique # Used to locate the topics associated with a keyword.#
|
|
# ByKeyword # +ID_keyword # External to Keywords # Used to locate the topics associated with a keyword.#
|
|
# ByTopic # +ID_topic # External to Topics # Used to locate the keywords accociated with a topic.#
|
|
#-----------#-----------------------#--------------------------------------#-----------------------------------------------------#
|
|
##################################################################################################################################
|
|
|
|
|
|
/////////////////////////////////////////////////////////////////////////////////
|
|
// //
|
|
// OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD OLD //
|
|
// //
|
|
/////////////////////////////////////////////////////////////////////////////////
|
|
|
|
DbParameters:
|
|
Name Text
|
|
Value LongText
|
|
|
|
ContentOwners:
|
|
OWID AutoNumber
|
|
DN Text
|
|
|
|
NodeOwners:
|
|
NOID AutoNumber
|
|
OWID Number
|
|
|
|
SuperKeywords:
|
|
KID AutoNumber
|
|
EID Number
|
|
Keyword Text
|
|
|
|
Matches:
|
|
OID Number External Key into topics database
|
|
KID Number Unique Keyword, which was originally submitted for the match.
|
|
EID Number Equivalent Keyword ID associated with the match.
|
|
HHK Yes/No Boolean value to determine whether it should make it to the Merged HHK
|
|
Title LongText Alternative title to be shown
|
|
|
|
Topics:
|
|
OID AutoNumber Unique ID entered when creating this TOC from the parsing process
|
|
Category LongText Path to the node in the taxonomy.
|
|
Entry Text
|
|
URI HyperLink
|
|
Title Text
|
|
Description LongText
|
|
Type Number
|
|
OWID Number
|