drupal.views.schema.json

{
    "views_view": {
        "description": "Stores the general data for a view.",
        "export": {
            "identifier": "view",
            "bulk export": true,
            "primary key": "vid",
            "default hook": "views_default_views",
            "admin_title": "human_name",
            "admin_description": "description",
            "api": {
                "owner": "views",
                "api": "views_default",
                "minimum_version": "2",
                "current_version": "3.0"
            },
            "object": "view",
            "subrecords callback": "views_load_display_records",
            "status": "views_defaults",
            "create callback": "views_new_view",
            "save callback": "views_save_view",
            "delete callback": "views_delete_view",
            "export callback": "views_export_view",
            "cache defaults": true,
            "default cache bin": "cache_views"
        },
        "fields": {
            "vid": {
                "type": "serial",
                "unsigned": true,
                "not null": true,
                "description": "The view ID of the field, defined by the database.",
                "no export": true
            },
            "name": {
                "type": "varchar",
                "length": "32",
                "default": "",
                "not null": true,
                "description": "The unique name of the view. This is the primary field views are loaded from, and is used so that views may be internal and not necessarily in the database. May only be alphanumeric characters plus underscores."
            },
            "description": {
                "type": "varchar",
                "length": "255",
                "default": "",
                "description": "A description of the view for the admin interface."
            },
            "tag": {
                "type": "varchar",
                "length": "255",
                "default": "",
                "description": "A tag used to group\/sort views in the admin interface"
            },
            "base_table": {
                "type": "varchar",
                "length": 64,
                "default": "",
                "not null": true,
                "description": "What table this view is based on, such as node, user, comment, or term."
            },
            "human_name": {
                "type": "varchar",
                "length": "255",
                "default": "",
                "description": "A human readable name used to be displayed in the admin interface"
            },
            "core": {
                "type": "int",
                "default": 0,
                "description": "Stores the drupal core version of the view."
            }
        },
        "primary key": [
            "vid"
        ],
        "unique keys": {
            "name": [
                "name"
            ]
        }
    },
    "views_display": {
        "description": "Stores information about each display attached to a view.",
        "fields": {
            "vid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "The view this display is attached to.",
                "no export": true
            },
            "id": {
                "type": "varchar",
                "length": "64",
                "default": "",
                "not null": true,
                "description": "An identifier for this display; usually generated from the display_plugin, so should be something like page or page_1 or block_2, etc."
            },
            "display_title": {
                "type": "varchar",
                "length": "64",
                "default": "",
                "not null": true,
                "description": "The title of the display, viewable by the administrator."
            },
            "display_plugin": {
                "type": "varchar",
                "length": "64",
                "default": "",
                "not null": true,
                "description": "The type of the display. Usually page, block or embed, but is pluggable so may be other things."
            },
            "position": {
                "type": "int",
                "default": 0,
                "description": "The order in which this display is loaded."
            },
            "display_options": {
                "type": "text",
                "size": "big",
                "description": "A serialized array of options for this display; it contains options that are generally only pertinent to that display plugin type.",
                "serialize": true,
                "serialized default": "a:0:{}"
            }
        },
        "indexes": {
            "vid": [
                "vid",
                "position"
            ]
        },
        "primary key": [
            "vid",
            "id"
        ]
    },
    "cache_views": {
        "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"
        ]
    },
    "cache_views_data": {
        "description": "Cache table for views to store pre-rendered queries, results, and display output.",
        "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": 1
            }
        },
        "indexes": {
            "expire": [
                "expire"
            ]
        },
        "primary key": [
            "cid"
        ]
    }
}