Userinformationtag

altes userinformationtag-Model

=> Beinhaltet die Userinformationtag, welche im Statusboard vergeben werden.

• Functionality
• Implementierung: ✅
• Alternative:

Data

---

CREATE TABLE `pyou_userinformationtags` (
    `userinformationtag_uuid` varchar(36) NOT NULL,
    `userinformationtag_order` tinyint(1) NOT NULL,
    `userinformationtag_name` varchar(255) NOT NULL,
    `userinformationtag_group_id` tinyint(1) NULL DEFAULT NULL,
    `userinformationtag_group_name` varchar(36) NULL DEFAULT NULL,
    `userinformationtag_class` varchar(36) NULL DEFAULT NULL,
    `userinformationtag_ts_create` timestamp NULL DEFAULT NULL,
    `userinformationtag_ts_update` timestamp NULL DEFAULT NULL,
    `userinformationtag_ts_delete` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`userinformationtag_uuid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

neues Userinformationtag-Model

Beziehungen

• n-n zu Userinformation(BelongsToMany(), pivot)

public function up()
{
Schema::create('userinformationtags', function (Blueprint $table) {
    $table->uuid('id')->primary();
    $table->tinyinteger('order');
    $table->string('name');
    $table->tinyinteger('group_id');
    $table->string('group_name');
    $table->string('group_class');
    $table->timestamps();
    $table->softDeletes();
});

übergeordnetes Thema

2.6 Datenstruktur