Redesign Data Entities

[rasnesakam]

We need to redesign our entity structure

Our Entities

• Product
• Category
• Order
• Property
• ProductImage
• Address
• Seller?
• Customer?

Product

• Id
• Name
• Description
• Seller
• Categories
• ProductImages
• Properties
• Price

Category

• Id
• Name
• Products

Address

• Id
• Name
• Type
• Line1
• Line2
• Country
• Province
• State
• PostalCode

MemberOrder

• Id
• Products
• Seller
• Customer
• Address
• CustomerNote
• SellerNote

NonMemberOrder

• Id
• Products
• Seller
• CustomerNote
• SellerNote
• CustomerName
• CustomerSurname
• CustomerMail
• CustomerPhone
• CustomerCitizenNumber
• Address...

Seller

• Id
• Name
• PasswordHash
• Address
• EMail

[rasnesakam]

There is one type of order now. It has old properties. For non member's order, the temporary customer data will be create on database. And so for address I guess i've solved it for now

[rasnesakam]

We need to add some fields for every datas:

• IsActive: Indicates that the entity should be shown in list or etc
• CreatedDate: Creation date of entity
• IsRemoved: Indicates that is entity removed temporarily

[rasnesakam]

Issues on Product, Category and ProductCategory Entity

We may delete the ProductCategory join table. and set List<Category> and List<Product>. So, entity framework can generate join table automatically and we can use nested entities more efficiently. Take a look at this link