summaryrefslogtreecommitdiff
path: root/assignments/1/question-5-before.puml
blob: 54c568f76600b5573f93fc4683b0fee3c6b367b0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
@startuml
!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
!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

Table(employees, "employees") {
  primary_key(emp_no) integer
  date datetime
  job varchar[255]
  phone_no varchar[255]
  office_no varchar[255]
  area varchar[255]
  sal decimal
  proj_no integer
  p_budget decimal
  dep_no integer
  d_budget decimal
  mgr_emp_no integer
}
@enduml