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

snjx id:snjx

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

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

SchemaSpyã§ERå›³ã‚’ãƒ‘ãƒ‘ãƒƒã¨è‡ªå‹•ç”Ÿæˆã™ã‚‹ - Qiita
ERå›³(Entity Relationship Diagram)ã¯DBãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é–¢é€£æ€§ã¨å±žæ€§ã‚’ä½¿ã£ã¦è¡¨ã™å›³ã®ã“ã¨ã§ã™ã€‚ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚¸ãƒ§ã‚¤ãƒ³ã™ã‚‹æ™‚ã¨ã‹ã€ERå›³ã‚’æ›¸ããªãŒã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã‚’æŠŠæ¡ã™ã‚‹ã¨æ—ã‚Šã¾ã™ã‚ˆã! ã¨ã¯ã„ãˆã€ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ãŒæ•°ç™¾ã‚’è¶…ãˆã‚‹ã¨æ‰‹æ›¸ãã¯æ™‚é–“ãŒã‹ã‹ã‚‹ã—ã€æ©Ÿèƒ½çš„ã«é‡è¦ã§ãªã„ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ã‚‚ã‚ã‚ŠåŠ¹çŽ‡ãŒæ‚ªããªã£ã¦ãã¾ã™ã€‚ (ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã‚‚ã„ã„ã§ã™ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¿½åŠ ãŒã‚ã£ãŸæ™‚ã«ã‚ã–ã‚ã–ãƒ¡ãƒ³ãƒ†ã™ã‚‹ã®å¿˜ã‚ŒãŒã¡ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã—ã) ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚‰ã—ãåŠ¹çŽ‡çš„ã«ä½œã‚Œãªã„ã‹ãªðŸ¤”ã¨æ€ã£ã¦ã„ãŸã‚‰ã€ERå›³ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹SchemaSpyã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒã‚ã£ãŸã®ã§ã€ä½¿ã„æ–¹ã¨å…±ã«ç´¹ä»‹ã—ã¾ã™ã€‚ SchemaSpyã«ã¤ã„ã¦ â†“ERå›³ã‚µãƒ³ãƒ—ãƒ« https://schemaspy.org/sample/index.html ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ERå›³è‡ªå‹•ç”Ÿæˆãƒ„ãƒ¼ãƒ«ã§ã€ dockerãƒ™ãƒ¼ã‚¹ã¨jarãƒ™ãƒ¼ã‚¹(Java
snjx 2024/03/01
ãƒ„ãƒ¼ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ERå›³

database

æŠ€è¡“

è€ƒå¯Ÿ
ãƒªãƒ³ã‚¯
SchemaSpyã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç”Ÿæˆã—ã¦ã¿ãŸ | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å‚äº•ã§ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã¯ï¼‘åº¦ä½œæˆã—ã¦çµ‚ã‚ã‚Šã§ã¯ãªãã€æ—¥ã€…æ©Ÿèƒ½æ”¹å–„ã€ä»•æ§˜å¤‰æ›´ã‚’ç¹°ã‚Šè¿”ã—ã¦å¤‰åŒ–ã—ã¦ã„ãã¾ã™ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹æ™‚é–“ãŒãªã‹ã£ãŸã€å¿˜ã‚Œã¦ã„ãŸãƒ»ãƒ»ãƒ»ãªã©è‰²ã€…ã¨ç†ç”±ã¯ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€å®Ÿè£…ã¨ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®æ•´åˆæ€§ã‚’ä¿ã¤ã®ã¯å¤§å¤‰ãªã“ã¨ã ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã“ã†ã„ã£ãŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒå°‘ã—ã§ã‚‚æ¥½ã«ãªã‚Šãã†ãªSchemaSpyã‚’åˆ©ç”¨ã—ã¦ã€æ—¢å˜ã®å®Ÿè£…ã‹ã‚‰ã©ã‚Œãã‚‰ã„ã®ãƒ¬ãƒ™ãƒ«ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒç”Ÿæˆã§ãã‚‹ã‹ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ SchemaSpyã¨ã¯ï¼Ÿ æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’HTMLã§å‡ºåŠ›ã™ã‚‹Javaè£½ã®ãƒ„ãƒ¼ãƒ«ã¨ãªã‚Šã¾ã™ã€‚ SchemaSpy ã¾ãŸã€å¼Šç¤¾ãƒ–ãƒã‚°ã§ã‚‚ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ Apache Airflowã®ERå›³ã‚’SchemaSpyã§è‡ªå‹•ç”Ÿæˆã™ã‚‹ã‚ˆã†ã«ã—ã¦ã¿ãŸ ï½œ DevelopersIO ç’°å¢ƒ macOS Mojave 10
snjx 2024/03/01
ã‚ã¨ã§èªã‚€

