What considerations should be made regarding relationships between game reports and comments in the database structure for PHP applications?

When designing the database structure for PHP applications that involve game reports and comments, it is important to establish a relationship between the two entities. One common approach is to have a one-to-many relationship where each game report can have multiple comments associated with it. This can be achieved by having a foreign key in the comments table that references the primary key of the game reports table.

CREATE TABLE game_reports (
    id INT PRIMARY KEY,
    title VARCHAR(255),
    description TEXT
);

CREATE TABLE comments (
    id INT PRIMARY KEY,
    report_id INT,
    comment TEXT,
    FOREIGN KEY (report_id) REFERENCES game_reports(id)
);