database.uml

@startuml database.png
hide methods
hide circle

class Customer {
    rowid: int
    customer_name: str
}
class Customer_Device {
    rowid: int
    customer_id: int
    device_name: str
    type_id: int
}

Customer "1"  *-- "0, m" Customer_Device 

class Device_Type {
    rowid: int
    device_type_name: str
}

Customer_Device "m" --* "1" Device_Type

class Service {
    rowid: int
    service_name: str
}

Customer_Device "m" *--* "m" Service
(Customer_Device, Service) .. CstDev_Svc

class CstDev_Svc {
    customer_device_id: int
    service_id: int
    start: datetime
    latitude: real
    longitude: real
}
@enduml