Questions tagged [Database design] (300)

1
answer

How to make the table the default set up value from another table?

There is a link word has one category, there is a "categories" table and it is foreign key, word_id, how to make the default that was substituted word_id id value from the table words?
tre_Hay asked April 19th 20 at 12:38
2
answers

How to organize communication between components in the database?

Hello. Currently rewriting one app since last DB scheme was terrible. There are two modules: Blog Company Blogs can have both companies and users. Also each company to relate to a specific user. Frequent operations: A sampling of blogs and user companies which he owns. Check who owns the blog article, if ...
cullen_Roberts asked April 19th 20 at 12:14
1
answer

How to design a database?

There is a conditional table with the data, for example data linked to the user. Each user can create custom fields in a multiple select. For example, creates a "Tags" field, and it adds the tags. Respectively have table fields with the field names and fields_values with the options to choose from. The user can create an un...
kade.Kle asked April 19th 20 at 12:06
2
answers

That performance in mysql (innodb) several small tables or one large?

What is better for performance and resource efficiency of iron - split data into multiple tables or have a great one? 1000 000 records 0.03 MB each. Table of goods. Sorting of goods, search goods, the rating on the main page. Random products.
micaela65 asked April 19th 20 at 11:58
1
answer

How to store tests in a database?

The challenge is to develop a system for professional development. Users need to be tested, which can be an arbitrary number of questions, several answers and only one answer is correct. On passing the test, will be given three attempts. Storing the number of attempts will be stored in the user table, but the question is: ...
Sydni asked April 19th 20 at 11:52
1
answer

Is there specializovany way of storing the data of the questionnaires in the database?

Storage and retrieval characteristics for example product, there is EAV or Nested Sets. And to build a phased questionnaire with branching of questions depending on previous answers in the wizard is a convenient way to store?
reese_Eichmann asked April 18th 20 at 13:27
1
answer

The composition table for mini filter properties?

How to store, what then could choose the relationship. spoiler For example, chose the black color, for it is the quality of the product: copy, high copy, original as there is only Revision L681h however, for the original is only black color.
Orlando.McLaughl asked April 18th 20 at 12:51
2
answers

Types of keys in databases?

Task: need to structurally separate all the entities in the database and to understand who is responsible for what. Trying to understand the structure of keys (types), indexes, relationships, but the confusion in his head. Use DataGrip, DBViewer, a renowned expert and sql queries: 1) In the DataGrip structuring nope, only...
Roy_Boyer asked April 18th 20 at 12:41
1
answer

How best to better organize the storage of data in mysql?

Plan to build a large web service with tens of thousands of records (products and announcements, news). Now lay the Foundation for Back-end and Fron-end I have already created, no complaints. Here is the database for high load projects had no experience. I want that the database is as fast as everything else that I have cr...
laron_Hackett asked April 18th 20 at 12:37
1
answer

How can I implement change of the order parameters?

How to change shipping price in the order of the frequent change of the parameters of this delivery I have in the database the order, the order has the properties id ..... id_доставки summadat summassaari summerslam in order to have a table with delivery id ..... procentov procentry summadayze The logic is this: 1) the c...
christy_Koelpin asked April 18th 20 at 12:30