Contactmessage

Beschreibung

Beinhaltet die Kontaktnachrichten (via. Kontaktformular & internen Tickets), welche auch als Ticketsystem genutzt werden.

altes contactmessage-Model

Die Kontaktnachrichten wurden früher direkt als Email gesendet und nicht in die Datenbank gespeichert.

neues Contactmessage-Model

Anmerkung

• 🆕

Model (json)

{
    "class": "App\\Models\\Contactmessage",
    "database": "mysql",
    "table": "contactmessages",
    "policy": null,
    "attributes": [
    {
    "name": "id",
    "type": "bigint unsigned",
    "increments": true,
    "nullable": false,
    "default": null,
    "unique": true,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "int"
    },
    {
    "name": "user_id",
    "type": "string(36)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "topic_id",
    "type": "string(36)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "name",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "email",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "telephone",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "message",
    "type": "text(65535)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "processed_by",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "processed_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" },
    { "name": "topic", "type": "BelongsTo", "related": "App\\Models\\Topic" },
    { "name": "actions", "type": "MorphMany", "related": "Laravel\\Nova\\Actions\\ActionEvent" }
    ],
    "observers": [{ "event": "created", "observer": ["App\\Observers\\ContactmessageObserver@created"] }]
}

Beziehungen

• Topic - [topic() - BelongsTo]
• User - [users() - BelongsTo]

übergeordnetes Thema

2.6 Datenstruktur