Jump to content

Extension:ORES/Schema

From mediawiki.org

ores_model

[edit]

This table keeps data about models and their versions.

mysql:wikiadmin@db1089 [enwiki]> DESC ores_model;
+------------------+----------------------+------+-----+---------+----------------+
| Field            | Type                 | Null | Key | Default | Extra          |
+------------------+----------------------+------+-----+---------+----------------+
| oresm_id         | smallint(5) unsigned | NO   | PRI | NULL    | auto_increment |
| oresm_name       | varbinary(32)        | NO   | MUL | NULL    |                |
| oresm_version    | varbinary(32)        | NO   |     | NULL    |                |
| oresm_is_current | tinyint(1)           | NO   |     | NULL    |                |
+------------------+----------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

oresm_id

[edit]

Primary key, oresc_model is a foreign key to this column.

oresm_name

[edit]

Name of the model, like "damaging", etc.

oresm_version

[edit]

Version of the model, like '0.1.1' or etc.

oresm_is_current

[edit]

Whether the model at this version is current version in the service or not.

ores_classification

[edit]

This table keeps scores of each revision in model and class

mysql:wikiadmin@db1089 [enwiki]> DESC ores_classification;
+--------------------+---------------------+------+-----+---------+----------------+
| Field              | Type                | Null | Key | Default | Extra          |
+--------------------+---------------------+------+-----+---------+----------------+
| oresc_id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| oresc_rev          | int(10) unsigned    | NO   | MUL | NULL    |                |
| oresc_model        | smallint(6)         | NO   |     | NULL    |                |
| oresc_class        | tinyint(4)          | NO   |     | NULL    |                |
| oresc_probability  | decimal(3,3)        | NO   |     | NULL    |                |
| oresc_is_predicted | tinyint(1)          | NO   |     | NULL    |                |
+--------------------+---------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

oresc_id

[edit]

Primary key

oresc_rev

[edit]

Foreign key to revision_id in revision table.

oresc_model

[edit]

Foreign key to oresm_id in ores_model table.

oresc_class

[edit]

class that ores gives the score. 1 for true and 0 for false in binary models (such as damaging and goodfaith). More numbers for more classes in multi-class models (For example in wp10, 0 is for "Stub", 1 for "B" and so on)

oresc_probability

[edit]

Probability that ORES services sends out, rounded to 3 decimal digits for performance.

oresc_is_predicted

[edit]

Whether ORES service thinks this is the most fitting class or not. If a class is binary, when probability is more than 50% this is 1 but for multi-class models, it's more complicated.