open:ermodel

這是本文件的舊版！

Customeraccount «PK»cust_code «PK»cust_namecust_addrother_detailsTrantran_code «PK»cust_code «FK»tran_code «PK»tran_datetran_totaltran_deliveryCartcart_code «generated»tran_code «FK»e1_id : number «FK»other_details : textProductprod_cdoe «PK»prod_namedescription


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 ||--o{ tran::account
tran::tran_code |o--|{ cart::tran_code
cart::prod_code }o--|| prod::prod_code
cust::account ||--o{ cart::account :加入購物車
@enduml

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