Benefit

Beschreibung

Beinhaltet die Vorteile für die Unternehmen bei der Partnervorstellungen angeben kann.

altes companybenefits-Model

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

old migration

---

CREATE TABLE `pyou_companybenefits` (
    `benefit_uuid` varchar(36) NOT NULL,
    `benefit_id` tinyint(9) NOT NULL,
    `benefit_category` varchar(128) DEFAULT NULL,
    `benefit_title` varchar(256) DEFAULT NULL,
    `benefit_order` tinyint(9) NOT NULL,
    `benefit_svg_name` varchar(128) DEFAULT NULL,
    `benefit_ts_create` timestamp NULL DEFAULT NULL,
    `benefit_ts_update` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`benefit_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

neues Benefit-Model

Model (json)

{
    "class": "App\\Models\\Benefit",
    "database": "mysql",
    "table": "benefits",
    "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": "order",
    "type": "boolean",
    "increments": false,
    "nullable": false,
    "default": "0",
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "title",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "svg",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "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": "businesses", "type": "BelongsToManySoft", "related": "App\\Models\\Business" },
    { "name": "presentations", "type": "BelongsToManySoft", "related": "App\\Models\\Presentation" }
    ],
    "observers": []
}

Beziehungen

• Business - [businesses() - BelongsToMany]
• Presentation - [presentations() - BelongsToMany]

übergeordnetes Thema

2.6 Datenstruktur