|
·ÖÀർº½ |
 |
|
|
|
|
×ÊÔ´´óС£º30.90 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
Èí¼þÉè¼ÆËµÃ÷Êé
____ÃÅÕï¹ÒºÅ
• ÒµÎñ·ÖÎö£º
ÃÅÕï¹ÒºÅÊÇÒ½ÔºÔÚʹÓÃÒ½ÔºÐÅÏ¢¹ÜÀíϵͳʱ×îÔç¿ÉÄܽӴ¥µÄ×Óϵͳ£¬ËüÖ÷ÒªÍê³É²¡È˵ĹҺš¢ÊÕ·ÑÒµÎñ£¬ÒÔ¼°Ò½ÔºÄÚ²¿¼°ÓëÔºÍⵥλ½áËã¡£
• ËùÐ蹦ÄÜ·ÖÎö£º
ÃÅÕï¹ÒºÅÖ÷Òª¹¦ÄÜ£º
Á÷³Ìͼ£º
1. »ù´¡×Öµäά»¤£º
gh_zd_clinic_type(ºÅ±ð×Öµä)£º¶¨ÒåÒ½Ôº¹ÒºÅºÅ±ðÈ磺ÆÕͨºÅ¡¢×¨¼ÒºÅ¡¢½ÌÊںš
gh_zd_clinic_charge(ºÅ±ð×Öµä·ÑÓÃÏîÄ¿Ã÷ϸ)£º¶¨ÒåҽԺijÖֺűðÓ¦ÊÕ·ÑÓÃÏîÄ¿£º¹ÒºÅ·Ñ¡¢ÕïÁÆ·Ñ¡¢·þÎñ·Ñ¡¢¸½¼Ó·Ñ¡
gh_zd_request_type(ºÅÀà×Öµä)£º¶¨ÒåÒ½Ôº¹ÒºÅºÅÀࣺÈçÃÅÕïºÅ¡¢Ô¤Ô¼ºÅ¡¢µç»°Ô¤Ô¼ºÅ¡
gh_zd_request_charge (ºÅÀà×Öµä·ÑÓÃÏîÄ¿Ã÷ϸ)£º¶¨ÒåҽԺijÖÖºÅÀàÓ¦ÊÕ·ÑÓÃÏîÄ¿£º·þÎñ·Ñ¡¢¸½¼Ó·Ñ¡
2. »ù´¡ºÅ±íά»¤£º
gh_base_request(ÃÅÕï»ù´¡ºÅ±í)£º°´¿ÆÊÒ¡¢Ò½Éú¡¢ºÅ±ð»®·Ö¶¨ÒåÒ½Ôº1~4ÖÜÿÌì¹ÒºÅ×ÜÊý£¬ Ö÷ÒªÓÃÀ´Éú³É½«À´Ò½ÔºÊ¹ÓùҺżÇ¼±í
gh_base_request_segment(»ù´¡ºÅ±í·ÖÅ䶨Òå)£º½«Ä³Öֺűð×ܺÅÊý°´ÕÕºÅÀà»®·Ö³É¶à¶Î£¬Óà ÒÔÈ·¶¨°´²»Í¬ºÅÀà¹ÒºÅʱӦ·ÖÅäµÄºÅ˳Ðò
3. gh_record(¹ÒºÅ¼Ç¼)£ºÒ½Ôº¶ÔÍâʹÓùҺżÇ¼£¬ÓÐÁ½ÖÖÇé¿öÇø·Ö
a-¼Ç¼²¡È˹ҺÅÇé¿ö
b-¼Ç¼δ¹Ò³öºÅÇé¿ö
4. gh_doctor_schedule (Ò½Éú³öÕï¼Æ»®)£ºÓÉÒ½Éú×Ô¼ºÈ·¶¨ÔÚijʱ¼ä¶ÎÄÚ²»³öÕÔÚÉú³É¹ÒºÅ¼Ç¼ʱӦÅжÏÒ½ÉúÊÇ·ñÔÚ²»³öÕïÆÚÄÚ£¬ÈôÊÇÔò²»Éú³É´ËÒ½Éú¹ÒºÅ¼Ç¼
5. ÔÚ¹ÒºÅʱ·ÑÓô¦ÀíÊǷdz£ÖØÒª¹¦ÄÜ£¬Ö÷񻃾¼°ÈýÕűí
gh_detail_charge(·ÑÓÃÃ÷ϸ)£º¼Ç¼²¡È˹ҺŷÑÓÃÃ÷ϸÇé¿ö
gh_receipt(·¢Æ±±í)£º²¡È˽áËãʱ°´·ÑÓÃÃ÷ϸÉú³É½áËã¼Ç¼
gh_receipt_charge(ÏÖ½ðÁ÷Ë®ÕË)£º¼Ç¼²¡È˽»Ô¤½»½ð¡¢½áÕËʱÍùÀ´Á÷Ë®ÕË
6. ic_register (IC¿¨µÇ¼Ç)£º¼Ç¼²¡ÈËÔÚÒ½Ôº¹ºÂòIC¿¨µÄÇé¿ö
7. ic_deposit(ICÁ÷Ë®ÕÊ)£º¼Ç¼²¡ÈËÔÚҽԺʹÓÃIC¿¨»¨·ÑÁ÷Ë®ÕË
• ±í½á¹¹¼°Êý¾Ý²Ù×÷
1. ±í½á¹¹
1) gh_base_request(ÃÅÕï»ù´¡ºÅ±í)
2) gh_base_request_segment(ÃÅÕïºÅ·ÖÅ䶨Òå)
3) gh_record(¹ÒºÅ¼Ç¼)
4) gh_detail_charge(·ÑÓÃÃ÷ϸ)
5) gh_receipt(·¢Æ±±í)
6) gh_receipt_charge(Õ˵¥·ÑÓÃ)
7) gh_deposit(ÏÖ½ðÕË)
8) gh_zd_clinic_type(ºÅ±ð×Öµä)
9) gh_zd_clinic_charge(ºÅ±ð×Öµä·ÑÓÃÏîÄ¿Ã÷ϸ)
10) gh_zd_request_type(ºÅÀà×Öµä)
11) gh_zd_request_charge (ºÅÀà×Öµä·ÑÓÃÏîÄ¿Ã÷ϸ)
12) ic_register (IC¿¨µÇ¼Ç)
13) ic_deposit(ICÁ÷Ë®ÕÊ)
14) gh_doctor_schedule (Ò½Éú³öÕï¼Æ»®)
ºÅ±í¹ÜÀíËùÃæ¶ÔÎÊÌ⣺
1) Ò½ÉúÓÐȨȷ¶¨×Ô¼ººÅ¿ª·Å±êÖ¾¡¢¿ª·Åʱ¼ä¶Î
2) Ô¤Ô¼ºÅ·ÖÁ½ÖÖa: Ò½ÉúÔ¤Ô¼ºÅ£¬²»ÊÜʱ¶ÎºÍ×ܺÅÊý¿ØÖÆ,Á¢¿Ì¼ÓºÅ
b: ²¡ÈËÔ¤Ô¼ºÅ£¬Ò»¶¨ÊÜºÅ±í¿ØÖÆ
3) ¶ÔijЩºÅ²»ÄÜËæ±ã¼ÓºÅ£¬ÓÉҽԺͳһ¿ØÖÆ
4) ÌØ¶¨´°¿ÚÖ»ÄܹÒÌØ¶¨ºÅ
˵Ã÷ £ºÒÔÉϱíÖ»¿¼ÂǹҺÅÒµÎñ¼°¹ÒºÅ·ÑÓÃÇé¿ö£¬¶ÔÓÚ¹ÒºÅÓëÊշѹ²Í¬Ê¹ÓñíÕ¸²»Áгö¡£
gh_base_request (ÃÅÕï»ù´¡ºÅ¶¨Òå)
×Ö¶Î Êý¾ÝÀàÐÍ ¿í¶È ÃèÊö Ö÷¼ü Êý¾ÝÀ´Ô´
request_sn identity 4 Ψһ±àºÅ£¨ÓëdetailÏà¹ØÎ¨Ò»±êʾ£© *
week tinyint 1 ÖÜ i
day tinyint 1 Ìì i
ampm char 1 ÉÏÎç/ÏÂÎç(a/p) i
unit_sn Small int 2 ¿Æ±ð i Zd_unit.code
group_sn Small int 2 ×é i Zd_unit.code
doctor_sn Small int 2 Ò½ÉúÐÕÃû i A_employee_mi.code
clinic_type char 2 ºÅ±ð i Gh_clinic_code
totle_num small int 2 ×ܺÅÊý
enter_opera Small int 2 ²Ù×÷Ô± A_employee_mi.code
enter_date datetime 8 ²Ù×÷ÈÕÆÚ
open_flag char 1 ¿ª·Å±êÖ¾ 1=¿ª·Å(´ËºÅ¿ÉÓÃ)
addopen_flag Char 1 ¼ÓºÅ¿ª·Å1=¿ª·Å£¨Ò½Éú»ò¹ÒºÅÔ±ÈÎÒâ¼ÓºÅ£©
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|