# Cooperation
# Beschreibung
Beinhaltet die Kooperationen, die Placing-Me mit anderen Akteuren eingegangen ist (z.B. IAS oder Kiefer).
# altes cooperation-Model
# old migration
CREATE TABLE `pyou_cooperations` (
`cooperation_uuid` varchar(36) NOT NULL,
`cooperation_role` varchar(36) DEFAULT NULL,
`cooperation_headline` varchar(36) DEFAULT NULL,
`cooperation_subheading` varchar(36) DEFAULT NULL,
`cooperation_text` text DEFAULT NULL,
`cooperation_information` text DEFAULT NULL,
`cooperation_ts_create` timestamp NULL DEFAULT NULL,
`cooperation_ts_update` timestamp NULL DEFAULT NULL,
`cooperation_ts_delete` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`cooperation_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
# neues Cooperation-Model
Anmerkung
Functionality- Implementierung: ✅
- Anpassungen
# Model (json)
{
"class": "App\\Models\\Cooperation",
"database": "mysql",
"table": "cooperations",
"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": "headline",
"type": "string(255)",
"increments": false,
"nullable": false,
"default": null,
"unique": false,
"fillable": true,
"hidden": false,
"appended": null,
"cast": null
},
{
"name": "subheading",
"type": "string(255)",
"increments": false,
"nullable": false,
"default": null,
"unique": false,
"fillable": true,
"hidden": false,
"appended": null,
"cast": null
},
{
"name": "text",
"type": "text(65535)",
"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": "company", "type": "HasMany", "related": "App\\Models\\Company" }],
"observers": [{ "event": "creating", "observer": ["Closure"] }]
}
# Beziehungen
- Company - [
company()-HasMany]
# übergeordnetes Thema
2.6 Datenstruktur