== 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 ] ]
notes	name	string	true					0	0				true
notes	age	Int						0	0				
notes	sex	String		sex				0	1	female			
notes	side	String		side				0	0				
notes	anatomic site	String		sites				0	0				
notes	Years	Int						0	0				
notes	operation	String						0	0				
notes	form	string			note forms	form		0	0		if strlen(e.form) = 0 then\n\treturn nil;\nlocal fc := :fetch("note forms", 'form, e.form);\nif not fc or not fc:entry() then\n\treturn nil;\nlocal strings := foreach v in e collect SPrintObject(v);\nArrayRemoveCount(strings, length(strings)-2, 2);\ne.note := paramstr(fc:entry().text, strings);		
notes	note	text						0	0				
== EOD ==
== DBNAME == notes
[ [ '|name|, 'String ], [ '|age|, 'Int ], [ '|sex|, 'String ], [ '|side|, 'String ], [ '|anatomic site|, 'String ], [ '|Years|, 'Int ], [ '|operation|, 'String ], [ '|form|, 'String ], [ '|note|, 'text ] ]
John H. Watson	39	male	right	shoulder	3	shoulder replacement	test	The patient, John H. Watson, is a 39 year old male complaining of right shoulder pain for 3 years.  I recommend a shoulder replacement.
== EOD ==
== DBNAME == _tables
[ [ '|tblName|, 'String ], [ '|tblDisplay|, 'String ], [ '|tblStore|, 'Int ] ]
sex	female	0
sex	male	1
side	left	0
side	right	1
sites	shoulder	0
== EOD ==
== DBNAME == _views
[ [ '|viewName|, 'String ], [ '|soup|, 'String ] ]
note	notes
== EOD ==
== DBNAME == _columns
[ [ '|view|, 'String ], [ '|column|, 'Int ], [ '|soup|, 'String ], [ '|field|, 'String ], [ '|width|, 'Int ], [ '|summary|, 'String ] ]
note	1	notes	note	0	
== 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 ] ]
note forms	form	string	true					0	0			0	true
note forms	text	code						0	0			0	
== EOD ==
== DBNAME == note forms
[ [ '|form|, 'String ], [ '|text|, 'code ] ]
test	The patient, ^0, is a ^1 year old ^2 complaining of ^3 ^4 pain for ^5 years.  I recommend a ^6.
== EOD ==
== EOD ==