Information about external individuals and organisations contributing to the statistical database

Table ID:

G_CREDIT_CONTRIBUTOR     (1247797)

Contents:

Information about external individuals and organisations contributing to the statistical database

Approx. number of rows:

35

Table type:

Documentation

Documentation Author:

Humphrey Southall

Notes:

1. This table holds basic contact information for the organisations and individual researchers who have contributed to the statistical database, mainly to clearly identify them.

---

Indices:

Index	Type	Column(s) indexed
g_credit_contributor_pkey	Primary key	g_credit_contributor

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
g_credit_contributor_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
g_credit_contributor	Text string (max.len.=24).	Identifier. For individuals, this is usually their surname immediately followed by their first initial, all in upper case.
contrib_name	Text string (max.len.=124).	Name of the organisation, or surname of the person.
contrib_forename	Text string (max.len.=44).	First name of an individual contributor; null for organisations.
contrib_org	Text string (max.len.=124).	For individual contributors, the name of the organisation, most often a university, that employs them.
contrib_post	Text string (max.len.=804).	Postal address.
contrib_email	Text string (max.len.=104).	E-mail address.
contrib_home_page	Text string (max.len.=124).	Home page for the individual or organisation.
notes	Long text.	Comments, not intended for public display.