Schema:identifiers

Schema Summary

+--------------------+---------+------+-----+---------+----------------+
| Field              | Type    | Null | Key | Default | Extra          |
+--------------------+---------+------+-----+---------+----------------+
| identifier_id      | int(11) | NO   | PRI | NULL    | auto_increment |
| identifier_type_id | int(11) | YES  | MUL | NULL    |                |
| identifier_value   | text    | YES  |     | NULL    |                |
| pub_id             | int(11) | YES  | MUL | NULL    |                |
+--------------------+---------+------+-----+---------+----------------+

Description

This table is used to store external identifiers for a publication.

• identifier_id - Unique key ID.
• identifier_type_id - ID of the identifier type for this identifier.
• identifier_value - Identifier value, e.g. a catalog ID.
• pub_id - Publication ID.