Single, Multiple, and Shared Fields

Last updated July 24, 2009. Created by KarenS on January 25, 2007.
Edited by bekasu, add1sun. Log in to edit this page.

Note that for CCK 5.x-1.9, the actual names and structures for the tables in these diagrams are as follows:

Content Type

node_type

Columns modified, locked, orig_type are just hidden by the layout of the first and third diagrams, but are not actually removed

Content Data table

content_type_<type name>

Field are actually in this order:

1. vid (PK)
2. nid
3. field_* columns

Field Instance

node_field_instance

Field

node_field

Field data table

content_field_<field name>

Field are actually in this order:

1. vid PK[0]
2. delta PK[1]
3. nid Index
4. field_* columns

‹ Practical example of CCK's flexibility up Updating CCK Modules from 5.x to 6.x ›