| 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 |