== DBNAME == _fields
[ [ '|soupName|, '|string| ], [ '|fieldName|, '|string| ], [ '|fieldType|, '|string| ], [ '|indexed|, '|boolean| ], [ '|table|, '|string| ], [ '|linkSoup|, '|string| ], [ '|linkField|, '|string| ], [ '|linkCondition|, '|code| ], [ '|fieldWidth|, '|int| ], [ '|fieldFlags|, '|int| ], [ '|defaultValue|, '|string| ], [ '|code|, '|code| ], [ '|decimals|, '|int| ], [ '|pKey|, '|boolean| ] ]
divers	name	string	true						0				
divers	club	string							0				
== EOD ==
== DBNAME == divers
[ [ '|name|, '|string| ], [ '|club|, '|string| ] ]
Cecil P. Bordages	
Micki King	
Phil Boggs	
== EOD ==
== DBNAME == _fields
[ [ '|soupName|, '|string| ], [ '|fieldName|, '|string| ], [ '|fieldType|, '|string| ], [ '|indexed|, '|boolean| ], [ '|table|, '|string| ], [ '|linkSoup|, '|string| ], [ '|linkField|, '|string| ], [ '|linkCondition|, '|code| ], [ '|fieldWidth|, '|int| ], [ '|fieldFlags|, '|int| ], [ '|defaultValue|, '|string| ], [ '|code|, '|code| ], [ '|decimals|, '|int| ], [ '|pKey|, '|boolean| ] ]
difficulties	dive	string	true						0				
difficulties	dod	real							0			2	
== EOD ==
== DBNAME == difficulties
[ [ '|dive|, '|string| ], [ '|dod|, '|Real| ] ]
1 1/2 gainer	1.20
cannonball	0.00
Joe's Bar	1.00
triple back pike	4.30
== EOD ==
== DBNAME == _fields
[ [ '|soupName|, '|string| ], [ '|fieldName|, '|string| ], [ '|fieldType|, '|string| ], [ '|indexed|, '|boolean| ], [ '|table|, '|string| ], [ '|linkSoup|, '|string| ], [ '|linkField|, '|string| ], [ '|linkCondition|, '|code| ], [ '|fieldWidth|, '|int| ], [ '|fieldFlags|, '|int| ], [ '|defaultValue|, '|string| ], [ '|code|, '|code| ], [ '|decimals|, '|int| ], [ '|pKey|, '|boolean| ] ]
dives	diver	string	true		divers	name			640				
dives	dive #	int							0				
dives	dive	string			difficulties	dive			704				
dives	judge 1	Real							0			2	
dives	judge 2	Real							0			2	
dives	judge 3	Real							0			2	
dives	judge 4	Real							0			2	
dives	judge 5	Real							0		local hi := e.|judge 1|;\nlocal low := e.|judge 1|;\nlocal tot := 0;\nlocal s;\ne.notes := "";\nfor i := 1 to 5 do begin\n\ts := e.(intern("judge " & i));\n\ttot := tot + s;\n\tif s < low then\n\t\tlow := s\n\telse if s > hi then \n\t\thi := s;\nend;\ntot := tot - (low +hi);\ne.score := tot * e.dod / 3	2	
dives	dod	Real							1			2	
dives	score	Real	true						1			2	
dives	notes	text							0				
== EOD ==
== DBNAME == dives
[ [ '|diver|, '|string| ], [ '|dive #|, '|int| ], [ '|dive|, '|string| ], [ '|judge 1|, '|Real| ], [ '|judge 2|, '|Real| ], [ '|judge 3|, '|Real| ], [ '|judge 4|, '|Real| ], [ '|judge 5|, '|Real| ], [ '|dod|, '|Real| ], [ '|score|, '|Real| ], [ '|notes|, '|text| ] ]
Phil Boggs	1	1 1/2 gainer	5.70	5.70	6.00	6.00	5.00	1.20	24.94	
Phil Boggs	7	triple back pike	5.00	6.00	6.00	7.00	5.00	4.30	24.37	
Phil Boggs	8	triple back pike	5.00	6.00	7.00	5.00	6.00	4.30	24.37	
Phil Boggs	5	triple back pike	5.00	6.00	7.00	6.00	5.00	4.30	24.37	
Phil Boggs	2	triple back pike	5.00	6.00	7.00	6.00	4.00	4.30	24.37	
Phil Boggs	2	triple back pike	5.00	6.00	5.00	7.00	6.00	4.30	24.37	
Phil Boggs	3	triple back pike	5.00	6.00	6.00	5.00	5.00	4.30	22.93	
Phil Boggs	1	triple back pike	5.00	6.00	6.00	5.00	5.00	4.30	22.93	
Micki King	5	1 1/2 gainer	6.10	7.20	4.50	6.00	7.10	1.20	7.68	
Phil Boggs	3	1 1/2 gainer	5.00	6.00	7.00	6.00	7.00	1.20	7.60	
Phil Boggs	3	1 1/2 gainer	6.00	6.00	6.00	5.00	9.00	1.20	7.20	
Micki King	6	1 1/2 gainer	6.00	7.00	6.00	6.00	5.00	1.20	7.20	
Phil Boggs	8	1 1/2 gainer	6.00	5.00	7.00	6.00	6.00	1.20	7.20	
Micki King	7	1 1/2 gainer	6.00	5.00	6.00	7.00	6.00	1.20	7.20	almost clean dive This fellow events too much
Micki King	5	1 1/2 gainer	5.00	6.00	7.00	6.00	6.00	1.20	7.20	
Phil Boggs	7	1 1/2 gainer	6.00	5.00	6.00	4.00	7.00	1.20	6.80	
Phil Boggs	3	1 1/2 gainer	5.00	6.00	7.00	6.00	5.00	1.20	6.80	
Phil Boggs	6	1 1/2 gainer	6.00	5.00	6.00	5.00	7.00	1.20	6.80	
Phil Boggs	4	1 1/2 gainer	4.00	5.00	6.00	5.00	7.00	1.20	6.40	
Phil Boggs	2	1 1/2 gainer	5.00	6.00	5.00	6.00	4.50	1.20	6.40	
Micki King	1	triple back pike	4.40	4.20	4.30	4.50	5.00	4.30	5.28	
Cecil P. Bordages	1	Joe's Bar	3.20	2.30	3.20	4.50	3.20	1.00	3.20	
Phil Boggs	2	1 1/2 gainer	0.00	0.00	0.00	0.00	0.00	0.00	0.00	
Micki King	3	1 1/2 gainer	0.00	0.00	0.00	0.00	0.00	1.20	0.00	
Phil Boggs	4	triple back pike	8.70	0.00	0.00	0.00	0.00	4.30	0.00	
Phil Boggs	1	triple back pike	0.00	0.00	0.00	0.00	0.00	4.30	0.00	
Micki King	0	1 1/2 gainer	0.00	0.00	0.00	0.00	0.00	1.20	0.00	
Micki King	6	1 1/2 gainer	5.00	6.00	5.00	4.00	0.00	1.20	0.00	
Micki King	7		0.00	0.00	0.00	0.00	0.00	0.00	0.00	
									0.00	
