MPD - Database table: people

Database table: people

people

Names and contact info for participating investigators (etc.)

people has the following fields:

Field name	Description	Data type*	Null allowed?	Key status
id	unique MPD id number identifying the person	int	no	primary key;
lastname	person's last name		no
firstname	person's first name		no
middlename	person's middle name or initial		yes
degree	degree such as PhD		yes
	If given, must be one of: PhD, MD, MD PhD, DVM PhD
suffix	suffix such as Jr.		yes
citname	person's name in citation format eg. Smith JS		no
instlist	all institutions affilliated with; a comma-delimited list of inst ids		no	foreign key on institutions
affil_list	comma-delimited list of codes describing MPD affiliation		yes
	(see 'people/form' for possible codes)
email	person's email address		yes
phone1	primary phone number		yes
postaddress1	postal address line 1		yes
postaddress2	postal address line 2		yes
postaddress3	postal address line 3		yes
city	city portion of postal address		yes
state	state portion of postal address		yes
postalcode	postal code		yes
country	country		yes
phone2	secondary phone number		yes
fax	fax number		yes
contactnotes	longer contact notes	text	yes
_lockowner	for record locking		yes
_locktime	for record locking		yes

Data example

* Data types

If no data type is given, varchar[255] may be assumed. As a guideline, projsyms and measurement varnames should be short (~30 chars or less) with no embedded spaces. For fields where a controlled vocabulary is shown, data type / char length may be inferred from the enumerated vocabulary.

A data type of 'text' indicates text of unlimited length. Content is stored in files; linkage is by filenames which contain embedded id info, the particulars of which are up to the application. Data table field contains 1 if there is text.

Suggestion box Hints Citing Units & abbreviations Change Log News Links Usage terms & conditions

Leading the search for tomorrow's cures