差異處
這裏顯示兩個版本的差異處。
| Both sides previous revision 前次修改 下次修改 | 前次修改 | ||
|
open:ermodel [2022/08/04 18:58] wenchin [2] |
open:ermodel [2022/08/04 19:08] (目前版本) wenchin |
||
|---|---|---|---|
| 行 46: | 行 46: | ||
| </uml> | </uml> | ||
| - | \\ | ||
| - | ===== 2 ===== | ||
| - | <uml> | ||
| - | @startuml | ||
| - | hide circle | ||
| - | |||
| - | entity "customer" as cust { | ||
| - | *account <<PK>> | ||
| - | -- | ||
| - | uid | ||
| - | +account | ||
| - | password | ||
| - | forget_q | ||
| - | forget_a | ||
| - | nickname | ||
| - | gentle | ||
| - | birthday | ||
| - | blood | ||
| - | interest | ||
| - | zipcode | ||
| - | address | ||
| - | telephone | ||
| - | |||
| - | epaper | ||
| - | lastlogin | ||
| - | level | ||
| - | } | ||
| - | |||
| - | entity "tran" as tran { | ||
| - | *tran_code <<PK>> | ||
| - | *account <<FK>> | ||
| - | -- | ||
| - | uid | ||
| - | +tran_code | ||
| - | +account | ||
| - | tran_date | ||
| - | fee_product | ||
| - | fee_delivery | ||
| - | notes | ||
| - | tran_status | ||
| - | } | ||
| - | |||
| - | entity "cart" as cart { | ||
| - | *tran_code <<FK>> | ||
| - | *prod_code <<FK>> | ||
| - | -- | ||
| - | *account <<FK>> | ||
| - | -- | ||
| - | uid | ||
| - | +tran_code | ||
| - | +account | ||
| - | +prod_code | ||
| - | unit_price | ||
| - | amount | ||
| - | cart_status | ||
| - | } | ||
| - | |||
| - | entity "product" as prod { | ||
| - | *prod_cdoe <<PK>> | ||
| - | -- | ||
| - | uid | ||
| - | +prod_code | ||
| - | prod_name | ||
| - | category | ||
| - | description | ||
| - | price_mark | ||
| - | price | ||
| - | picture | ||
| - | } | ||
| - | |||
| - | cust::account ||-r-o{ tran::account | ||
| - | tran::tran_code |o-d-|{ cart::tran_code | ||
| - | cart::prod_code }o-r-|| prod::prod_code | ||
| - | cust::account ||-r-o{ cart::account :加入購物車 | ||
| - | @enduml | ||
| - | </uml> | ||