open:ermodel

這是本文件的舊版！


@startuml
hide circle
left to right direction

entity "Customer" as e01 {
*account <>
--
*cust_code <>
cust_name
cust_addr
other_details
}

entity "Tran" as e02 {
*tran_code <>
*cust_code <>
--
*tran_code <>
tran_date
tran_total
tran_delivery
}

entity "Cart" as e03 {
*cart_code <>
--
*tran_code <>
--
e1_id : number <>
other_details : text
}

entity "Product" as e04 {
*prod_cdoe <>
--
prod_name
description
}

e01::cust_code ||..o{ e02::cust_code
e02::tran_code ||..o{ e03::tran_code
e03::e1_id |o..o{ e04::prod_cdoe

@enduml


2


@startuml
hide circle

entity "customer" as cust {
*account <>
--
uid
+account
password
forget_q
forget_a
nickname
gentle
birthday
blood
interest
zipcode
address
telephone
email
epaper
lastlogin
level
}

entity "tran" as tran {
*tran_code <>
*account <>
--
uid
+tran_code
+account
tran_date
fee_product
fee_delivery
notes
tran_status
}

entity "cart" as cart {
*tran_code <>
*prod_code <>
--
*account <>
--
uid
+tran_code
+account
+prod_code
unit_price
amount
cart_status
}

entity "product" as prod {
*prod_cdoe <>
--
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

  • open/ermodel.1659610684.txt.gz
  • 上一次變更: 2022/08/04 18:58
  • 由 wenchin