Campaign

The CAMPAIGN table contains metadata about campaigns (synonyms: cruise, expedition or leg) and are related to a certain project. Campaign as the second level in the data model may be used as an option, but is recommended to more easily list separate sampling locations. If no metainformation is available, a generic campaign label or the label 'not_given' may be used.

Define new campaigns
 * 1) by clicking on an empty line in the list of campaigns in the project window and fill out the fields as decribed below. Input to relational fields must be defined in the related tables first.
 * 2) For lists of campaigns use the import form for campaigns and import via 4D-Menue File/Import, choose Campaigns.

Field descriptions for the campaign table; recommendations on how to fill out the columns in the import form are given in cursive.

Basics tab
 * Label of the campaign; must be unique and should not contain blanks (use _ instead); use abbreviations instead of full names. (This campaign label is used in an Event import list to set the relation between event and campaign.)
 * Optional label may contain any additional names of a campaign separated by a blank as free text.
 * Basis is the station platform of (mostly) ship used to carry out the campaign; > relational to table Basis; the column headed 'Ship' must contain the name as defined in the Basis table.
 * Begin defines the start date of the campaign.
 * End defines its end.
 * Responsible scientist(s) are those persons beeing responsible for a campaign; > multiple choice relation to Staff; in the column headed 'Chief scientist' use staff-IDs separated by ; for import.
 * Area > relational to table Area; new names are automaticaly added to the area table; avoid misspellings.
 * Project > is related to table Project and selected when choosing Import/Campaign.

Details card
 * Report > may contain the citation of the campaigns report (e.g. cruise report); > related to table Reference; relations to be set by hand; use ReferenceID for import.
 * Comment > free text for any further information which does not fit into the existing fields.
 * URI may contain the link to a campaigns web page.