Metadata (explanation of main table)				
-Dave Lazarus (dbl) 23 August 2012				
"Most fields as given in source, but (as needed) transposed, filled, normalised to database record format."				
"Original format was 'report' style with headers over unfilled columns to left, filled detail to right."				
Core-level info entered inconsistently in available white spaces.  DSDP-ODP names entered very inconsistently.  Minor differences between printout provided with shipment and excel file provided later.				
Regularly spaced sample series were commonly only indirectly entered with 'every x cm' and from-to.				
"Various formulas, macros and external programs were used, with extensive manual editing, to fill down blanks in columns, reformat, insert implied records and improve consistency in names etc."				
Original content was not checked for accuracy.				
				
	core_name	varchar80		"piston core, trigger, grab sample; DSDP or ODP (begin with number); water column"
	latitude	real		this and longitude as given (decimal degrees)
	longitude	real		
	water_depth_m	real		as given
	core_length	real		of importance primarily for piston cores. 
	box_number	integer		"primary slide box storage, standard boxes hold 100 slides each.  Numbers ca 50 may mean duplicate slides (for which no info provided,and no separate record entries made). Values >100 are suspect, may reflect gaps in real samples vs auto-generated series."
added	shipping_number	integer		shipping crate number for transfer between OSU and Tokyo
	depth_top_cm	real		sample identifier.  Blanks (very rare) changed to zero in i-o between db and spreadsheet.
	depth_bottom_cm	real		generally 1-2 cm larger value than top_cm
	comment	varchar255		"combined text from various locations in original, plus other comments by dbl"
added	insert step	integer		"increment used to insert additional implied rows, based on text comments. -99 - flag for series marked in original 'as above', e.g. based on similar series immediately preceding in listing."
added	record_type	varchar2		"blank for records in original file, 'c' means calculated inserted record "
added	pisias_id	integer		"auto-generated by database, used as key field"
added	sample_type	varchar2		"d-deep sea drilling (DSDP, ODP), w-water column, else blank"