C14Samples
C14 samples table. Radiocarbon dates with the minimum acceptable level of meta data and data hygiene. Ideally 14C dates should be associated with a specific PhaseID which allows them to be directly connected to a multitude of other data. However, many 14C dates can only be secured to a SiteID. Therefore the 14CSamples table uses a composite foreign key to connect to the Phases table.
Column name	Data type	Column description
ABotAnatomy	varchar	Please see the detailed description of the 'zoptions_ABotAnatomy' table.
ABotIsoID	varchar	ID of sample in the ABotIsotopes table, from which this 14C sample is also directly obtained.
AltLabID	varchar	Alternative lab code such as where the sample first went to one lab for treatment but was eventually measured at another. In such situations the first lab code is considered the primary one and stored in LabID with the second code stored here. But it is true that sometimes the order is unknown or confusing.
AltPrefix	varchar	Laboratory prefix generated automatically (DO NOT ADD VALUES) by MySQL trigger, which automatically strips this from the AltLabID, as a sanity check that it is valid.
C/N_collagen	decimal	Carbon / Nitrogen Atomic ratio (C:N) of carbon and nitrogen in the collagen sample.
C14.Age	int	Uncalibrated years BP
C14.SD	int	Standard deviation
C14ID	int	Unique identification code for each C14 sample
CitationID	varchar	See citation table for the strict character code.
Collagen%	decimal	Percentage collagen in the sample.
Context	varchar
ContextType	varchar	Specification of the feature dated directly by the 14C sample. Check the zoptions PhaseType table for categories.
errorType	varchar	Cause of unreliability, such as reservoir effect etc.
FaunIsoID	varchar	ID of sample in the FaunalIsotopes table, from which this 14C sample was also directly obtained.
Flag	varchar	Published issues or problems with the date.
GraveID	varchar	ID of the specific grave (in the Graves table) that this 14C sample is directly associated with.
IndividualID	varchar	ID of the specific human individual (in the GraveIndividuals table) that this 14C sample is directly associated with.
LabID	varchar	Unique Laboratory identification number. Lab suffixes must be in the C14laboratories table, which end with a hyphen. This is important as labcodes are automatically checked by string splitting on the first hyphen. Note, there are cases where multiple hyphen legitimately exist in a labcode (e.g. OxA-X-2135-46). Other non-standard characters are also permitted, such as ‘.’ or ‘/’. Case sensitivity is important, for example, prefix GD- and Gd- are two different laboratories. Spaces are NOT permitted, therefore rare occasions such as 'GIF FG 39a' will be automatically assigned 'GIFFG-39a'
Material	varchar	Material of the sample. See zoptions_Material for available options.
MaterialNotes	varchar	Additional information about the sample. If Citation specifies whether the sampled bone or tooth comes from the left or right side of the body, structure information as 'sin' (corresponding to sinestra = left) or 'dex' (corresponding to dexter = right)
Method	varchar	Method for obtaing the radiocarbon date
offsetCorrection	varchar	Either provide the published correction, or state 'uncorrected'.
Period	varchar	Broad chronological period e.g. Early Neolithic (EN), Middle Neolithic (MN)
PhaseID	varchar	Please see the detailed description of the 'Phases' table.
Prefix	varchar	Laboratory prefix generated automatically (DO NOT ADD VALUES) by MySQL trigger, which automatically strips this from the LabID, as a sanity check that it is valid.
Preservation	varchar	Please see the detailed description of the 'zoptions_Preservation' table.
Quantity	varchar	Please see the detailed description of the 'zoptions_Quantity' table.
ReplicateID	varchar	BIAD created ID assigned to multiple 14C dates that are all replicates of each other. Format: 'Rep1001' etc.
ReplicateType	varchar	There are various stages of the analysis pipeline at which the replicate may have been taken from.
SiteID	varchar	Unique site identification number
SkeletalElement	varchar	Please see the detailed description of the 'zoptions_SkeletalElement' table.
SkeletalPosition	varchar
TaxonCode	varchar	Code to identify species/genus etc, as specified in the zoptions_Taxalist.
δ13C	decimal	C13 value with respect to the radiocarbon date.
δ13C.SD	decimal	C13 error (standard deviation) with respect to the radiocarbon date.