What database structure would be suitable for storing questions and character profiles for a personality test in PHP?

To store questions and character profiles for a personality test in PHP, a suitable database structure would be to have two tables: one for questions and another for character profiles. The questions table would contain fields such as question_id, question_text, and profile_id (to link to the corresponding character profile). The character profiles table would contain fields like profile_id, profile_name, and profile_description.

CREATE TABLE questions (
    question_id INT PRIMARY KEY AUTO_INCREMENT,
    question_text VARCHAR(255),
    profile_id INT
);

CREATE TABLE character_profiles (
    profile_id INT PRIMARY KEY AUTO_INCREMENT,
    profile_name VARCHAR(50),
    profile_description TEXT
);