projstrains
Many-to-many mapping indicating the strains tested by individual projects.
projstrains has the following fields:
| Field name | Description | Data type* | Null allowed? | Key status |
| projid | project id | int | no |
foreign key on projects
|
| strainid | strain id | int | no |
foreign key on strains
|
* 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