Extension:CountingMarker/countingmarker author table

countingmarker_author table

Authors reporting to VG Wort

describe countingmarker_author;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| author_id    | int(10) unsigned    | NO   | PRI |         | auto_increment |
| user_id      | int(10) unsigned    | NO   | KEY |         | wiki user id*  |
| first_name   | varchar(32)         | NO   |     | ''      | "Vorname"      |
| last_name    | varchar(32)         | NO   |     | ''      | "Nachnahme"    |
| birth_date   | date                | YES  |     | NULL    | "Geburtstag"   |
| index_number | int(10) unsigned    | YES  |     | NULL    | "Karteinummer" |
| comment      | varchar(128)        | YES  |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

^* user id