drupal.field.schema.json

{
    "field_config": {
        "fields": {
            "id": {
                "type": "serial",
                "not null": true,
                "description": "The primary identifier for a field"
            },
            "field_name": {
                "type": "varchar",
                "length": 32,
                "not null": true,
                "description": "The name of this field. Non-deleted field names are unique, but multiple deleted fields can have the same name."
            },
            "type": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "description": "The type of this field."
            },
            "module": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "The module that implements the field type."
            },
            "active": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0,
                "description": "Boolean indicating whether the module that implements the field type is enabled."
            },
            "storage_type": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "description": "The storage backend for the field."
            },
            "storage_module": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "The module that implements the storage backend."
            },
            "storage_active": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0,
                "description": "Boolean indicating whether the module that implements the storage backend is enabled."
            },
            "locked": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0,
                "description": "@TODO"
            },
            "data": {
                "type": "blob",
                "size": "big",
                "not null": true,
                "serialize": true,
                "description": "Serialized data containing the field properties that do not warrant a dedicated column."
            },
            "cardinality": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0
            },
            "translatable": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0
            },
            "deleted": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0
            }
        },
        "primary key": [
            "id"
        ],
        "indexes": {
            "field_name": [
                "field_name"
            ],
            "active": [
                "active"
            ],
            "storage_active": [
                "storage_active"
            ],
            "deleted": [
                "deleted"
            ],
            "module": [
                "module"
            ],
            "storage_module": [
                "storage_module"
            ],
            "type": [
                "type"
            ],
            "storage_type": [
                "storage_type"
            ]
        }
    },
    "field_config_instance": {
        "fields": {
            "id": {
                "type": "serial",
                "not null": true,
                "description": "The primary identifier for a field instance"
            },
            "field_id": {
                "type": "int",
                "not null": true,
                "description": "The identifier of the field attached by this instance"
            },
            "field_name": {
                "type": "varchar",
                "length": 32,
                "not null": true,
                "default": ""
            },
            "entity_type": {
                "type": "varchar",
                "length": 32,
                "not null": true,
                "default": ""
            },
            "bundle": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": ""
            },
            "data": {
                "type": "blob",
                "size": "big",
                "not null": true,
                "serialize": true
            },
            "deleted": {
                "type": "int",
                "size": "tiny",
                "not null": true,
                "default": 0
            }
        },
        "primary key": [
            "id"
        ],
        "indexes": {
            "field_name_bundle": [
                "field_name",
                "entity_type",
                "bundle"
            ],
            "deleted": [
                "deleted"
            ]
        }
    },
    "cache_field": {
        "description": "Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.",
        "fields": {
            "cid": {
                "description": "Primary Key: Unique cache ID.",
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": ""
            },
            "data": {
                "description": "A collection of data to cache.",
                "type": "blob",
                "not null": false,
                "size": "big"
            },
            "expire": {
                "description": "A Unix timestamp indicating when the cache entry should expire, or 0 for never.",
                "type": "int",
                "not null": true,
                "default": 0
            },
            "created": {
                "description": "A Unix timestamp indicating when the cache entry was created.",
                "type": "int",
                "not null": true,
                "default": 0
            },
            "serialized": {
                "description": "A flag to indicate whether content is serialized (1) or not (0).",
                "type": "int",
                "size": "small",
                "not null": true,
                "default": 0
            }
        },
        "indexes": {
            "expire": [
                "expire"
            ]
        },
        "primary key": [
            "cid"
        ]
    }
}