項目頁面
Project Site
更多
More
Source Code
@startuml
!define TABLE(name,desc) class name as "desc" << (T,#FFAAAA) >>
!define PK(name) name
TABLE(Recipients, "Recipients") {
PK(recipient_id) : INT
name : VARCHAR(100)
address : VARCHAR(255)
phone : VARCHAR(15)
zip : VARCHAR(10)
latitude : DECIMAL(9,6)
longitude : DECIMAL(9,6)
delivery_frequency : ENUM('monthly', 'bi-monthly')
delivery_instructions : TEXT
food_restrictions : TEXT
driver_id : INT
}
TABLE(Drivers, "Drivers") {
PK(driver_id) : INT
name : VARCHAR(100)
phone : VARCHAR(15)
}
TABLE(Delivery, "Delivery") {
PK(delivery_id) : INT
recipient_id : INT
driver_id : INT
delivery_date : DATE
status : ENUM('pending', 'delivered', 'failed')
driver_notes : TEXT
recipient_notes : TEXT
}
' Define relationships
Recipients ||--o{ Delivery : "has"
Drivers ||--o{ Delivery : "handled by"
Recipients ||--o{ Drivers : "assigned to"
@enduml