Schema:identifier sites

Schema Summary

+--------------------+------------+------+-----+---------+----------------+
| Field              | Type       | Null | Key | Default | Extra          |
+--------------------+------------+------+-----+---------+----------------+
| identifier_site_id | int(11)    | NO   | PRI | NULL    | auto_increment |
| identifier_type_id | int(11)    | YES  | MUL | NULL    |                |
| site_position      | tinyint(3) | YES  |     | NULL    |                |
| site_url           | text       | YES  |     | NULL    |                |
| site_name          | text       | YES  |     | NULL    |                |
+--------------------+------------+------+-----+---------+----------------+

Description

This table is used to store information about Web sites that an identifier type links to.

• identifier_site_id - Unique key ID.
• identifier_type_id - ID of the identifier type that this Web site is associated with.
• site_position - Position of this site in the ordering sequence for this identifier type. If the associated identifier type has only Web site/URL, the value is 1. If it has more than one Web site/URL, this number will determine the order in which URLs will be displayed.
• site_url - URL of the Web site. The identifier value should be entered as "%s" so that it would be replaced with the actual identifier at display time.
• site_name - The displayed name of the Web site.