Business

Beschreibung

Beinhaltet die Branchen in welchen Placing-Me aktiv ist.

altes business-Model

• Functionality
• Implementierung: ✅

old migration

CREATE TABLE `pyou_businesses` (
    `business_uuid` varchar(36) NOT NULL,
    `business_name` varchar(255) DEFAULT NULL,
    `business_href` varchar(255) DEFAULT NULL,
    `icon_path` varchar(255) DEFAULT NULL,
    `icon_alt` varchar(100) DEFAULT NULL,
    `icon_source` text,
    `business_order` int(11) DEFAULT NULL,
    `business_active` int(11) DEFAULT NULL,
    `business_ts_create` timestamp NULL DEFAULT NULL,
    `business_ts_delete` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`business_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

neues Business-Model

Model (json)

{
    "class": "App\\Models\\Business",
    "database": "mysql",
    "table": "businesses",
    "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": "name",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "key",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "icon_path",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "icon_alt",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "order",
    "type": "boolean",
    "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": "benefits", "type": "BelongsToManySoft", "related": "App\\Models\\Benefit" },
    { "name": "companies", "type": "BelongsToManySoft", "related": "App\\Models\\Company" },
    { "name": "filters", "type": "HasMany", "related": "App\\Models\\Filter" },
    { "name": "interviewquestions", "type": "BelongsToManySoft", "related": "App\\Models\\Interviewquestion" },
    { "name": "purchasingpools", "type": "BelongsToManySoft", "related": "App\\Models\\Purchasingpool" },
    { "name": "salarytables", "type": "HasMany", "related": "App\\Models\\Salarytable" },
    { "name": "searches", "type": "HasMany", "related": "App\\Models\\Search" },
    { "name": "searchbenefitsmappers", "type": "HasMany", "related": "App\\Models\\Searchbenefitsmapper" },
    { "name": "valuemappers", "type": "HasMany", "related": "App\\Models\\Valuemapper" }
    ],
    "observers": []
}

Beziehungen

• Benefit - [benefits() - BelongsToMany]
• Company - [companies() - BelongsToMany]
• Filter - [filters() - HasMany]
• Interviewquestion - [purchasingpools() - BelongsToMany]
• Salarytable - [searches() - HasMany]
• Search - [interviewquestions() - BelongsToMany]
• Searchbenefitsmapper - [searchbenefitsmappers() - HasMany]
• Valuemapper - [valuemappers() - HasMany]

übergeordnetes Thema

2.6 Datenstruktur