Manual:Content table

The content table represents 1>Multi-Content Revisions|content objects.

Its primary purpose is to provide the necessary meta-data for loading and interpreting a serialized data blob to create a content object.

content_id
ID of the content object

content_size
Nominal size of the content object (not necessarily of the serialized blob)

content_sha1
Nominal hash of the content object (not necessarily of the serialized blob)

content_model
Reference to .

Note the serialization format isn't specified; it should be assumed to be in the default format for the model unless auto-detected otherwise.

content_address
URL-like address of the content blob. Currently the structure is:   where   is a number referencing the text.old_id column.

Schema summary
+-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field          | Type                 | Null | Key | Default | Extra          |
 * content_id     | bigint(20) unsigned  | NO   | PRI | NULL    | auto_increment |
 * content_size   | int(10) unsigned     | NO   |     | NULL    |                |
 * content_sha1   | varbinary(32)        | NO   |     | NULL    |                |
 * content_model  | smallint(5) unsigned | NO   |     | NULL    |                |
 * content_address | varbinary(255)      | NO   |     | NULL    |                |