項目源碼

Source Code

複製並粘貼以下代碼至此處鏈接。
Copy and paste the code below to this link. 
    @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

更多

More

Fullscreen Image