ãƒ„ãƒ¼ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ERå›³

database

æŠ€è¡“

è€ƒå¯Ÿ
ãƒªãƒ³ã‚¯
plant_erdã‚’MacOSã§ä½¿ã†ã¨ã
snjx 2020/01/14
ã‚ã‚ŠãŒãŸã„ã¨ã¦ã‚‚ã‚ã‚ŠãŒãŸã„

plantuml

uml

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ERå›³

æŠ€è¡“

è¨è¨ˆ

plant_erd

mac
ãƒªãƒ³ã‚¯
plant_erd - ERå›³ã‚’PlantUMLç”¨ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ
UMLã‚’ãƒ†ã‚ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã§è¨˜è¿°ã§ãã‚‹PlantUMLã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ã‚¯ãƒ©ã‚¹å›³ã‚’æµç”¨ã™ã‚‹å½¢ã§ERå›³ã‚‚æãã“ã¨ãŒã§ãã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã™ã§ã«ã‚ã‚Šã€ãã“ã‹ã‚‰PlantUMLç”¨ã«å‡ºåŠ›ã§ãã‚Œã°ã„ã„ã®ã«ã€ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ã‚‚ã¾ãŸå¤šã„ã§ã—ã‚‡ã†ã€‚ ãã‚“ãªæ–¹ã«ãŠå‹§ã‚ãªã®ãŒplant_erdã§ã™ã€‚å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸERå›³ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ plant_erdã®ä½¿ã„æ–¹ å‡ºåŠ›ã—ãŸå†…å®¹ã‚’PlantUMLã§è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ plant_erdã¯SQLite3ã€MySQLãã—ã¦PostgreSQLã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’ãã®ã¾ã¾PlantUMLå‘ã‘ã«å‡ºåŠ›ãŒå¯èƒ½ã§ã™ã€‚ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã‚’å‡ºåŠ›å¯¾è±¡ã«ã‚‚ã§ãã¾ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚å†ç¾ã•ã‚Œã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹é€ ã‚’ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ›¸ãå‡ºã™ã®ã«ã´ã£ãŸã‚Šã§ã™ã€‚ plant_erdã¯Goè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆMIT
snjx 2020/01/14
ã™ã°ã‚‰ã—ã„ã¨ã¦ã‚‚ã™ã°ã‚‰ã—ã„

plantuml

uml

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ERå›³

æŠ€è¡“

è¨è¨ˆ

plant_erd
ãƒªãƒ³ã‚¯
GitHub - sue445/plant_erd: ERD exporter with PlantUML and mermaid format
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
snjx 2020/01/14
plantuml

db

ERå›³

æŠ€è¡“

è€ƒå¯Ÿ

è¨è¨ˆ

