Extension:ORES/Schema
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.