You are here

public static function FeedsItem::schema in Feeds 8.3

Returns the schema for the field.

This method is static because the field schema information is needed on creation of the field. FieldItemInterface objects instantiated at that time are not reliable as field settings might be missing.

Computed fields having no schema should return an empty array.

Parameters

\Drupal\Core\Field\FieldStorageDefinitionInterface $field_definition: The field definition.

Return value

array An empty array if there is no schema, or an associative array with the following key/value pairs:

  • columns: An array of Schema API column specifications, keyed by column name. The columns need to be a subset of the properties defined in propertyDefinitions(). The 'not null' property is ignored if present, as it is determined automatically by the storage controller depending on the table layout and the property definitions. It is recommended to avoid having the column definitions depend on field settings when possible. No assumptions should be made on how storage engines internally use the original column name to structure their storage.
  • unique keys: (optional) An array of Schema API unique key definitions. Only columns that appear in the 'columns' array are allowed.
  • indexes: (optional) An array of Schema API index definitions. Only columns that appear in the 'columns' array are allowed. Those indexes will be used as default indexes. Field definitions can specify additional indexes or, at their own risk, modify the default indexes specified by the field-type module. Some storage engines might not support indexes.
  • foreign keys: (optional) An array of Schema API foreign key definitions. Note, however, that the field data is not necessarily stored in SQL. Also, the possible usage is limited, as you cannot specify another field as related, only existing SQL tables, such as {taxonomy_term_data}.

Overrides EntityReferenceItem::schema

File

src/Plugin/Field/FieldType/FeedsItem.php, line 77

Class

FeedsItem
Plugin implementation of the 'feeds_item' field type.

Namespace

Drupal\feeds\Plugin\Field\FieldType

Code

public static function schema(FieldStorageDefinitionInterface $field_definition) {
  return [
    'columns' => [
      'target_id' => [
        'description' => 'The ID of the target feed.',
        'type' => 'int',
        'not null' => TRUE,
        'unsigned' => TRUE,
      ],
      'imported' => [
        'type' => 'int',
        'not null' => TRUE,
        'unsigned' => TRUE,
        'description' => 'Import date of the feed item, as a Unix timestamp.',
      ],
      'url' => [
        'type' => 'text',
        'description' => 'Link to the feed item.',
      ],
      'guid' => [
        'type' => 'text',
        'description' => 'Unique identifier for the feed item.',
      ],
      'hash' => [
        'type' => 'varchar',
        // The length of an md5 hash.
        'length' => 32,
        'not null' => TRUE,
        'description' => 'The hash of the feed item.',
        'is_ascii' => TRUE,
      ],
    ],
    'indexes' => [
      'target_id' => [
        'target_id',
      ],
      'lookup_url' => [
        'target_id',
        [
          'url',
          128,
        ],
      ],
      'lookup_guid' => [
        'target_id',
        [
          'guid',
          128,
        ],
      ],
      'imported' => [
        'imported',
      ],
    ],
    'foreign keys' => [
      'target_id' => [
        'table' => 'feeds_feed',
        'columns' => [
          'target_id' => 'fid',
        ],
      ],
    ],
  ];
}