Salary

Beschreibung

Beinhaltet die Gehälter für die Suchen (AG).

altes salary-Model

old migration

CREATE TABLE `pyou_salaries` (
    `salary_uuid` varchar(36) NOT NULL,
    `search_uuid` varchar(36) NOT NULL,
    `user_uuid` varchar(36) NOT NULL,
    `contact_uuid` varchar(36) DEFAULT NULL,
    `salary_Total` int(11) DEFAULT NULL,
    `salary_Base` int(11) DEFAULT NULL,
    `salary_Thirteen` int(11) DEFAULT NULL,
    `salary_Fourteen` int(11) DEFAULT NULL,
    `salary_Min_Comission` int(11) DEFAULT NULL,
    `salary_Max_Comission` int(11) DEFAULT NULL,
    `salary_Min_Addition` int(11) DEFAULT NULL,
    `salary_Max_Addition` int(11) DEFAULT NULL,
    `salary_Reduce_Factor` int(11) DEFAULT NULL,
    `salary_Min` int(11) DEFAULT NULL,
    `salary_ts_create` timestamp NULL DEFAULT NULL,
    `salary_ts_update` timestamp NULL DEFAULT NULL,
    `salary_ts_delete` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`salary_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

neues Salary-Model

Anmerkung

• Functionality
• ~Jobseeker & ~Company
• Implementierung: ✅

Model (json)

{
    "class": "App\\Models\\Salary",
    "database": "mysql",
    "table": "salaries",
    "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": "search_id",
    "type": "string(36)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "total",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "accessor"
    },
    {
    "name": "base",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "min",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "thirteen",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "fourteen",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "min_comission",
    "type": "integer",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "max_comission",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "min_addition",
    "type": "integer",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "max_addition",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "reduce_factor",
    "type": "integer",
    "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": "search", "type": "BelongsTo", "related": "App\\Models\\Search" },
    { "name": "activities", "type": "MorphMany", "related": "Spatie\\Activitylog\\Models\\Activity" }
    ],
    "observers": [
    { "event": "creating", "observer": ["Closure"] },
    { "event": "created", "observer": ["Closure"] },
    { "event": "updating", "observer": ["Closure"] },
    { "event": "updated", "observer": ["Closure"] },
    { "event": "deleted", "observer": ["Closure"] },
    { "event": "restored", "observer": ["Closure"] }
    ]
}

Beziehungen

• Search - [search() - BelongsTo]

übergeordnetes Thema

2.6 Datenstruktur