Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You're making a common mistake of database design, storing name in one column and value in another column. This is not a relational database design. </p> <p>Each attribute should be named by the column name. Color, pages, shirt size, publish date, should be <em>column names</em>.</p> <p>If each product type has a distinct set of attributes, there are other solutions. See my answers to:</p> <ul> <li><a href="https://stackoverflow.com/questions/695752/product-table-many-kinds-of-product-each-product-has-many-parameters/695860#695860">Product table, many kinds of product, each product has many parameters</a> for details.</li> <li><a href="https://stackoverflow.com/questions/884050/how-do-you-model-custom-attributes-of-entities/884279#884279">How do you model custom attributes of entities?</a></li> <li><a href="https://stackoverflow.com/questions/2219713/design-question-filterable-attributes-sql/2255750#2255750">Design question: Filterable attributes, SQL</a></li> <li><a href="https://stackoverflow.com/questions/373126/how-to-design-a-database-schema-to-support-tagging-with-categories/373291#373291">How to design a database schema to support tagging with categories?</a></li> <li><a href="https://stackoverflow.com/questions/287839/how-to-define-structure-in-a-tag-based-organization/287977#287977">How to define structure in a tag-based organization?</a></li> </ul> <p>Also <em>please</em> read this story: <a href="http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/" rel="nofollow noreferrer">Bad CaRMa: <em>Introducing Vision</em></a> before you implement a database designed around name-value pairs as you are doing.</p>
    singulars
    1. This table or related slice is empty.
    1. PO(Database Design - products attributes): What is better option for product attribute database design?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USBill Karwin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO(Database Design - products attributes): What is better option for product attribute database design?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthank you Bill, I give my votes also to other my questions, thank you for tell me.
      singulars
      1. PO
      1. USYosef
    2. COHi Bill, I read You links Thanks, I have question: Why do you prefer to use **Class Table Inheritance** and not **Single Table Inheritance**? Please explain, Thanks, Yosef
      singulars
      1. PO
      1. USYosef
    3. CO@Yosef: With Class Table Inheritance it's more clear which groups of columns go together. Also you can add a new subtype table at any time, with its own set of type-specific columns, with no need to alter the parent table that contains columns common to all subtypes. This is important for example for MySQL, where `ALTER TABLE` is an expensive operation.
      singulars
      1. PO
      1. USBill Karwin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload