Object Score Table

Object Score Table

This table supports the scoring API. It is used to hold the scores assigned to various objects in the system.

Fields

• id - integer - Primary key
• namespace - string(100) - This field is defined by a plugin which uses the scoring API. It is used to help the scoring system figure out which plugin's functionality the author wants to use.
• object_id - integer - The object receiving the scoring.
• author_id - integer - The author ID of the user who scored the object in the event they're a registered user.
• score - float - The object's score
• object_ds - string(50) - The table name where the object is stored.
• ip - string(50) - The IP address of the user who scored an object.

Indexes

• ds_obj - Columns:
  • `object_ds
  • `object_id
• ns_user_ds_obj - Columns:
  • namespace
  • author_id
  • object_ds
  • object_id
• ns_ip_ds_obj - Columns:
  • namespace
  • ip
  • object_ds
  • object_id
• user_ns - Columns:
  • author_id
  • namespace