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

customeraccount «PK»uidaccountpasswordforget_qforget_anicknamegentlebirthdaybloodinterestzipcodeaddresstelephoneemailepaperlastloginleveltrantran_code «PK»account «FK»uidtran_codeaccounttran_datefee_productfee_deliverynotestran_statuscarttran_code «FK»prod_code «FK»account «FK»uidtran_codeaccountprod_codeunit_priceamountcart_statusproductprod_cdoe «PK»uidprod_codeprod_namecategorydescriptionprice_markpricepicture加入購物車

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