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



@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



@startuml

' hide the spot
' hide circle

' avoid problems with angled crows feet
' skinparam linetype ortho

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_date
tran_total
tran_delivery
}

e01::cust_code ||...o{ e02::cust_code

@enduml

Userid : INTEGERother_id : INTEGEREmailid : INTEGERuser_id : INTEGERaddress : INTEGER


Userid : INTEGERother_id : INTEGEREmailid : INTEGERuser_id : INTEGERaddress : INTEGER

  • open/ermodel.1659606188.txt.gz
  • 上一次變更: 2022/08/04 17:43
  • wenchin