Companyvideo

Beschreibung

Beinhaltet die Videos (bzw. deren Links), welche die Arbeitgeber in ihrer Präsentation angeben.

altes companyvideo-Model

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

old migration

CREATE TABLE `pyou_companyvideos` (
    `companyvideo_uuid` varchar(36) NOT NULL,
    `companypresentation_uuid` varchar(36) NOT NULL,
    `company_uuid` varchar(36) DEFAULT NULL,
    `companyvideo_id` tinyint(1) DEFAULT NULL,
    `companyvideo_link` varchar(250) DEFAULT NULL,
    `companyvideo_purified_link` varchar(250) DEFAULT NULL,
    `companyvideo_hash` varchar(55) DEFAULT NULL,
    `companyvideo_splash` varchar(250) DEFAULT NULL,
    `companyvideo_provider` varchar(55) DEFAULT NULL,
    `companyvideo_ts_create` timestamp NULL DEFAULT NULL,
    `companyvideo_ts_update` timestamp NULL DEFAULT NULL,
    `companyvideo_ts_delete` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`companyvideo_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8

neues Address-Model

Anmerkung

• 🆕

Model (json)

{
    "class": "App\\Models\\Companyvideo",
    "database": "mysql",
    "table": "companyvideos",
    "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": "presentation_id",
    "type": "string(36)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "order",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "raw_link",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "link",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "hash",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "splash",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "provider",
    "type": "string",
    "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"
    },
    {
    "name": "full_url",
    "type": null,
    "increments": false,
    "nullable": null,
    "default": null,
    "unique": null,
    "fillable": true,
    "hidden": false,
    "appended": true,
    "cast": "accessor"
    }
    ],
    "relations": [{ "name": "presentation", "type": "BelongsTo", "related": "App\\Models\\Presentation" }],
    "observers": [{ "event": "creating", "observer": ["Closure"] }]
}

Beziehungen

• Presentation - [users() - BelongsTo]

übergeordnetes Thema

2.6 Datenstruktur