@startuml
!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
!define primary_key(x) x
!define foreign_key(x) x
!define unique(x) x
!define not_null(x) x
hide methods
hide stereotypes
' entities
Table(members, "Member") {
primary_key(member_ID)
Name
Address
}
Table(insured_items, "InsuredItem") {
primary_key(Item_ID)
Description
CoverageType
}
Table(coop_offices, "CoopOffice") {
primary_key(Office_ID)
Address
Manager_name
}
Table(policies, "Policy") {
primary_key(Policy_ID)
Type
}
Table(periods, "Period") {
Date_Key
Fiscal_Period
}
Table(claims, "Claim") {
primary_key(Claim_ID)
Claim_Description
Claim_Type
}
@enduml