Schema:identifier types

From ISFDB
Jump to navigation Jump to search

Schema Summary

+---------------------------+----------+------+-----+---------+----------------+
| Field                     | Type     | Null | Key | Default | Extra          |
+---------------------------+----------+------+-----+---------+----------------+
| identifier_type_id        | int(11)  | NO   | PRI | NULL    | auto_increment |
| identifier_type_name      | tinytext | YES  |     | NULL    |                |
| identifier_type_full_name | text     | YES  |     | NULL    |                |
+---------------------------+----------+------+-----+---------+----------------+

Description

This table is used to store the names of external identifier types.

  • identifier_type_id - Unique key ID.
  • identifier_type_name - Displayed short name of an external identifier type.
  • identifier_type_full_name - Displayed full name of an external identifier type.