up to bottles
Test Clinic
$Id: testclinic.html 47 2004-09-03 04:31:18Z connolly $
supporting tools
The loadTables (src) tool is used to insert these data into the SQL
database.
Clinics
id |
name |
address |
city |
st |
zip |
phone |
| 01 |
Air Mlad Clinic |
11021 Drury Lane |
Roeland Park |
KS |
66205 |
912-555-9876 |
Patients
id |
surname |
givenname |
chart |
born |
email |
phone |
| 10 |
Walker |
Matilda |
w001 |
1965-09-01 |
mwalker@example.net |
816-555-1212 |
| 11 |
Henderson |
Frank |
h002 |
1990-03-22 |
frankh@example.org |
913-555-1234 |
| 12 |
Davis |
Joan |
100003 |
1972-03-23 |
|
913-555-4345 |
| 13 |
Edwards |
Kimberly |
100009 |
1978-05-10 |
|
913-555-5674 |
| 14 |
Hansen |
Lyle |
100006 |
1987-12-12 |
|
913-555-4335 |
| 15 |
Johnson |
Karen |
100005 |
1945-07-23 |
|
913-555-7554 |
| 16 |
Kenner |
Louis |
100007 |
1951-06-01 |
|
913-555-6584 |
| 17 |
Lee |
Stefany |
100012 |
1962-01-07 |
|
816-555-6754 |
| 18 |
Little |
John |
100004 |
1948-09-14 |
|
816-555-2157 |
| 19 |
Meza |
Brent |
100008 |
1951-02-15 |
|
816-555-6785 |
| 101 |
Nelson |
Lisa |
100010 |
1964-10-10 |
|
816-555-2457 |
| 102 |
Perkins |
Alice |
100011 |
1959-11-01 |
|
913-555-7325 |
| 103 |
Smith |
Chad |
100015 |
1941-12-07 |
|
913-555-7853 |
| 104 |
Smith |
Albert |
100001 |
1950-04-10 |
|
913-555-3554 |
Supplements
id |
desc |
| 21 |
vitamin C 1000mg |
| 22 |
vitamin D 500mg |
| 23 |
vitamin B complex 500mg |
Rates
id |
label |
num |
denom |
| 31 |
3x day, every day |
3 |
1 |
| 32 |
1x/day M, W, F |
3 |
7 |
Instructions
id |
who |
what |
rate |
start |
stop |
| 41 |
10 |
22 |
31 |
2004-09-02 |
2004-11-01 |
| 42 |
11 |
23 |
32 |
2004-08-15 |
2004-10-30 |
Products
id |
what |
qty |
price |
| 51 |
21 |
100 |
12.50 |
| 52 |
21 |
50 |
7.00 |
| 53 |
22 |
90 |
11.75 |
| 54 |
23 |
15 |
9.50 |
Counts
product |
qty |
minimum |
| 51 |
5 |
10 |
| 52 |
20 |
10 |
| 53 |
9 |
10 |
Orders
id |
who |
product |
qty |
delivery |
| 61 |
10 |
51 |
2 |
2004-05-01 |
| 62 |
11 |
52 |
3 |
2004-07-01 |