DeZign for Databases V4

Logical model

List of entities

Entity name	Primary key attributes	# Attributes	Description
AccessControlAssociation	ID	3
BillingAddress	ID	3
Category	ID	12
CategoryImage	ID	4
Currency	ID	8
CustomerOrder	ID	14
DeliveryZone	ID	6
DeliveryZoneAddressMask	ID	3
DeliveryZoneCityMask	ID	3
DeliveryZoneCountry	ID	3
DeliveryZoneRealTimeService	ID	3
DeliveryZoneState	ID	3
DeliveryZoneZipMask	ID	3
ExpressCheckout	ID	5
Filter	ID	8
FilterGroup	ID	5
Manufacturer	ID	2
NewsPost	ID	7
OrderedItem	ID	10
OrderLog	ID	10
OrderNote	ID	7
Product	ID	29
ProductFile	ID	9
ProductFileGroup	ID	4
ProductImage	ID	4
ProductPrice	productID, currencyID	3
ProductRelationship	ProductID, relatedProductID	4
ProductRelationshipGroup	ID	4
ProductReview	ID	6
Role	ID	2
Shipment	ID	11
ShipmentTax	ID	4
ShippingAddress	ID	3
ShippingRate	ID	10
ShippingService	ID	5
SpecField	ID	15	Field data type. Available types: 1. text field 2. drop down list (select one item from a list) 3. select multiple items from a list
SpecFieldGroup	ID	4
SpecFieldValue	ID	4	Is there a need to translate this field to diferent languages?
SpecificationDateValue	productID, specFieldID	3
SpecificationItem	specFieldValueID, productID, specFieldID	3	Product specification: maps input field value list to a particular product
SpecificationNumericValue	productID, specFieldID	3
SpecificationStringValue	productID, specFieldID	3
State	ID	5
StaticPage	ID	6
Tax	ID	3
TaxRate	ID	4
Transaction	ID	21
User	ID	12	Store system base user (including frontend and backend)
UserAddress	ID	12
UserGroup	ID	3	A list of role based groups in a store system