Extension:ORES/Schema

From MediaWiki.org
Jump to navigation Jump to search

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_predicited[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.