Oval: CanHave childrenOval: Category IDOval: NameOval: CanBeDeletedDiamond: Is Father ofOval: User IDOval: User IDOval: TitleOval: IsBuyerOval: MemberSinceOval: UsernameOval: PasswordOval: Address infoOval: IsSellerOval: e-mailOval: User ID

Italics means that this is a unique item

Underline means that this is an index

Double lines from a relation means that this entity inherits the index from the other entity

Dotted lines mean that this entity is optional for later implementation

In the entity bid it is supposed to have a composite index, namely date/time and userid.

 

 

Legend:

 

M

 

1

 
Diamond: IsIn categoryOval: Offered price

M

 

Categories

 

1

 
Diamond: Creates CategoryOval: Session KeyOval: Last Trans

M

 

Session

 

1

 
Diamond: Used clientOval: price proposalOval: Date of placementOval: User IDOval: descriptionOval: Product Id

M

 

1

 
Diamond: sells product

ForSale

 
Oval: zipOval: state codeOval: phone

User

 
EER Model for Cotrader 1.0