Schema:sfe3 authors

Schema Summary

+-----------------+---------+------+-----+---------+----------------+
| Field           | Type    | Null | Key | Default | Extra          |
+-----------------+---------+------+-----+---------+----------------+
| sfe3_authors_id | int(11) | NO   | PRI | NULL    | auto_increment |
| url             | text    | YES  | MUL | NULL    |                |
| author_name     | text    | YES  |     | NULL    |                |
| resolved        | int(2)  | YES  |     | NULL    |                |
+-----------------+---------+------+-----+---------+----------------+

Description

This table stores URLs of SFE3 articles about people (authors, editors, artists, etc) which are not linked from ISFDB author records. It is automatically updated by the ISFDB nightly process based on lists of "person" Web pages maintained by SFE3. It is manually updated by moderators who mark ineligible SFE3 Web pages as "ignored"/"resolved".

• sfe3_authors_id -- Unique ID of the record in this table.

• url -- URL of a SFE3 Web page about a person. Only the last/unique part of the URL is kept here.

• author_name -- Name of the person in the SFE3 article. The SFE3 format is typically "Last name, First/Middle name(s)"

• resolved - Flag indicating whether this record has been marked as "resolved" by a moderator. 1 if resolved and NULL if not resolved.