[B! erd][db] imai78ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

imai78 id:imai78

erdã¨dbã«é–¢ã™ã‚‹imai78ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€Œã‚‚ã†DBã¯ã“ã†ãªã£ã¦ã¾ã™ã®ã§ã€ã¯ã‚‚ã£ãŸã„ãªã„ - jfluteã®æ—¥è¨˜
DBè¨è¨ˆã®ã‚¢ãƒ—ãƒªæœ€é©ãªä½œæ¥ å¼•ç”¨è¨˜äº‹ï¼šã€Œã‚¢ãƒ—ãƒªå¯„ã‚ŠãªDBè¨è¨ˆè€…ã€ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚ŠãªDBè¨è¨ˆè€…ã€ â€»ã“ã¡ã‚‰ã®è¨˜äº‹ã®å†…å®¹ã‚’å‰æã¨ã—ã¾ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆã€ã¨èžãã¨ã€ ã©ã‚“ãªã“ã¨ã‚’æƒ³åƒã—ã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿ å¤§æŠµã®äººã¯ã€ ãƒ‡ãƒ¼ã‚¿åž‹ãªã©ã‚’æ±ºå®šã—è«–ç†ãƒ¢ãƒ‡ãƒ«ã‹ã‚‰ç‰©ç†ãƒ¢ãƒ‡ãƒ«ã‚’ä½œæˆã—ã¦ã€ ãƒ‡ãƒ¼ã‚¿å®¹é‡ã‚„ãã®ä»–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãªã©ã€ ã‚¤ãƒ³ãƒ•ãƒ©çš„ãªèª¿æ•´ã‚’ã™ã‚‹è¨è¨ˆã¨è€ƒãˆã‚‹ã§ã—ã‚‡ã†ã€‚ ã¾ã‚ã€ãã‚Œã§æ£ã—ã„ã‚ã‘ã§ã™ã€‚ã¨ã¦ã‚‚å¤§äº‹ãªä½œæ¥ã§ã™ã€‚ è‡ªåˆ†ã¯ã“ã®ã€Œç‰©ç†è¨è¨ˆã€ã«ã€ ã€Œã‚¢ãƒ—ãƒªã§ã®é–‹ç™ºã®ã—æ˜“ã•ã®ãŸã‚ã®èª¿æ•´ã€ã‚’å…¥ã‚ŒãŸã„ã€ ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ DBè¨è¨ˆã®ã‚¤ãƒ³ãƒ•ãƒ©æœ€é©ãªä½œæ¥ã¯ã‹ãªã‚Šä¸€èˆ¬çš„ãªæ¦‚å¿µã§ å¿˜ã‚Œã‚‰ã‚Œã‚‹ã“ã¨ã¯ãªã„ã§ã™ãŒã€ ã€ŒDBè¨è¨ˆã®ã‚¢ãƒ—ãƒªæœ€é©ãªä½œæ¥ã¨ã„ã†æ¦‚å¿µã€ã¯ã€ ã‚ã¾ã‚Šä¸€èˆ¬çš„ã¨ã¯è¨€ãˆãªã„ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ (ç‰©ç†è¨è¨ˆãŒé•å’Œæ„Ÿã‚ã‚‹ãªã‚‰åˆ¥ã«ä»–ã§ã‚‚ã„ã„ã€‚ ã¨ã«ã‹ããã®æ¦‚å¿µãŒã©ã“ã‹ã«å¿…è¦) ä½•ã‚’è¨€ã£ã¦ã‚‚ã€ã‚‚ã†å¤‰ãˆã‚‰ã‚Œã¾ã›ã‚“ ç¾å ´ã§ã‚ˆã
imai78 2009/12/18
db

design

database

erd

è€ƒãˆæ–¹

engineer
ãƒªãƒ³ã‚¯
Javaè£½ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢Â·Ermodeller MOONGIFT
Ermodellerã¯Javaè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚æœ€è¿‘ã¯ãƒ‡ãƒ¼ã‚¿ãŒä¸»ä½“ã«ãªã£ãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãŒå¤šã„ã€‚ãƒ‡ãƒ¼ã‚¿ã¯å¤§æŠµãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹ã‚‚ã®ã ã€‚ãã†ãªã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ã®å®šç¾©ãŒå›ºã¾ã‚Œã°ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã®ä»•çµ„ã¿ã‚‚å¤§æŠµæ±ºã¾ã£ã¦ãã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é©åˆ‡ã«è¨è¨ˆã™ã‚‹ã“ã¨ãŒã€ã‚·ã‚¹ãƒ†ãƒ ã®çµ„ã¿ã‚„ã™ã•ã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã®ã ã€‚ å„ç¨®DBã«å¯¾å¿œã—ãŸãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãŒã§ãã‚‹ ãã†ãªã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«å¯¾ã™ã‚‹æœŸå¾…ãŒå¤§ãããªã‚‹ã€‚ãã®ç‚¹ã€ãƒžãƒ«ãƒãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹Javaè£½ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¯å„ªä½ã ã‚ã†ã€‚Ermodellerã¯å¤šæ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦ä¾¿åˆ©ã«ä½¿ãˆãã†ã ã€‚ ErmodellerãŒå¯¾å¿œã™ã‚‹ã®ã¯MySQL/PostgreSQL/Oracle/PointBaseã¨ãªã£ã¦ã„ã‚‹ã€‚ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯æ¦‚å¿µã€è«–ç†ã€ç‰©ç†åž‹ã®3ã¤ã«å¯¾å¿œã—ã¦ã„ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã®ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³
imai78 2009/10/22
èµ·å‹•ã¯ant

