[B! ERå›³] cyokodogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

cyokodog id:cyokodog

ERå›³ã«é–¢ã™ã‚‹cyokodogã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

MySQL/SQLiteã®ERå›³ã‚’æãPHPã‚¹ã‚¯ãƒªãƒ—ãƒˆÂ·mysqlviz MOONGIFT
mysqlvizã¯MySQL/SQLiteã®æ§‹é€ ã‚’å¯è¦–åŒ–ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ DBã‚’ä½¿ã£ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã¦ã„ã‚‹ã¨å¿…è¦ã«ãªã‚‹ã®ãŒERå›³ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã‚“ãªERå›³ã‚’å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ™ãƒ¼ã‚¹ã«æãå‡ºã™ã®ãŒmysqlvizã§ã™ã€‚ ãƒ˜ãƒ«ãƒ—ã§ã™ã€‚ ã¾ãšdotãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ã¾ã™ã€‚ ã•ã‚‰ã«dotãƒ•ã‚¡ã‚¤ãƒ«ã‚’pngã«å¤‰æ›ã—ã¦å¾—ã‚‰ã‚ŒãŸçµæžœã§ã™ã€‚ mysqlvizã¯MySQLã¨SQLiteã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚MySQLã®å ´åˆã¯ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã€SQLiteã®å ´åˆã¯å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚“ã§dotãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã—ã¾ã™ã€‚å¾Œã¯Graphvizã‚’ä½¿ã£ã¦PNGç”»åƒã«å¤‰æ›ã™ã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ mysqlvizã¯PHPè£½ã€GPL v3ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ MOONGIFTã¯ã“ã†è¦‹ã‚‹ mysqlvizã®é¢ç™½ã„ã¨ã“ã‚ã¯MySQLã«ã¤ã„ã¦ã¯ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨
cyokodog 2013/05/06
oss

php

ERå›³
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
cyokodog 2010/01/22
*etc

IDE

eclipse

ERå›³