sql
ãƒªãƒ³ã‚¯
PlantUMLã§ERå›³ã‚’æãï¼
å‰å›žã¯ã€GitHubã§ERå›³ã‚’ç®¡ç†ã™ã‚‹æ–¹æ³•ã‚’è¨˜äº‹ã«ã—ã¾ã—ãŸãŒã€ä»Šå›žã¯PlantUMLã§ERå›³ã‚’æãæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ï¼ˆå‰å›žã®è¨˜äº‹ã¯ã“ã¡ã‚‰ï¼‰ ãªãœã‹ã¯çŸ¥ã‚‰ãªã„ã®ã§ã™ãŒã€ã‚·ãƒ¼ã‚±ãƒ³ã‚¹å›³ã‚„ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹å›³ã€ã‚¯ãƒ©ã‚¹å›³ãªã©ã¨ã¯é•ã„ã€ERå›³ã«ã¤ã„ã¦ã¯PlantUMLã®æãæ–¹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå°‘ãªã„ã§ã™ã€‚ï¼ˆãã‚‚ãã‚‚å…¬å¼ã®ãƒšãƒ¼ã‚¸ã«è¨˜è¼‰ãŒãªã„ï¼‰ ã¨ã„ã†ã“ã¨ã§ã€éžå…¬å¼ã§ã™ãŒã€æã„ã¦ã„ã‚‹ä¸ã§è¦‹ã¤ã‘ãŸæãæ–¹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¯é€šå¸¸ã€ã“ã‚“ãªæ„Ÿã˜ã«æãã¾ã™ã€‚ã‚ã¾ã‚Šãªã„ã¨æ€ã„ã¾ã™ãŒã€ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã§å›²ã†ã“ã¨ã§ã€éžæ–‡å—ï¼ˆã‚¹ãƒšãƒ¼ã‚¹ç‰ï¼‰ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚éžæ–‡å—ã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã¯ã€asã‚’ä½¿ã£ã¦åˆ¥åã‚’å®šç¾©ã—ã¦ã‚ã’ã¾ã—ã‚‡ã†ã€‚ entity entity1 { primary_key -- attribute } entity "entity 2" as entity2 { }ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®E
snjx 2019/02/05
iml

plantuml

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

db

