Tjyylli

Why does the freezing point matter when picking cooler ice packs?

Is it okay to majorly distort historical facts while writing a fiction story?

Can I cast Thunderwave and be at the center of its bottom face, but not be affected by it?

How seriously should I take size and weight limits of hand luggage?

Is the offspring between a demon and a celestial possible? If so what is it called and is it in a book somewhere?

"Eavesdropping" vs "Listen in on"

Gödel's incompleteness theorems - what are the religious implications?

Why did early computer designers eschew integers?

Does Germany produce more waste than the US?

How to pronounce fünf in 45

How badly should I try to prevent a user from XSSing themselves?

What does this strange code stamp on my passport mean?

How exploitable/balanced is this homebrew spell: Spell Permanency?

That's an odd coin - I wonder why

What did the word "leisure" mean in late 18th Century usage?

How can I separate the number from the unit in argument?

Find a path from s to t using as few red nodes as possible

Gauss' Posthumous Publications?

MT "will strike" & LXX "will watch carefully" (Gen 3:15)?

What happens if you break a law in another country outside of that country?

Man transported from Alternate World into ours by a Neutrino Detector

Could a dragon use its wings to swim?

Avoiding the "not like other girls" trope?

How can a day be of 24 hours?

should I consider color as an attribute in ecommerce application database? [on hold]

-1

I am creating an ecommerce website. following is simplified version of my database tables:
product==>id name
attribute==>id name
product_attribute==>product_id attribute_id value.

if you look at amazon and check for example laptops, you'll see that refine system helps you refine products based on ram, display, cpu and other attributes. you can also refine products by color. but color is not displayed as name or rgba or hexadecimal value. it is displayed as an graphical image or a tag with a background representing color. so should I consider color as a products column or maybe manipulate my EAV (entity-attribute-value) system to helpe to add additional information about attributes? please help me choose best way.

php

share|improve this question

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as off-topic by n8te, Mokubai♦ 48 mins ago

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "This question is not about computer hardware or software, within the scope defined in the help center." – Mokubai

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try dba.stackexchange.com?
  
  – grawity
  1 hour ago
  

  
  
  
  

add a comment | 

-1

I am creating an ecommerce website. following is simplified version of my database tables:
product==>id name
attribute==>id name
product_attribute==>product_id attribute_id value.

if you look at amazon and check for example laptops, you'll see that refine system helps you refine products based on ram, display, cpu and other attributes. you can also refine products by color. but color is not displayed as name or rgba or hexadecimal value. it is displayed as an graphical image or a tag with a background representing color. so should I consider color as a products column or maybe manipulate my EAV (entity-attribute-value) system to helpe to add additional information about attributes? please help me choose best way.

php

share|improve this question

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as off-topic by n8te, Mokubai♦ 48 mins ago

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "This question is not about computer hardware or software, within the scope defined in the help center." – Mokubai

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try dba.stackexchange.com?
  
  – grawity
  1 hour ago
  

  
  
  
  

add a comment | 

I am creating an ecommerce website. following is simplified version of my database tables:
product==>id name
attribute==>id name
product_attribute==>product_id attribute_id value.

if you look at amazon and check for example laptops, you'll see that refine system helps you refine products based on ram, display, cpu and other attributes. you can also refine products by color. but color is not displayed as name or rgba or hexadecimal value. it is displayed as an graphical image or a tag with a background representing color. so should I consider color as a products column or maybe manipulate my EAV (entity-attribute-value) system to helpe to add additional information about attributes? please help me choose best way.

php

share|improve this question

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 hour ago

user1015509user1015509

1

New contributor

user1015509 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 hour ago

user1015509user1015509

1