_favorite
ãƒªãƒ³ã‚¯
ã€ã‚³ãƒ©ãƒ ã€‘ã‚¤ãƒžãƒ‰ã‚ã®IDEäº‹æƒ… (73) é«˜æ©Ÿèƒ½ERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒER Masterã€ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ER Masterã¨ã¯? ER Masterã¯ERå›³ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã ã€‚ERå›³ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã«ã¯Clay Mark IIã‚„AmaterasERDãªã©ãŒã‚ã‚‹ãŒã€ä¸ã§ã‚‚ER Masterã¯é«˜æ©Ÿèƒ½ã§ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€ã‚¤ãƒã‚ªã‚·ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã ã€‚ ER Masterã¯æ›´æ–°ã‚µã‚¤ãƒˆã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ER Masterã‚’ä½¿ã£ã¦ã¿ã‚ˆã† ER Masterã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€æ–°è¦ä½œæˆã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã®[ERMaster]ã‚«ãƒ†ã‚´ãƒªã‹ã‚‰ERå›³ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ERå›³ã®ä½œæˆæ™‚ã«ã¯å¯¾å¿œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä»¥ä¸‹ã®ä¸ã‹ã‚‰é¸æŠžã™ã‚‹ã€‚ä¸»è¦ãªDBã«ã¤ã„ã¦ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ãŒã€ä¸€éƒ¨ã®DBã®ã‚µãƒãƒ¼ãƒˆã«ã¤ã„ã¦ã¯é–‹ç™ºé€”ä¸Šã¨ãªã£ã¦ã„ã‚‹ã®ã§æ³¨æ„ã—ã¦ã»ã—ã„(ç†è€…ã®è©¦ã—ãŸã¨ã“ã‚ã§ã¯ã€ä¸€éƒ¨ã®DBã‚’æŒ‡å®šã—ãŸå ´åˆã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã¨ã„ã£
cyokodog 2010/01/12
*soft

eclipse

ERå›³
ãƒªãƒ³ã‚¯
[ãƒã‚·ãƒ£ãƒã‚°ã‚¹ã‚¿ãƒƒãƒ•ã®é“å…·ç®±] ERå›³ä½œæˆæ”¯æ´ã€ŒA5:SQL Mk-2ã€ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
äºˆé˜²ã—ã¦ã¾ã™ã‹ï¼ ç¾åœ¨ã‚·ãƒ¼ãƒ–ãƒ¬ã‚¤ãƒ³ç¤¾å†…ã§ã¯ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ãŒæµè¡Œã‚Šã ã—ã¦ã„ã¦ã€ãƒ“ã‚¯ãƒ“ã‚¯ã—ã¦ã„ã‚‹ kimoto ã§ã™ã€‚ ã•ã¦ã€ãƒã‚·ãƒ£ãƒã‚°ã‚¹ã‚¿ãƒƒãƒ•ã®é“å…·ç®±ç¬¬3å›žã€‚ ä»Šå›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã™ã‚‹éš›ã«é‡å®ã—ã¦ã„ã‚‹ã€ã€ŒA5:SQL Mk-2ã€ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ åæ„›ãƒ„ãƒ¼ãƒ«ã€ŒA5:SQL Mk-2ã€ ã“ã®ãƒ„ãƒ¼ãƒ«ã¯ã€DB è¨è¨ˆã‚’å…¨èˆ¬çš„ã«æ”¯æ´ã—ã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ç§ã¯ä¸»ã« ER å›³ã‚’ä½œæˆã™ã‚‹éš›ã«ãŠä¸–è©±ã«ãªã£ã¦ã¾ã™ã€‚ 1.ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®è¿½åŠ ã¾ãšã¯æ–°è¦ã® ER å›³ã‚’ä½œæˆã™ã‚‹ã¨ã€ãªã«ã‚‚ãªã„ã‚ãƒ£ãƒ³ãƒã‚¹ãŒã§ãã‚‹ã®ã§ã€ãã“ã§æ–°è¦ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’ä½œæˆã—é…ç½®ã—ã¦ã„ãã¾ã™ã€‚ 2.ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®è¨å®šï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«åï¼‰ é…ç½®ã—ãŸã‚‰ã€ãã®ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’ãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã€‚ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ãŒé–‹ãã¾ã™ã€‚ ãã“ã«ã€ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã‚’å…¥åŠ›ã—ã¦ã„ãã¾ã™ã€‚ åˆ¥ç”»é¢ã§ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’ä½œã£ã¦ãŠã‘ã°ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã•ã‚ŒãŸåž‹ã‚‚ç°¡å˜ã«è¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™
cyokodog 2009/01/29
*soft

ERå›³
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
cyokodog 2009/01/26
*service-generator

ERå›³
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆã«å„ªã‚ŒãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€ŒA5:SQL Mk-2ã€
ã€ŒA5:SQL Mk-2ã€ã¯ã€SQLæ–‡ã®å…¥åŠ›æ”¯æ´ã‚„ERå›³ä½œæˆãªã©ã®æ©Ÿèƒ½ã‚’å‚™ãˆãŸé«˜æ©Ÿèƒ½ãªSQLé–‹ç™ºç’°å¢ƒã€‚Windows 98/2000/XP/Server 2003/Vista/Server 2008/Vista x64ã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ æœ¬ã‚½ãƒ•ãƒˆã¯ã€SQLæ–‡ã®ä½œæˆãƒ»å®Ÿè¡Œã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚ADOã‚„ODBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã‚’åˆ©ç”¨ã—ã¦å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ã§ã€æœ¬ã‚½ãƒ•ãƒˆã§ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ã¾ãŸã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€å®Ÿè¡Œçµæžœã‚’ã€ŒExcelã€ã¸å‡ºåŠ›ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ ç”»é¢ã¯ã‚µã‚¤ãƒ‰ãƒãƒ¼ã¨ç·¨é›†ç”»é¢ã®2ã¤ã«åˆ†å‰²ã•ã‚Œã¦ãŠã‚Šã€ã‚µã‚¤ãƒ‰ãƒãƒ¼ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŠã‚ˆã³é–¢é€£ã™ã‚‹ã‚¹ã‚ãƒ¼ãƒžãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ»ãƒ“ãƒ¥ãƒ¼ã¨ã„ã£ãŸé …ç›®ãŒãƒ„ãƒªãƒ¼å½¢å¼ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ç·¨é›†ç”»é¢ã¯ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆå¼ã«ãªã£ã¦ãŠã‚Šã€SQLæ–‡ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã©ã‚’è¤‡æ•°é–‹ã„ã¦
cyokodog 2008/12/03
*soft

ERå›³
ãƒªãƒ³ã‚¯
1