INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
DATATYPES | SQL SUMMARY | TRIGGERS |
Table : names |
In order to track in particular changed names, we have a separate table
Field Summary | ||
Name | Type | Description |
---|---|---|
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 | |||||||
Name | Type | PrKey | Unq | NotN | MUnq | Def | Idx1 |
---|---|---|---|---|---|---|---|
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 | |||
Field | Import | On Update | On Delete |
---|---|---|---|
contributers_id | contributors(id) | NO ACTION | NO ACTION |
INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
DATATYPES | SQL SUMMARY | TRIGGERS |