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.

Help:Syntrans table

From OmegaWiki
Jump to: navigation, search
Help:Index Database layout Syntrans table



The Syntrans table is the table that links the Expression table with the Defined Meaning table. Basically, it defines the links between words and their definitions. To better understand what a Syntrans is, have a look at Help:SynTrans.

+-----------------------+------------+------+-----+---------+-------+
| Field                 | Type       | Null | Key | Default | Extra |
+-----------------------+------------+------+-----+---------+-------+
| syntrans_sid          | int(10)    | NO   |     | 0       |       | 
| defined_meaning_id    | int(10)    | NO   | MUL | 0       |       | 
| expression_id         | int(10)    | NO   | MUL | 0       |       | 
| identical_meaning     | tinyint(1) | NO   |     | 0       |       | 
| add_transaction_id    | int(11)    | NO   | MUL | NULL    |       | 
| remove_transaction_id | int(11)    | YES  | MUL | NULL    |       | 
+-----------------------+------------+------+-----+---------+-------+

Fields[edit]

syntrans_sid 
A number that identifies the current syntrans
defined_meaning_id 
A reference to an entry in the Defined Meaning table, i.e. one particular concept.
expression_id 
A reference to an entry in the Expression table, i.e. one particular word of a particular language.
identical_meaning 
Set to 1 if the given expression is an exact translation for the given concept (or definedMeaning). It is set to 0 if it is only an approximate translation. See Help:not identical.
add_transaction_id 
Indicates when and by who the syntrans was added. See Transactions table.
remove_transaction_id 
Indicates when and by who the syntrans was removed. NULL if the syntrans is still valid.