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