<default>
ER Logical Diagram BookExpressDelivery_ER
 
 
Custom properties
erVersion:
Trinity
 
Key Group Summary
PK_Book 
PK_BookCarrier 
PK_CarrierCurrentStatus 
PK_Customer 
PK_PODetail 
PK_PurchaseOrder 

 
Logical Attribute Summary
Active 
ActuralIncome 
Address 
Address 
Amount 
Author 
BackDistance 
BookCode 
BookCode 
BookDeliveryCode 
BookDeliveryCode 
BookDeliveryStatus 
BookPackageCode 
BookPackageCode 
BookPackageCode 
CarrierCode 
CarrierCode 
CarrierCode 
CarrierName 
CarrierStatus 
CarryDate 
CompanyName 
ContactName 
CurrentValue 
CustomerCode 
CustomerCode 
DiscountRatio 
Email 
FinishDate 
GoDistance 
HasTasks 
ItemName 
Note 
Notes 
OrderedDate 
OriginalSumMoney 
Password 
Phone 
POStatus 
Price 
PublishDate 
PublishHouse 
Quantity 
ShipDate 
ShipFees 
ShipTo 
Sum 
TableName 
Telephone 
Title 
UserName 

 
Logical Domain Container Summary
Domain 

 
Logical Entity Summary
Book 
BookDelivery 
CarrierStaus 
Customer 
DeliveryMan 
NextSheetNum 
PODetail 
PurchaseOrder 





Diagram Elements Detail

Book
 
 
Key Group Summary
PK_Book 

 
Logical Attribute Summary
Author 
BookCode 
Notes 
Price 
PublishDate 
PublishHouse 
Quantity 
Title 
Author
Attribute name :
Author
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
BookCode
Attribute name :
BookCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Notes
Attribute name :
Notes
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
100
Size:
100
 
PK_Book
Primary.
 
Links:
erAssociationLink erAssociationLink from PK_Book to BookCode
to erLogicalAttribute BookCode
 
Custom properties
erOrder:
1
Price
Attribute name :
Price
Check:
Price > 0
Check:
Price > 0
Default.
Domain.
Logical type:
DECIMAL
Logical type:
DECIMAL
Not null.
Primary key.
Scale:
2
Scale:
2
Size:
6
Size:
6
 
PublishDate
Attribute name :
PublishDate
Check.
Default.
Domain.
Logical type:
DATE
Logical type:
DATE
Not null.
Primary key.
Scale.
Size.
 
PublishHouse
Attribute name :
PublishHouse
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Quantity
Attribute name :
Quantity
Check:
Quantity>0
Check:
Quantity>0
Default.
Domain.
Logical type:
INTEGER
Logical type:
INTEGER
Not null.
Primary key.
Scale.
Size.
 
Title
Attribute name :
Title
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
BookDelivery
 
Links:
Logical Relationship Execute
to erLogicalEntity DeliveryMan
 
Logical Relationship relationship1
to erLogicalEntity PurchaseOrder
 
 
Key Group Summary
PK_CarrierCurrentStatus 

BookDeliveryCode
Attribute name :
BookDeliveryCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
BookDeliveryStatus
Attribute name :
BookDeliveryStatus
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
BookPackageCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
CarrierCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
CarryDate
Attribute name :
CarryDate
Check.
Default.
Domain.
Logical type:
DATE
Logical type:
DATE
Not null.
Primary key.
Scale.
Size.
 
PK_CarrierCurrentStatus
Primary.
 
Links:
erAssociationLink erAssociationLink from PK_CarrierCurrentStatus to BookDeliveryCode
to erLogicalAttribute BookDeliveryCode
 
Custom properties
erOrder:
1
CarrierStaus
 
Links:
Logical Relationship Display
to erLogicalEntity DeliveryMan
 
 
Logical Attribute Summary
BackDistance 
BookDeliveryCode 
CarrierCode 
CarrierStatus 
GoDistance 
HasTasks 
BackDistance
Attribute name :
BackDistance
Check.
Default.
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
BookDeliveryCode
Attribute name :
BookDeliveryCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CarrierCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
CarrierStatus
Attribute name :
CarrierStatus
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
GoDistance
Attribute name :
GoDistance
Check.
Default.
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
HasTasks
Attribute name :
HasTasks
Check.
Default:
false
Default:
false
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Customer
 
 
Key Group Summary
PK_Customer 

 
Logical Attribute Summary
Address 
CompanyName 
ContactName 
CustomerCode 
Email 
Note 
Password 
Phone 
UserName 
Address
Attribute name :
Address
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CompanyName
Attribute name :
CompanyName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
ContactName
Attribute name :
ContactName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CustomerCode
Attribute name :
CustomerCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Email
Attribute name :
Email
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Note
Attribute name :
Note
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
100
Size:
100
 
