92 lines
1.6 KiB
Plaintext
92 lines
1.6 KiB
Plaintext
@startuml
|
|
!pragma layout smetana
|
|
|
|
entity "beli"{
|
|
* id : number <<generated>>
|
|
* admin_id : number <<FK>>
|
|
"harga_beli" : number <<FK>>
|
|
petani_id : number <<FK>>
|
|
kendaraan : text
|
|
waktu : timestamp
|
|
}
|
|
|
|
entity timbang{
|
|
* id : number <<generated>>
|
|
* penimbang_id : number <<FK>>
|
|
* pemilah_id : number <<FK>>
|
|
beli_id : number <<FK>>
|
|
waktu : timestamp
|
|
kualitas : enum (1,2,sortiran, kendaraan)
|
|
berat : number
|
|
}
|
|
|
|
entity harga_beli {
|
|
* id
|
|
tanggal : date
|
|
created_by : number <<FK>>
|
|
harga_kw1 : number
|
|
harga_kw2 : number
|
|
harga_kw3 : number
|
|
}
|
|
|
|
entity "harga_jual"{
|
|
* id : number <<generated>>
|
|
* admin_id : number <<FK>>
|
|
harga : number
|
|
tanggal : date
|
|
}
|
|
|
|
entity "petani"{
|
|
* id : number <<generated>>
|
|
nama : text
|
|
alamat : text
|
|
|
|
}
|
|
|
|
entity "user"{
|
|
* id : number <<generated>>
|
|
username : text
|
|
password : text
|
|
nama : text
|
|
}
|
|
|
|
entity "role" {
|
|
* id : number <<generated>>
|
|
name : text
|
|
}
|
|
|
|
entity user_role {
|
|
* id : number <<generated>>
|
|
user_id : number <<FK>>
|
|
role_id : number <<FK>>
|
|
}
|
|
|
|
entity "authority" {
|
|
* authority : text
|
|
name : text
|
|
}
|
|
|
|
entity "role_authority" {
|
|
* id : number <<generated>>
|
|
role_id : number <<FK>>
|
|
authority : text <<FK>>
|
|
}
|
|
|
|
user::id ||..o{ user_role::user_id
|
|
user_role::role_id }o..|| role::id
|
|
role::id ||..o{ role_authority::role_id
|
|
role_authority::authority }o..|| authority::authority
|
|
|
|
user::id ||..|{ beli::admin_id
|
|
beli::petani_id }o..|| petani::id
|
|
beli::id ||..o{ berat::timbang_id
|
|
beli::harga_beli }o..|| harga_beli::id
|
|
|
|
berat::penimbang_id }o..|| user::id
|
|
berat::pemilah_id }o..|| user::id
|
|
|
|
harga_beli::created_by }o..|| user::id
|
|
|
|
|
|
@enduml
|