institutions
Institutions to which participating investigators are affilliated
institutions has the following fields:
| Field name | Description | Data type* | Null allowed? | Key status |
| id | unique MPD id number identifying the institution | int | no |
primary key;
|
| name | institution name | | no |
|
| prefix | first word not to be considered when sorting eg. 'the' | | yes |
|
| city | institution city | | yes |
|
| country | institution country | | no |
|
| nick | institution nickname | | yes |
|
| _locktime | for record locking | | yes |
|
| _lockowner | for record locking | | yes |
|
* 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