CreateAwardGatheringActivities
extends BaseMigration
in package
CreateAwardGatheringActivities Migration
This creates a join table for the many-to-many relationship between Awards and GatheringActivities.
GatheringActivities are configuration/template objects that define types of activities (e.g., "Armored Combat", "Archery"). A single activity can be associated with many different awards, and an award can be given out during many activities.
Table of Contents
Properties
- $autoId : bool
Methods
- change() : void
- Create the award_gathering_activities join table linking awards to gathering activities.
Properties
$autoId
public
bool
$autoId
= \false
Methods
change()
Create the award_gathering_activities join table linking awards to gathering activities.
public
change() : void
The table includes an auto-increment primary key id, foreign keys award_id and gathering_activity_id,
audit fields (created, modified, created_by, modified_by), indexes (including a unique composite index
on award_id and gathering_activity_id), and foreign key constraints with cascade-on-delete.