I have Drupal installed successfully and just studying the database schema a bit, I see some tables have a column named "delta", "blocks" table for example. Can someone explain to me how delta column is used? like the general design concept behind the use of this column? and why is it named 'delta'? I am just curious. In 'blocks' table for example it seems to store record id of other tables per module. Thanks in advance.

Comments

nevets’s picture

The blocks table keep track of available blocks and their status. Blocks are created by modules and each module can have more than one block. Delta is used to tell which block is which, the module assigns each one a unique (to the module) delta.

harsh197’s picture

In Drupal, "delta" only appears fields that have multiple values. "Delta" refers to the order of the values: 0 is the first item, 1 is the second item, 2 is the third item, and so on.