{
    "status": true,
    "database": "u658730471_mailer",
    "tables": {
        "mail_admins": {
            "in_schema": true,
            "column_count": 10,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "email": "varchar(200) [UNIQUE, NOT NULL]",
                "password": "varchar(255) [NOT NULL]",
                "name": "varchar(100) [NOT NULL]",
                "role": "varchar(20) [NOT NULL]",
                "must_change_pw": "tinyint(1) unsigned [NOT NULL]",
                "last_login_at": "datetime",
                "status": "tinyint(1) unsigned [NOT NULL]",
                "created_at": "datetime",
                "updated_at": "datetime"
            }
        },
        "mail_apps": {
            "in_schema": true,
            "column_count": 13,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_key": "varchar(64) [UNIQUE, NOT NULL]",
                "app_secret_hash": "varchar(255) [NOT NULL]",
                "name": "varchar(150) [NOT NULL]",
                "from_email": "varchar(200) [NOT NULL]",
                "from_name": "varchar(150) [NOT NULL]",
                "reply_to": "varchar(200)",
                "daily_quota": "int(11) unsigned [NOT NULL]",
                "otp_rate_per_hour": "int(11) unsigned [NOT NULL]",
                "status": "tinyint(1) unsigned [NOT NULL]",
                "notes": "text",
                "created_at": "datetime",
                "updated_at": "datetime"
            }
        },
        "mail_logs": {
            "in_schema": true,
            "column_count": 11,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_id": "int(11) unsigned [NOT NULL]",
                "channel": "varchar(20) [NOT NULL]",
                "recipient": "varchar(200) [NOT NULL]",
                "template_key": "varchar(64)",
                "subject": "varchar(255)",
                "status": "varchar(20) [NOT NULL]",
                "provider_message_id": "varchar(255)",
                "error_message": "text",
                "sent_at": "datetime",
                "created_at": "datetime"
            }
        },
        "mail_otps": {
            "in_schema": true,
            "column_count": 12,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_id": "int(11) unsigned [NOT NULL]",
                "recipient": "varchar(200) [NOT NULL]",
                "recipient_type": "varchar(16) [NOT NULL]",
                "otp_hash": "varchar(255) [NOT NULL]",
                "purpose": "varchar(32) [NOT NULL]",
                "attempts": "int(11) unsigned [NOT NULL]",
                "max_attempts": "int(11) unsigned [NOT NULL]",
                "expires_at": "datetime [NOT NULL]",
                "verified_at": "datetime",
                "ip_address": "varchar(45)",
                "created_at": "datetime"
            }
        },
        "mail_providers": {
            "in_schema": true,
            "column_count": 8,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "channel": "varchar(20) [NOT NULL]",
                "provider_name": "varchar(32) [NOT NULL]",
                "config_json": "text",
                "is_default": "tinyint(1) unsigned [NOT NULL]",
                "status": "tinyint(1) unsigned [NOT NULL]",
                "created_at": "datetime",
                "updated_at": "datetime"
            }
        },
        "mail_queue": {
            "in_schema": true,
            "column_count": 14,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_id": "int(11) unsigned [NOT NULL]",
                "channel": "varchar(20) [NOT NULL]",
                "recipient": "varchar(200) [NOT NULL]",
                "template_key": "varchar(64) [NOT NULL]",
                "data_json": "text",
                "priority": "int(4) [NOT NULL]",
                "status": "varchar(20) [NOT NULL]",
                "attempts": "int(11) unsigned [NOT NULL]",
                "max_attempts": "int(11) unsigned [NOT NULL]",
                "last_error": "text",
                "scheduled_at": "datetime",
                "sent_at": "datetime",
                "created_at": "datetime"
            }
        },
        "mail_quotas": {
            "in_schema": true,
            "column_count": 5,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_id": "int(11) unsigned [NOT NULL]",
                "date": "date [NOT NULL]",
                "count": "int(11) unsigned [NOT NULL]",
                "updated_at": "datetime"
            }
        },
        "mail_templates": {
            "in_schema": true,
            "column_count": 12,
            "columns": {
                "id": "int(11) unsigned [PK, NOT NULL]",
                "app_id": "int(11) unsigned",
                "template_key": "varchar(64) [NOT NULL]",
                "channel": "varchar(20) [NOT NULL]",
                "subject": "varchar(255) [NOT NULL]",
                "body_html": "longtext",
                "body_text": "text",
                "variables_json": "text",
                "description": "text",
                "status": "tinyint(1) unsigned [NOT NULL]",
                "created_at": "datetime",
                "updated_at": "datetime"
            }
        }
    }
}