Schema:recognized domains

From ISFDB
Revision as of 20:21, 12 July 2023 by Ahasuerus (talk | contribs) (→‎Schema Summary: Changed domain_id to be auto-increment)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Schema Summary

+------------------------+------------+------+-----+---------+--------------+
| Field                  | Type       | Null | Key | Default | Extra        |
+------------------------+------------+------+-----+---------+--------------+
| domain_id              | int(11)    | NO   | PRI | 0       |auto-increment|
| domain_name            | text       | NO   |     | NULL    |              |
| site_name              | text       | NO   |     | NULL    |              |
| site_url               | mediumtext | YES  |     | NULL    |              |
| linking_allowed        | tinyint(1) | YES  |     | NULL    |              |
| required_segment       | text       | YES  |     | NULL    |              |
| explicit_link_required | tinyint(1) | YES  |     | NULL    |              |
+--------------+-------------+------+-----+---------+-----------------------+

Description

  • domain_id - Unique integer auto-incremented domain ID.
  • domain_name - Internet domain name.
  • site_name - The name of the site that will be credited on ISFDB pages.
  • site_url - The URL of the site that will be linked in the credit on ISFDB pages.
  • linking_allowed - 1 if the site has given the ISFDB permission to link to its images or 0 if it hasn't.
  • required_segment - Optional URL segment; if specified, the string must be present in the URL.
  • explicit_link_required - 1 if a Web page URL must be added to the end of the image URL after "|", e.g. https://x.sf-encyclopedia.com/gal/clute/OwenW-More.jpg|https://sf-encyclopedia.com/gallery.php?id=OwenW-More.jpg ; 0 otherwise.