{
    "php": "7.4.33",
    "db": "OK",
    "tables": [
        "vr_vehiculos"
    ],
    "count": 19,
    "indexes": [
        {
            "Table": "vr_vehiculos",
            "Non_unique": 0,
            "Key_name": "PRIMARY",
            "Seq_in_index": 1,
            "Column_name": "id",
            "Collation": "A",
            "Cardinality": 14,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        },
        {
            "Table": "vr_vehiculos",
            "Non_unique": 0,
            "Key_name": "ux_mat_fecha",
            "Seq_in_index": 1,
            "Column_name": "matricula",
            "Collation": "A",
            "Cardinality": 14,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        },
        {
            "Table": "vr_vehiculos",
            "Non_unique": 0,
            "Key_name": "ux_mat_fecha",
            "Seq_in_index": 2,
            "Column_name": "fecha_robo",
            "Collation": "A",
            "Cardinality": 14,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        },
        {
            "Table": "vr_vehiculos",
            "Non_unique": 1,
            "Key_name": "idx_estado_fecha",
            "Seq_in_index": 1,
            "Column_name": "estado",
            "Collation": "A",
            "Cardinality": 3,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        },
        {
            "Table": "vr_vehiculos",
            "Non_unique": 1,
            "Key_name": "idx_estado_fecha",
            "Seq_in_index": 2,
            "Column_name": "fecha_robo",
            "Collation": "A",
            "Cardinality": 14,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        },
        {
            "Table": "vr_vehiculos",
            "Non_unique": 1,
            "Key_name": "idx_matricula",
            "Seq_in_index": 1,
            "Column_name": "matricula",
            "Collation": "A",
            "Cardinality": 14,
            "Sub_part": null,
            "Packed": null,
            "Null": "",
            "Index_type": "BTREE",
            "Comment": "",
            "Index_comment": "",
            "Visible": "YES",
            "Expression": null
        }
    ],
    "columns": [
        {
            "Field": "id",
            "Type": "char(36)",
            "Null": "NO",
            "Key": "PRI",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "matricula",
            "Type": "varchar(16)",
            "Null": "NO",
            "Key": "MUL",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "marca",
            "Type": "varchar(64)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "modelo",
            "Type": "varchar(64)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "color",
            "Type": "varchar(64)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "fecha_robo",
            "Type": "datetime",
            "Null": "NO",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "lugar",
            "Type": "varchar(255)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "ref",
            "Type": "varchar(128)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "obs",
            "Type": "text",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "estado",
            "Type": "enum('robado','recuperado','archivado')",
            "Null": "NO",
            "Key": "MUL",
            "Default": "robado",
            "Extra": ""
        },
        {
            "Field": "recuperado_en",
            "Type": "datetime",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "archivado_en",
            "Type": "datetime",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": ""
        },
        {
            "Field": "creado_en",
            "Type": "datetime",
            "Null": "NO",
            "Key": "",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "DEFAULT_GENERATED"
        },
        {
            "Field": "actualizado_en",
            "Type": "datetime",
            "Null": "NO",
            "Key": "",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "DEFAULT_GENERATED on update CURRENT_TIMESTAMP"
        }
    ]
}