I am writing the warehouse interface there are tables:

CREATE TABLE "sklad" ( "Name" character varying NOT NULL, "Uint" character varying NOT NULL, "Count" numeric, "Changed" boolean, "OneCID" character varying, UNIQUE ("Name") )

In my architecture there is the possibility of adding new warehouses to the organization, at the moment it is implemented like this: That when registering a warehouse, a new table is created with a new warehouse name. Imagine that at 1 warehouse there are more than 10,000 positions and the number of warehouses is about 2,000. The question arises how best to organize the filling? 1 Warehouse = 1 table. Or 1 The table with the goods and in the rows indicates the name of the warehouse.

  CREATE TABLE "sklad" ( "NameSklad" varchar NOT NULL, "Name" character varying NOT NULL, "Uint" character varying NOT NULL, "Count" numeric, "Changed" boolean, "OneCID" character varying, UNIQUE ("Name") )

How is this implemented in 1C? And how to do it right?

  • one
    This question should be closed, because the practical value of the question is not shown. See useless knowledge - AK ♦
  • It is not useless, I need to know how this action is implemented in 1C. - Oma
  • one
    Well, you did not write about this "you need to know" -> "in order for ..." - it is possible that with this explanation the task will acquire practical meaning. I also put it correctly: "value is not shown," and not "does not carry any value." - AK ♦
  • one
    Well, I would more clearly write the word "performance", but let's say. This question is no longer necessary to close because we can assume that there is a practical value issue. But you still need to close it, because There is no specifics. Give requests, plans of requests. So far, three reasons for closing are right for your question. I do not find fault, but there are no telepaths, so far your question is very vague - and nobody even wants to answer it. - AK ♦
  • one
    And what's stopping you from getting a list of tables in the database, creating a warehouse, getting a new list of tables and comparing the results? Why do you even need to know how it was done in 1C, are you convinced that they did everything right? In vain, if so :) - D-side

1 answer 1

In 1c, data for all warehouses are stored in one register. The register is two tables in one stored turnover (movement of goods) in the other balances at the end of each month from the start of accounting. In postges, the 1c structure works poorly on a large amount of data. In general, how correctly the question is philosophical and has no answer. Especially for dside. Personally, I understand the question, it makes practical sense, although I recognize the task is very specific.