In order to track in particular changed names, we have a separate table
Field Summary |
id
|
Serial
|
|
givenname
|
Varchar-50
|
|
familyname
|
Varchar-50
|
|
articular
|
Varchar-50
|
|
prefix
|
Varchar-50
|
|
suffix
|
Varchar-50
|
|
preffered
|
Bool
|
|
language
|
Varchar-5
|
|
valid
|
date
|
|
contributers_id
|
contributors(id)
|
|
Sql Summary |
id
|
int |
|
|
|
|
|
|
givenname
|
varchar(50) |
|
|
|
|
|
|
familyname
|
varchar(50) |
|
|
|
|
|
|
articular
|
varchar(50) |
|
|
|
|
|
|
prefix
|
varchar(50) |
|
|
|
|
|
|
suffix
|
varchar(50) |
|
|
|
|
|
|
preffered
|
char(1) |
|
|
|
|
1 |
|
language
|
varchar(5) |
|
|
|
|
|
|
valid
|
date |
|
|
|
|
|
|
contributers_id
|
int |
|
|
|
|
|
|
Foreign Keys |
contributers_id | contributors(id) | NO ACTION | NO ACTION |