ERå›³
ãƒªãƒ³ã‚¯
PlantUML ã§ ER å›³ï¼ˆERDï¼‰ã‚’æãï¼ˆä¼¼éžã§ã¯ãªã„ã§ã™ï¼‰ - Qiita
------ :1 ----|| :1 and only 1 ----o| :0 or 1 -----{ :many ----|{ :1 or more ----o{ :0 or many æç”»çµæžœ ã“ã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯ä¸è¦ãªæ°´å¹³ç·šãŒå…¥ã£ã¦ã„ã¾ã™ã€‚ã“ã®æ°´å¹³ç·šã¯ã‚¯ãƒ©ã‚¹å›³ã®ã€Œãƒ—ãƒãƒ‘ãƒ†ã‚£ï¼ˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ï¼‰ã€ã¨ã€Œãƒ¡ã‚½ãƒƒãƒ‰ã€ã‚’åˆ†ã‘ã‚‹ã€ŒåŒºåˆ‡ã‚Šç·šã€ã§ã™ãŒã€hide empty members ã‚’æœ€åˆã«æ›¸ã„ã¦ãŠãã¨éžè¡¨ç¤ºã«å‡ºæ¥ã¾ã™ã€‚ å‚è€ƒï¼šhttp://plantuml.com/class-diagram#Hide ER å›³ã¨ã¯ ERå›³ãã®ã‚‚ã®ã«ã¤ã„ã¦ã¯ä¸‹è¨˜ã®ã‚µã‚¤ãƒˆãŒè©³ã—ã„ã§ã™ã€‚ ERå›³ ï¼ˆEntity Relationship Diagramï¼‰ ã¾ãŸã€æ›¸ãæ–¹ã«ã¤ã„ã¦ã¯ä¸‹è¨˜ã®æ›¸ç±ãŒè©³ã—ã„ã§ã™ã€‚ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ æ¥½ã€…ERDãƒ¬ãƒƒã‚¹ãƒ³ ã‚µãƒ³ãƒ—ãƒ« å‰å›ž åŒæ§˜ã€ä¸‹è¨˜ã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã‚’å‚è€ƒã«ã—ã¦ã€PlantUML ã§
snjx 2017/11/20
UML

ER

DB

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

plantuml

ERå›³

SQL
ãƒªãƒ³ã‚¯
Mastodonã®ERå›³ã‚’ç”Ÿæˆã—ã¦ã¿ãŸ Â· hnakamur's blog
2017-04-24 ã¯ã˜ã‚ã« voormedia/rails-erd: Generate Entity-Relationship Diagrams for Rails applications ã‚’ä½¿ã£ã¦ tootsuite/mastodon: A GNU Social-compatible microblogging server ã®ERå›³ã‚’ç”Ÿæˆã—ã¦ã¿ã¾ã—ãŸã€ã¨ã„ã†ã ã‘ã®è¨˜äº‹ã§ã™ã€‚ Relax Ruby version requirement (#1901) Â· tootsuite/mastodon@0611209 ã®ã‚³ãƒŸãƒƒãƒˆã«å¯¾ã—ã¦ ç”Ÿæˆã—ãŸPDFãŒ mastodon-er-diagram.pdf ã§ã™ã€‚ ãŸã¶ã‚“ä»Šå¾Œæ›´æ–°ã—ãªã„ã®ã§æ–°ã—ã„ERå›³ãŒæ¬²ã—ã„æ–¹ã¯è‡ªåˆ†ã§ç”Ÿæˆã—ã¦ãã ã•ã„ã€‚ ç”Ÿæˆæ‰‹é † ç”Ÿæˆæ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ã§ã€mastodonã®ã‚½ãƒ¼ã‚¹ã‚’ git clone ã—ãŸã ã‘ã§
snjx 2017/04/24
mastodon

ERå›³

erd

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

Rails

webã‚µãƒ¼ãƒ“ã‚¹

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

è³‡æ–™

æŠ€è¡“
ãƒªãƒ³ã‚¯
ãƒ†ã‚ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã§ERå›³ã‚’æ›¸ã - Qiita
æœ€è¿‘ã‚·ãƒ¼ã‚±ãƒ³ã‚¹å›³ã‚’æ›¸ãã®ã«PlantUMLã‚’ä½¿ã£ã¦ã„ã¾ã™ãŒã€ãƒ†ã‚ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã§æ›¸ã‘ã‚‹ã“ã¨ã«ã‚ˆã‚Šç„¡é§„ãªãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆèª¿æ•´ã®ä½œæ¥ã‹ã‚‰é–‹æ”¾ã•ã‚Œã¦ã¨ã¦ã‚‚å¿«é©ã§ã™ã€‚ ERå›³ã‚‚åŒæ§˜ã«æ›¸ããŸã„ã¨æŽ¢ã—ã¦ã„ãŸã‚‰Githubã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«(BurntSushi/erd)ãŒã‚ã‚Šã¾ã—ãŸã®ã§ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æœ€çµ‚çš„ã«ã€ã“ã®ã‚ˆã†ãªãƒ†ã‚ã‚¹ãƒˆã‚’æ›¸ãã¨ã€ title {label: "nfldb Entity-Relationship diagram (condensed)", size: "20"} # Nice colors from Erwiz: # red #fcecec # blue #ececfc # green #d0e0d0 # yellow #fbfbdb # orange #eee0a0 # Entities [player] {bgcolor: "#d0e0d0"} *player_id {label
snjx 2016/12/16
ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

æŠ€è¡“

è³‡æ–™

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ERå›³

uml

PlantUML

è¨è¨ˆ

erd
ãƒªãƒ³ã‚¯
Railsã‚¢ãƒ—ãƒªã§ERå›³ã¨ã‹ã‚¯ãƒ©ã‚¹å›³ã‚’ä½œã‚‹ - Qiita
ã‚ã‚“ã¾ã‚Šæ—¥å¸¸çš„ã«é–‹ç™ºã§ä½¿ã†ã“ã¨ãªã•ãã†ã ã‘ã©ã€èª°ã‹ã«ã‚¢ãƒ—ãƒªã®æ¦‚è¦ã‚’èª¬æ˜Žã—ãŸã‚Šã€Qiitaã¨ã‹ã§ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªã®ERå›³ã‚’è¦‹ã›ãŸã„æ™‚ã¨ã‹ã«ä½¿ãˆã‚‹GemãŸã¡ã€‚ preston/railroady voormedia/rails-erd ã“ã®2ã¤ã€‚railroadyã®æ–¹ã¯ãƒ¢ãƒ‡ãƒ«ã®ERå›³ã ã‘ã˜ã‚ƒãªãã¦ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ãƒ¼ãªã©ã®ã‚¯ãƒ©ã‚¹å›³ãªã©ã‚‚ä½œæˆã§ãã‚‹ã€‚ å‰æ Rails v4.x Graphviz v2.22 Graphvizã¨ã„ã†ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå¿…è¦ã«ãªã‚‹ã€‚Graphvizã¨ã¯DOTè¨€èªžã¨ã„ã†ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ã‚°ãƒ©ãƒ•ã«æç”»ã—ã¦ãã‚Œã‚‹è‰¯ã„æ„Ÿã˜ã®ã‚„ã¤ã‚‰ã—ã„ã€‚ã©ã†ã§ã‚‚ã„ã„ã‘ã©ã€DOTè¨€èªžã£ã¦ã‚«ãƒƒã‚³ã„ã„ãªâ€¦ã€‚ Graphvizã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yumç³»
snjx 2016/12/06
ã‚ã‚ŠãŒãŸã„

rails

gem

ERå›³

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

webã‚µãƒ¼ãƒ“ã‚¹

æŠ€è¡“

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

graphviz
ãƒªãƒ³ã‚¯
Railsã§ERå›³ã‚’ç”Ÿæˆã™ã‚‹Gemï¼ˆrails-erdï¼‰ - Qiita
Railsã§ã®ERå›³ã®è‡ªå‹•ç”Ÿæˆã«ã¤ã„ã¦ã€‚ rails-erdã¨ã„ã†Gemã‚’CentOS6ã«å…¥ã‚Œã‚‹æ–¹æ³•ã§ã™ã€‚ ã€Œgraphvizã€ã¨ã„ã†RPMã‚’è¿½åŠ ã—ã¦ã€Gemã§ã€Œrails-erdã€ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æµã‚Œã¨ãªã‚Šã¾ã™ã€‚ # yum -y install graphviz $ vi Gemfile ä»¥ä¸‹ã®è¡Œã‚’è¿½åŠ --------------------------- gem 'rails-erd', group: [:development, :test] --------------------------- $ bundle install
snjx 2016/12/06
ãŠãŠã€ã™ã°ã‚‰ã—ã„ã€‚

rails

gem

ERå›³

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

webã‚µãƒ¼ãƒ“ã‚¹

æŠ€è¡“

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

graphviz
ãƒªãƒ³ã‚¯
ERå›³ãƒ¬ãƒ“ãƒ¥ãƒ¼ã®ï¼“ã¤ã®ãƒã‚¤ãƒ³ãƒˆ - è¨è¨ˆè€…ã®ç™ºè¨€
å‰å›žè¨˜äº‹ã§ã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ä¸Šæµå·¥ç¨‹ã§DBè¨è¨ˆãŒãªã„ãŒã—ã‚ã«ã•ã‚Œã‚‹ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨æŒ‡æ‘˜ã—ãŸãŒã€ã‚ˆã»ã©ä½Žãƒ¬ãƒ™ãƒ«ãªè·å ´ã§ãªã„é™ã‚Šã€ä»Šã§ã¯ä¸Šæµå·¥ç¨‹ã§ã®ERå›³ã®ä½œæˆãŒæ¨™æº–åŒ–ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ ã¨ã“ã‚ãŒã€ãã®ERå›³ãŒã¾ã‚‹ã§ã‚·ãƒ§ãƒœã„ã«ã‚‚é–¢ã‚ã‚‰ãšãƒ¬ãƒ“ãƒ¥ãƒ¼ã§æ‰¿èªã•ã‚Œã‚‹ã‚±ãƒ¼ã‚¹ãŒã‚ã¨ã‚’çµ¶ãŸãªã„ã€‚ç†ç”±ã¯å˜ç´”ã§ã€ERå›³ãŒã‚ã‚‹ã‹ã©ã†ã‹ã ã‘ãŒãƒã‚§ãƒƒã‚¯ã•ã‚Œã¦ã€å†…å®¹ãƒ¬ãƒ™ãƒ«ã®æ¤œè¨¼ãŒãªã•ã‚Œã¦ã„ãªã„ãŸã‚ã ã€‚ãã‚Œã¯ã¨ã‚Šã‚‚ãªãŠã•ãšã€DBè¨è¨ˆã‚’çš„ç¢ºã«ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ãã‚‹æŠ€è¡“è€…ãŒã„ãªã„ãŸã‚ã§ã‚‚ã‚ã‚‹ã€‚ ERå›³ã‚’è¦‹ã‚Œã°ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒæˆåŠŸã™ã‚‹ã‹ã©ã†ã‹ã¾ã§ã¯ã‚ã‹ã‚‰ãªã„ã‹ã‚‚ã—ã‚Œãªã„ãŒã€ã€Œãƒ‡ã‚¹ãƒžãƒ¼ãƒåŒ–ã™ã‚‹ã‹ã©ã†ã‹ã€ã¯ã‚ã‹ã‚‹ã€‚ãã‚Œã»ã©ä¾¿åˆ©ãªå›³é¢ãŒæå‡ºã•ã‚ŒãªãŒã‚‰ãƒ¬ãƒ“ãƒ¥ãƒ¯ãƒ¼ã®ã‚¹ã‚ãƒ«ãŒè¶³ã‚Šãªã„ã®ã§ã¯ã€è¨è¨ˆæ¨™æº–ã®æŒã¡è…ã‚Œã¨ã„ã†ã‚‚ã®ã ã€‚ ãã“ã§ã€ERå›³ã‚’åŠ¹æžœçš„ã«ãƒ¬ãƒ“ãƒ¥ãƒ¼ã™ã‚‹ãŸã‚ã®ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ãŸã„ã€‚æ§‹æˆçš„ãªå¿ƒåœ°ã‚ˆã•ãŒã‚ã‚‹ã‹ã€ã‚ãƒ¼æ§‹æˆãŒå˜ç´”ã™ãŽãªã„ã‹ã€å‰µæ„
snjx 2016/07/19
ERå›³

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

è³‡æ–™

è€ƒå¯Ÿ

æŠ€è¡“

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Oracle DBã‚’ERMasterã§ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã—ã¦ã¿ã‚‹ - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
ã¯ã˜ã‚ã« ä»Šå¹´ã‹ã‚‰ã€ã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’å¼•ãç¶™ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã‚·ã‚¹ãƒ†ãƒ ã§ã€å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®é …ç›®å®šç¾©æ›¸ã®ã‚ˆã†ãªè³‡æ–™ãŒã‚ã‚‹ã“ã¨ã¯åˆ†ã‹ã£ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹è³‡æ–™ã‚’ã¿ãŸã“ã¨ãŒãªã„ã®ã§ã€æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã§ã€ERå›³ã‚’ãŠã“ã™ã“ã¨ãŒã§ããªã„ã‹ã¨è€ƒãˆã¾ã—ãŸã€‚ ã‚°ãƒ©ã‚¹ç‰‡æ‰‹ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ~è²©å£²ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ç·¨ (DBMagazine SELECTION)posted with amazlet at 13.01.06æ¢…ç”° å¼˜ä¹‹ ç¿”æ³³ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 34,882 Amazon.co.jp ã§è©³ç´°ã‚’è¦‹ã‚‹ DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ERMasterã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ã€æ—¢å˜ã®Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ERå›³ã‚’ç”Ÿæˆã§ãã‚‹ã“ã¨ãŒåˆ†ã‹ã‚Šã¾ã—ãŸã€‚ DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãª
snjx 2016/02/01
JDBC

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

eclipse

ERå›³

ermaster

DB

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

æŠ€è¡“

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
snjx 2016/01/29
Eclipse

plugin

ER

Database

ERå›³

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

ãƒ„ãƒ¼ãƒ«

ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

è³‡æ–™

æŠ€è¡“
ãƒªãƒ³ã‚¯
#18 plantuml ã‚’ä½¿ã£ã¦ã¿ãŸ - KAYAC engineers' blog
ã“ã®è¨˜äº‹ã¯ tech.kayac.com Advent Calendar 2014 18æ—¥ç›®ã§ã™ã€‚ ã©ã†ã‚‚ã€‚system perl version 5.8 ã§ class ã¨ã‹ã»ã¼ä½¿ã‚ãªã„ ORM ã‚‚ç„¡ã„ ç”ŸDBI ã§ ã§ã‚‚ãªãœã‹ Xslate ã¯ä½¿ã£ã¦ã¦ Apache 2.0 ã¨ MySQL5.1 ã¨ memcached ã§ãªãœã‹ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°(DBã®æ°´å¹³åˆ†å‰²)ã•ã‚ŒãŸã€ç”Ÿã¾ã‚Œã¦ã‹ã‚‰æ»ã¬ã¾ã§(ç´„3å¹´è¿‘ã)ã‚’è¦‹å±Šã‘ãŸãƒ¢ãƒã‚¤ãƒ«ãªæ¡ˆä»¶ã‹ã‚‰ä¸€è»¢ã—ã¦ã€plenv ã§ãƒ“ãƒ«ãƒ‰ã™ã‚‹ perl ã® version 5.20 ã‚’ä½¿ã£ã¦ Carton ã§ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’å›ºå®šã— Mouse ã‚’ä½¿ã£ã¦ class ã‚’ä½œã‚Šã¾ãã‚Š DBIx::Class ã§ ORM ã‚’ä½¿ã„ã¾ãã‚Š nginx ã¨ MySQL5.6 ã¨ Redis ã§ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ãªã„ fluentd ã§ãƒã‚°ã‚’æŠ•ã’ã¾ãã‚‹ã‚¹ãƒžãƒ¼ãƒˆãªãƒ‡ãƒã‚¤ã‚¹ã®æ–°è¦æ¡ˆä»¶ã«
snjx 2015/09/07
ã‚¢ã‚¤ãƒ‡ã‚¢ã®ã²ã¨ã¤

PlantUML

ERå›³

UML

æŠ€è¡“

db
ãƒªãƒ³ã‚¯
ER Master ã‚’åˆ©ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆæœŸåŒ–ã‚’è‡ªå‹•åŒ–ã™ã‚‹ - Qiita
ER Master ã¯è¶…ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã ãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼šDBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ (1/3) - ï¼ IT ER Master ã¯è¶…ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã ã€‚ ã‚ã‹ã‚Šã‚„ã™ãè¶…ä¾¿åˆ©ã ã€‚ Eclipse ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç‰¹ã« Java é–‹ç™ºè€…ã§ã‚ã‚Œã°ä¸€åº¦ã¯ä½¿ã£ã¦ã¿ãŸã»ã†ãŒã„ã„ã€‚ç¥žãƒ„ãƒ¼ãƒ«ã¨å‘¼ã°ã‚Œã‚‹ã®ã«ã‚‚ç´å¾—ã™ã‚‹ã¨æ€ã†ã€‚ ER Master ã‚’åˆ©ç”¨ã—ãŸã‚¹ã‚ãƒ¼ãƒžã®å†æ§‹æˆ ãã‚“ãª ER Master ã¯ DDLã€DML ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹ã®ã ãŒã€ã“ã‚Œã¯ Ant ã‹ã‚‰å®Ÿè¡Œã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ ã“ã‚Œã‚’åˆ©ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çŠ¶æ…‹ã‚’åˆæœŸåŒ–ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ä»¥ä¸‹ã®ä¾‹ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã« H2 Database ã‚’ä½¿ç”¨ã€‚ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE project> <
snjx 2015/07/09
DB

Eclipse

plugin

ERå›³

DBMS
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
snjx 2015/07/09
DB

Eclipse

plugin

ERå›³

DBMS
ãƒªãƒ³ã‚¯
1