java

db

postgresql

mysql

oracle

erd

modeling

tool
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ ä¼ç”»ã«å½¹ç«‹ã¤æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ä½œæˆã®åŸºæœ¬
æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®æ§‹æˆè¦ç´ æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¯ã€ã‚·ã‚¹ãƒ†ãƒ åŒ–å¯¾è±¡ç¯„å›²ã«ã‚ã‚‹æ¥å‹™ãƒ—ãƒã‚»ã‚¹ã‚’ãƒ¢ãƒ‡ãƒ«åŒ–ã—ãŸã‚‚ã®ã§ã€ã“ã‚Œã‚’è¦‹ãŸã ã‘ã§ä¼æ¥ã®ãƒ“ã‚¸ãƒã‚¹æ´»å‹•ãŒåˆ†ã‹ã‚‹ã¨ã„ã†å¤§ããªãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚å›³1ã®è²©å£²æ´»å‹•ã«ç„¦ç‚¹ã‚’ã‚ã¦ãŸæ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚’ä¾‹ã«ã€ã“ã®ä¼æ¥ã®è²©å£²æ´»å‹•ã‚’èªã¿è§£ã„ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¯ã€Œãƒã‚¤ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã€ï¼ˆå›³1ç·‘è‰²æž ï¼‰ã€ã€Œè˜åˆ¥åã€ï¼ˆå›³1é’è‰²æž ï¼‰ã€ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ—ã€ï¼ˆå›³1èµ¤è‰²æž ï¼‰ã®3ã¤ã‹ã‚‰æ§‹æˆã•ã‚Œã¾ã™ã€‚ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ãã‚Œã‚’æ•æ‰ã™ã‚‹è˜åˆ¥å ã¾ãšã€æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¯ä¼ç”»æ®µéšŽã§ä½œæˆã™ã‚‹ã‚‚ã®ã§ã‚ã‚‹ãŸã‚ã€ã‚·ã‚¹ãƒ†ãƒ åŒ–å¯¾è±¡ç¯„å›²ã«ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ç¾¤ã‚’ç°¡æ˜“çš„ãªãƒ¬ãƒ™ãƒ«ã§è¡¨ã—ã¾ã™ã€‚ã“ã®ãƒ‡ãƒ¼ã‚¿ç¾¤ãŒã€Œãƒã‚¤ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã€ï¼ˆæœ¬ç¨¿ã§ã¯ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ç•¥è¨˜ã—ã¾ã™ï¼‰ã§ã™ã€‚ ã“ã‚Œã‚‰ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’é¡§å®¢ã‚³ãƒ¼ãƒ‰ã‚„å•†å“ç•ªå·ã®ã‚ˆã†ãªã€Œï½˜ï½˜ã‚³ãƒ¼ãƒ‰ã€ã€ã€Œï½˜ï½˜ç•ªå·ã€ã¨ã„ã†ã€Œè˜åˆ¥åã€ã‹ã‚‰æ•æ‰ã—ã¾ã™ã€‚ ã‚¤ãƒ™ãƒ³ãƒˆç³»ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã€ãƒªã‚½
imai78 2009/06/15
db

erd

modeling

database

analyze
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (11)

erdã¨dbã«é–¢ã™ã‚‹imai78ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (11)

erdã¨dbã«é–¢ã™ã‚‹imai78ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã€Œã‚‚ã†DBã¯ã“ã†ãªã£ã¦ã¾ã™ã®ã§ã€ã¯ã‚‚ã£ãŸã„ãªã„ - jfluteã®æ—¥è¨˜

Javaè£½ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢Â·Ermodeller MOONGIFT

ã‚·ã‚¹ãƒ†ãƒ ä¼ç”»ã«å½¹ç«‹ã¤æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ä½œæˆã®åŸºæœ¬

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (11)

erdã¨dbã«é–¢ã™ã‚‹imai78ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ã€Œã‚‚ã†DBã¯ã“ã†ãªã£ã¦ã¾ã™ã®ã§ã€ã¯ã‚‚ã£ãŸã„ãªã„ - jfluteã®æ—¥è¨˜

Javaè£½ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢Â·Ermodeller MOONGIFT

ã‚·ã‚¹ãƒ†ãƒ ä¼ç”»ã«å½¹ç«‹ã¤æ¦‚å¿µãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ä½œæˆã®åŸºæœ¬

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆç¬¬5é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