drupal.user.schema.json

{
    "authmap": {
        "description": "Stores distributed authentication mapping.",
        "fields": {
            "aid": {
                "description": "Primary Key: Unique authmap ID.",
                "type": "serial",
                "unsigned": true,
                "not null": true
            },
            "uid": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "User's {users}.uid."
            },
            "authname": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "Unique authentication name."
            },
            "module": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "Module which is controlling the authentication."
            }
        },
        "unique keys": {
            "authname": [
                "authname"
            ]
        },
        "primary key": [
            "aid"
        ],
        "foreign keys": {
            "user": {
                "table": "users",
                "columns": {
                    "uid": "uid"
                }
            }
        }
    },
    "role_permission": {
        "description": "Stores the permissions assigned to user roles.",
        "fields": {
            "rid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "description": "Foreign Key: {role}.rid."
            },
            "permission": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "A single permission granted to the role identified by rid."
            },
            "module": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "The module declaring the permission."
            }
        },
        "primary key": [
            "rid",
            "permission"
        ],
        "indexes": {
            "permission": [
                "permission"
            ]
        },
        "foreign keys": {
            "role": {
                "table": "roles",
                "columns": {
                    "rid": "rid"
                }
            }
        }
    },
    "role": {
        "description": "Stores user roles.",
        "fields": {
            "rid": {
                "type": "serial",
                "unsigned": true,
                "not null": true,
                "description": "Primary Key: Unique role ID."
            },
            "name": {
                "type": "varchar",
                "length": 64,
                "not null": true,
                "default": "",
                "description": "Unique role name.",
                "translatable": true
            },
            "weight": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "The weight of this role in listings and the user interface."
            }
        },
        "unique keys": {
            "name": [
                "name"
            ]
        },
        "primary key": [
            "rid"
        ],
        "indexes": {
            "name_weight": [
                "name",
                "weight"
            ]
        }
    },
    "users": {
        "description": "Stores user data.",
        "fields": {
            "uid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "description": "Primary Key: Unique user ID.",
                "default": 0
            },
            "name": {
                "type": "varchar",
                "length": 60,
                "not null": true,
                "default": "",
                "description": "Unique user name."
            },
            "pass": {
                "type": "varchar",
                "length": 128,
                "not null": true,
                "default": "",
                "description": "User's password (hashed)."
            },
            "mail": {
                "type": "varchar",
                "length": 254,
                "not null": false,
                "default": "",
                "description": "User's e-mail address."
            },
            "theme": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "User's default theme."
            },
            "signature": {
                "type": "varchar",
                "length": 255,
                "not null": true,
                "default": "",
                "description": "User's signature."
            },
            "signature_format": {
                "type": "varchar",
                "length": 255,
                "not null": false,
                "description": "The {filter_format}.format of the signature."
            },
            "created": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "Timestamp for when user was created."
            },
            "access": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "Timestamp for previous time user accessed the site."
            },
            "login": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "Timestamp for user's last login."
            },
            "status": {
                "type": "int",
                "not null": true,
                "default": 0,
                "size": "tiny",
                "description": "Whether the user is active(1) or blocked(0)."
            },
            "timezone": {
                "type": "varchar",
                "length": 32,
                "not null": false,
                "description": "User's time zone."
            },
            "language": {
                "type": "varchar",
                "length": 12,
                "not null": true,
                "default": "",
                "description": "User's default language."
            },
            "picture": {
                "type": "int",
                "not null": true,
                "default": 0,
                "description": "Foreign key: {file_managed}.fid of user's picture."
            },
            "init": {
                "type": "varchar",
                "length": 254,
                "not null": false,
                "default": "",
                "description": "E-mail address used for initial account creation."
            },
            "data": {
                "type": "blob",
                "not null": false,
                "size": "big",
                "serialize": true,
                "description": "A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal."
            }
        },
        "indexes": {
            "access": [
                "access"
            ],
            "created": [
                "created"
            ],
            "mail": [
                "mail"
            ],
            "picture": [
                "picture"
            ]
        },
        "unique keys": {
            "name": [
                "name"
            ]
        },
        "primary key": [
            "uid"
        ],
        "foreign keys": {
            "signature_format": {
                "table": "filter_format",
                "columns": {
                    "signature_format": "format"
                }
            }
        }
    },
    "users_roles": {
        "description": "Maps users to roles.",
        "fields": {
            "uid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "Primary Key: {users}.uid for user."
            },
            "rid": {
                "type": "int",
                "unsigned": true,
                "not null": true,
                "default": 0,
                "description": "Primary Key: {role}.rid for role."
            }
        },
        "primary key": [
            "uid",
            "rid"
        ],
        "indexes": {
            "rid": [
                "rid"
            ]
        },
        "foreign keys": {
            "user": {
                "table": "users",
                "columns": {
                    "uid": "uid"
                }
            },
            "role": {
                "table": "roles",
                "columns": {
                    "rid": "rid"
                }
            }
        }
    }
}