Data Structure
All tables are listed below. Those in blue/mauve and underlined are tables which could be of use in XML reports. Click on the name to go to details for the table. Those in green are tables used within the system for various control purposes. those in pink relate to the import wizard. Those in red are not currently being used within the standard system Most tables have a unique key (the first field). This provides the link with other tables, normally using the same field name. Within the detailed tables lists, the foreign keys (keys to other tables) are highlighted in yellow.. It should be possible to work out the relationship between tables, with this information.
For examples on linking tables see SQL Queries - How To.
Application
Application_Concept_Group
Base_Map
BIOTOPE_CLASSIFICATION_VERSION
Computer_Map
Concept_Designation
Concept_Group
Concept_Group_Version
Concept_History
Concept_Lineage
Concept_Rank
Concept_Relation
DATABASE_RELATIONSHIP
Domain
Domain_Hyperlink
DTD_FRAGMENT
dtproperties
EXPORT_FILTER
EXPORT_FILTER_SURVEY
EXPORT_FILTER_TAXON
EXPORT_FORMAT_LK
IW_Column_Type
IW_Column_Type_Match_Rule
IW_Column_Type_Pattern
IW_Column_Type_Relationship
IW_Match_Rule
IW_Matched_Abundance_Qualifiers
IW_Matched_Associated_Species
IW_Matched_Association_Types
IW_Matched_Biotopes
IW_Matched_Locations
IW_Matched_Names
IW_Matched_Record_Types
IW_Matched_References
IW_Matched_Sample_Types
IW_Matched_Species
IW_Matched_Specimen_Types
IW_Matched_Substrates
IW_Output_Field
IW_Post_Processing_Procedure
IW_Table_Rule
IW_Table_Rule_Output_Field
IW_Table_Rule_Related_Field
IW_Table_rule_related_Table
Language
LAST_KEY
Local_Domain
MAP_SHEET
Meaning
Meaning_Relation
MEASUREMENT_CONTEXT
MEASUREMENT_TYPE_CONTEXT
Measurement_Unit_Value
PREFERRED_LINKS
RECORDING_SCHEME
REPORT_ATTRIBUTE
REPORT_FIELD
REPORT_JOIN
REPORT_WHERE
Semantic_Relation
Session
SPECIAL_XML_ELEMENT
Subject_Area
TERM_LIST
Term_Version
Term_Version_Relation
Thesaurus_Fact
Thesaurus_Relation_Type
Thesaurus_Relation_Type_Usage
USABLE_FIELD
USABLE_TABLE
USER
VW_ConceptChildren
VW_ConceptChildrenOnly
VW_ConceptTerm
VW_ConceptTermCommon
VW_ConceptTermPreferred
VW_REFERENCE_AUTHORS