Tags System (Pivot)

A flexible tagging system using a many-to-many pivot table. Posts and snippets can both be tagged with the same tags.

ERD Concept

Tables

Relationships

• Tag belongsToMany Topic (topic_tag)
• Tag belongsToMany Snippet (snippet_tag)
• Topic belongsToMany Tag
• Snippet belongsToMany Tag

Migration

Schema::create('tags', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->string('slug')->unique();
    $table->timestamps();
});

Schema::create('topic_tag', function (Blueprint $table) {
    $table->foreignId('topic_id')->constrained()->cascadeOnDelete();
    $table->foreignId('tag_id')->constrained()->cascadeOnDelete();
    $table->primary(['topic_id', 'tag_id']);
    $table->timestamps();
});

Schema::create('snippet_tag', function (Blueprint $table) {
    $table->foreignId('snippet_id')->constrained()->cascadeOnDelete();
    $table->foreignId('tag_id')->constrained()->cascadeOnDelete();
    $table->primary(['snippet_id', 'tag_id']);
    $table->timestamps();
});