Micki King	0		0.00	0.00	0.00	0.00	0.00	0.00	0.00	
== EOD ==
== DBNAME == _queries
[ [ '|qName|, '|string| ], [ '|soup|, '|string| ] ]
gainer	dives
not gainer	dives
== EOD ==
== DBNAME == _criteria
[ [ '|Query|, '|string| ], [ '|soup|, '|string| ], [ '|field|, '|string| ], [ '|comparison|, '|string| ], [ '|value|, '|string| ] ]
gainer	dives	dive	=	1 1/2 gainer
not gainer	dives	dive	\u2260\u	1 1/2 gainer
== EOD ==
== DBNAME == _views
[ [ '|viewName|, '|string| ], [ '|soup|, '|string| ] ]
dives	dives
== EOD ==
== DBNAME == _columns
[ [ '|view|, '|string| ], [ '|column|, '|int| ], [ '|soup|, '|string| ], [ '|field|, '|string| ], [ '|width|, '|int| ], [ '|summary|, '|string| ] ]
dives	1	dives	diver		
dives	2	dives	dive #	34	
dives	3	dives	dive		
dives	4	dives	score	51	
== EOD ==
== DBNAME == _links
[ [ '|linkDescr|, '|string| ], [ '|otherFrom|, '|string| ], [ '|otherTo|, '|string| ] ]
dives/dive/difficulties/dive	dod	dod
== EOD ==
== EOD ==