Schema:isbn ranges

Schema Summary

+------------------+------------+------+-----+---------+-------+
| Field            | Type       | Null | Key | Default | Extra |
+------------------+------------+------+-----+---------+-------+
| start_value      | bigint(20) | NO   | PRI | 0       |       |
| end_value        | bigint(20) | YES  |     | NULL    |       |
| prefix_length    | tinyint(4) | YES  |     | NULL    |       |
| publisher_length | tinyint(4) | YES  |     | NULL    |       |
+------------------+------------+------+-----+---------+-------+

Description

This table is used to store ISBN ranges which determine how the ISFDB software hyphenates ISBN -- see https://www.isbn-international.org/range_file_generation , which is maintained by the International ISBN Agency, for details.

• start_value - Lowest 11-digit ISBN part for this ISBN hyphenation range.
• end_value - Highest 11-digit ISBN part for this ISBN hyphenation range.
• prefix_length - Number of digits in the prefix part of the ISBNs within this range.
• publisher_length - Number of digits in the publisher part of the ISBNs within this range.