drupal.taxonomy.schema.json

{
    "taxonomy_term_data": {
        "description": "Stores term information.",
        "fields": {
            "tid": {
                "type": "serial",
                "unsigned": true,
                "not null": true,
                "description": "Primary Key: Unique term ID."
            },
            "vid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "The {taxonomy_vocabulary}.vid of the vocabulary to which the term is assigned."
            },
            "name": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "The term name.",
                "translatable": true
            },
            "description": {
                "type": "text",
                "not null": false,
                "size": "big",
                "description": "A description of the term.",
                "translatable": true
            },
            "format": {
                "type": "varchar",
                "length": 255,
                "not null": false,
                "description": "The {filter_format}.format of the description."
            },
            "weight": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The weight of this term in relation to other terms."
            }
        },
        "primary key": [
            "tid"
        ],
        "foreign keys": {
            "vocabulary": {
                "table": "taxonomy_vocabulary",
                "columns": {
                    "vid": "vid"
                }
            }
        },
        "indexes": {
            "taxonomy_tree": [
                "vid",
                "weight",
                "name"
            ],
            "vid_name": [
                "vid",
                "name"
            ],
            "name": [
                "name"
            ]
        }
    },
    "taxonomy_term_hierarchy": {
        "description": "Stores the hierarchical relationship between terms.",
        "fields": {
            "tid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "Primary Key: The {taxonomy_term_data}.tid of the term."
            },
            "parent": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "Primary Key: The {taxonomy_term_data}.tid of the term's parent. 0 indicates no parent."
            }
        },
        "indexes": {
            "parent": [
                "parent"
            ]
        },
        "foreign keys": {
            "taxonomy_term_data": {
                "table": "taxonomy_term_data",
                "columns": {
                    "tid": "tid"
                }
            }
        },
        "primary key": [
            "tid",
            "parent"
        ]
    },
    "taxonomy_vocabulary": {
        "description": "Stores vocabulary information.",
        "fields": {
            "vid": {
                "type": "serial",
                "unsigned": true,
                "not null": true,
                "description": "Primary Key: Unique vocabulary ID."
            },
            "name": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "Name of the vocabulary.",
                "translatable": true
            },
            "machine_name": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "The vocabulary machine name."
            },
            "description": {
                "type": "text",
                "not null": false,
                "size": "big",
                "description": "Description of the vocabulary.",
                "translatable": true
            },
            "hierarchy": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "size": "tiny",
                "description": "The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple)"
            },
            "module": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "The module which created the vocabulary."
            },
            "weight": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The weight of this vocabulary in relation to other vocabularies."
            }
        },
        "primary key": [
            "vid"
        ],
        "indexes": {
            "list": [
                "weight",
                "name"
            ]
        },
        "unique keys": {
            "machine_name": [
                "machine_name"
            ]
        }
    },
    "taxonomy_index": {
        "description": "Maintains denormalized information about node\/term relationships.",
        "fields": {
            "nid": {
                "description": "The {node}.nid this record tracks.",
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0
            },
            "tid": {
                "description": "The term ID.",
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0
            },
            "sticky": {
                "description": "Boolean indicating whether the node is sticky.",
                "type": "int",
                "not null": false,
                "default": 0,
                "size": "tiny"
            },
            "created": {
                "description": "The Unix timestamp when the node was created.",
                "type": "int",
                "not null": true,
                "default": 0
            }
        },
        "indexes": {
            "term_node": [
                "tid",
                "sticky",
                "created"
            ],
            "nid": [
                "nid"
            ]
        },
        "foreign keys": {
            "tracked_node": {
                "table": "node",
                "columns": {
                    "nid": "nid"
                }
            },
            "term": {
                "table": "taxonomy_term_data",
                "columns": {
                    "tid": "tid"
                }
            }
        }
    }
}