[
    {
        "Field": "user_id",
        "Type": "int(11)",
        "Null": "NO",
        "Key": "PRI",
        "Default": null,
        "Extra": "auto_increment"
    },
    {
        "Field": "username",
        "Type": "varchar(100)",
        "Null": "NO",
        "Key": "UNI",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "email",
        "Type": "varchar(255)",
        "Null": "NO",
        "Key": "UNI",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "google_id",
        "Type": "varchar(255)",
        "Null": "YES",
        "Key": "UNI",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "password_hash",
        "Type": "varchar(255)",
        "Null": "NO",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "full_name",
        "Type": "varchar(255)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "avatar_url",
        "Type": "varchar(500)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "phone",
        "Type": "varchar(20)",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    },
    {
        "Field": "role",
        "Type": "enum('admin','user','moderator')",
        "Null": "YES",
        "Key": "",
        "Default": "user",
        "Extra": ""
    },
    {
        "Field": "status",
        "Type": "enum('active','inactive','suspended')",
        "Null": "YES",
        "Key": "MUL",
        "Default": "active",
        "Extra": ""
    },
    {
        "Field": "created_at",
        "Type": "timestamp",
        "Null": "YES",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": ""
    },
    {
        "Field": "updated_at",
        "Type": "timestamp",
        "Null": "YES",
        "Key": "",
        "Default": "current_timestamp()",
        "Extra": "on update current_timestamp()"
    },
    {
        "Field": "last_login",
        "Type": "timestamp",
        "Null": "YES",
        "Key": "",
        "Default": null,
        "Extra": ""
    }
]