Password
Attribute name :
Password
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Phone
Attribute name :
Phone
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
PK_Customer
Primary.
 
Links:
erAssociationLink erAssociationLink from PK_Customer to CustomerCode
to erLogicalAttribute CustomerCode
 
Custom properties
erOrder:
1
UserName
Attribute name :
UserName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
DeliveryMan
 
 
Key Group Summary
PK_BookCarrier 

 
Logical Attribute Summary
Active 
Address 
CarrierCode 
CarrierName 
Telephone 
Active
Attribute name :
Active
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Address
Attribute name :
Address
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CarrierCode
Attribute name :
CarrierCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CarrierName
Attribute name :
CarrierName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
PK_BookCarrier
Primary.
 
Links:
erAssociationLink erAssociationLink from PK_BookCarrier to CarrierCode
to erLogicalAttribute CarrierCode
 
Custom properties
erOrder:
1
Telephone
Attribute name :
Telephone
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Domain
 
NextSheetNum
 
 
Logical Attribute Summary
CurrentValue 
ItemName 
TableName 
CurrentValue
Attribute name :
CurrentValue
Check:
CurrentValue>=0
Check:
CurrentValue>=0
Default.
Domain.
Logical type:
INTEGER
Logical type:
INTEGER
Not null.
Primary key.
Scale.
Size.
 
ItemName
Attribute name :
ItemName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
TableName
Attribute name :
TableName
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
PODetail
 
Links:
Logical Relationship Reference
to erLogicalEntity Book
Cardinality:
E
 
Logical Relationship Include
to erLogicalEntity PurchaseOrder
Cardinality:
P
 
 
Key Group Summary
PK_PODetail 

 
Logical Attribute Summary
Amount 
BookCode 
BookPackageCode 
Amount
Attribute name :
Amount
Check:
Amount>0
Check:
Amount>0
Default.
Domain.
Logical type:
INTEGER
Logical type:
INTEGER
Not null.
Primary key.
Scale.
Size.
 
BookCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
BookPackageCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
PK_PODetail
Primary.
 
PurchaseOrder
 
Links:
Logical Relationship Order
to erLogicalEntity Customer
 
 
Key Group Summary
PK_PurchaseOrder 

ActuralIncome
Attribute name :
ActuralIncome
Check.
Default:
SumMoney*DiscountRation
Default:
SumMoney*DiscountRation
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
BookPackageCode
Attribute name :
BookPackageCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
CustomerCode
Check.
Default.
Domain.
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
 
DiscountRatio
Attribute name :
DiscountRatio
Check:
DiscountRatio>0 and DiscountRatio<=1
Check:
DiscountRatio>0 and DiscountRatio<=1
Default:
1
Default:
1
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
FinishDate
Attribute name :
FinishDate
Check.
Default.
Domain.
Logical type:
DATE
Logical type:
DATE
Not null.
Primary key.
Scale.
Size.
 
OrderedDate
Attribute name :
OrderedDate
Check.
Default.
Domain.
Logical type:
DATE
Logical type:
DATE
Not null.
Primary key.
Scale.
Size.
 
OriginalSumMoney
Attribute name :
OriginalSumMoney
Check.
Default.
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
PK_PurchaseOrder
Primary.
 
Links:
erAssociationLink erAssociationLink from PK_PurchaseOrder to BookPackageCode
to erLogicalAttribute BookPackageCode
 
Custom properties
erOrder:
1
POStatus
Attribute name :
POStatus
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
ShipDate
Attribute name :
ShipDate
Check.
Default.
Domain.
Logical type:
DATE
Logical type:
DATE
Not null.
Primary key.
Scale.
Size.
 
ShipFees
Attribute name :
ShipFees
Check:
ShipFees>0
Check:
ShipFees>0
Default:
0
Default:
0
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.
 
ShipTo
Attribute name :
ShipTo
Check.
Default.
Domain.
Logical type:
VARCHAR
Logical type:
VARCHAR
Not null.
Primary key.
Scale.
Size:
20
Size:
20
 
Sum
Attribute name :
Sum
Check.
Default.
Domain.
Logical type:
FLOAT
Logical type:
FLOAT
Not null.
Primary key.
Scale.
Size.