ÃÑ 49ÆäÀÌÁö
48ÆäÀÌÁö º»¹®½ÃÀÛ
9. Ä£±¸±×·ì »ó¼¼ °ü¸®(regist_group_detail)
Ä£±¸ ±×·ì
ȸ¿ø°ü¸®
Å×À̺í ID
Å×À̺í¸í
ÀÛ¾÷¿µ¿ª
regist_group_detail
»ó¼¼
member
Table ID
Table Name
Group
group detail
-ship
Á¤ÀÇ
Ä£±¸±×·ì »ó¼¼¸¦ °ü¸® ÇÑ´Ù (Management of group detail)
Definition
À妽º Index
À妽º¸í
À妽º ŸÀÔ
Ä÷³¸í
Unique
Index Name
Index Type
Column Name
PRIMARY
PK
O
PID
PRIMARY
PK
O
GROUP_SN
PRIMARY
PK
O
USER_ID
PRIMARY
PK
O
GROUP_DETAIL_SN
µðÆúÆ®°ª
Null°ª
¼ø¹ø
Ä÷³ ID
Ä÷³¸í
µ¥ÀÌÅÍÀ¯Çü
Çã¿ë¿©ºÎ
PK
Default
Seq.
Column ID
Column Name
Data Type
Null
Value
Ä£±¸±×·ì»ó¼¼
1
PID
ÀϷùøÈ£
O
int(11)
N
serial number
Ä£±¸±×·ì»ó¼¼
¼ø¹ø
2
group_sn
O
int(11)
N
serial number
of group
»ç¿ëÀÚ ¾ÆÀ̵ð
3
user_id
O
char(30)
N
¡¡
user ID
±×·ì»ó¼¼ ¼ø¹ø
4
group_detail_sn
serial number
O
int(11)
N
of group detail
±×·ìµî·Ï ¾ÆÀ̵ð
5
group_user_id
user ID
¡¡
char(30)
Y
¡¡
grouping
- 43 -
Ä£±¸ ±×·ì
ȸ¿ø°ü¸®
Å×À̺í ID
Å×À̺í¸í
ÀÛ¾÷¿µ¿ª
regist_group_detail
»ó¼¼
member
Table ID
Table Name
Group
group detail
-ship
Á¤ÀÇ
Ä£±¸±×·ì »ó¼¼¸¦ °ü¸® ÇÑ´Ù (Management of group detail)
Definition
À妽º Index
À妽º¸í
À妽º ŸÀÔ
Ä÷³¸í
Unique
Index Name
Index Type
Column Name
PRIMARY
PK
O
PID
PRIMARY
PK
O
GROUP_SN
PRIMARY
PK
O
USER_ID
PRIMARY
PK
O
GROUP_DETAIL_SN
µðÆúÆ®°ª
Null°ª
¼ø¹ø
Ä÷³ ID
Ä÷³¸í
µ¥ÀÌÅÍÀ¯Çü
Çã¿ë¿©ºÎ
PK
Default
Seq.
Column ID
Column Name
Data Type
Null
Value
Ä£±¸±×·ì»ó¼¼
1
PID
ÀϷùøÈ£
O
int(11)
N
serial number
Ä£±¸±×·ì»ó¼¼
¼ø¹ø
2
group_sn
O
int(11)
N
serial number
of group
»ç¿ëÀÚ ¾ÆÀ̵ð
3
user_id
O
char(30)
N
¡¡
user ID
±×·ì»ó¼¼ ¼ø¹ø
4
group_detail_sn
serial number
O
int(11)
N
of group detail
±×·ìµî·Ï ¾ÆÀ̵ð
5
group_user_id
user ID
¡¡
char(30)
Y
¡¡
grouping
- 43 -
48ÆäÀÌÁö º»¹®³¡
¸Þ´º
ÇöÀç Æ÷Ä¿½ºÀÇ ¾Æ·¡³»¿ëµéÀº µ¿ÀÏÇÑ ÄÁÅÙÃ÷¸¦ °¡Áö°í ÆäÀÌÁö³Ñ±è È¿°ú¹× ½Ã°¢Àû È¿°ú¸¦ Á¦°øÇÏ´Â ÆäÀÌÁöÀ̹ǷΠ½ºÅ©¸°¸®´õ »ç¿ëÀÚ´Â ¿©±â±îÁö¸¸ ³¶µ¶ÇϽðí À§ÀÇ ÆäÀÌÁöÀ̵¿ ¸µÅ©¸¦ »ç¿ëÇÏ¿© ´ÙÀ½ÆäÀÌÁö·Î À̵¿ÇϽñ⠹ٶø´Ï´Ù.