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


1


@startuml

' hide the spot
hide circle

' avoid problems with angled crows feet
skinparam linetype ortho


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 ||.r..o{ e02
e02 ||.r..o{ e03
e03 |o...o{ e04

@enduml

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