Is my database design good enough?

Databases
1

hi mate,

i am just new in database design and i want to build new online store with php and mysql but i am doubt about my own design so i need your suggestion is there any change that i need?

here is my work

h**p://i60.tinypic.com/2pr8w0y.png

but hey sitepoint doesn’t allowed new user to upload or post a picture in their post. pfff so please just change the above h**p to http. sorry for this inconvenience

2

looks fine…

there’s a minor inconsistency in your relationship tables – product_attributes has two columns (okay) but product_platform has three (the id is redundant – see Deleting duplicated rows (SOLVED))

2 Likes
3

so i need to delete the product_platform_id at product_platform table isn’t it?

thank you sir for your suggestion i will change my database table first.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.