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


1

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

  • open/ermodel.1659606759.txt.gz
  • 上一次變更: 2022/08/04 17:52
  • 由 wenchin