As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

User:SabineCretella/Omegawiki database tables with fieldnamse

From OmegaWiki
Jump to: navigation, search

Last update: 01 May 2007

language

gives iso codes for a language id.
  • language_id - the id of the language, for example English=85
  • dialect_of_lid - language_id is a dialect of dialect_of_lid
  • iso639_2 - iso code 639-2 of that language
  • iso639_3 - iso code 639-3 of that language
  • wikimedia_key

language_names

makes the correspondance between languages ids and languages names.
  • language_id - the id of the language, for example English=85
  • name_language_id
  • language_name

text

contains various texts: definitions, mediawiki messages, ...
  • old_id - identifier of the text
  • old_text - the text itself
  • old_flags

translated_content

table linking between defined_meanings, and the various definitions (text_id) of that DM (translated_content_id) in a language (language_id)
  • translated_content_id - = uw_defined_meaning.meaning_text_tcid
  • language_id - language of the definition
  • shorttext_id
  • text_id - link to text.old_id, the corresponding definition is text.old_text
  • original_language_id
  • add_transaction_id
  • remove_transaction_id

uw_alt_meaningtexts

  • meaning_mid
  • meaning_text_tcid
  • source_id
  • add_transaction_id
  • remove_transaction_id

uw_class_attributes

  • object_id
  • class_mid
  • level_mid
  • attribute_mid
  • attribute_type
  • add_transaction_id
  • remove_transaction_id

uw_class_membership

  • class_membership_id
  • class_mid
  • class_member_mid
  • add_transaction_id
  • remove_transaction_id

uw_collection_contents

  • collection_id
  • member_mid
  • internal_member_id
  • applicable_language_id
  • add_transaction_id
  • remove_transaction_id

uw_collection_language

  • collection_id
  • language_id

uw_collection_ns

  • collection_id
  • collection_mid
  • collection_type
  • add_transaction_id
  • remove_transaction_id

uw_defined_meaning

  • defined_meaning_id
  • expression_id
  • meaning_text_tcid - links to many translated_content.translated_content_id (1 for each def in a language)
  • add_transaction_id
  • remove_transaction_id

uw_expression_ns

Gives the spelling and the language (id) corresponding to a given expression_id
  • expression_id
  • spelling
  • hyphenation
  • language_id
  • add_transaction_id
  • remove_transaction_id

uw_meaning_relations

  • relation_id
  • meaning1_mid
  • meaning2_mid
  • relationtype_mid
  • add_transaction_id
  • remove_transaction_id

uw_option_attribute_options

  • option_id
  • attribute_id
  • option_mid
  • language_id
  • add_transaction_id
  • remove_transaction_id

uw_option_attribute_values

  • value_id
  • object_id
  • option_id
  • add_transaction_id
  • remove_transaction_id

uw_syntrans

links defined_meaning_id to expression_id
  • syntrans_sid
  • defined_meaning_id - a number identifying the defined_meaning
  • expression_id - a number identifying the expression (see uw_expression_ns)
  • firstuse_id
  • identical_meaning - 1 if identical meaning, 0 if not
  • add_transaction_id - never null (identify the action of adding the DM-expression relation)
  • remove_transaction_id - not null if the DM-expression relation was removed (by clicking delete on an expression)

uw_syntrans_relations

  • syntrans1_id
  • syntrans2_id
  • relationtype_mid

uw_text_attribute_values

  • value_id
  • object_id
  • attribute_mid
  • text
  • add_transaction_id
  • remove_transaction_id

uw_translated_content_attribute_values

  • value_id
  • object_id
  • attribute_mid
  • value_tcid
  • add_transaction_id
  • remove_transaction_id

uw_url_attribute_values

  • value_id
  • object_id
  • attribute_mid
  • url
  • label
  • add_transaction_id
  • remove_transaction_id