Oldemailaddress

Beschreibung

Beinhaltet die (alte) Emailadresse.

altes oldemailaddress-Model

old migration

CREATE TABLE `pyou_emailbackups` (
    `emailbackup_uuid` varchar(36) NOT NULL,
    `emailbackup_subject` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    `emailbackup_from` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
    `emailbackup_to` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
    `emailbackup_content` text CHARACTER SET utf8,
    `emailbackup_success` timestamp NULL DEFAULT NULL,
    `emailbackup_type` varchar(255) DEFAULT NULL,
    `emailbackup_attachments` varchar(255) DEFAULT NULL,
    `emailbackup_errorinfo` varchar(255) DEFAULT NULL,
    `amazon_ses_messageid` varchar(255) DEFAULT NULL,
    `amazon_ses_responsemetadata` text DEFAULT NULL,
    `emailbackup_ts_read` timestamp NULL DEFAULT NULL,
    `emailbackup_ts_create` timestamp NULL DEFAULT NULL,
    `emailbackup_ts_update` timestamp NULL DEFAULT NULL,
    `emailbackup_ts_delete` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`emailbackup_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin;

neues Oldemailaddress-Model

Anmerkung

• Functionality
• Implementierung: ✅
• Erweiterung:
• kleinere Anpassungen

Model (json)

{
    "class": "App\\Models\\Oldemailaddress",
    "database": "mysql",
    "table": "oldemailaddresses",
    "policy": null,
    "attributes": [
    {
    "name": "id",
    "type": "string(36)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": true,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "user_id",
    "type": "string(36)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "email",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "email_verified_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    },
    {
    "name": "created_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    },
    {
    "name": "updated_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    },
    {
    "name": "deleted_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    }
    ],
    "relations": [{ "name": "user", "type": "BelongsTo", "related": "App\\Models\\User" }],
    "observers": [{ "event": "creating", "observer": ["Closure"] }]
}

Beziehungen

• User - [user() - BelongsTo]

übergeordnetes Thema

2.6 Datenstruktur