single value field

multiple value field

shared field

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