Skip to main content

Timeline for what does {node} node mean

Current License: CC BY-SA 3.0

10 events
when toggle format what by license comment
Sep 1, 2015 at 14:36 history edited Aaron CC BY-SA 3.0
added 182 characters in body
Sep 1, 2015 at 14:33 vote accept Joe Lloyd
Sep 1, 2015 at 14:33 comment added Joe Lloyd Awesome Aaron, yeah this makes things much much clearer. thanks for the help.
Sep 1, 2015 at 14:31 comment added Aaron Yes -- I'd recommend exploring the database structure. It might be easiest with a GUI but you can also do it with SHOW and DESCRIBE queries. The Drupal database structure is fairly complex. Since nodes are just one type of entity, most tables that need to relate data to entities will have both an "entity_type" and "entity_id" field which, taken in tandem, allows their data to relate to any type of entity in the system. In those cases the data that relates to a node would have "entity_type" as "node" and "entity_id" as the nid of the node.
Sep 1, 2015 at 14:26 comment added Joe Lloyd ok, Thanks Aaron you've made this much clearer. just one last question, how would I know what records are held in node, is it the nid field on the other tables?
Sep 1, 2015 at 14:24 history edited Aaron CC BY-SA 3.0
deleted 69 characters in body
Sep 1, 2015 at 14:23 comment added Aaron @JoeLloyd The node table has one record for every node on your site. It does not necessarily (indeed almost certainly does not) contain all field data and there are almost certainly other types of entities on your site such as taxonomy terms that are in other tables.
Sep 1, 2015 at 14:20 comment added Joe Lloyd Oh I see, so does that mean the node table has a reference to all of my content? because I just got a count back and its got 700000+ items in it
Sep 1, 2015 at 14:20 history edited Aaron CC BY-SA 3.0
added 561 characters in body
Sep 1, 2015 at 14:15 history answered Aaron CC BY-SA 3.0