cosmoSys Help » Formats examples

csInfo #4045

Updated by Redmine Admin 7 days ago

{{kroki(dbml)  
 Table users { 
   id integer 
   username varchar 
   role varchar 
   created_at timestamp 
 } 

 Table posts { 
   id integer [primary key] 
   title varchar 
   body text [note: 'Content of the post'] 
   user_id integer 
   status post_status 
   created_at timestamp 
 } 

 Enum post_status { 
   draft 
   published 
   private [note: 'visible via URL only'] 
 } 

 Ref: posts.user_id > users.id // many-to-one 
 }} 

 The diagram above is shown by just simply put sample diagram code copied from [kroki.io](https://kroki.io) inside a macro. 
 The macro language is described in [redmine-kroki](https://github.com/JeffDess/redmine-kroki) plugin page. 

 This is the exact code: 
 ``` 
 {{kroki(dbml) 
 Table users { 
   id integer 
   username varchar 
   role varchar 
   created_at timestamp 
 } 
 


 Table posts { 
   id integer [primary key] 
   title varchar 
   body text [note: 'Content of the post'] 
   user_id integer 
   status post_status 
   created_at timestamp 
 } 

 Enum post_status { 
   draft 
   published 
   private [note: 'visible via URL only'] 
 } 

 Ref: posts.user_id > users.id // many-to-one 
 }} 

 ``` 

Back