ÃÑ 57ÆäÀÌÁö
53ÆäÀÌÁö º»¹®½ÃÀÛ
6. Àü¿°º´ °ü¸®(diseasetype)
Áúº´ °ü¸®
Å×À̺í ID
Å×À̺í¸í
ÀÛ¾÷¿µ¿ª
º´¼º°¨Á¤
diseasetype
Disease type
Table ID
Table Name
Group
disease
management
Á¤ÀÇ
Áúº´¸í ¸ñ·Ï °ü¸® Manage list of disease type
Definition
À妽º Index
À妽º¸í
À妽º ŸÀÔ
Ä÷³¸í
Unique
Index Name
Index Type
Column Name
PRIMARY
PK
O
PID
µðÆúÆ®°ª
Null°ª
¼ø¹ø
Ä÷³ ID
Ä÷³¸í
µ¥ÀÌÅÍÀ¯Çü
PK
Çã¿ë¿©ºÎ
Default
Seq.
Column ID
Column Name
Data Type
Null
Value
Àü¿°º´
1
PID
ÀϷùøÈ£
O
int(2)
N
serial number
Áúº´¸í
2
diseasename
varchar(12)
Y
disease name
- 48 -
Áúº´ °ü¸®
Å×À̺í ID
Å×À̺í¸í
ÀÛ¾÷¿µ¿ª
º´¼º°¨Á¤
diseasetype
Disease type
Table ID
Table Name
Group
disease
management
Á¤ÀÇ
Áúº´¸í ¸ñ·Ï °ü¸® Manage list of disease type
Definition
À妽º Index
À妽º¸í
À妽º ŸÀÔ
Ä÷³¸í
Unique
Index Name
Index Type
Column Name
PRIMARY
PK
O
PID
µðÆúÆ®°ª
Null°ª
¼ø¹ø
Ä÷³ ID
Ä÷³¸í
µ¥ÀÌÅÍÀ¯Çü
PK
Çã¿ë¿©ºÎ
Default
Seq.
Column ID
Column Name
Data Type
Null
Value
Àü¿°º´
1
PID
ÀϷùøÈ£
O
int(2)
N
serial number
Áúº´¸í
2
diseasename
varchar(12)
Y
disease name
- 48 -
53ÆäÀÌÁö º»¹®³¡
¸Þ´º
ÇöÀç Æ÷Ä¿½ºÀÇ ¾Æ·¡³»¿ëµéÀº µ¿ÀÏÇÑ ÄÁÅÙÃ÷¸¦ °¡Áö°í ÆäÀÌÁö³Ñ±è È¿°ú¹× ½Ã°¢Àû È¿°ú¸¦ Á¦°øÇÏ´Â ÆäÀÌÁöÀ̹ǷΠ½ºÅ©¸°¸®´õ »ç¿ëÀÚ´Â ¿©±â±îÁö¸¸ ³¶µ¶ÇϽðí À§ÀÇ ÆäÀÌÁöÀ̵¿ ¸µÅ©¸¦ »ç¿ëÇÏ¿© ´ÙÀ½ÆäÀÌÁö·Î À̵¿ÇϽñ⠹ٶø´Ï´Ù.