Database tables¶
In the following section, each database table contained in WALIS is described. Six fields are given:
- Field: Column name as it appears in the database
- Type: Type of data accepted by the mySQL database
- Collation: Econding
- Null: are null values allowed?
- Key: primary (PRI) or foreign (MUL) key
- Comment: label within the PhP interface
Table: rsl (RSL stratigraphy)¶
This table contains data and metadata related to paleo relative sea level datapoints from stratigraphic or geomorphic sea level indicators.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| RSL _ ID | int(11) | NO | PRI | WALIS RSL ID | |
| Public | int(11) | NO | Is this datapoint public? | ||
| Site | varchar(40) | utf8 _ general _ ci | NO | Site | |
| AddLocInfo | varchar(100) | utf8 _ general _ ci | YES | Subsite | |
| Nation | int(11) | NO | Nation | ||
| Region | int(11) | NO | Region | ||
| Ref | varchar(255) | utf8 _ general _ ci | NO | MUL | Main reference |
| addRef | varchar(45) | utf8 _ general _ ci | YES | Additional references | |
| RSLlat | decimal(10,6) | NO | Latitude (decimal degrees) | ||
| RSLlon | decimal(10,6) | NO | Longitude (decimal degrees) | ||
| HrzPosTech | int(11) | YES | MUL | Horizontal Positioning Technique | |
| Limiting | varchar(45) | utf8 _ general _ ci | NO | Is this a marine/terrestrial limiting record? | |
| Indicator | int(11) | YES | MUL | Type of RSL Indicator | |
| Ind _ descr _ det | longtext | utf8 _ general _ ci | YES | Indicator description | |
| ULmodAn | decimal(10,2) | YES | Upper limit of modern analog (m) | ||
| LLmodAn | decimal(10,2) | YES | Lower limit of modern analog (m) | ||
| Quant _ ind _ mean | varchar(45) | utf8 _ general _ ci | YES | Quantification of indicative meaning | |
| SLdatum | int(11) | NO | Sea level datum | ||
| VrtMeasTech | int(11) | NO | Elevation measurement technique | ||
| Upper _ Lower _ elev | varchar(45) | utf8 _ general _ ci | YES | Do you want to insert upper and lower elevation limits? | |
| Elev _ upper | varchar(45) | utf8 _ general _ ci | YES | Upper elevation of indicator (m) | |
| Elev _ lower | varchar(45) | utf8 _ general _ ci | YES | Lower elevation of indicator (m) | |
| UppLowErr | varchar(45) | utf8 _ general _ ci | YES | Upper/Lower elevation measurement error (1-sigma) (m) | |
| RSLelev | decimal(10,2) | YES | RSL indicator elevation (m) | ||
| RSLelevErr | decimal(10,2) | YES | RSL indicator elevation error (m) | ||
| ElevationNotes | longtext | utf8 _ general _ ci | YES | Notes on elevation and indicative range | |
| RWL | decimal(10,2) | YES | Reference Water Level (m) | ||
| IR | decimal(10,2) | YES | Indicative Range (m) | ||
| PaleoRSL | decimal(10,2) | YES | Paleo Relative Sea Level (m) | ||
| PaleoRSLunc | decimal(10,2) | YES | Paleo Relative Sea Level Uncertainty (m) | ||
| ChoiceVLM | varchar(45) | utf8 _ general _ ci | YES | Is data on vertical land movements (independent from the sea level record) available? | |
| Tect _ cat | varchar(45) | utf8 _ general _ ci | YES | Tectonic category | |
| tect _ cat _ comments | longtext | utf8 _ general _ ci | YES | Comments on tectonic category | |
| Publ _ VLM | varchar(45) | utf8 _ general _ ci | YES | Published VLM rate (m/ky) | |
| Publ _ VLM _ unc | varchar(45) | utf8 _ general _ ci | YES | Published VLM rate uncertainty (m/ky) | |
| Interpr _ VLM | varchar(45) | utf8 _ general _ ci | YES | Interpreted VLM rate (m/ky) | |
| Interpr _ VLM _ unc | varchar(45) | utf8 _ general _ ci | YES | Interpreted VLM rate (m/ky) uncertainty | |
| Comments _ VLM | longtext | utf8 _ general _ ci | YES | Comments on VLM rates | |
| SelectAge | varchar(45) | utf8 _ general _ ci | NO | Age attribution | |
| Useries _ time | varchar(45) | utf8 _ general _ ci | YES | U-Series constraint | |
| Useries | mediumtext | utf8 _ general _ ci | YES | U-series age IDs | |
| AAR _ time | varchar(45) | utf8 _ general _ ci | YES | AAR constraint | |
| AAR | mediumtext | utf8 _ general _ ci | YES | Amino Acid Racemization age IDs | |
| ESR _ time | varchar(45) | utf8 _ general _ ci | YES | ESR constraint | |
| ESR | mediumtext | utf8 _ general _ ci | YES | Electro Spin Resonance age IDs | |
| LUM _ time | varchar(45) | utf8 _ general _ ci | YES | Luminescence constraint | |
| Luminescence | mediumtext | utf8 _ general _ ci | YES | Luminescence age IDs | |
| Strat _ time | varchar(45) | utf8 _ general _ ci | YES | Stratigraphic constraint | |
| Stratcontext | mediumtext | utf8 _ general _ ci | YES | Stratigraphic context/age IDs | |
| Other _ time | varchar(45) | utf8 _ general _ ci | YES | Other age constraint | |
| Other _ age | mediumtext | utf8 _ general _ ci | YES | Other age constraints IDs | |
| Qual | int(11) | NO | Quality of RSL data | ||
| Qual _ Age | int(11) | NO | Quality of age information | ||
| Qualnotes | longtext | utf8 _ general _ ci | YES | Quality notes | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| coord | point | YES | MySQL coordinates |
Table: vertmeastech (Elevation measurement techniques)¶
This table contains elevation measurement techniques used in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| idvrtpostech | int(11) | NO | PRI | WALIS ElevMeas ID | |
| VrtType | mediumtext | utf8 _ general _ ci | YES | Measurement technique | |
| VrtDescr | longtext | utf8 _ general _ ci | YES | Description | |
| VrtAcc | mediumtext | utf8 _ general _ ci | YES | Typical accuracy | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update |
Table: hrzmeastech (Geographic positioning techniques¶
This table contains geographic positioning techniques used in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| idposhrz | int(11) | NO | PRI | WALIS GeoPos ID | |
| HrzType | mediumtext | utf8 _ general _ ci | YES | Measurement technique | |
| HrzDescr | longtext | utf8 _ general _ ci | YES | Description | |
| HrzAcc | longtext | utf8 _ general _ ci | YES | Typical accuracy | |
| Createdby | text | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | text | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update |
Table: countries (Country)¶
This table contains the countries selectable in the interface.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| id | smallint(5) unsigned | NO | PRI | Country ID | |
| name | varchar(255) | latin1 _ swedish _ ci | NO | UNI | Country name |
Table: regions (Region)¶
This table contains the administrative regions selectable in the interface.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | Region ID | |
| name | varchar(255) | utf8 _ general _ ci | NO | Region name | |
| country _ id | smallint(5) unsigned | NO | MUL | Country ID |
Table: MIS_ages (MIS Ages)¶
This table contains the Marine Isotopic Stages selectable in the interface.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| MIS ID | int(11) | NO | PRI | WALIS MIS ID | |
| MIS name | varchar(45) | utf8 _ general _ ci | YES | Name of Marine Isotopic stage | |
| MIS peak age | varchar(45) | utf8 _ general _ ci | YES | MIS peak age (ka) | |
| MIS start age | varchar(45) | utf8 _ general _ ci | YES | MIS start age (ka) | |
| MIS end age | varchar(45) | utf8 _ general _ ci | YES | MIS end age (ka) |
Table: rsl_ind (RSL index point types)¶
This table contains the types of RSL indicators inserted in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| idrsl _ ind | int(11) | NO | PRI | WALIS RSLind ID | |
| Ind _ name | mediumtext | utf8 _ general _ ci | YES | Name of RSL indicator | |
| Ind _ descr | longtext | utf8 _ general _ ci | YES | Description of RSL indicator | |
| RWL _ descr | longtext | utf8 _ general _ ci | YES | Description of RWL | |
| IR _ descr | longtext | utf8 _ general _ ci | YES | Description of IR | |
| Ref _ indicator | mediumtext | utf8 _ general _ ci | YES | Indicator reference(s) | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | date | YES | Last Update |
Table: sldatum (Vertical datums)¶
This table contains the sea level datums inserted in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| SLdatum _ ID | int(11) | NO | PRI | WALIS SLdatum ID | |
| SLdatumname | varchar(45) | utf8 _ general _ ci | YES | Datum name | |
| SLdatumdescr | longtext | utf8 _ general _ ci | YES | Datum description | |
| SLdatum _ unc | longtext | utf8 _ general _ ci | YES | Datum uncertainty | |
| Ref _ SLdatum | longtext | utf8 _ general _ ci | YES | Reference(s) | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update |
Table: references (References)¶
This table contains the references inserted in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| Ref _ ID | int(11) | NO | PRI | WALIS reference ID | |
| ShortRef | mediumtext | utf8 _ bin | YES | Reference | |
| Fullref | longtext | utf8 _ bin | YES | Full reference | |
| Journal | mediumtext | utf8 _ bin | YES | Journal | |
| Year | int(4) | YES | Year | ||
| doi | mediumtext | utf8 _ bin | YES | doi | |
| Link | varchar(100) | utf8 _ general _ ci | YES | Link | |
| Nation | mediumtext | utf8 _ general _ ci | YES | Nation | |
| Language | mediumtext | utf8 _ bin | YES | Language | |
| Timeframe | mediumtext | utf8 _ bin | YES | Timeframe | |
| Abstract | longtext | utf8 _ bin | YES | Abstract | |
| Createdby | tinytext | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | tinytext | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| PaperType | varchar(45) | utf8 _ general _ ci | YES | Type of paper |
Table: Useries_Corals (U-Series)¶
This table contains samples of corals, mollusks or speleothems dated with U-Series techniques.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| ID _ Useries | int(11) | NO | PRI | WALIS U-Series ID | |
| Public | mediumtext | utf8 _ general _ ci | YES | Is this datapoint public? | |
| Material _ type | varchar(45) | utf8 _ general _ ci | YES | Material type | |
| Material _ details | mediumtext | utf8 _ general _ ci | YES | Details on dated material | |
| Recalc | varchar(45) | utf8 _ general _ ci | YES | Were U-Series data recalculated? | |
| Spectr | varchar(45) | utf8 _ general _ ci | YES | Type of spectrometry | |
| RSL _ Estimate _ avaliable | varchar(45) | utf8 _ general _ ci | YES | Are RSL estimates available for this record? | |
| Tectonics | varchar(45) | utf8 _ general _ ci | YES | Are data on tectonics available? | |
| Source | mediumtext | utf8 _ general _ ci | YES | Reference(s) | |
| IGSN | varchar(100) | utf8 _ general _ ci | YES | IGSN | |
| SampleID | varchar(100) | utf8 _ general _ ci | YES | Sample ID | |
| AnalysisID | varchar(100) | utf8 _ general _ ci | YES | Analysis ID | |
| ReportedID | varchar(100) | utf8 _ general _ ci | YES | Reported ID | |
| Analysis _ Date | datetime | YES | Date of analysis | ||
| Accepted | varchar(45) | utf8 _ general _ ci | YES | Accepted? | |
| ReasonRej | longtext | utf8 _ general _ ci | YES | Reason for rejection | |
| Accepted _ other | varchar(45) | utf8 _ general _ ci | YES | Accepted in other study? | |
| Reas _ rej _ other | longtext | utf8 _ general _ ci | YES | Reason for rejection in other studies | |
| Other ref | varchar(45) | utf8 _ general _ ci | YES | Other study ID | |
| Screening | longtext | utf8 _ general _ ci | YES | Screening | |
| Location | mediumtext | utf8 _ general _ ci | YES | Location | |
| Site | mediumtext | utf8 _ general _ ci | YES | Site | |
| Additional _ site _ info | longtext | utf8 _ general _ ci | YES | Additional site information | |
| SampleLat | varchar(45) | utf8 _ general _ ci | YES | Latitude (decimal degrees) | |
| SampleLon | varchar(45) | utf8 _ general _ ci | YES | Longitude (decimal degrees) | |
| Reported _ Latitude | varchar(45) | utf8 _ general _ ci | YES | Reported Latitude | |
| Reported _ Longitude | varchar(45) | utf8 _ general _ ci | YES | Reported Longitude | |
| Lat _ Lon _ est | mediumtext | utf8 _ general _ ci | YES | Are Lat/Long estimated? | |
| Coord _ comments | longtext | utf8 _ general _ ci | YES | Comments on geographic coordinates | |
| Original _ elevation _ datum _ used | mediumtext | utf8 _ general _ ci | YES | Original elevation datum used | |
| How _ elevation _ derived | mediumtext | utf8 _ general _ ci | YES | Elevation measurement method | |
| Elevation _ reported | varchar(45) | utf8 _ general _ ci | YES | Reported elevation (m) | |
| Reported _ elevation _ uncertainty | varchar(45) | utf8 _ general _ ci | YES | Reported elevation uncertainty (m) | |
| Elevation _ above _ MSL | varchar(45) | utf8 _ general _ ci | YES | Elevation above MSL (m) | |
| Elevation _ uncertainty _ used | varchar(45) | utf8 _ general _ ci | YES | Elevation uncertainty used (m) | |
| Interpr _ elev | mediumtext | utf8 _ general _ ci | YES | Interpreted elevation relative to mllw/mlws (m) | |
| Elevation _ comments | longtext | utf8 _ general _ ci | YES | Elevation comments | |
| Tect _ cat | mediumtext | utf8 _ general _ ci | YES | Tectonic category | |
| Publ _ uplift | varchar(45) | utf8 _ general _ ci | YES | Published uplift rate (m/ky) | |
| Publ _ uplift _ unc | varchar(45) | utf8 _ general _ ci | YES | Published uncertainty in uplift rate (m/ky) | |
| Interpr _ uplift | varchar(45) | utf8 _ general _ ci | YES | Interpreted uplift rate (m/ky) | |
| Interpr _ uplift _ unc | varchar(45) | utf8 _ general _ ci | YES | Interpreted uplift rate uncertainty (m/ky) | |
| Comments _ uplift | longtext | utf8 _ general _ ci | YES | Comments (uplift), including sources of uplift rates | |
| Speleo _ insitu | varchar(45) | utf8 _ general _ ci | YES | Reported in situ? | |
| Speleo _ deposit _ type | varchar(45) | utf8 _ general _ ci | YES | Type of deposit | |
| Speleo _ distance _ base | varchar(45) | utf8 _ general _ ci | YES | Distance from base of deposit (m) | |
| Speleo _ Sampled _ material | varchar(45) | utf8 _ general _ ci | YES | Sampled material | |
| Speleo _ add _ context | longtext | utf8 _ general _ ci | YES | Additional sample context | |
| Speleo _ RSL | varchar(45) | utf8 _ general _ ci | YES | paleo RSL (m) | |
| Speleo _ RSL _ uncertainty | varchar(45) | utf8 _ general _ ci | YES | paleo RSL uncertainty (m) | |
| Terrace _ ID | mediumtext | utf8 _ general _ ci | YES | Terrace ID | |
| Facies _ descr | longtext | utf8 _ general _ ci | YES | Facies description | |
| In _ situ | tinytext | utf8 _ general _ ci | YES | Reported as in situ? | |
| Growth _ pos | tinytext | utf8 _ general _ ci | YES | Reported as in growth position? | |
| Coral _ taxa _ information | longtext | utf8 _ general _ ci | YES | Taxa information (as reported) | |
| Family | mediumtext | utf8 _ general _ ci | YES | Family | |
| Genus | mediumtext | utf8 _ general _ ci | YES | Genus | |
| Species | mediumtext | utf8 _ general _ ci | YES | Species | |
| Original _ paleodepth _ interpretation | longtext | utf8 _ general _ ci | YES | Original palaeodepth interpretation | |
| Comments _ Ecology | longtext | utf8 _ general _ ci | YES | Ecological metadata | |
| PWD _ estimate | varchar(45) | utf8 _ general _ ci | YES | Paleo water depth estimate (m) | |
| PWD _ upper | varchar(45) | utf8 _ general _ ci | YES | Upper limit of living range (m) | |
| PWD _ lower | varchar(45) | utf8 _ general _ ci | YES | Lower limit of living range (m) | |
| PWD _ comments | longtext | utf8 _ general _ ci | YES | Paleo water depth comments | |
| Pa _ Th _ Age | tinytext | utf8 _ general _ ci | YES | Pa/Th age? | |
| 14C _ Age | tinytext | utf8 _ general _ ci | YES | 14C age? | |
| Instrument | varchar(45) | utf8 _ general _ ci | YES | Instrument | |
| Decay _ Const | varchar(45) | utf8 _ general _ ci | YES | Decay constants | |
| Comments _ on _ decay _ constants | longtext | utf8 _ general _ ci | YES | Comments on decay constants | |
| Calib _ Method _ 230Th _ 238U | varchar(45) | utf8 _ general _ ci | YES | Calibration method for 230Th/238U ratio | |
| Calib _ Method _ 234U _ 238U | varchar(45) | utf8 _ general _ ci | YES | Calibration method for 234U/238U ratio | |
| Comments _ on _ spike _ calibration | longtext | utf8 _ general _ ci | YES | Comments on spike calibration | |
| Speleo _ mineralogy _ detected | varchar(45) | utf8 _ general _ ci | YES | How was speleothem mineralogy determined? | |
| Speleo _ mineralogy | varchar(45) | utf8 _ general _ ci | YES | Speleothem mineralogy | |
| Other _ screening _ techniques | longtext | utf8 _ general _ ci | YES | Other screening techniques applied | |
| Publ _ calcite | varchar(45) | utf8 _ general _ ci | YES | Published % calcite | |
| Interpr _ calcite | varchar(45) | utf8 _ general _ ci | YES | Interpreted % calcite | |
| 230 _ 232 _ Th _ ACT _ backcalc | varchar(45) | utf8 _ general _ ci | YES | [230Th/232Th]ACT backcalculated? | |
| 232Th _ 238U _ ACT _ backcalc | varchar(45) | utf8 _ general _ ci | YES | [232Th/238U]ACT backcalculated? | |
| 230Th _ 238U _ ACT _ backcalc | varchar(45) | utf8 _ general _ ci | YES | [230Th/238U]ACT backcalculated? | |
| 234Th _ 238U _ ACT _ backcalc | varchar(45) | utf8 _ general _ ci | YES | [234Th/238U]ACT backcalculated? | |
| 232Th | varchar(45) | utf8 _ general _ ci | YES | [232Th] (ppb) | |
| 232Th _ unc | varchar(45) | utf8 _ general _ ci | YES | [232Th] (ppb) uncertainty (±2sigma) | |
| 238U | varchar(45) | utf8 _ general _ ci | YES | [238U] (ppm) | |
| 238U _ unc | varchar(45) | utf8 _ general _ ci | YES | [238U] (ppm) uncertainty (±2sigma) | |
| Atom _ ratio _ 232Th _ 238U | varchar(45) | utf8 _ general _ ci | YES | Atomic ratio (232Th/238U)*10^5 | |
| 230 _ 232Th _ init | varchar(45) | utf8 _ general _ ci | YES | Initial 230Th/232Th | |
| 230Th _ 232Th _ ACT | varchar(45) | utf8 _ general _ ci | YES | [230Th/232Th]ACT | |
| 230Th _ 232Th _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | [230Th/232Th]ACT uncertainty (±2sigma) | |
| 232Th _ 238U _ ACT | varchar(45) | utf8 _ general _ ci | YES | [232Th/238U]ACT | |
| 232Th _ 238U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | [232Th/238U]ACT uncertainty (±2sigma) | |
| 230Th _ 234U _ ACT | varchar(45) | utf8 _ general _ ci | YES | [230Th/234U]ACT | |
| 230Th _ 234U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | [230Th/234U]ACT uncertainty (±2sigma) | |
| 230Th _ 238U _ ACT | varchar(45) | utf8 _ general _ ci | YES | [230Th/238U]ACT | |
| 230Th _ 238U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | [230Th/238U]ACT uncertainty (±2sigma) | |
| 234U _ 238 _ ACT | varchar(45) | utf8 _ general _ ci | YES | [234U/238U]ACT | |
| 234U _ 238U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | [234U/238U]ACT uncertainty (±2sigma) | |
| Reported _ age | varchar(45) | utf8 _ general _ ci | YES | Reported age (ka) | |
| Reported _ age _ unc | varchar(45) | utf8 _ general _ ci | YES | Reported ageuncertainty (ka, ±2sigma) | |
| Speleo _ corr _ rep _ age | varchar(45) | utf8 _ general _ ci | YES | Corrected reported age (ka) | |
| Speleo _ corr _ rep _ age _ unc | varchar(45) | utf8 _ general _ ci | YES | Corrected reported age uncert. (ka, ±2sigma) | |
| Reported _ d234U _ init | varchar(45) | utf8 _ general _ ci | YES | Reported delta 234U initial (‰) | |
| Reported _ d234U _ unc | varchar(45) | utf8 _ general _ ci | YES | Reported delta 234U (‰) uncertainty (±2sigma) | |
| 234U _ 238U _ init | varchar(45) | utf8 _ general _ ci | YES | Initial 234U/238U | |
| 234U _ 238U _ init _ unc | varchar(45) | utf8 _ general _ ci | YES | Initial 234U/238U uncertainty (±2sigma) | |
| 234U _ 238U _ meas | varchar(45) | utf8 _ general _ ci | YES | Measured 234U/238U | |
| 234U _ 238U _ meas _ unc | varchar(45) | utf8 _ general _ ci | YES | Measured 234U/238U uncertainty (±2sigma) | |
| Meas _ delta234U | varchar(45) | utf8 _ general _ ci | YES | Measured delta234U | |
| Meas _ delta234U _ unc | varchar(45) | utf8 _ general _ ci | YES | Measured delta234U uncertainty (±2sigma) | |
| Comments _ Age | longtext | utf8 _ general _ ci | YES | Comments on age determination | |
| Ref _ 230Th _ 238U | varchar(45) | utf8 _ general _ ci | YES | Reference material name for 230Th/238U | |
| Ref _ 234U _ 238U | varchar(45) | utf8 _ general _ ci | YES | Reference material name for 234U/238U | |
| Corr _ 230Th _ 238U | varchar(45) | utf8 _ general _ ci | YES | Correction factor for 230Th/238U | |
| Corr _ 230Th _ 238U _ unc | varchar(45) | utf8 _ general _ ci | YES | Correction factor for 230Th/238U uncertainty (±2sigma) | |
| Corr _ 234U _ 238U | varchar(45) | utf8 _ general _ ci | YES | Correction factor for 234U/238U | |
| Corr _ 234U _ 238U _ unc | varchar(45) | utf8 _ general _ ci | YES | Correction factor for 234U/238U uncertainty (±2sigma) | |
| Comments | longtext | utf8 _ general _ ci | YES | Comments | |
| Rec _ 230Th _ 238U _ ACT | varchar(45) | utf8 _ general _ ci | YES | Recalculated [230Th/238U]ACT | |
| Rec _ 230Th _ 238U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | Recalculated [230Th/238U]ACT uncertainty (±2sigma) | |
| Rec _ 234U _ 238 _ ACT | varchar(45) | utf8 _ general _ ci | YES | Recalculated [234U/238U]ACT | |
| Rec _ 234U _ 238U _ ACT _ unc | varchar(45) | utf8 _ general _ ci | YES | Recalculated [234U/238U]ACT uncertainty (±2sigma) | |
| Rec _ age | varchar(45) | utf8 _ general _ ci | YES | Recalculated Conventional Age (ka) | |
| Rec _ age _ unc | varchar(45) | utf8 _ general _ ci | YES | Recalculated Conventional Age uncert. (±2sigma) | |
| Rec _ d234U _ init | varchar(45) | utf8 _ general _ ci | YES | Recalculated delta 234Ui (‰) | |
| Rec _ d234U _ unc | varchar(45) | utf8 _ general _ ci | YES | Recalculated delta 234Ui uncertainty (±2sigma) | |
| Rec _ Conv _ age _ no _ decay | varchar(45) | utf8 _ general _ ci | YES | Recalculated Conventional Age uncert. w/ decay constant uncertainties (±2sigma) | |
| Rec _ d234Init _ no _ decay | varchar(45) | utf8 _ general _ ci | YES | Recalculated delta 234Ui uncert. (±2sigma) w/ decay constant uncertainties | |
| Comments age and d234Ui | longtext | utf8 _ general _ ci | YES | Comments (age and delta234i) | |
| MISchoice _ limit | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Equal/Younger than | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| Age determination | longtext | utf8 _ general _ ci | YES | Age determination | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| coord | point | YES | MySQL coordinates |
Table: aar (Amino Acid Racemization¶
This table contains samples dated with Amino Acid Racemization.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| ID AAR | int(11) | NO | PRI | WALIS AAR ID | |
| Public | varchar(45) | utf8 _ general _ ci | YES | Is this datapoint public? | |
| AARRef | mediumtext | utf8 _ general _ ci | YES | Reference(s) | |
| IGSN | varchar(45) | utf8 _ general _ ci | YES | IGSN | |
| SampleID | varchar(100) | utf8 _ general _ ci | YES | Sample ID | |
| AnalysisID | varchar(100) | utf8 _ general _ ci | YES | Analysis ID | |
| ReportedID | varchar(100) | utf8 _ general _ ci | YES | Reported ID | |
| Analysis _ Date | datetime | YES | Date of analysis | ||
| Laboratory name | mediumtext | utf8 _ general _ ci | YES | Laboratory name | |
| SampleType | longtext | utf8 _ general _ ci | YES | Sample Type | |
| Taxonomy | longtext | utf8 _ general _ ci | YES | Taxonomy | |
| SamplePos | longtext | utf8 _ general _ ci | YES | Sample position | |
| WRock | int(11) | YES | Whole-Rock? | ||
| WRsize | varchar(45) | utf8 _ general _ ci | YES | Grain Size (micrometersm) | |
| WRcarb | varchar(45) | utf8 _ general _ ci | YES | Carbonate (%) | |
| WRfract | varchar(45) | utf8 _ general _ ci | YES | Fraction (micrometersm) | |
| SampleQualNotes | longtext | utf8 _ general _ ci | YES | Notes and comments on sample quality | |
| CollectionContext | longtext | utf8 _ general _ ci | YES | Collection Context | |
| DoB | varchar(45) | utf8 _ general _ ci | YES | Depth of burial (m) | |
| Accepted | varchar(45) | utf8 _ general _ ci | YES | Accepted? | |
| ReasRej | longtext | utf8 _ general _ ci | YES | Reason for rejection | |
| Reported _ Latitude | varchar(45) | utf8 _ general _ ci | YES | Reported Latitude | |
| Reported _ Longitude | varchar(45) | utf8 _ general _ ci | YES | Reported Longitude | |
| SampleLat | varchar(45) | utf8 _ general _ ci | YES | Latitude (decimal degrees) | |
| SampleLon | varchar(45) | utf8 _ general _ ci | YES | Longitude (decimal degrees) | |
| Lat _ Lon _ Est | varchar(45) | utf8 _ general _ ci | YES | Are Lat/Long estimated? | |
| Original _ datum | varchar(45) | utf8 _ general _ ci | YES | Original elevation datum used | |
| Elev _ meas _ method | varchar(45) | utf8 _ general _ ci | YES | Elevation measurement method | |
| Reported _ Elev | varchar(45) | utf8 _ general _ ci | YES | Reported elevation (m) | |
| Reported _ Elev _ Unc | varchar(45) | utf8 _ general _ ci | YES | Reported elevation uncertainty (m) | |
| Elev _ MSL | varchar(45) | utf8 _ general _ ci | YES | Elevation above MSL (m) | |
| Elev _ MSL _ unc | varchar(45) | utf8 _ general _ ci | YES | Elevation uncertainty used (m) | |
| Elev _ comments | longtext | utf8 _ general _ ci | YES | Elevation comments | |
| MISchoice _ limit | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Equal/Younger than | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| MIS | longtext | utf8 _ general _ ci | YES | Comments/details on MIS designation | |
| ReportedAge | varchar(45) | utf8 _ general _ ci | YES | Reported age (ka) | |
| ReportedAgeUnc | varchar(45) | utf8 _ general _ ci | YES | Reported age uncertainty (±2sigma) (ka) | |
| CMAT | varchar(45) | utf8 _ general _ ci | YES | Current Annual Mean Temperature (°C) | |
| PrepProc | longtext | utf8 _ general _ ci | YES | Preparation procedure | |
| ChromMethod | longtext | utf8 _ general _ ci | YES | Method of chromatography | |
| StatPhaseCol | longtext | utf8 _ general _ ci | YES | Stationary phase of the column | |
| ReplNsamples | varchar(45) | utf8 _ general _ ci | YES | Number of replicates (samples) | |
| ReplNinj | varchar(45) | utf8 _ general _ ci | YES | Number of sample replicates (injections) | |
| RatioType | mediumtext | utf8 _ general _ ci | YES | Ratio type | |
| PyrolysisAvail | mediumtext | utf8 _ general _ ci | YES | Pyrolysis experiment available | |
| LevUnc | varchar(45) | utf8 _ general _ ci | YES | Level of uncertainty | |
| Aspartic | varchar(45) | utf8 _ general _ ci | YES | Aspartic | |
| Aspartic _ unc | varchar(45) | utf8 _ general _ ci | YES | Aspartic uncertainty | |
| Glutamic | varchar(45) | utf8 _ general _ ci | YES | Glutamic | |
| Glutamic _ unc | varchar(45) | utf8 _ general _ ci | YES | Glutamic uncertainty | |
| Serine | varchar(45) | utf8 _ general _ ci | YES | Serine | |
| Serine _ unc | varchar(45) | utf8 _ general _ ci | YES | Serine uncertainty | |
| Alanine | varchar(45) | utf8 _ general _ ci | YES | Alanine | |
| Alanine _ unc | varchar(45) | utf8 _ general _ ci | YES | Alanine uncertainty | |
| Valine | varchar(45) | utf8 _ general _ ci | YES | Valine | |
| Valine _ unc | varchar(45) | utf8 _ general _ ci | YES | Valine uncertainty | |
| A _ I | varchar(45) | utf8 _ general _ ci | YES | *A/I | |
| AI _ unc | varchar(45) | utf8 _ general _ ci | YES | *A/I uncertainty | |
| Leucine | varchar(45) | utf8 _ general _ ci | YES | Leucine | |
| Leucine _ unc | varchar(45) | utf8 _ general _ ci | YES | Leucine uncertainty | |
| Notes | longtext | utf8 _ general _ ci | YES | Notes/Comments | |
| ShowIndep | varchar(45) | utf8 _ general _ ci | YES | Independent age constraints available? | |
| Showblock | varchar(45) | utf8 _ general _ ci | YES | Calibration data available? | |
| freeAAR | varchar(45) | utf8 _ general _ ci | YES | Are free AAR ratios available? | |
| LevUnc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Level of uncertainty free AAR | |
| Aspartic _ FAA | varchar(45) | utf8 _ general _ ci | YES | Aspartic (free AAR) | |
| Aspartic _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Aspartic uncertainty (free AAR) | |
| Glutamic _ FAA | varchar(45) | utf8 _ general _ ci | YES | Glutamic (free AAR) | |
| Glutamic _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Glutamic uncertainty (free AAR) | |
| Serine _ FAA | varchar(45) | utf8 _ general _ ci | YES | Serine (free AAR) | |
| Serine _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Serine uncertainty (free AAR) | |
| Alanine _ FAA | varchar(45) | utf8 _ general _ ci | YES | Alanine (free AAR) | |
| Alanine _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Alanine uncertainty (free AAR) | |
| Valine _ FAA | varchar(45) | utf8 _ general _ ci | YES | Valine (free AAR) | |
| Valine _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Valine uncertainty (free AAR) | |
| A _ I _ FAA | varchar(45) | utf8 _ general _ ci | YES | *A/I (free AAR) | |
| AI _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | *A/I uncertainty (free AAR) | |
| Leucine _ FAA | varchar(45) | utf8 _ general _ ci | YES | Leucine (free AAR) | |
| Leucine _ unc _ FAA | varchar(45) | utf8 _ general _ ci | YES | Leucine uncertainty (free AAR) | |
| Notes _ FAA | longtext | utf8 _ general _ ci | YES | Notes/Comments free AAR | |
| CalibMethod | longtext | utf8 _ general _ ci | YES | Calibration method | |
| AARequation | mediumtext | utf8 _ general _ ci | YES | Amino Acid age equation | |
| CalibLab | mediumtext | utf8 _ general _ ci | YES | Calibration laboratory | |
| CalibLabID | mediumtext | utf8 _ general _ ci | YES | Calibration laboratory ID | |
| CalibRef | mediumtext | utf8 _ general _ ci | YES | Calibration reference | |
| CalibDLvalue | varchar(45) | utf8 _ general _ ci | YES | Calibration D/L value | |
| CalibDLvalue _ unc | varchar(45) | utf8 _ general _ ci | YES | Calibration D/L value uncertainty (±1sigma) | |
| Calib _ Age | varchar(45) | utf8 _ general _ ci | YES | Calibration age (ka) | |
| Calib _ Age _ unc | varchar(45) | utf8 _ general _ ci | YES | Calibration age (ka) uncertainty (±1sigma) | |
| Indep _ age _ choice | varchar(45) | utf8 _ general _ ci | YES | Independent age choice | |
| IndepAgeMethod | longtext | utf8 _ general _ ci | YES | Independent age method | |
| IndepAgeLab | mediumtext | utf8 _ general _ ci | YES | Independent age laboratory | |
| IndepAgeLabID | mediumtext | utf8 _ general _ ci | YES | Independent age laboratory ID | |
| IndepAgeResult | longtext | utf8 _ general _ ci | YES | Independent age result | |
| IndepAgeRef | mediumtext | utf8 _ general _ ci | YES | Independent age reference | |
| Useries constraint | varchar(45) | utf8 _ general _ ci | YES | U-Series age constraint | |
| ESR constraint | varchar(45) | utf8 _ general _ ci | YES | ESR age constraint | |
| Luminescene constraint | varchar(45) | utf8 _ general _ ci | YES | Luminescence age constraint | |
| Strat constraint | varchar(45) | utf8 _ general _ ci | YES | Stratigraphic age constraint | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| coord | point | YES | mySQL coordinates |
Table: esr (Electron Spin Resonance)¶
This table contains samples dated with Electron Spin Resonance.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| ESR _ ID | int(11) | NO | PRI | WALIS ESR ID | |
| Public | varchar(45) | utf8 _ general _ ci | YES | Is this datapoint public? | |
| ESR _ Method | tinytext | utf8 _ general _ ci | YES | Method | |
| IGSN | varchar(45) | utf8 _ general _ ci | YES | IGSN | |
| Refs | longtext | utf8 _ general _ ci | YES | Reference(s) | |
| Sample _ ID | varchar(45) | utf8 _ general _ ci | YES | Sample ID | |
| AnalysisID | varchar(45) | utf8 _ general _ ci | YES | Analysis ID | |
| ReportedID | varchar(45) | utf8 _ general _ ci | YES | Reported ID | |
| Lab _ name | mediumtext | utf8 _ general _ ci | YES | Laboratory name | |
| AnalysisDate | datetime | YES | Date of analysis | ||
| Accepted | varchar(45) | utf8 _ general _ ci | YES | Accepted? | |
| Reas _ rej | longtext | utf8 _ general _ ci | YES | Reason for rejection | |
| Reported _ Latitude | varchar(45) | utf8 _ general _ ci | YES | Reported Latitude | |
| Reported _ Longitude | varchar(45) | utf8 _ general _ ci | YES | Reported Longitude | |
| SampleLat | varchar(45) | utf8 _ general _ ci | YES | Latitude (decimal degrees) | |
| SampleLon | varchar(45) | utf8 _ general _ ci | YES | Longitude (decimal degrees) | |
| Lat _ Lon _ Est | varchar(45) | utf8 _ general _ ci | YES | Are Lat/Long estimated? | |
| Original _ datum | varchar(45) | utf8 _ general _ ci | YES | Original elevation datum used | |
| Elev _ meas _ method | varchar(45) | utf8 _ general _ ci | YES | Elevation measurement method | |
| Reported _ Elev | varchar(45) | utf8 _ general _ ci | YES | Reported elevation (m) | |
| Reported _ Elev _ Unc | varchar(45) | utf8 _ general _ ci | YES | Reported elevation uncertainty (m) | |
| Elev _ MSL | varchar(45) | utf8 _ general _ ci | YES | Elevation above MSL (m) | |
| Elev _ MSL _ unc | varchar(45) | utf8 _ general _ ci | YES | Elevation uncertainty used (m) | |
| Elev _ comments | longtext | utf8 _ general _ ci | YES | Elevation comments | |
| MISchoice _ limit | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Younger/Equal to | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| Reported _ MIS | longtext | utf8 _ general _ ci | YES | Comments/details on MIS designation or age | |
| Final _ age | varchar(45) | utf8 _ general _ ci | YES | Age (ka) | |
| Final _ age _ unc | varchar(45) | utf8 _ general _ ci | YES | Age uncertainty (ka) | |
| Mineral _ type | varchar(45) | utf8 _ general _ ci | YES | Mineral type | |
| Grain _ size | varchar(45) | utf8 _ general _ ci | YES | Grain size (µm) | |
| Aliquot size | varchar(45) | utf8 _ general _ ci | YES | Aliquot size (mg) | |
| Meas _ protocol | longtext | utf8 _ general _ ci | YES | Measurement protocol | |
| ESR _ spectr _ type | mediumtext | utf8 _ general _ ci | YES | ESR spectrometre type | |
| Meas _ temp | longtext | utf8 _ general _ ci | YES | Measurement temperature (K) | |
| AAcquisition _ parameters | mediumtext | utf8 _ general _ ci | YES | Acquisition parameters | |
| Paramagnetic _ centre | mediumtext | utf8 _ general _ ci | YES | ESR signal | |
| Nb _ Scans | varchar(45) | utf8 _ general _ ci | YES | Number of scans | |
| Nb _ repeat _ meas | varchar(45) | utf8 _ general _ ci | YES | Number of repeated measurements | |
| Nb _ rotations | varchar(45) | utf8 _ general _ ci | YES | Number of rotations in the cavity | |
| ESR _ Sign _ int | mediumtext | utf8 _ general _ ci | YES | Evaluation of the ESR signal intensity | |
| Corr _ ESR _ int | mediumtext | utf8 _ general _ ci | YES | Correction of the ESR intensities | |
| Bleaching _ coeff | mediumtext | utf8 _ general _ ci | YES | Bleaching coefficient (%) | |
| Fitting _ prog _ err _ calc | mediumtext | utf8 _ general _ ci | YES | Fitting program and error calculation | |
| Fitting function | mediumtext | utf8 _ general _ ci | YES | Fitting function | |
| Data _ weight _ fitting | mediumtext | utf8 _ general _ ci | YES | Data weighting used for fitting | |
| Equivalent _ dose | varchar(45) | utf8 _ general _ ci | YES | Equivalent dose estimate (Gy) | |
| Equivalent _ dose _ err | varchar(45) | utf8 _ general _ ci | YES | Equivalent dose estimate undertainty (±1sigma) (Gy) | |
| Depth | varchar(45) | utf8 _ general _ ci | YES | Depth (m) | |
| Technique | longtext | utf8 _ general _ ci | YES | Technique | |
| Dose _ rate _ unc _ type | varchar(45) | utf8 _ general _ ci | YES | Dose rate uncertainty type | |
| extU | varchar(45) | utf8 _ general _ ci | YES | external U (ppm) | |
| extU _ unc | varchar(45) | utf8 _ general _ ci | YES | external U error (ppm) | |
| extTh | varchar(45) | utf8 _ general _ ci | YES | external Th (ppm) | |
| extTh _ unc | varchar(45) | utf8 _ general _ ci | YES | external Th error (ppm) | |
| extK | varchar(45) | utf8 _ general _ ci | YES | external K (%) | |
| extK _ unc | varchar(45) | utf8 _ general _ ci | YES | external K error (%) | |
| extRb | varchar(45) | utf8 _ general _ ci | YES | external Rb (ppm) | |
| extRb _ unc | varchar(45) | utf8 _ general _ ci | YES | external Rb error (ppm) | |
| Ext _ dose _ rate | varchar(45) | utf8 _ general _ ci | YES | External dose rate (Gy/ka) | |
| Ext _ dose _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | External dose rate uncertainty (Gy/ka) | |
| intU | varchar(45) | utf8 _ general _ ci | YES | internal U (ppm) | |
| intU _ unc | varchar(45) | utf8 _ general _ ci | YES | internal U error (ppm) | |
| intTh | varchar(45) | utf8 _ general _ ci | YES | internal Th (ppm) | |
| intTh _ unc | varchar(45) | utf8 _ general _ ci | YES | internal Th error (ppm) | |
| intK | varchar(45) | utf8 _ general _ ci | YES | internal K (%) | |
| intK _ unc | varchar(45) | utf8 _ general _ ci | YES | internal K error (%) | |
| intRb | varchar(45) | utf8 _ general _ ci | YES | internal Rb (ppm) | |
| intRb _ unc | varchar(45) | utf8 _ general _ ci | YES | internal Rb error (ppm) | |
| Int _ dose _ rate | varchar(45) | utf8 _ general _ ci | YES | Internal dose rate (Gy/ka) | |
| Int _ dose _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Internal dose rate uncertainty (Gy/ka) | |
| Alpha _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Alpha dose rate (Gy/ka) | |
| Alpha _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Alpha dose rate error (Gy/ka) | |
| Gamma _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Gamma dose rate (Gy/ka) | |
| Gamma _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Gamma dose rate error (Gy/ka) | |
| Beta _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Beta dose rate (Gy/ka) | |
| Beta _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Beta dose rate error (Gy/ka) | |
| Cosmic _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Cosmic dose rate (Gy/ka) | |
| Cosmic _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Cosmic dose rate error (Gy/ka) | |
| Field _ water | varchar(45) | utf8 _ general _ ci | YES | Field water content (% of dry mass) | |
| Water _ cont _ det | longtext | utf8 _ general _ ci | YES | Water content determination method | |
| Water _ cont _ val | varchar(45) | utf8 _ general _ ci | YES | Water content used (%) | |
| Water _ cont _ unc | varchar(45) | utf8 _ general _ ci | YES | Water content used error (%) | |
| Atten _ fact | longtext | utf8 _ general _ ci | YES | Attenuation factors | |
| Conv _ fact | longtext | utf8 _ general _ ci | YES | Conversion factors | |
| Alpha _ eff _ fact | longtext | utf8 _ general _ ci | YES | Alpha efficiency factor | |
| Etching _ method | longtext | utf8 _ general _ ci | YES | Etching method | |
| etch _ depth | varchar(45) | utf8 _ general _ ci | YES | Etch depth (µm) | |
| etch _ depth _ unc | varchar(45) | utf8 _ general _ ci | YES | Etch depth error (µm) | |
| Total _ dose _ rate | varchar(45) | utf8 _ general _ ci | YES | Total dose rate (Gy/ka) | |
| Total _ dose _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Total dose rate uncertainty (Gy/ka) | |
| Notes | longtext | utf8 _ general _ ci | YES | Comments and notes | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| coord | point | YES | mySQL coordinates |
Table: luminescence (Luminescence)¶
This table contains samples dated with luminescence techniques.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| LUM _ ID | int(11) | NO | PRI | WALIS LUM ID | |
| Public | varchar(45) | utf8 _ general _ ci | YES | Is this datapoint public? | |
| Lum _ Method | tinytext | utf8 _ general _ ci | YES | Luminescence method | |
| IGSN | varchar(45) | utf8 _ general _ ci | YES | IGSN | |
| lum _ ref | longtext | utf8 _ general _ ci | YES | Reference (s) | |
| Sample _ ID | varchar(45) | utf8 _ general _ ci | YES | Sample ID | |
| AnalysisID | varchar(45) | utf8 _ general _ ci | YES | Analysis ID | |
| ReportedID | varchar(45) | utf8 _ general _ ci | YES | Reported ID | |
| Lab _ name | mediumtext | utf8 _ general _ ci | YES | Laboratory name | |
| Mineral _ type | varchar(45) | utf8 _ general _ ci | YES | Mineral type | |
| Grain _ size | varchar(45) | utf8 _ general _ ci | YES | Grain size | |
| AnalysisDate | datetime | YES | Date of analysis | ||
| Accepted | varchar(45) | utf8 _ general _ ci | YES | Accepted? | |
| Reas _ rej | longtext | utf8 _ general _ ci | YES | Reason for rejection | |
| Reported _ Latitude | varchar(45) | utf8 _ general _ ci | YES | Reported Latitude | |
| Reported _ Longitude | varchar(45) | utf8 _ general _ ci | YES | Reported Longitude | |
| Sample _ lat | varchar(45) | utf8 _ general _ ci | YES | Sample latitude (decimal degrees) | |
| Sample _ lon | varchar(45) | utf8 _ general _ ci | YES | Sample longitude (decimal degrees) | |
| Lat _ Lon _ Est | varchar(45) | utf8 _ general _ ci | YES | Are Lat/Long estimated? | |
| Original _ datum | varchar(45) | utf8 _ general _ ci | YES | Original elevation datum used | |
| Elev _ meas _ method | varchar(45) | utf8 _ general _ ci | YES | Elevation measurement method | |
| Sample _ elev | varchar(45) | utf8 _ general _ ci | YES | Reported elevation (m) | |
| Sample _ elev _ unc | varchar(45) | utf8 _ general _ ci | YES | Reported elevation uncertainty (m) | |
| Elev _ MSL | varchar(45) | utf8 _ general _ ci | YES | Elevation above MSL (m) | |
| Elev _ MSL _ unc | varchar(45) | utf8 _ general _ ci | YES | Elevation uncertainty used (m) | |
| Elev _ comments | longtext | utf8 _ general _ ci | YES | Comments on elevation | |
| MISchoice _ limit | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Equal/Younger than | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| Reported _ MIS | longtext | utf8 _ general _ ci | YES | Comments/details on MIS designation or age | |
| Final _ age | varchar(45) | utf8 _ general _ ci | YES | Age (ka) | |
| Final _ age _ unc | varchar(45) | utf8 _ general _ ci | YES | Age uncertainty (ka) | |
| Aliquot size | varchar(45) | utf8 _ general _ ci | YES | Aliquot size | |
| ED _ meas _ protocol | longtext | utf8 _ general _ ci | YES | Equivalent Dose measurement protocol | |
| Treatment | longtext | utf8 _ general _ ci | YES | Treatment during measurement | |
| ED _ stat _ model | varchar(45) | utf8 _ general _ ci | YES | Statistical model for burial dose | |
| Machine _ type | longtext | utf8 _ general _ ci | YES | Machine type | |
| Detection _ unit | longtext | utf8 _ general _ ci | YES | Detection unit | |
| Stimulation _ unit | longtext | utf8 _ general _ ci | YES | Stimulation unit | |
| Optical _ filters | longtext | utf8 _ general _ ci | YES | Optical Filters used for Detection | |
| Nb _ aliquots _ sg _ run | mediumtext | utf8 _ general _ ci | YES | Number of aliquots/ single grains run | |
| Nb _ aliquots _ sg _ used | mediumtext | utf8 _ general _ ci | YES | Number of aliquots/ single grains used in sample | |
| Dose _ unc _ lev | varchar(45) | utf8 _ general _ ci | YES | Uncertainty level | |
| ED | varchar(45) | utf8 _ general _ ci | YES | Equivalent dose (Gy) | |
| ED _ unc | varchar(45) | utf8 _ general _ ci | YES | Equivalent dose uncertainty (Gy) | |
| OD _ val | varchar(45) | utf8 _ general _ ci | YES | Overdispersion value (%) | |
| OD _ val _ unc | varchar(45) | utf8 _ general _ ci | YES | Overdispersion value uncertainty (%) | |
| Depth _ of _ burial | varchar(45) | utf8 _ general _ ci | YES | Depth of burial (m) | |
| DR _ determination | longtext | utf8 _ general _ ci | YES | Approach of dose rate dermination | |
| Dose _ rate _ unc _ type | varchar(45) | utf8 _ general _ ci | YES | Uncertainty levels | |
| U | varchar(45) | utf8 _ general _ ci | YES | Uranium content (ppm) | |
| U _ unc | varchar(45) | utf8 _ general _ ci | YES | Uranium content uncertainty (ppm) | |
| Th | varchar(45) | utf8 _ general _ ci | YES | Thorium content (ppm) | |
| Th _ unc | varchar(45) | utf8 _ general _ ci | YES | Thorium content uncertainty (ppm) | |
| K | varchar(45) | utf8 _ general _ ci | YES | Potassium content (%) | |
| K _ unc | varchar(45) | utf8 _ general _ ci | YES | Potassium content uncertainty (%) | |
| Rb | varchar(45) | utf8 _ general _ ci | YES | Rubidium content (ppm) | |
| Rb _ unc | varchar(45) | utf8 _ general _ ci | YES | Rubidium content uncertainty (ppm) | |
| Alpha _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Alpha dose rate (Gy/ka) | |
| Alpha _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Alpha dose rate uncertainty (Gy/ka) | |
| Gamma _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Gamma dose rate (Gy/ka) | |
| Gamma _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Gamma dose rate uncertainty (Gy/ka) | |
| Beta _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Beta dose rate (Gy/ka) | |
| Beta _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Beta dose rate uncertainty (Gy/ka) | |
| Cosmic _ rate _ val | varchar(45) | utf8 _ general _ ci | YES | Cosmic dose rate (Gy/ka) | |
| Cosmic _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Cosmic dose rate uncertainty (Gy/ka) | |
| Field _ water | varchar(45) | utf8 _ general _ ci | YES | Field water content (% of dry mass) | |
| Water _ cont _ det | longtext | utf8 _ general _ ci | YES | Water content determination method | |
| Water _ cont _ val | varchar(45) | utf8 _ general _ ci | YES | Water Content used in Final Age Calculation (% of dry mass) | |
| Water _ cont _ unc | varchar(45) | utf8 _ general _ ci | YES | Water Content used in Final Age Calculation uncertainty (% of dry mass) | |
| Atten _ fact | varchar(45) | utf8 _ general _ ci | YES | Alpha attenuation factor | |
| DR _ conv _ fact | varchar(45) | utf8 _ general _ ci | YES | Dose Rate conversion factors | |
| Total _ dose _ rate | varchar(45) | utf8 _ general _ ci | YES | Total dose rate (Gy/Ka) | |
| Total _ dose _ rate _ unc | varchar(45) | utf8 _ general _ ci | YES | Total dose rate uncertainty (Gy/ka) | |
| Fading _ corr | varchar(45) | utf8 _ general _ ci | YES | Was fading correction applied? | |
| Method _ fading | varchar(45) | utf8 _ general _ ci | YES | Method of fading correction | |
| g-value | varchar(45) | utf8 _ general _ ci | YES | g-value (% per decade) | |
| g-value _ unc | varchar(45) | utf8 _ general _ ci | YES | g-value (±1sigma) (% per decade) | |
| Notes | longtext | utf8 _ general _ ci | YES | Comments | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update | ||
| coord | point | YES | MySQL coordinates |
Table: strat (Chronostratigraphy)¶
This table contains chronostratigraphic age constraints.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| Strat _ ID | int(11) | NO | PRI | WALIS Strat ID | |
| Public | tinytext | utf8 _ general _ ci | YES | Is this datapoint public? | |
| StratName | varchar(45) | utf8 _ general _ ci | YES | Chronostratigraphy ID | |
| StratRef | mediumtext | utf8 _ general _ ci | YES | Reference(s) | |
| StratDescr | longtext | utf8 _ general _ ci | YES | Description for chronostratigraphic constraint | |
| UnitThickness | mediumtext | utf8 _ general _ ci | YES | Unit thickness (m) | |
| MISchoice _ limits | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Equal/Younger than | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| MIS | longtext | utf8 _ general _ ci | YES | Comments/details on MIS designation | |
| UpperAge | decimal(10,0) | YES | Upper Age (ka) | ||
| LowerAge | decimal(10,0) | YES | Lower Age (ka) | ||
| AgeNotes | longtext | utf8 _ general _ ci | YES | Notes on age determination | |
| OfficialStrat | varchar(45) | utf8 _ general _ ci | YES | Is this an official stratigraphic designation? | |
| dur _ yrs _ y _ n | varchar(45) | utf8 _ general _ ci | YES | Has duration estimated in years? | |
| duration | varchar(45) | utf8 _ general _ ci | YES | Duration (yrs) | |
| duration _ unc | varchar(45) | utf8 _ general _ ci | YES | Duration uncertainty (yrs) | |
| parent _ strat _ y _ n | varchar(45) | utf8 _ general _ ci | YES | Is a subzone of a parent Chronostratigraphy entry? | |
| parent _ link | varchar(45) | utf8 _ general _ ci | YES | Parent record (WALIS Strat ID) | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update |
Table: other_dating (Other)¶
This table contains samples dated with age techniques not detailed in WALIS.
| Field | Type | Collation | Null | Key | Comment |
|---|---|---|---|---|---|
| idOther _ dating | int(11) | NO | PRI | WALIS Other chronology ID | |
| Public | varchar(45) | utf8 _ general _ ci | YES | Is this datapoint public? | |
| Short name | varchar(45) | utf8 _ general _ ci | YES | Short name | |
| Dating _ technique | mediumtext | utf8 _ general _ ci | YES | Dating technique | |
| Description | longtext | utf8 _ general _ ci | YES | Description | |
| Upper age | decimal(10,2) | YES | Upper age (ka) | ||
| Lower age | decimal(10,2) | YES | Lower age (ka) | ||
| MISchoice _ limit | varchar(45) | utf8 _ general _ ci | YES | Age is Older/Equal/Younger than | |
| MISchoice | varchar(45) | utf8 _ general _ ci | YES | Marine Isotopic Stage | |
| MIS | longtext | utf8 _ general _ ci | YES | Comments/details on MIS designation | |
| Ref | varchar(45) | utf8 _ general _ ci | YES | Reference(s) | |
| Createdby | varchar(45) | utf8 _ general _ ci | YES | Record created by | |
| Updatedby | varchar(45) | utf8 _ general _ ci | YES | Record updated by | |
| LastUpdate | datetime | YES | Last Update |