QuantumGhost · June 18, 2025 14:09 · Oct 10, 2019 · Apr 5, 2016 · Apr 5, 2016 · Apr 5, 2016
diff --git a/example.puml b/example.puml
@@ -27,7 +27,7 @@ not_null(password) VARCHAR[64]
 Table(session, "session\n(session for user)") {
 primary_key(id) INTEGER
 not_null(user_id) INTEGER
-not_null(unique(session_id) VARCHAR[64]
+not_null(unique(session_id)) VARCHAR[64]
 }
 
 Table(user_profile, "user_profile\n(Some info of user)") {

diff --git a/example.puml b/example.puml
@@ -1,4 +1,6 @@
 @startuml
+' uncomment the line below if you're using computer with a retina display
+' skinparam dpi 300
 !define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
 ' we use bold for primary key
 ' green color for unique

diff --git a/template.puml b/template.puml
@@ -1,4 +1,6 @@
 @startuml
+' uncomment the line below if you're using computer with a retina display
+' skinparam dpi 300
 !define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
 ' we use bold for primary key
 ' green color for unique

diff --git a/template.puml b/template.puml
@@ -10,6 +10,7 @@
 ' <i></i>
 ' <back:COLOR></color>, where color is a color name or html color code
 ' (#FFAACC)
+' see: http://plantuml.com/classes.html#More
 hide methods
 hide stereotypes
 

diff --git a/example.puml b/example.puml
@@ -6,6 +6,11 @@
 !define primary_key(x) <b>x</b>
 !define unique(x) <color:green>x</color>
 !define not_null(x) <u>x</u>
+' other tags available:
+' <i></i>
+' <back:COLOR></color>, where color is a color name or html color code
+' (#FFAACC)
+' see: http://plantuml.com/classes.html#More
 hide methods
 hide stereotypes
 

diff --git a/template.puml b/template.puml
@@ -6,6 +6,10 @@
 !define primary_key(x) <b>x</b>
 !define unique(x) <color:green>x</color>
 !define not_null(x) <u>x</u>
+' other tags available:
+' <i></i>
+' <back:COLOR></color>, where color is a color name or html color code
+' (#FFAACC)
 hide methods
 hide stereotypes
 

diff --git a/example.svg b/example.svg
diff --git a/example.puml b/example.puml
@@ -0,0 +1,53 @@
+@startuml
+!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
+' we use bold for primary key
+' green color for unique
+' and underscore for not_null
+!define primary_key(x) <b>x</b>
+!define unique(x) <color:green>x</color>
+!define not_null(x) <u>x</u>
+hide methods
+hide stereotypes
+
+' entities
+
+Table(user, "user\n(User in our system)") {
+primary_key(id) INTEGER
+not_null(unique(username)) VARCHAR[32]
+not_null(password) VARCHAR[64]
+}
+
+Table(session, "session\n(session for user)") {
+primary_key(id) INTEGER
+not_null(user_id) INTEGER
+not_null(unique(session_id) VARCHAR[64]
+}
+
+Table(user_profile, "user_profile\n(Some info of user)") {
+primary_key(user_id) INTEGER
+age SMALLINT
+gender SMALLINT
+birthday DATETIME
+}
+
+Table(group, "group\n(group of users)") {
+primary_key(id) INTEGER
+not_null(name) VARCHAR[32]
+}
+
+Table(user_group, "user_group\n(relationship of user and group)") {
+primary_key(user_id) INTEGER
+primary_key(group_id) INTEGER
+joined_at DATETIME
+}
+
+' relationships
+' one-to-one relationship
+user -- user_profile : "A user only \nhas one profile"
+' one to may relationship
+user --> session : "A user may have\n many sessions"
+' many to many relationship
+' Add mark if you like
+user "1" --> "*" user_group : "A user may be \nin many groups"
+group "1" --> "0..N" user_group : "A group may \ncontain many users"
+@enduml
diff --git a/template.puml b/template.puml
@@ -0,0 +1,16 @@
+@startuml
+!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
+' we use bold for primary key
+' green color for unique
+' and underscore for not_null
+!define primary_key(x) <b>x</b>
+!define unique(x) <color:green>x</color>
+!define not_null(x) <u>x</u>
+hide methods
+hide stereotypes
+
+' entities
+
+' relationships
+
+@enduml