MySQL電子カルテ/MyProdoc

12$B7n(B23$BF|$K%f!<%6!<$N3'MM$K(B2$B2sL\$N(BMyProdoc$B$N$*CN$i$;$r$*Aw$j$$$?$7$^$7$?!#(B
$BB??t$N!"(BMyProdoc$B$X$N%"%C%W%5%$%:$N$*?=$79~$_$bFO$$$F$*$j$^$9!#@?$K$"$j$,$H$&$4$6$$$^$9!#(B
$BAaB.(BMySQL$B$r%$%s%9%H!<%k$7$F!"%G!<%?0\?"$N
MyProdoc$B$K4X$9$k$4R2p$$$?$7$^$9(B(2003-12-24)

$B%[!<%`%Z!<%8(B$B$KLa$k(B

$B!J$4$B$I$N$/$i$$$N4|4V$G0\9T$G$-$^$9$+!)(B

$B!J$*Ez$(!K(B
MySQL$B$N%$%s%9%H!<%k!&@_Dj!"(BODBC$B%I%i%$%P$N%$%s%9%H!<%k!&@_Dj$O$9$0$K=PMh$^$9!#(B
$B%G!<%?0\9T$O%G!<%?$NNL$K$h$j$^$9$,!"#1!"#2;~4V0JFb$G2DG=$@$H;W$$$^$9!#(B
$B$=$N8e!"?7$7$$%f!<%6!<%$%s%?!<%U%'!<%9$K47$l$k$?$a$K!"#1!"(B2$B=54V$O;n831?MQ$rI,MW$H$7$^$9!#(B
$B=>Mh$N%W%m%U%'%C%7%g%J%k%I%/%?!<$r1?MQ$7$J$,$i!"(BMyProdoc$B$N;n831?MQ$,2DG=$G$9!#(B
$B:G?7$N%W%m%U%'%C%7%g%J%k%I%/%?!<$N%G!<%?$N(BMySQL$B%G!<%?$X$N0\9T$O2?EY$G$b$G$-$^$9!#(B

$B!J$4MyProdoc$B$X$N0\9T$N6qBNE*$JJ}K!$,$o$+$i$J$$$N$G$9$,!#(B

$B!J$*Ez$(!K(B
$B-!(BMySQL$B$N%@%&%s%m!<%IK!!&%$%s%9%H!<%kK!!&@_DjJ}K!(B
$B-"(BODBC$B%I%i%$%P$N%$%s%9%H!<%kK!!&@_DjJ}K!(B
$B-#%W%m%U%'%C%7%g%J%k%I%/%?!<$N%G!<%?"*(BMyProdoc$B$N%G!<%?$X$N0\9TK!(B
$B-$(BMyProdoc$B$N1?MQK!!J(BLAN$B$N@_Dj!K(B
$B-%$=$NB>$K4X$9$k@bL@(B
$B$r8=:_:n@.Cf$G$9!#(B
$B:#$7$P$i$/$*$^$A$/$@$5$$!#(B

$B!J$4MyProdoc$B$K0\9T$9$k$?$a$K?7$7$$%3%s%T%e!<%?$,I,MW$G$9$+!)(B

$B!J$*Ez$(!K(B
$B?7$7$$%3%s%T%e!<%?$OI,MW$"$j$^$;$s!#8=:_$N4D6-$N$^$^$G2DG=$G$9!#(B
$B$^$?!"F10l%3%s%T%e!<%?Fb$G!"%W%m%U%'%C%7%g%J%k%I%/%?!<$r5/F0$7$?$j!"(BMyProdoc$B$r5/F0$7$?$j$b2DG=$G$9!#(B

$B!J$4$B%"%C%W%5%$%:%*%W%7%g%s$r9XF~$7$F$b!"$9$0$KF3F~$7$J$$>l9g$O!"7n!9$N%"%+%&%s%HNA$O;YJ'$o$J$/$F$b$$$$$N$G$9$+(B

$B!J$*Ez$(!K(B
$B6D$;$N$H$*$j$G!"$B?75,%f!<%6!<$,F3F~$9$k>l9g$O$=$N$^$^$9$0;HMQ$r3+;O$G$-$^$9$N$G4JC1$G$9$,!"=>Mh$N%W%m%U%'%C%7%g%J%k%I%/%?!<%f!<%6!<$N>l9g$O!"%G!<%?$N0\9T$r$7$J$1$l$P$J$j$^$;$s$7!"6HL3$r$7$J$,$i$N0\9T:n6H$K$J$j$^$9$N$G!"2?EY$+;n9T:x8m$r7+$jJV$7$J$,$i!"$&$^$/9T$/$H3N?.$,;}$F$?CJ3,$G0l5$$K0\9T$9$k$H$$$&$3$H$K$J$k$H;W$$$^$9!#(B
$B$^$?$4<+J,$G:n$i$l$?%*%V%8%'%/%H$J$I$N0\9T:n6H$b$"$k$H;W$$$^$9!#(B
$B$3$l$i$N$3$H$r4*0F$7$F!"4{B8%f!<%6!<$NFC8"$r3NJ]$7$?>e$G(B1$BG/$N4V$K0B?4$7$FF3F~$7$F$$$?$@$1$k$h$&$K!"%"%C%W%5%$%:%*%W%7%g%s$r@_Dj$7$^$7$?!#(B

$B!J$4MyProdoc$B$r1?MQ$9$k$K$O%$%s%?!<%M%C%H$K@\B3$7$J$1$l$P$J$i$J$$$N$G$9$+!)(B
$B$=$N$H$-$O8w%U%!%$%P!<$,I,MW$G$9$+!)(B

$B!J$*Ez$(!K(B
$B$$$$$((BMyProdoc$B$r1?MQ$9$k$N$K%$%s%?!<%M%C%H@\B3$OI,MW$"$j$^$;$s!#(B
MySQL$B$O%$%s%?!<%M%C%H%5!<%P!<$H$7$F;HMQ$5$l$k$3$H$GM-L>$K$J$j$^$7$?$,!"0lHL$N%G!<%?%Y!<%9$H$7$F1!Fb(BLAN$B>e$N%5!<%P!<%G!<%?%Y!<%9$H$7$F;HMQ$7$^$9$N$G!"(BMyProdoc$B$r2TF0$5$;$k$N$K%$%s%?!<%M%C%H@\B3$OITI,MW$G$9!#(B
$B$?$@!"(BMySQL$B$=$N$b$N$rF~

$B!J$4MyProdoc$B$N%$%a!<%8$,$h$/$o$+$i$J$$$G$9$,!#(B

$B!J$*Ez$(!K(B
$B=>Mh$N%W%m%U%'%C%7%g%J%k%I%/%?!<$,!"<+E>MyProdoc$B$O%m!<%k%9%m%$%9$,0z$CD%$k!"$H$$$&%$%a!<%8$G$9!#(B

$B!J$4$B:#$N%W%m%U%'%C%7%g%J%k%I%/%?!<$,CY$$$H$O;W$o$J$$$7!"ITK~$O$J$$$N$G$9$,!#(B

$B!J$*Ez$(!K(B
$B%W%m%U%'%C%7%g%J%k%I%/%?!<$O%G%9%/%H%C%W%G!<%?%Y!<%9$G$bKhF|$N6HL3$O>o$K0lDj$NB.EY$r0];}$G$-$k$h$&$K$J$C$F$$$^$9$N$G!"L5M}$7$F(BMyProdoc$B$K0\9T$5$l$kI,MW$O$"$j$^$;$s!#(B
MyProdoc$B$OFC$K8E$$%f!<%6!<$N@h@8J}$N6HL3$NG=N(2=$KLrN)$D$H;W$o$l$^$9!#(B
$B$^$?!"$?$/$5$s$N%3%s%T%e!<%?Cl9g$K$bM-8z$G$9!#(B

$B!J$4$B!!(BMyProdoc$B$N%$%s%?!<%U%'!<%9$O$I$&$J$k$N$G$7$g$&$+!)%U%)!<%`$@$1(Baccess$B;H$&$N$G$7$g$&$+!)(B

$B!J$*Ez$(!K(B
MyProdoc$B$O!c%+%k%F(BB.MDB$B!d$N%j%s%/%F!<%V%k$r!c%G!<%?(B.$B#M#D#B!d$J$I$N(BACCESS$B%F!<%V%k$+$i(BMySQL$B%F!<%V%k$KJQ99$7$?$b$N$G$9!#(B

$BF1$8!c%+%k%F(BB.MDB$B!d$G$9$N$G!"4pK\E*$K=>Mh$NEE;R%+%k%F$HF1$8$G$9!#(B
$B$=$N$?$a=>Mh$4<+J,$G%+%9%?%^%$%:$5$l$?ItJ,$O$=$N$^$^;HMQ$G$-$^$9!#(B
$BC1=c$K$$$($P!"!c%+%k%F(BB.MDB$B!d$N%j%s%/%F!<%V%k$r(BACCESS$B%G!<%?%Y!<%9$N%F!<%V%k$+$i"*(BMySQL$B%G!<%?%Y!<%9$N%F!<%V%k$KJQ$($F!"(B ACCESS$B%$%s%?!<%U%'!<%9(B+MySQL$B%G!<%?%Y!<%9$K$7$?$N$,(BMyProdoc$B$G$9!#(B
$B%j%s%/$5$l$?(BMySQL$B%F!<%V%k$N@h$K$O!"(BMySQL$B%G!<%?%Y!<%9%5!<%P!<$,2TF0$7$F$$$k$?$a$K!"(B $BEE;R%+%k%F!c%+%k%F(BB.MDB$B!d$N(BSQL$B$KBP$7$F!"?WB.$KI,MW$J7k2L$N$_$rJV$7$F$/$l$^$9!#(B
ACCESS$B$N(BSQL$B$O%j%s%/@h$,(BACCESS$B%F!<%V%k$N>l9g$O!"C1$J$k%U%#%k%?!<5!G=$H$7$F$7$+F/$/$3$H$,=PMh$J$$$?$a!"0lEY%F!<%V%kFbMF$r$9$Y$FFI$_9~$s$@8e!"%G!<%?$NA*Br$r9T$C$F$$$?$?$a!"=hM}$K$@$s$@$s$H;~4V$,$+$+$k$h$&$K$J$j$^$9!#(B
MyProdoc$B$G$O%j%s%/%F!<%V%k$,(BMySQL$B$G$"$k$?$a$K!"K\Mh$N(BSQL$B$H$7$F5!G=$9$k$H$$$&$o$1$G$9!#(B
$B$7$?$,$C$F!"=>Mh$N(BACCESS$B%*%V%8%'%/%H$O%F!<%V%k0J30$O$9$Y$F:FMxMQ2DG=$G$9!#(B

$B!J$4$B%F!<%V%k!"%/%(%j$O0\?"2DG=$i$7$$$G$9$,%b%8%e!<%k$J$I$O0\?"$G$-$^$9$+(B

$B!J$*Ez$(!K(B
$B%j%s%/%F!<%V%k$,JQ$o$j$^$9$N$G!"%F!<%V%k$N%G!<%?$O!c%G!<%?(B.$B#M#D#B!d$J$I$+$i(BMySQL$B%U%!%$%k$K0\?"$7$^$9!#!J0\?"%D!<%k$OG[I[$$$?$7$^$9!K(B
$B%F!<%V%k0J30$N$4<+J,$G:n@.$5$l$?%/%(%j!MyProdoc$B$O=>Mh$HF1$8(BACCESS$B%U%!%$%k$G$9$+$i!"$4<+J,$G:n@.$5$l$?%*%V%8%'%/%H$O$9$Y$F:FMxMQ2DG=$G$9!#(B
$B%b%8%e!<%k$b:FMxMQ2DG=$G$9!#(B

$B!J$4 $B!!(Bprodoc$B$N%G!<%?%Y!<%9$r;H$C$F$+$J$j$N<+:n$N%"%W%j$r:n$C$F$^$9$N$G$=$l$i$r(B $B!!$&$^$/0\?"$G$-$k$+$I$&$+IT0B$G$9(B
$B!!!!(B
$B!J$*Ez$(!K(B
$B%W%m%U%'%C%7%g%J%k%I%/%?!<$N%f!<%6!<$N@h@8J}$O!"$4<+J,$G$+$J$j2~B$$5$l$F<+J,$J$j$N%7%9%F%`$K$5$l$F$$$k>l9g$,B?$$$?$a$K!"2~B$$5$l$F$$$kItJ,$r@8$+$9$?$a$K=>Mh$HF1$8(BACCESS$B%U%!%$%k$G%G!<%?%Y!<%9$@$1$rJQ99$7$F$^$9!#(B
$B$4<+J,$G2~B$$7$?ItJ,$rEvA0$,JQ$o$k$+$b$7$l$^$;$s$,!K$K=>Mh$HF1$8$h$&$K%$%s%]!<%H$9$l$PF1$8$h$&$K;HMQ$G$-$^$9!#(B
$B<+:n%"%W%j$b%F!<%V%k$r(BMySQL$B$N%F!<%V%k!J%G!<%?0\?"8e!K$K%j%s%/$7D>$7$F0JA0$HF1$8$h$&$KMxMQ2DG=$G$9!#(B

$B!J$4$BF10l(BLAN$BFb$K!"J#?t(BPC$B$K(BMySQL$B$*$h$S$=$N%G!<%?%Y!<%9$r@_CV$9$k$3$H$O2DG=$G$9$+!)(B
$B2DG=$@$H$9$k$H!"%/%i%$%"%s%H$+$i@\B3$9$k%G!<%?%Y!<%9$NJQ99$O4JC1$K9T$($^$9$+!)(B

$B!J$*Ez$(!K(B
$B2DG=$G$9$7!"DL>oJ#?t$N%3%s%T%e!<%?$K(BMySQL$B$r%$%s%9%H!<%k$7$F$*$-!"%5!<%P!<$,%@%&%s$7$?>l9g$OB>$N%3%s%T%e!<%?$r%5!<%P!<$K$7$F6HL3$r7QB3$9$k$3$H$,=PMh$k$h$&$K$7$F$*$/I,MW$,$"$j$^$9!#(B
$B%/%i%$%"%s%H$+$iJL$N%5!<%P!<$K@\B3$9$k>l9g$O!"C

$B!J$4$B:#2s$N%"%C%W%5%$%:%*%W%7%g%s$r?=$79~$^$:!"(BMyProdoc$B$NF3F~?=$79~$_$,!"(BH16$BG/0J9_$H$J$C$?>l9g$NHqMQ$O!"$I$N$/$i$$$K$J$kM=Dj$G$7$g$&$+!#(B

$B!J$*Ez$(!K(B
$B4{B8%f!<%6!<$H$7$F$NM%@h8"$r<:$&$3$H$K$J$j$^$9$N$G!"?75,%f!<%6!<$H$7$F$NF3F~$H$J$j$^$9!#(B
$B?75,%f!<%6!<$NF3F~HqMQ$O$^$@L$Dj$G$9!#(B

$B!J$4MyProdoc$B$rF3F~$7$?$"$H$G!"8=:_;HMQCf$N%W%m%U%'%C%7%g%J%k%I%/%?!<$KLa$9$3$H$O!"2DG=$G$7$g$&$+!#(B $B2DG=$J>l9g!"%f!<%6!<%"%+%&%s%H;HMQNA$O$I$&$J$j$^$9$+(B $B!#(B

$B!J$*Ez$(!K(B
MyProdoc$B$+$i8=:_$N%W%m%U%'%C%7%g%J%k%I%/%?!<$KLa$9$3$H$O2DG=$@$H;W$$$^$9$,!"%G!<%?9=B$$,>/$70c$$$^$9$N$G!"$=$NE@$NN10U$,I,MW$G$9!#(B
MyProdoc$B$r;HMQ$7$J$/$J$j%W%m%U%'%C%7%g%J%k%I%/%?!<$KLa$k>l9g$O(BMyProdoc$B%f!<%6!<%"%+%&%s%H$+$i:o=|$5$l$^$9$N$G!"%"%+%&%s%HNA$OITMW$G$9!#(B

$B!J$4$B%W%m%U%'%C%7%g%J%k%I%/%?!<$N%F!<%V%k$K@\B3$7$F!"(BEXEL$B!"(BACCESS$B$G%U%!%$%k$r:n@.$7$F$$$^$9$,!"$=$l$i$,;HMQ$r7QB3$G$-$^$9$+!)(B

$B!J$*Ez$(!K(B
MyProdoc$B$O!"%j%s%/%F!<%V%k$,=>Mh(Bmdb$B%U%!%$%k$G$"$C$?$b$N$,!"(BMySQL$B%F!<%V%k$KJQ99$5$l$F$$$^$9$N$G!"%F!<%V%k%G!<%?$r0\?"8e!"(BACCESS$B$J$I$G:n@.$5$l$?%A%(%C%/%=%U%H$N%F!<%V%k$N%j%s%/$r(BMySQL$B%F!<%V%k$KJQ99$9$l$P;HMQ$G$-$k$h$&$K$J$j$^$9!#(B
$B:#$^$G%+%k%F%U%!%$%k$r%+%9%?%^%$%:$7$?ItJ,$b%$%s%]!<%H$r9T$($P;HMQ$G$-$k$h$&$K$J$j$^$9!#(B

$B!J$4MyProdoc$B$GKhF|$N%G!<%?0\F0$O$J$/$J$j$^$9$+!)(B

$B!J$*Ez$(!K(B
$B%G!<%?0\F0$O%G%9%/%H%C%W%G!<%?%Y!<%9$N=hM}>e$NLdBj$r2sHr$9$k$?$a$KEvF|F~NOJ,$H2a5n$N%G!<%?J,$KJ,$1$F$$$?$N$G$9$,!"(BMyProdoc$B$G$bF1$8%F!<%V%k9=B$$rF'=1$7$^$9$N$G!"%G!<%?0\F0$bF1$8$h$&$K9T$o$l$^$9!#(B

$B!J$4l9g!"=>Mh$N%W%m%U%'%C%7%g%J%k%I%/%?!<$N%5%]!<%H$O$I$&$J$j$^$9$+!)(B

$B!J$*Ez$(!K(B
$B=>Mh$HF1$8$h$&$K%5%]!<%H$5$l$^$9!#(B

$B!J$4$B=>Mh$N%W%m%U%'%C%7%g%J%k%I%/%?!<$O>CLG$9$k$N$G$9$+!)(B

$B!J$*Ez$(!K(B
$B%W%m%U%'%C%7%g%J%k%I%/%?!<$O$J$s$H8@$C$F$b!"4JC1$KF3F~$7$d$9$/!"$o$+$j$d$9$$$H$$$&MxE@$,$"$j$^$9$N$G!"$3$l$+$i$bHNGd$$$?$7$^$9$7!";HMQ$5$l$F$f$/$H;W$$$^$9!#(B

$B%[!<%`%Z!<%8(B$B$KLa$k(B