doc/database/db_item_id.md

   1 Table item_id
   2 =============
   3
   4 | Field   | Description                                                                                                                                               | Type         | Null | Key | Default | Extra           |
   5 | ------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | ---- | --- | ------- | --------------- |
   6 | id      | sequential ID                                                                                                                                             | int(11)      | NO   | PRI | NULL    | auto_increment  |
   7 | iid     | item.id of the referenced item                                                                                                                            | int(11)      | NO   | MUL | 0       |                 |
   8 | uid     | user.id of the owner of this data                                                                                                                         | int(11)      | NO   | MUL | 0       |                 |
   9 | sid     | an additional identifier to attach or link to the referenced item (often used to store a message_id from another system in order to suppress duplicates)  | varchar(255) | NO   | MUL |         |                 |
  10 | service | the name or description of the service which generated this identifier                                                                                    | varchar(255) | NO   | MUL |         |                 |
  11
  12 Return to [database documentation](help/database)